On 23.06.2011 11:37, Oliver Brinzing wrote:
i noticed hiding columns in large spreadsheets (~3MB) can be
very slow compared to oo 2.x, for example:

      For i = 0 To uBound(mRanges())
        oRange = oSheet.getCellRangeByName(mRanges(i))
        oRange.getColumns().IsVisible = bVisible
      Next i

will take about 3 seconds for each range in my spreadsheet - why ?

Are there many comments (notes) in the file? Then it might be related to issue 102716.

adding oDoc.addActionLock() / oDoc.removeActionLock()
will solve the problem, but i am not sure if i have to use a
oDoc.calculateAll() after removing the lock to be sure,
all formulas are calculated correctly ?

No, addActionLock for the document doesn't interfere with formula calculation. It mainly affects the drawing layer.

To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help

Reply via email to