| View previous topic :: View next topic |
| Author |
Message |
1car1
General User
Joined: 21 Sep 2006
Posts: 9
|
 Posted: Fri Sep 22, 2006 1:54 am Post subject: Calc considerably slower than Excel? |
 |
|
Our accounts department have several large excel spreadsheets that they use ona daily basis, ranging from 7Mb to 30Mb in size.
Opening and modifying these sheets in Calc is considerably slower than they were in Excel.
Can take 10 seconds to open a 10mb spreadsheet as opposed to 1-2 secs in Excel.
Also when editting the sheet and putting in formula's the text types in and completes in like lagged state, they type 20 things, then it fills each one in (if I am making any sense).
A check of the PC shows no worries as far as CPU and memory usage. The PC it's running on is a P4 3.3Ghz with 1Gb of RAM so should be more than enough to cope?
Is there any way to speed Calc up any? or is this because we are using MS Excel format spreadsheets from within Calc?
_________________
Thanks,
1car1 - IT Team |
|
| Back to top |
|
 |
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
| Posted: Fri Sep 22, 2006 2:01 am Post subject: |
|
|
What happens if OpenDocument is used instead? You should find the speed improved as no import filter is used. Still, Calc is known to recalculate relatively slowly for a spreadsheet. Which version are you using? Recent versions have featured speedups in this area.
_________________
Arch Linux
OOo 3.2.0
OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/ |
|
| Back to top |
|
|
1car1
General User
Joined: 21 Sep 2006
Posts: 9
|
| Posted: Fri Sep 22, 2006 4:19 am Post subject: |
|
|
We just downloaded it yesterday so am guessing it's the latest version.
What is OpenDocument?
_________________
Thanks,
1car1 - IT Team |
|
| Back to top |
|
|
Kaaredyret
Moderator
Joined: 22 Aug 2003
Posts: 1356
Location: Denmark
|
|
| Back to top |
|
|
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
| Posted: Fri Sep 22, 2006 4:57 am Post subject: |
|
|
In short, OpenDocument is the default format of OOo. Try converting it to an OpenDocument spreadsheet (.ods) and then seeing how long it takes to open.
_________________
Arch Linux
OOo 3.2.0
OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/ |
|
| Back to top |
|
|
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Fri Sep 22, 2006 12:07 pm Post subject: |
|
|
You may get faster loading from a .ods (OpenDoc) file, but in general, Calc is noticeably slower than Excel. Can you just leave the sheet open? At least you only have to suffer the loading delay one time.
| Quote: | | Also when editting the sheet and putting in formula's the text types in and completes in like lagged state, they type 20 things, then it fills each one in (if I am making any sense). |
This is probably the "autoinput" feature, where Calc tries to use the contents of the column to autocomplete what you're typing. You can turn it off by Tools > Cell Contents > Autoinput (make sure it's UNchecked). |
|
| Back to top |
|
|
|
