[libreoffice-dev] - questions about calc extension

[Kohei Yoshida]

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