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 [email protected] For additional commands send email to [email protected] with Subject: help
