Charts with lots of data in Calc

classic Classic list List threaded Threaded
4 messages Options
Sebastián Dietrich Sebastián Dietrich
Reply | Threaded
Open this post in threaded view
|

Charts with lots of data in Calc

I'm making some x-y chart in Calc with a lot of data. In this moment, i
have some with more than 25,000 data points.
It seems like Calc cannot manage these charts quickly. Each modification
takes a long time to be accomplished.
I've have try these same type of chart in gnumeric and it works very fast.
Is this the normal functioning of calc?

I'm running the suite LibreOffice 4.0.4 in Ubuntu, with an I7 processor.

Thanks!

Best regards!

--
Sebastián Dietrich
Instituto de Hidrología de Llanuras
"Dr. Jorge Eduardo Usunoff"
Rep. de Italia 780
Azul - Pcia. de Bs. As. - Argentina
CC 47 (7300)
Tel/Fax: 54 02281 432666
www.ihlla.org.ar


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|

Re: Charts with lots of data in Calc

Hi Sebastián,

Sebastián Dietrich schrieb:
> I'm making some x-y chart in Calc with a lot of data. In this moment, i
> have some with more than 25,000 data points.

Your screen has likely not more than 2000 dots width. Are you sure you
need 25000 data points?

> It seems like Calc cannot manage these charts quickly. Each modification
> takes a long time to be accomplished.

That is true. Opening such documents is a problem too, especially with
xsl import filter.

> I've have try these same type of chart in gnumeric and it works very fast.
> Is this the normal functioning of calc?
>
> I'm running the suite LibreOffice 4.0.4 in Ubuntu, with an I7 processor.

It is a shortcoming in LibreOffice and Apache OpenOffice. There exists
already an internal point reducing for identical points. But the problem
still remains. I would generate the chart from a reduced set of data
points with less than 10000. And never try to use 3D charts on such huge
set of data points.

Kind regards
Regina

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: Charts with lots of data in Calc

Hi :)
Yes, gnumeric is a dedicated specialist spreadsheet tool.  It doesn't have to consider other apps.  It does just one thing and does it very well.  It's only focus is on spreadsheets so it's processes are more streamlined for just that. 


So, Gnumeric is better than Calc at quite a few things but it's also better than Excel in those ways and in other ways too.


The advantage with Calc or Excel is that they are more integrated with other office apps.  Both do their job pretty well and for most usages do them far better than most office workers ever need.  Yours is more of a specialists needs so Gnumeric is a better tool for you for this task.  There is nothing stopping you having both and you will find that Gnumeric plays well with LibreOffice/OpenOffice quite well. 


Regards from

Tom :) 





>________________________________
> From: Regina Henschel <[hidden email]>
>To: [hidden email]
>Sent: Thursday, 8 August 2013, 17:14
>Subject: Re: [libreoffice-users] Charts with lots of data in Calc
>
>
>Hi Sebastián,
>
>Sebastián Dietrich schrieb:
>> I'm making some x-y chart in Calc with a lot of data. In this moment, i
>> have some with more than 25,000 data points.
>
>Your screen has likely not more than 2000 dots width. Are you sure you
>need 25000 data points?
>
>> It seems like Calc cannot manage these charts quickly. Each modification
>> takes a long time to be accomplished.
>
>That is true. Opening such documents is a problem too, especially with
>xsl import filter.
>
>> I've have try these same type of chart in gnumeric and it works very fast.
>> Is this the normal functioning of calc?
>>
>> I'm running the suite LibreOffice 4.0.4 in Ubuntu, with an I7 processor.
>
>It is a shortcoming in LibreOffice and Apache OpenOffice. There exists
>already an internal point reducing for identical points. But the problem
>still remains. I would generate the chart from a reduced set of data
>points with less than 10000. And never try to use 3D charts on such huge
>set of data points.
>
>Kind regards
>Regina
>
>
--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Screwbottle Screwbottle
Reply | Threaded
Open this post in threaded view
|

Re: Charts with lots of data in Calc

In reply to this post by Regina Henschel
Thanks Regina

I have found your reply and the original question of Sebastián
interesting and useful. I had a similiar issue just recently, but did
not ask for any help as it was not an urgent task to do in a
spreadsheet, just experimenting, now at least I am aware of the
limitations, and interestingly of Gnumeric's use. I never realised the
dot points of the screen width, mine 1920, having an effect, I was
playing with 2000 data points.

Nice, one learns more every day.

Regards

Andrew Brown

On 08/08/2013 06:14 PM, Regina Henschel wrote:

> Hi Sebastián,
>
> Sebastián Dietrich schrieb:
>> I'm making some x-y chart in Calc with a lot of data. In this moment, i
>> have some with more than 25,000 data points.
>
> Your screen has likely not more than 2000 dots width. Are you sure you
> need 25000 data points?
>
>> It seems like Calc cannot manage these charts quickly. Each modification
>> takes a long time to be accomplished.
>
> That is true. Opening such documents is a problem too, especially with
> xsl import filter.
>
>> I've have try these same type of chart in gnumeric and it works very
>> fast.
>> Is this the normal functioning of calc?
>>
>> I'm running the suite LibreOffice 4.0.4 in Ubuntu, with an I7 processor.
>
> It is a shortcoming in LibreOffice and Apache OpenOffice. There exists
> already an internal point reducing for identical points. But the
> problem still remains. I would generate the chart from a reduced set
> of data points with less than 10000. And never try to use 3D charts on
> such huge set of data points.
>
> Kind regards
> Regina
>


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted