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

Performance tuning

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rajeshdangle
Newbie
Newbie


Joined: 06 May 2008
Posts: 3

PostPosted: Tue May 06, 2008 9:56 pm    Post subject: Performance tuning Reply with quote

We have some excel files which have several formulas, links to other excel sheets. When we try to open these files using OpenOffice Calc, system becomes extremely slow.

Kindly suggest some solutions for improving the performance.

There is general feedback from users, that the system slows down while working with open office calc. Can we do some thing for improving the performance (any patch )

Thanks & Regards

Rajesh
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 07, 2008 2:22 am    Post subject: Reply with quote

Optimize your formulas, so you won't recalculate the same expression over and over again. Put repetitive calculations in separate ranges, so they are evaluated once before beeing referenced.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Aladdin
General User
General User


Joined: 23 Jan 2007
Posts: 40
Location: France

PostPosted: Wed May 07, 2008 3:13 am    Post subject: Reply with quote

Please provide some document to test in your issue.
Back to top
View user's profile Send private message
rajeshdangle
Newbie
Newbie


Joined: 06 May 2008
Posts: 3

PostPosted: Wed May 07, 2008 3:23 am    Post subject: Reply with quote

Hi Guys,

Thanks for your reply. Regarding formulas, we are trying to optimise it.

But when we select say 100 - 200 rows / columns , system becomes very slow as if it hung.

Kindly suggest whether some patches will improve the performance. Or some settings in OpenOffice Calc will solve this performance problem.

Kindly revert back, its a very serious problem.

Regards

Rajesh
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 07, 2008 4:02 am    Post subject: Reply with quote

Without a single detail nobody can help you. I suspect you have the same problems like this fellow: http://www.oooforum.org/forum/viewtopic.phtml?t=59839

If you desparately need to misuse a spreadsheet as database, then I recommend to stay with Excel and it's old binary file format.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
rajeshdangle
Newbie
Newbie


Joined: 06 May 2008
Posts: 3

PostPosted: Wed May 07, 2008 4:18 am    Post subject: Reply with quote

What details you want ?

My problem is not with a specific formula or a particular file.

I am talking about general performance issue.

Even if you select some thing in CALC, system becomes slow. Forget about any other operation.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed May 07, 2008 4:22 am    Post subject: Reply with quote

Villeroy wrote:
If you desparately need to misuse a spreadsheet as database, then I recommend to stay with Excel and it's old binary file format.


I agree with your basic premise here, in that the database proper is the tool to use perhaps in this case. However, I have sometimes wondered myself about the fact that the common folk [at least myself] having been given apparently the same tools as the experts [a bazillion cells filled with formulas and data] who use them daily with massive amounts of information [as in the military], have the same expectations without access to a Cray computer. It's reminiscent of the used-car-salesman approach: "It works fine, just don't press too hard on the brake."

Whether used as a "database" or not, it is a spreadsheet, and should compute. ...I say this about all office suite programs, not this one in particular.

David.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 07, 2008 4:28 am    Post subject: Reply with quote

We do not know the operating system, nor the vendor of the office suite (there are some different compilations of this suite). We do not even know the version number. You started with
Quote:
We have some excel files which have several formulas, links to other excel sheets. When we try to open these files using OpenOffice Calc, system becomes extremely slow.

For me this pointless thread is finished.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Wed May 07, 2008 6:00 am    Post subject: Reply with quote

rajeshdangle wrote:
What details you want ?

My problem is not with a specific formula or a particular file.

I am talking about general performance issue.

Even if you select some thing in CALC, system becomes slow. Forget about any other operation.


What are you using this file for?
What hardware?
What Operating System ?
What version of Excel?
What version of OOo ? ( we need the three digit number - look under help)
Number of sheets?
Approximate number of cells used in a calculation?
Amount of data being accessed?
Do you have Autocalculate turned on?
Can you supply an example?

Handy places to post a file:
media fire http://www.mediafire.com/
or
mytempdir.com http://www.mytempdir.com

That should do for a start.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
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