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

pivot table on more than 5000 rows

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting
View previous topic :: View next topic  
Author Message
vijaykhurana
Newbie
Newbie


Joined: 21 Aug 2009
Posts: 3

PostPosted: Thu Sep 17, 2009 10:33 pm    Post subject: pivot table on more than 5000 rows Reply with quote

data pilot when applied on a calc sheet with more than 5000 rows and 6-7 cols either takes too long to complete or simply hangs
Back to top
View user's profile Send private message
Karun
General User
General User


Joined: 16 Jul 2008
Posts: 28
Location: DELHI

PostPosted: Thu Sep 17, 2009 11:10 pm    Post subject: DATA PIVOT Reply with quote

here i hav same prob., i had upload the file.
plz find the solution.....
------------------------------------------------------
http://www.mediafire.com/?uz71wxdazu4
-------------------------------------------------------


THK
Back to top
View user's profile Send private message Send e-mail Visit poster's website
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Fri Sep 18, 2009 12:15 am    Post subject: Reply with quote

There are limitations in what pivot tables in Calc can handle. For heavy data processing, you need to resort to a database program at some point.
_________________
--
GNU/Linux (Ubuntu)
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: Fri Sep 18, 2009 2:04 pm    Post subject: Re: DATA PIVOT Reply with quote

Karun wrote:
here i hav same prob., i had upload the file.
plz find the solution.....
------------------------------------------------------
http://www.mediafire.com/?uz71wxdazu4
-------------------------------------------------------


THK


Use a data base. You have over 600,000 entries in that one sheet.
As ftack says some things are too much for Calc.
_________________
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 -> Setup and Troubleshooting 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