Quoting Randomthots <[EMAIL PROTECTED]>:
Daniel Carrera wrote:Randomthots wrote:
I think Writer is easily as good as, and probably better than, Word for most users. Ditto for Impress (in 2.0), and Draw has no equal in MSO. But Excel is likely the finest piece of software in MS's stable, and a damn high target for Calc.
I would be interested to hear more details on this. In which ways is Excel superior to Calc?
Cheers, Daniel.
Well, a lot of things... most probably, are right on par with Excel, but overall I just find Excel a lot easier to use. Charting, for one. It's just a lot easier to get the chart you want, and the way you want it to look in Excel. It's in a hundred and one little "ease of use" things that have been engineered into Excel over the years that are missing in Calc. And Excel is *fast* compared to Calc, much faster.
You probably won't notice the difference with average sized sheets, but you *really* notice it when you start working with a large data set. I posted on this a while back, and I attribute a lot of it to the XML file format of Calc. I understand all the very good reasons for preferring the OASIS formats overall -- and I think they're clearly superior for most purposes -- but it's a horribly inefficient way of storing a spreadsheet.
Try this: Go to ftp://ftp.arin.net/pub/stats/arin/delegated-arin-latest. This is a bunch of statistics on Internet number registries for the American Registry of Internet Numbers. It's a character-delimited text file -- like a csv but the delimiting character is a pipe "|". It has 52670 rows. Save it on your hd with an extension of .csv. Open it in Excel. Then tell it to Save As in the xls format. Now do the same thing in Calc (you need to use the beta due to the # of rows) -- save it in xls. Excel takes just a couple of seconds, but Calc takes a little longer. Not bad, though, you could deal with it. Now Save As either sxw or odt. Get a cup of coffee, call a friend, have lunch, watch some TV.. whatever. It *will* take that long. It was like about 20 minutes when I did it under WinXP, IIRC. It's even worse under Linux (FC3 with KDE). It took between 35 and 40 minutes to just save the raw data using 1.9.91 under Linux. I don't know how much of that is due to FC3, KDE, and OOo 1.9.91, but in the end it was simply unbearable. God help you if you have it set to autosave every so often.
And it wasn't just file saving, either. *Anything* I tried to do with that data set took a lot longer with Calc than Excel. I tried to use the Datapilot and it just crashed -- of course it *was* the beta, so I'll withhold judgement there, but using the Pivotable in Excel was a breeze. Every operation was nearly instantaneous. I had it chopped, minced, sliced and charted the way I needed it in under an hour. That's less time than it takes just to open the saved sxw and close it again without even doing anything to it in Calc.
If you were going to do this a lot, the money you would spend on both Windows and Excel would be worth it even if that's all you used it for.
Rod
Hi tanks for your files, I am happy to see this type of discussion because is more factual than just ranting. I didn't like the calc because is very subjective, with arguments like 'thinks I like' and 'I expect' are very vage and can easily be argued simply because you are used to see what Excel present you rather than what Calc present you so of course it would be more 'efficient'.
Remember OpenOffice.org is not a MSO clone, we don't want to be a clone. We want
to be efficient, which is a different direction.
However you other argument is challenging :)
I did went to the file and open it and time it, the Calc program opened in the usual 4 seconds with Quickstarter. The version is 1.1.4 and the hardware specs are AMD XP 2200 1.79 Ghz on a 500 MB RAM
I saved your text file as csv and open it with Calc it opened in 2.32 seconds. taking from the time I set the delimiter was a | symbol.
It saved in aprox 10.5 seconds as a sxc.
I do have to agree that the fileds were only saved until line 6253 at field D and not G like the rest of the lines, but this has to do with calc rowspan capacity.
I didn't use Excel to use the same process simply because I dont have it. But if
someone on a similar hardware want's to try it and spit out the times you are
welcome.
I also have to say that I was running many programs and that my capacity was just 80% and process were eating 43% of my total resources.
-- Alexandro Colorado Co-Leader of OpenOffice.org Spanish http://es.openoffice.org/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
