Sofware in Review
Tech news
at TheJemReport.com
Software reviews
at SoftwareinReview.com
Hardware reviews
at HardwareinReview.com
Discuss technology
at TJRForum.com
Sofware in Review → Office/business → Spreadsheets →

PlanMaker 2004 review

By Jem Matzan

Spreadsheet development has more or less solidified over the past year, and that means that the door is open for smaller companies and Free Software projects to walk in and grab market share with capable, inexpensive competition. That's probably the best way to describe PlanMaker for Linux: capable, inexpensive, cross-platform competition for Microsoft Excel 2003. You won't find a more Excel-compatible spreadsheet on any operating system, but all that glitters is not Microsoft compatibility.

The first thing you'll notice about PlanMaker for Linux is that it's considerably faster than OpenOffice.org Calc and about equally as fast as Gnumeric when starting up and when loading a moderately large worksheet, especially if there are embedded charts in it. Speed of calculation is equivalent to Excel or Gnumeric.

The interface uses an independent toolkit, so it's not controlled by GTK, Qt or Motif. It has a nice Excel 2003 gradient look to it when using the default settings, although you can change it to look more like older Windows, OS/2, or PocketPC styles. The menus are not identical to Excel's or any other program's, but they are by no means difficult to navigate if you're accustomed to using a spreadsheet application.

Features and limitations

Like all spreadsheet programs, PlanMaker has a row limit; in this case it's set to 16384 rows. This is below most of PlanMaker's competitors, such as Excel (65536 max rows) and OpenOffice.org Calc (32000 rows). Maximum columns for most spreadsheets stands at 256, and PlanMaker is no exception. If you try to import a worksheet that has more than 16384 rows, PlanMaker will truncate it, ignoring all data after that row. According to SoftMaker, the program is capable of handling more rows, but the code is not yet optimized to get ideal performance with larger worksheets. Future versions are likely to include support for 65536 rows.

Charting and graphing are quite advanced; both 2D and 3D chart types are provided, the most prominent being the surface chart. You can also set the color palette of the charts to specific schemes, including the same color palette used by Microsoft Excel. In other words if you really don't want someone to know that you're not using Excel to generate your charts, you can use Excel's default color scheme to make the output identical between the two programs.

Compatibility with other programs is outstanding, comparatively. This is where PlanMaker really shines -- it can read from and write to Excel 2003 worksheets even if they employ various Excel-only features. SoftMaker has a page detailing all of their Excel compatibility victories. While certainly you have to take a manufacturer's propaganda with a grain of salt, my own analysis of their test cases shows them to be completely accurate and as-advertised. What they don't show, of course, is the fact that any Excel sheet with any kind of macro in it will not have full functionality because of the lack of macro support in PlanMaker for Linux. Embedded macros are, however, perfectly preserved in an Excel worksheet when editing it with PlanMaker even though it can't make use of them. In writing to the Excel format from PlanMaker I was unable to find any flaws in translation when reading the same worksheets in Excel 2003.

The internationalization support is poor as of this writing; the program is only available in English, but it does have spelling dictionaries available in 17 different languages and automatic hyphenation for several more. Internationalized versions of PlanMaker are now in development for Spanish and Portuguese, and support for further languages will be available in the future, according to SoftMaker.

PlanMaker is both smaller in size (29MB) and faster to start than most of the other spreadsheet applications I've used. It's also lightning fast when it comes to opening a worksheet, even when there is a lot of data to load and formulas to calculate. One particularly data-heavy test case with a single large chart takes only ten seconds to load whereas the same worksheet takes more than a minute to load in StarOffice 7 Calc. The calculation speed is fast enough that you'll hardly think about it; it takes a lot longer to load the data and scroll through a large worksheet to get to an empty cell than it does to perform a numeric calculation.

There are, unfortunately, no analytical or statistical functions built into PlanMaker (covariance, forecasting, etc.) although there are certainly a large number of calculation functions. You also won't find any support for macros in the GNU/Linux or pocket/handheld PC editions. 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 BasicMaker into English is underway and will be available in future editions of PlanMaker for Windows; the GNU/Linux edition will also have macro support eventually.

The English documentation is nonexistent but SoftMaker does provide an enormous, comprehensive 400-page PDF manual in German, which is currently being translated into English.

Installation and licensing

There's no fancy installation program for PlanMaker for Linux -- you simply unpack a .tgz file and move the resulting directory to your preferred location. Your user home directory, /opt, or /usr/local are probably the best choices to store the program files.

Upon running the PlanMaker binary for the first time, you're asked for your email address and the product key, which is emailed to you when you purchase the software. While this step is required to install the program, there is no "phone home" activation scheme as in a number of other proprietary applications on the market today.

The license is of course proprietary -- this is not Free Software. You're allowed to install the software on multiple systems as long as PlanMaker is not concurrently used. You can also use it over a network as long as each client machine that accesses PlanMaker has its own license.

Conclusions

PlanMaker is a good value considering its price and features. It's not the kind of heavily armed force that Excel is, but if you're one of the large percentage of users who uses a small percentage of the features in Excel, PlanMaker is definitely an excellent low-cost alternative. If you need the best possible Excel compatibility in a GNU/Linux-based spreadsheet, PlanMaker is your best bet (outside of a virtual machine running Windows and Excel).

The Windows version and the GNU/Linux version are the same in most respects, the only exceptions being platform-dependent options with regard to fonts and memory usage, and the programmability through VB or Delphi. You can create a worksheet with PlanMaker for Linux and edit and use that same worksheet in the same program on a handheld or pocket PC or in Windows. There is no other spreadsheet program that works so effectively on as many platforms.

PlanMaker is limited in several ways, however. It doesn't have the internationalization support that Gnumeric has, or the macro capabilities that most other spreadsheets have, or the large worksheet support that high-end spreadsheet applications have. PlanMaker is a lot like its wordprocessing partner TextMaker in that it provides the functionality that most people will need to use while providing superior compatibility with Microsoft file formats at a low price. It fits its niche quite well.

Purpose Spreadsheet
Manufacturer SoftMaker
Operating systems GNU/Linux, Windows, Handheld PC, Pocket PC
License Proprietary
Market Cross-platform business users, GNU/Linux and Pocket/Handheld PC users
Price (retail) US$49.95 or €49.95 (includes VAT), but package deals and discounts for return customers are available
Previous version N/A
Product website Click here
Screen shots Screen shot directory