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

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

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

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