Ummm, a lot of this article reads as an apology for Open Office. I would love to see OO work better on such big sheets, but it is unfortunate that people disparage Ou for his factual report. One observation is that inserting a value into an unreferenced cell costs 9 or 10 CPU seconds on a 3GHz CPU, which suggests that recalculation takes little account of dependencies. Suggested Options/Memory tweaks ( ) do not help much.
OO is almost unusably slow, and saves the file at 2 to 3 times the size of M$. My spreadsheet is a sort of diary/time log with a lot of running totals, long chains of references and lookup functions. PJTraill 10:33, 19 January 2007 (UTC) I'm sorry to say that my experience with a 65,000 x 40 spreadsheet conforms to the Ou article. Keep in mind, however, this is unprecedented in Wikipedia as we have no articles in Category:Software_comparison that has focused on benchmarking results, not even for database comparison which is rather performance sensitive in nature. In addition, I would suggest testing the same set of samples using Gnumeric as well if it to be a comparison of general office suite. Also other sample files can be tested, like this one - which focuses on smaller files for daily use.
However, due to the highly disputable nature of benchmarking, I suggest writers perform their due duty to do some independent verification of those benchmark results on their systems using George's samples from his blog, like these from. But since this is a comparison article, I suggest contributors should try to write it in an article with a title like Comparison of office suites or Comparison of office performance. Right now it is moved to this article under the above topic. Lately there is a lot of input on Performance of Calc based on a single blog on the web. Preceding unsigned comment added by DrKC MD ( talk
Excel Ĭalc provides a number of features not present in Excel, including a system which automatically defines series for graphing, based on the layout of the user's data.Įxplain? Excel defines series automatically. Ondrejsv ( talk) 22:57, 24 November 2010 (UTC) Calc vs. Not saying that it's not a bug but a compatibility feature (with Lotus 1-2-3), indeed. This is simply false (check yourself what is 1904 date system in Excel). I deleted a sentence which claimed that handling year 1900 is a unique feature of Calc and even Excel does not handle it correctly. This page serious needs to be rewritten from scratch following WikiPedia's guidelines. Far too much screen space taken up by a commercial detractor. This article should be about Calc, its feature set, its history, how it is extended/integrated with other applications. The comparison w/ Excel should be removed, and anything approximating information in that section put into the page comparing spreadsheets. This page is supposed to be about OOo (or Libre Office Calc), which it has scant info.
I just happened to check this page looking for some information on Calc, hoping to find more information and less antagonism from Microsoft fan-boys.
Important software product, but not so great WikiPedia article Untitled