[Solved] Hide row based on cell value - Issues with macro?

[Bdelude89]

Sub FTest()
theSheet=thisComponent.getSheets.getByName( "Production" )
CellDest = theSheet.getCellByPosition(4,8)
If CellDest.string = "1" then CellDest.Rows.IsVisible=false
end if
end sub

This is my macro that is not working. I have a formula in D8 that detects the length of of another cell in the spreadsheet. It displays "1" if the cell length is zero and nothing if the cell length is greater than zero. If the formula in D8 produces a "1" I want to hide the D row. For some reason this is not working. Could someone with much greater knowledge please help me troubleshoot?

[FJCC]

This line is returning cell E9

Code: Select all

CellDest = theSheet.getCellByPosition(4,8)

because rows and columns are indexed from 0: A = 0, B = 1, C = 2, D = 3. Similarly, and confusingly, row 1 has an index of 0.

[Bdelude89]

Thank you, good looking out!