[sc-dev] oo 3.x: hiding columns in large spreadsheets sometimes very slow

[Oliver Brinzing]

Hi,

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 ?
btw: i could not find a way to hide a couple of ranges with
a single api call  ...

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 ?

any hints ?

Regards

Oliver
-- 


GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45

signature.asc
Description: OpenPGP digital signature