Macro slow in version 4.1.3 and not in version 3.2.0

[loomismilitia]

Hello guys,

Maybe you can help me.

I have a macro to hide and unhide some rows in OpenOffice Calc.
It checks in one column if the cell value obeys a condition, if so hide or unhide that row.

I have recently installed the new OpenOffice 4.1.3 and this macro becomes running very slow.
In version 3.2.0 it runs very fast.

Do you have any thoughts??

Here is some code snippets I am using:

Code: Select all

Dim Sheet as  object
Dim srcCol as integer 
Dim strRow as integer

Sheet = ThisComponent.Sheets(0)
valCell = Sheet.getCellByPosition(srcCol,strRow) 
valCell.Rows.isVisible= false
 

[Zizi64]

How you calculate or get the parameters srcCol, strRow?
How many rows you want hide or unhide?

Please upload your example .ods file and the full macro here.

[RoryOF]

Put in a few timing printouts to narrow down where the problem occurs.

[loomismilitia]

Hello,

You can find attached the example ods and the macro.

You should click on cell 'hide/unhide' to view the macro in action.
This is a loop from row 13 to row 9000.

Even if you comment all the lines on Sub ProcessSheet (maybe a heavy processing ) the macro is taking much more time compared to version 3.2.0 (it's instantaneous).

Thanks for your support.

[Villeroy]

Runs within a second or two with LibreOffice5. Whatever that code tries to do, I'd prefer to do this without any macro code. Looks like a typical "VBA solution".
P.S. unhiding takes some 5 seconds.

[loomismilitia]

But this not answer why in version 3.2.0 it is instantaneous.
In version 4.1.3 it takes several seconds.

[Villeroy]

Only a core developer could answer this question.