oRow.isVisible causes OpenOffice to Crash
Posted: Fri Jun 01, 2018 3:29 am
Using oRow.isVisible = any boolean value causes OpenOffice to crash. See code below:
Am I using the object properties correctly? Is there a library descibing all such properties?
NOTE: I used Variants in ShowRow() since using Integer and Booleans caused other issues? Could this be a related issue?
Background: This macro is used on a speadsheet meant to be a teaching aid on division for my son.
Use of this macro seems to work in another spread sheet, but not this one. See attached.
Here's my environment:
WIndows 7
OpenOffice Calc Apache 4.1.5
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
Am I using the object properties correctly? Is there a library descibing all such properties?
NOTE: I used Variants in ShowRow() since using Integer and Booleans caused other issues? Could this be a related issue?
Code: Select all
function ShowRow(row as Variant, show as Variant) as Variant
Dim oSheet as Object, oRow as Object
oSheet = ThisComponent.currentController.activeSheet
oRow = oSheet.getRows().getByIndex(row-1)
'Problem #1
'Why does the following line (if uncommented) cause OpenOffice Calc to crash?
'oRow.isVisible = show
ShowRow = show
end function
Use of this macro seems to work in another spread sheet, but not this one. See attached.
Here's my environment:
WIndows 7
OpenOffice Calc Apache 4.1.5
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25