Hi Niklas,
> Are there many comments (notes) in the file? Then it might be related to
> issue 102716.
no, only notes in column headers, but the spreadsheet has ~100 sheets with
up to 7500 rows and a lot of vlookup formulas
> No, addActionLock for the document doesn't interfere with formula calc
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
N