NewsForge Reviews Excel Clone for Linux 312
martin-k writes "NewsForge has a glowing review about PlanMaker for Linux, a new spreadsheet for Linux that is much more compatible with Microsoft Excel than the competition and speedier, too. PlanMaker has Excel-compatible charting and AutoShapes and reads and writes any Excel file you throw at it. Here is a chart comparing Excel, OpenOffice.org, and PlanMaker." Yes, Virginia, NewsForge is also part of OSDN, like Slashdot.
Interesting.... (Score:3, Informative)
Re:Interesting.... (Score:2, Insightful)
Re:Interesting.... (Score:5, Informative)
Re:Interesting.... (Score:2, Insightful)
> weakened userbase of Gnumeric, which was and is a better and more compatible app. I don't see you whining about that.
As far as most practical users are concerned, who gives a damn.
Sure it'd be great if Linux had a perfectly compatible and "free" Office application but it doesn't (yet).
Why is it that "yet another" syndrom is always welcome when the other app is F/OSS and trashed when the other app is
Re:Interesting.... (Score:2)
I disagree. The opensource community is about choice. Could you picture a world with 1 linux distribution or 1 browser? Part of the power in opensource that freedom of choice. The question is not "where do you want to go today?" it is "how do I get job done today". Also, I find the whole opensource vs. MS thing a waste of energy. At the end of the day open source has no competition because it's a debate of ideolog
Re:Interesting.... (Score:5, Interesting)
From working in a large company I can say that most people only ever used a small number of features - excel becomes a requirement because "programmers" write utilities in VBA!
Surely being VBA compatible wouldnt be that hard, it is a joke of a language.
Re:Interesting.... (Score:3, Informative)
Unfortunately it's a non-trivial amount of work to write a vba clone. Not impossible by any means, but it does require a community to do it. We started the gb project years ago, but it faded away without real progress. I'm currently pinning my hopes on mono and it's basic implementation.
Re:Interesting.... (Score:4, Insightful)
ARRRGGG. This is the attitude that has caused there to be a dominant platform.
I don't want Linux to be dominant, I don't want Macs to be dominant and I don't want Windows to be dominant. When there is a variety of system, they need to embrace open standards (open source or not), and compete. This can provide better software for all.
Now mod me down because my rant is off topic.
Re:Interesting.... (Score:2)
Let me be the first (Score:5, Informative)
gnumeric exists. Acknowledge both its existence and superiority in the world of spreadsheets.
Re:Let me be the first (Score:2, Funny)
Re:Let me be the first (Score:2)
Superiority? Almost everyone else uses Excel... and the ability to read other people's spreadsheets is a very important characteristic in most environments where spreadsheets are used.
That's why Planmaker (and OpenOffice to some extent) should scare Microsoft. People may think MS Office stinks, but the pain of having to convert all your existing files, and finding a way to exchange files with your MS Office u
Re:Let me be the first (Score:2, Insightful)
MS Office Doesn't Stink (Score:5, Interesting)
I like OpenOffice as well, however I never use any features that would conflict between OO and MS Office with the exception of passwords. However, you should never use an MS password if what your storing is actually important. Downloading cracking tools is very easy and free (astalavista.box.sk). Real encryption is necessary for critical documents/spreadsheets not the garbage built into access/excel/word. I've cracked so many competitors stupid presentation info it's sad really that they trust adding a password at all (pdf's as well).
MS Office is great but overkill for my company so we just use OO and it works well and is missing any license violations/bsa audits.
Pfft (Score:4, Informative)
Any bets.. (Score:3, Interesting)
My guess is that they will release a new security patch for Excel within a month.
Re:Any bets.. (Score:2)
Re:Any bets.. (Score:2)
Re:Any bets.. (Score:3, Informative)
They left out Gnumeric (Score:5, Informative)
Re:They left out Gnumeric (Score:5, Insightful)
Re:They left out Gnumeric (Score:5, Interesting)
This is what FreeDesktop.org people need to realise: The single MOST IMPORTANT thing you can do is agree on a standard Linux component embedding (OLE/COM) technology, and then maybe one day people _will_ have the choice of using gnumeric instead of OOo Calc to read excel data embedded in word documents being edited in OOo Writer. But
it DOESN'T WORK YET.
Microsoft just dictates their OLE in their normal stalinist style, but we can't. So we need to have a lively technical debate, and then broad agreement on a baseline set. I recommend specifying protocol, not binary API, in the normal X fashion, but make it good!
Re:They left out Gnumeric (Score:3, Informative)
Re:They left out Gnumeric (Score:2, Interesting)
What is, exactly, the problem? (Score:2, Insightful)
I don't really understand what is the real problem about it. Yes,
Re:What is, exactly, the problem? (Score:2)
The problem is that Mono falls between two stools: it's neither a complete Dotnet clone, meaning that users get no true Dotnet/Mono portability; nor has it confined itself to merely "adapting" ideas from Dotnet - it's similarity is a good deal closer than that.
Mono is therefore asking its users to risk infringing MS's IP without delivering the associated benefit of real portability. There's little likelihood of Mono ever b
Re:What is, exactly, the problem? (Score:2)
We can then move on to look at the merits of Mono, Java, Parrot etc. from the same standpoint. Regarding the VM, I'd be interested in your source indicating that the Mono VM is safer and more reliable than the "Java" VM. You d
Re:What is, exactly, the problem? (Score:2)
Re:They left out Gnumeric (Score:5, Interesting)
Re:They left out Gnumeric (Score:3, Interesting)
Re:They left out Gnumeric (Score:3, Insightful)
For most people Windows comes pre-installed on their computer, and Dell (or whoever) didn't pay too much to Windows for the license. And they probably need Windows anyway for some other applications.
But to get MS Office means sending a lot more of your money to MS, or pretending you're a teacher or something like that. And if you do buy MSOffice you're going to start spreading MSOffice documents. If you install some cross-platform MSOffice alternative you'll be one (giant) st
Gnumeric on Windows via Cygwin (Score:2)
References.
Cygwin homepage [cygwin.com]
Gnome 1.4 apps for Cygwin [sourceforge.net]
Cygwin Gnome homepage [sourceforge.net]
KDE on Cygwin homepage [sourceforge.net]
Cygwin is a brilliant tool to help manage a migration from Windows to Linux. I don't know why we dont hear of it more.
Re:Gnumeric on Windows via Cygwin - More detail (Score:2)
Whether this means currently the available binaries won't run, I'm not sure. It may be necessary to do a manual compile from the Gnumeric source code using Cygwin-GCC. This has caught my attention now.....
Re:Gnumeric on Windows via Cygwin (Score:2)
There's already Gnome 2 for Cygwin [cygnome2.sf.net], but Gnumeric wasn't ported (or at least packaged) yet.
It would be nice if Debian MS W32 [debian.org] went forward, so that we'd have a better installer than Cygwin's.
Re:They left out Gnumeric (Score:2)
No, it is a Gnome implementation. That means it can be relatively easily ported to MS Windows (Red Hat Cygwin) or Mac OS X. There were some Gnome ports around, don't know if they live still.
Re:They left out Gnumeric (Score:2)
Gnumeric 1.4 with Windows support is just around the corner. Abiword List post by Jody [abisource.com]
Re:They left out Gnumeric (Score:3, Informative)
and cvs head is ready and all of its dependencies compile under win32 with gtk-2.4.x. We're very very close to getting a release out.
Re:gnumeric it is too good (Score:2)
That may very well be the case. After all the comparision is done by people trying to sell a product. Their product have to be better (in at least one way) than every product they compare themselves to. If they couldn't find any advantage of their own product over gnumeric, it makes sense to exclude gnumeric from the comparision.
Re:gnumeric it is too good (Score:2, Interesting)
Chosing test files is part of the comparision. I wouldn't be surprised if the result would look differently by trying a set of xls files relevant for your own work. Of course in my case that set would be empty, I can't remember when I last came across an xls file. If I ever need to open such a file it will probably be because somebody email me one, there is no way I'm going to pay this amount of money for a program to read a file somebody send to me. At l
For scientific calculations, clones are useless (Score:4, Interesting)
I was hoping the open source or free versions would overcome this limitation but none of them do so as this makes them incompatible with excel.
can't someone figure out a smart solution for this without asking the user to modify the source themselves??
Re:For scientific calculations, clones are useless (Score:4, Informative)
If you need more than 64k of data use a app made for scientific work, like R [r-project.org], mupad [mupad.com] or Mathematica [osu.edu].
numeric package for science, DB for accouting (Score:2, Informative)
Thats just wrong - it depends on the task. Spreadsheets are the right tools for a budget calulation resulting in a nice formatted table for the boss. If you have more then 64K lines of data, you should use something like R, mupad, mathematica or octave - simply because they are more useable for this task - 64k lines of data do not need a pretty layout - they will (almost) never get printed - they need a tool to be transparently processed. Spreadsheets dont
Re:For scientific calculations, clones are useless (Score:3, Insightful)
Re:For scientific calculations, clones are useless (Score:3, Funny)
Re:The Row Limit is Definitely Frustrating (Score:4, Informative)
Performance. We will increase PlanMaker's row limit (basically, the sky is the limit) once we have tweaked certain routines, like sorting and transposing.
Re:The Row Limit is Definitely Frustrating (Score:3, Interesting)
Actually, I venture that you really should be doing it in a database program. Spreadshe
Re:The Row Limit is Definitely Frustrating (Score:4, Informative)
- edit SHEET_MAX_ROWS in gnumeric.h
- compile
More sense (Score:5, Insightful)
Re:More sense (Score:5, Informative)
They survived all the storms of time by getting large contracts with public administrations like towns and counties. And there they probably got most of their bugreports from, because a town administration can be sure to get lots of quite strange documents, in content and in form.
Re:More sense (Score:2)
Re:More sense (Score:3, Informative)
Non-Free (Score:5, Insightful)
Whatever it's qualities may be, this PlanMaker thingie is non-free (as in speech and as in beer). This makes it very much uninteresting for quite some people. If there's a decent alternative that's free (hint: there are, several), then that's the way to go IMHO.
How long can this last? (Score:3, Insightful)
Re:How long can this last? (Score:3, Informative)
Re:How long can this last? (Score:2)
It depends. Maybe they paid MS for a
Obvious question (Score:3, Interesting)
Is it open source?
Second, they claim better Excel compatibility than OOo, how did they manage this.
Maybe they licensed some code?
I like having good compatibility, from a technical point of view, we are only going to benefit from better compatibility if there is documentation on how it was achieved. Could anyone mail OOo a link to those specs?
Re:Obvious question (Score:3, Informative)
2) They certainly have good filters for such a young project, but the claim of _better_ seems questionable. The test cases they provide are not consistent with my testing of the beta.
Why not buy Win4Lin/Wine and run Excel? (Score:5, Insightful)
Alternatively you get codeweavers wine for $40 and run your old MS Office tools and at the same time support wine development.
More important is to have OpenOffice have all the Excel charting functionality. Currently OOo Charting tools are a bit more crude.
Compatibility for WordArt is not at the top of my requirements list for compatibility.
Re:Why not buy Win4Lin/Wine and run Excel? (Score:3, Funny)
It's definitely on my list of things I don't want to see compatibility for.
Re:Why not buy Win4Lin/Wine and run Excel? (Score:2)
gnumeric is also very good (Score:3, Funny)
besides..
Macros rear their ugly head again. (Score:5, Insightful)
What about the Macros? Surely this is one of the most important parts of Excel, and could even be one of the things that makes it such an indespensable tool for many companies. It gives it the freedom to move outside of the solely number crunching arena, and into a million and one other places.
It's all very well having a new Excel clone for linux that can retain my conditional formatting better than ever, but 99% of the sheets I use here involve macros to open many
I guess at the end of the day, lockdown isn't lockdown after all when there isn't a viable alternative.
So you are using Excel as a database? (Score:4, Informative)
That sounds like a database to me. Using Excel as a database is one of the most harmful things there are. It's slow, eats a lot of memory, and I have seen entire databases go to hell because of slight bugs in the macros or the interpreter.
Re:So you are using Excel as a database? (Score:3, Insightful)
And you STILL have the problem of having to pull data from many sources, process it, reformat, etc. So now we need a REAL coder (no insult intended, VBA guys) to write programs in- C#? Java? Even perl or pytho
Re:Macros rear their ugly head again. (Score:2)
Re:Macros rear their ugly head again. (Score:5, Insightful)
The number of cases of huge excel/macro combinations dieing messily, or corrupting the data is legion. I'm no database specialist (network admin myself), but the guy I work with who is, has several stories of companies that regretted relying on access or excel/vb for critical data processing, and one of them nearly went under when they found one of their (many) linked spreadsheets had been corrupted and had been feeding bad data into their conclusions for months.
Seriously, PLEASE don't rely on a cheap and cheerful desktop products (which is what ms office and openoffice are) to manage your company dataflow. Get a proper system on the backend. Use excel to munge a bit on the front end, do the graphs etc, fine - but put your data-storage and processing into a proper database system. It'll cost you more, but it just ain't worth the risk.
Re:Macros rear their ugly head again. (Score:2)
From the article:
"The Windows edition does have a certain amount of programmability through a bring-your-own-language method. By importing PlanMaker's type library into Visual Basic or Borland Delphi, you can program macros and scripts in an interface similar to that of Microsoft Excel. SoftMaker does have a VBA-compatible macro language called BasicMaker, but currently it is only supported in the Windows version of the SoftMaker office suite in the German language. Translation of
Re:Macros rear their ugly head again. (Score:2)
Firstly, the data is mostly numbers in particular time slots on certain days. These require manipulation, and the most straightforward way to do this is in a spreadsheet environment.
Secondly, ease of use - it's easier to train a relatively new user to use Excel for mathematical functions and for some data analysis, rather than to train a relatively new user in Excel for mathematical work, and Access for data analysis.
Re:Macros rear their ugly head again. (Score:2)
Initially you've got an Excel spreadsheet that you've got to update, so maybe you write a small macro that does a few repetitive tasks. Then someone says 'Hey, wouldn't it be great if...' and you slap together an interface for your colleague.
Next thing you know, people are modifying and extending this simple program into something really useful. And all without having to install a
Intergration is important (Score:3, Insightful)
Also - the ability for it to follow the theme of the user's desktop is not yet considered important it is getting there.
I do not know the product, but I do not see the advantages it gives me ofer the free ones significant, and many of the free ones have advantages over it.
As far as interplay is concerned, can it talk the OpenOffice formats? These are becoming more and more deployed.
I'm sorry SoftMaker - you may have a good product, but it has no relevance to me - and I do not seeing it have in the future either.
Re:Intergration is important (Score:2)
In my experience of teaching supporting, teaching and using office software, this kind of thing was very fashionable a few years ago, but most experienced users don't do it.
Why? Because its a memory hog, and it is extremely version and system dependent. Its a very mixed software world, and not everyone runs Office XP. Far more important than embedding applications is the ability to exchange the informati
Shameless. (Score:5, Interesting)
Re:Shameless. (Score:2)
Or is it possible that some people use Linux because they like Unix? I was using BSDi and Coherent before that. I've bought hundreds of dollars worth of commercial Linux software over the years, and been very happy with it.
Many of the things that people have bitched about being "not available for Linux" have just not been available _free_ for Linux. Over time, there have been FOSS proj
Re:Shameless. (Score:2)
Re:Shameless. (Score:2)
Non-Free, Why not just use Excel? (Score:5, Insightful)
When nothing other than Excel will do, why not just run Citrix (or some virtual box if you don't have access to a Citrix server) and run real Excel?
If you seriously need Excel, I doubt this will be a satisfactory long-term solution, for any number of reasons. Plus, it ain't free.
In sum, who needs another me-too piece of proprietary software?
Comprehensive compatibility list? (Score:3, Informative)
Does anyone maintain a list of features OO doesn't support?
I know that the only incompatibility I found was when I had a formula that referred to a calculated value in another tab, and then yet another cell that referred to the first formula, I got an error when I opened the file in Excel. When I opened it in Excel, went to the formula and hit enter, it recalculated and got a non-error.
To example, sheet 1 A1 = 1, sheet 1 A2 = A1 * 2, sheet 2 A1 = sheet 1 A2 * 4, sheet 2 A2 = sheet 2 A1 * 5. In this example, sheet 2 A2 is an error in all versions of Excel I could find, and was good as of all versions of OO I could find last December.
I always got the OO errors about how data may be lost by saving in the non-native file format, but aside from the above case, I never lost any content.
Re:Comprehensive compatibility list? (Score:2)
My father, Linux, and the spreadsheet battle (Score:4, Insightful)
Does anyone know if you can make a bulleted list within PlanMaker without too much trouble? Yes, I know that this feature doesn't make much sense, but it's one of the major factors preventing my father from switching to Linux and from regularly using open-source office software. My dad gave up on Open Office in short order.
It seems that for open-source software, and Linux in particular, to appeal to the business world, the software must make the features business execs regularly use, such as tools for making memos, readily accessible and as similar as possible to the features in MS Office. My father, for example, is eager to try something new, but becomes frustrated when he needs to relearn everything or when he has trouble importing documents and spreadsheets from other programs
Maybe PlanMaker will convince him to give Linux another chance. I hope so.
I don't care about Excel, what about OO (Score:4, Interesting)
As a person who writes software which can read/write OO files I see a couple reasons why OO sheets may tend to read/write more slowly.
- The OO files are compressed zip files. Gotta spend a few precious seconds uncompressing them.
- The files contain very verbose XML which has to be parsed. My guess is that Excel sheets in a lot of cases have far fewer bytes to accomplish the same thing.
Re:I don't care about Excel, what about OO (Score:3, Interesting)
Re:I don't care about Excel, what about OO (Score:3, Interesting)
You people are getting on my nerves (Score:4, Insightful)
Second, I can understand that people want to run a system that is 100% open source. If you want to, do it, but please also stop your whining, that this has not been ported to linux and that has not been ported to linux.
Softmaker is offering a spreadsheat that seems to be more compatible with Excel then other spreadsheats on linux. I can't possibly see how this is bad.
No support for macros (Score:4, Interesting)
What sort of serious spreadsheet user doesn't employ macros?
And they're selling it for Linux - a platform where most users know how to do a bit of scripting.
If I were in a Linux shop and had to do power-user type spreadsheet stuff, and this were the only Linux option, it would be enough to motivate me to sneak in a copy of Windows so I could get my job done efficiently.
hmm (Score:2, Insightful)
Re:hmm (Score:3, Informative)
Included with SUSE 9.1 (Score:3, Informative)
It works well for me (Score:5, Informative)
However, I just tried the trial version of PlanMaker for LInux and it had no trouble displaying the graphs exactly as they should and was able to open even the largest file in just a few seconds.
Horay for a viable alternative, even if it is not open source.
Integration (Score:2)
Integration is what is reqired, to be able to interact directly with other applactions natively, i.e. a 'suite'.
Re:Integration (Score:2)
CLI (Score:3, Insightful)
This isn't a case of CLI is better than GUI. It is a case of CLI is easier to automate.
excle2csv foo.* | automated && echo Done.
You just can't do that with a GUI app. There are things that are easier with a GUI. But the basics (Save As file conversion being one of them) that should be available from the command line.
Re:CLI (Score:4, Informative)
ssconvert foo.xls foo.csv
Whaddaya mean compatible? (Score:2, Funny)
Excel's power (Score:4, Interesting)
I think the main thing Open Source spreadsheet programs need to compete with Excel is something fully compatible with Visual Basic code, as crappy as it might be. Or at least something to migrate from the Visual Basic to some other kind of scripting language with the same functionality.
Re:Pretty Cool (Score:2)
Re:Remember This Marketing Strategy (Score:2, Funny)
Please get this [microsoft.com] cloned for linux and I would send you ten penguins for dinner ( sorry no 'wine' in stock )
Graphs and Charts for Scientific Publication (Score:3, Interesting)
Re:It's not free. (Score:4, Funny)
Re:Planmaker uses GTK Toolkit (Score:2)
ldd planmaker /lib/libc.so.6 (0x40021000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
libc.so.6 =>
That's it.
Re:Took exactly 2 minutes to install - and delete (Score:2)