On 4/7/2016 3:16 PM, s|b wrote:
On Thu, 07 Apr 2016 13:50:31 -0400, Paul wrote:

LibreOffice has failed every "quality" test I've given it.

You get "half an office at no cost".

And what's that worth ? About what you paid for it.

*******

As an example, I tried to do an Excel-type chart project.
Accept a list of maybe 80,000 ordered pairs and graph it.

I'm betting not many people have files like that. I've used OOo and then
LO and I've never encountered a problem. Mind you, I *know* there are
some problems, I'm only saying I haven't encountered one yet in all
those years.


I used the OS/2 version of Lotus but when I had to by a new computer and
OS/2 unavailable. I tried use MS Works as it came with my first MS
Computer. The word processors was acceptable and it had a useable
database. The spreadsheet was acceptable but could handle only the
simplest of graphs.

I then went looking for an office suit for home use I tried Open Office
(It has been some years ago) which I understand has become LibreOffice.

At that time I was quite pleased with the word processor, and if that
had been the only criteria I would have continued to use it. The spread
sheet was horrible. I tried a couple of other free Office suites with
similar results.

I had used both MS office and WordPerfect office at work and my first
purchased Office suite was Word Perfect Office X-3 because of the revel
codes, and the many more function in Quattro Pro. I am now on Word
Perfect Office X-5 and hope to upgrade to X-8 when it comes out.

The spread sheet has been the deciding factor in most of my decision on
office suites. I consider myself and average spreadsheet user. My Stock
Market spread sheet tracks the DOW and the S&P with data from 2007. One
worksheet calculates the weekly and monthly changes in both the DOW and
the S&P. This spread sheet has charts for the last 30, 60, 90, 120, and
180 days of the daily closing and daily volumes.

I have two other spread sheet. One is for my assets, and is principally
a database of the monthly closing data for my accounts and chart to
track the change in the value of the assets since 2008.

My Check book spread sheet usually runs with about two years of data and
tracks the balances in my checking account, my credit accounts, and my
savings accounts. Each purchase is coded and the the expenditure
against the codes are calculated.

I have similar spreadsheets to manage my church Chair of the trustees
activities.

I don't consider my uses of a spreadsheet unique. If those office
suites like Open Office had been able to hand this type of spread sheet
I would be using them today.

If you are testing spread sheet performance, one test is to generate the
data and plot the curve for the normal curve of error. 160 points will
give a good definition of the curve create by the formula
see https://en.wikipedia.org/wiki/Normal_distribution. And with the
function use, give a good speed test. With Quattro Pro this takes a
couple of seconds while the spread sheet is opening. With the
OpenOffice based spreadsheets it took minutes.