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