Bill Gradwohl wrote:
>
> Is there any way to stop all screen activity while a macro is executing?
>
> I've written some basic macros and during their operation, cells get
> reset to 0, columns get deleted, things get moved around, etc. Each of
> those actions causes the screen to refresh which wastes a lot of time
> and is annoying to watch.
>
> While on the subject, I read that the spreadsheet is actually written in
> C, and not JAVA as I assumed, so why is the application so slow?
>
>
> --
> Bill Gradwohl
>
>
Regarding screen refreshing, there is a discussion here:
http://www.oooforum.org/forum/viewtopic.phtml?t=49527
The ruse of creating a blank document to cover the document being processed:
http://www.oooforum.org/forum/viewtopic.phtml?t=36652
Two things which I understand detract from performance in terms of speed are
hard formatting and use of range names. The former can be minimised by
using styles (F11) - see the Calc guide chapter (~ 10) on styles on
http://documentation.openoffice.org/manuals/oooauthors2/index.html
--
View this message in context:
http://www.nabble.com/Screen-refresh-in-spreadsheet-tf3691773.html#a10333272
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]