[libreoffice-users] 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: users+unsubscr...@global.libreoffice.org 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
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 1. And never try to use 3D charts on such huge set of data points. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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 rb.hensc...@t-online.de To: users@global.libreoffice.org 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 1. And never try to use 3D charts on such huge set of data points. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Charts with lots of data in Calc
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 1. And never try to use 3D charts on such huge set of data points. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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
[libreoffice-users] Charts in Writer
How do I insert a chart in Writer. If I go Insert / Object / Chart one appears which I can edit but as soon as I save and close the file when I reopen it the chart is blank Ta M -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
[libreoffice-users] Charts
how one can draw a chart with x or y axis (or both) will be on log scale? Reuven -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Charts
Hi, On Wed, 01 Jun 2011 13:23:44 +0300 reuven g_reuv...@bezeqint.net wrote: how one can draw a chart with x or y axis (or both) will be on log scale? You need to use a x-y-diagram. When selecting the range that should be displayed and all the other needed settings, there's a checkbox that you can check for each axis to be divided logarithmically. HTH. Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted