OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Calc considerably slower than Excel?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
1car1
General User
General User


Joined: 21 Sep 2006
Posts: 9

PostPosted: Fri Sep 22, 2006 1:54 am    Post subject: Calc considerably slower than Excel? Reply with quote

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
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Fri Sep 22, 2006 2:01 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
1car1
General User
General User


Joined: 21 Sep 2006
Posts: 9

PostPosted: Fri Sep 22, 2006 4:19 am    Post subject: Reply with quote

We just downloaded it yesterday so am guessing it's the latest version.

What is OpenDocument?
_________________
Thanks,

1car1 - IT Team
Back to top
View user's profile Send private message
Kaaredyret
Moderator
Moderator


Joined: 22 Aug 2003
Posts: 1356
Location: Denmark

PostPosted: Fri Sep 22, 2006 4:46 am    Post subject: Reply with quote

http://en.wikipedia.org/wiki/OpenDocument
_________________
www.kaaredyret.dk - OpenOffice resources (templates, extensions, tutorials and more) !
Stay updated on software and OpenOffice.org news via Twitter
Back to top
View user's profile Send private message Visit poster's website
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Fri Sep 22, 2006 4:57 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
acknak
Moderator
Moderator


Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W

PostPosted: Fri Sep 22, 2006 12:07 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group