List Info

Thread: Disabling cell updates




Disabling cell updates
user name
2006-06-20 01:57:38
I wasn't sure if I should ask this question on the api
list, but here goes.

One Solver user has requested that I disable refreshing of
cells while
it's converting a model from the sheet to the standard
format (by
setting the value of a cell to 1 and those of the others to
0, and
repeat for every single cell).  This cell update action
obviously
consumes significant CPU cycles so much so that scrolling
the sheet to
hide the data area prior to slick "Solve" speeds
up the execution.

My question is, is it possible to disable repainting of
cells while
their data are being modified?  Something like:

disableCellUpdates();

<convert models>

enableCellUpdates();

would be the most desirable, but I'm not sure if such API
exists.

Thanks in advance,
Kohei

-- 
Kohei Yoshida, OpenOffice.org Calc Hacker
<koheiopenoffice.org>

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

Disabling cell updates
user name
2006-06-20 08:32:09
Kohei Yoshida wrote:
> My question is, is it possible to disable repainting of
cells while
> their data are being modified?  Something like:
> 
> disableCellUpdates();
> 
> <convert models>
> 
> enableCellUpdates();
> 
> would be the most desirable, but I'm not sure if such
API exists.

You can use lockControllers / unlockControllers from the
document's 
XModel interface.

Niklas

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

Disabling cell updates
user name
2006-06-21 01:30:57
On 6/20/06, Niklas Nebel <Niklas.Nebelsun.com> wrote:

> You can use lockControllers / unlockControllers from
the document's
> XModel interface.

It amazingly works well.  Thanks a lot!

Kohei

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )