On 01/10/2013 10:50 AM, Rai, Neeraj wrote:
Hi Michael,

Appreciate your feedback.
I ran callgrind but no output on screen and 0 bytes files generated. I can run 
it on non-LO exe.
I'll compile LO with --enable-debug and see if situation improves. Please 
advise if other steps might be needed.

What's your hunch about how long it should take to update 60K cells with 
{getCellByPosition(ii,jj) and setValue() } ?

Two things you might try.

1) Try getDataArray() and setDataArray() to update multiple contiguous cells. Doing it this way is much much faster than updating one cell at a time. These methods are available for cell range object.

2) Try lockControllers() and unlockControllers() to disable/enable repainting while updating cell values. The example of these methods should be in my xcalc.cxx file I referenced earlier.

HTH,

Kohei

--
Kohei Yoshida, LibreOffice hacker, Calc
_______________________________________________
LibreOffice mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to