ynaras
Power User
Joined: 01 Nov 2004
Posts: 78
Location: Waltham, MA
|
 Posted: Fri Jan 21, 2005 7:48 am Post subject: How do I improve performance of my Spreadsheet? |
 |
|
Hi,
I have an OpenOffice spreadsheet (Version 1.1.1) with 3 worksheets. Worksheet 1 has 241 Listboxes, 2 Command Buttons and 8 Checkboxes. When I navigate between Worksheet 2 and 3 which do not have any form controls, it moves back and forth very quickly. However, when I navigate into or away from Worksheet 1 from any of the other 2 worksheets, it takes forever.
I just timed the navigation on a 2 GHz processor with 2.5GB RAM. It took 57 seconds to show Worksheet 1 (with form controls) when I clicked on its tab while I had Worksheet 2 open. My users will dump OO usage if they see this performance.
Any help in optimizing performance of this tool would greatly help,
Yogesh. |
|
