Hi Matthias, also consider using css::document::XActionLockable to improve performance. See http://api.openoffice.org/docs/common/ref/com/sun/star/document/XActionLockable.html
2005/8/22, Matthias Benkmann <[EMAIL PROTECTED]>: > Hi, > > I need to create a large Calc document from scratch via UNO. Calling > setFormula() for all the cells is pretty slow (about 1.5ms per Cell on > my 2800MHz computer). By introducing un/lockControllers() calls I've > managed to reduce the time to about 0.5ms, but when generating a large > document this is still painfully slow. > > Does anyone have a suggestion for speeding the code up further? > > I've noticed that while lockControllers() disables the synchronous > screen updates of the table itself, every call to setFormula() results > in the formula being displayed in the Formula bar. So there still > seems to be a lot of event processing going on. Is there anything else > I can do aside from lockControllers() to reduce event processing even > further? Note that disabling the Formula bar in View/Toolbars does not > give a very significant speed up. > > Matthias > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Best Regards Christian Junker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]