Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread Tom Davies
Hi :) I think it's the same with programmer training. Inevitably there are too many variables or unknown factors that rarely occur. One methodology to handle it is to release early and release often to get more eyeballs on the code. Even if people can't see the code itself or don't bother to

Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread Jacqueline Tarleton
But I am getting more comfortable with using R itself to answer these... Excuse my ignorance - What is R? This particular Thread has provided amazing details on the limitations of Libre Office Calc, tips, hints, and workarounds- except do not know what is R. I apologize in advance for not

[libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread V Stuart Foote
Jacqueline Tarleton wrote But I am getting more comfortable with using R itself to answer these... Excuse my ignorance - What is R? This particular Thread has provided amazing details on the limitations of Libre Office Calc, tips, hints, and workarounds- except do not know what is R.

Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread Tom Davies
Hi :) i assumed it is a 3rd party database program that contains the tables of data. Base is usually excellent at linking to such external databases. It seems to be the best way of using Base and the default way of using it. The idea is that Base then performs various functions through SQL

Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread Andrew Douglas Pitonyak
http://en.wikipedia.org/wiki/R_(programming_language) R is a free software programming language and software environment for statistical computing and graphics. Calc has a limit of one million rows (well, 1048576 if I remember correctly). I expect that you will not have this problem if

[libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-30 Thread andrewH
Dear Tom -- Thanks for your attention to my problem. I believe the problem with using Calc as a viewer is that I have 3.6 million lines of data. But I am getting more comfortable with using R itself to answer these questions. I think part of my problem is that it is the nature of of legal training

Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-18 Thread Tom Davies
Hi :) Ahh, Base seems to be better when the data is held externally. Postgresql should be an excellent choice for holding the data and then 'just' get Base to connect to it. I would have thought Calc would then be really good at displaying the data?! So i'm not sure what the problem is now.

[libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-17 Thread andrewH
Thanks for the offer, Andrew! The original file is definitely bigger than the allowable limit. However, when I originally tried to import it, it opened up the first third of the file and allowed me to save it, and reopen it. However, when I tried to save it a second time, it crashed and the file

[libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-17 Thread andrewH
Thanks Tom! Gnumeric is a great product and I have used it before. I was hoping to use Calc in this case because I am trying to learn to use the LO database, Base, as a stand-alone or a front end for PostgreSQL. But I find it very hard to define, use, and even just to import a file into a

[libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-04 Thread Owen Genat
andrewH wrote I am working with a data set that keeps causing my LibreOffice to freeze. I am pretty sure that this is only because it is big. It is a pipe-separated text from the US Economic Census imported into Calc, about 30 columns and around a million rows. (The actual data set is bigger,