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.
Niklas
--
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help