Joined: Sep 14, 2005 Posts: 3 Location: Wisconsin, USA
Posted: Wed Sep 14, 2005 10:21 pm Post subject: Slow when opening/saving spreadsheets
When I open or save spreadsheets it takes a very long time (several orders of magnitude longer than to open the equivalent spreadsheet in, for example, M$ Office or Corel Office on my 6-year old Windows 98 computer). I'm running NeoOffice on a G4 1.4 GHz with 1 GB RAM, so hardware is not the bottleneck.
Is this normal? Can I do anything to improve this?
I have to wait 10-20 seconds each time I open or save a spreadsheet (except for very simple spreadsheets). My most complex spreadsheets are really not complex: 64 kB file size, no images or graphs, no math beyond addition and multiplication, one font, <100 rows and <30 columns and <10 sheets per file.
Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Thu Sep 15, 2005 12:36 pm Post subject:
Unfortunately, I think that this is just one of those things - the more sheets you have, the longer Calc takes to load the document in NOJ. As far as I know, there isn't anything that can be done about it, but a little experimentation shows that OOo 1.1.2 for MacOS X X11 opens such files a lot faster - obviously, there is something that is slowing this operation down in NOJ. All I can recommend is that you submit a bug to the Bugzilla explaining the discrepancy with the speed in OOo for X11 and if possible attach an example document that we can test. I suspect that it will be left open as a deferred bug as Patrick or Ed may not be able to do anything about it as it may be a consequence of bugs present in Apple's Java 1.3.1 implementation. Perhaps the update to Java 1.4.2 will improve things... _________________ PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5
... and if possible attach an example document that we can test. I suspect that it will be left open as a deferred bug as Patrick or Ed may not be able to do anything about it as it may be a consequence of bugs present in Apple's Java 1.3.1 implementation. Perhaps the update to Java 1.4.2 will improve things...
I would add that you absolutely need to attach a sample document as we cannot fix what we cannot reproduce.
Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Thu Sep 15, 2005 2:00 pm Post subject:
Follow-up: I realised why the test file I was using was opening faster in OOo for X11 - for some reason in NOJ, an additional step was added for each sheet in the document of "adapting the row height" whereas it wasn't doing this in OOo. I'm going to take a guess that this may be due to differences in the way fonts are rendered which is causing this additional step to be needed in NOJ...
I'll generate a bugzilla report and attach the document - if alanng can add any files that exhibit slow opening as well, I can do some further comparisons between OOo for X11 and NOJ.
(Bug 978 generated - alanng, can you add any sample files to this bug and any description of the problem that differs to mine, thanks). _________________ PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5
Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Fri Sep 16, 2005 2:06 am Post subject:
Hi, thanks for submitting your report and documents - I've closed my bug as a duplicate and appended my observations to yours. Can you check if the additional "Adapting row height" stage that I describe in the report is occurring for you as well? _________________ PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum