#Lotus symphony spreadsheet functions full
#Lotus symphony spreadsheet functions software

I didn't even bother opening the file in Excel compatibility is already a bust.Р”Р‡or those running KDE, the performance bump makes KSpread a better option than it is for those running GNOME. From KSpread to Calc, the data was maintained, but the formatting was mostly lost. I had to open KSpread's OASIS open document file in OO.o Calc, and then save it as. Then there is the fact that KSpread doesn't even have the option to save as an. Either way there are just too many columns that need adjusting from the test. This may all be by design for some reason, or it could be buggy. Strangely, the entries in the last column spilled over into the next, instead of displaying the arrows. Other than the first column, KSpread will show as many characters as it can along with a red arrow indicating that the column width needs to be enlarged. Like Lotus Symphony, KSpread displays pound signs, but only in the first column. KSpread has extremely small cells, which don't display more than three characters by default. Overall, OO.o's Calc has the most comprehensive feature set, making it the best option for anyone more concerned with open standards than MS Office compatibility. All data, equations, and the rest of the formatting was completely intact. As with the number of characters within a cell, I suspect this to be a default formatting choice as well. xls file, it displayed almost perfectly in Excel 2007. When the Calc spreadsheet was saved as an.

This can also be changed in the format/cells menu with little effort.

#Lotus symphony spreadsheet functions full

Fortunately, the actual data is intact, you need only highlight a cell to see the full string of numerals in the input line. On the other hand, for those who need to quickly reference all of the information displayed in every cell of a spreadsheet, this is more of a nuisance. For the spreadsheet-dabbler, this could be considered a feature-a way to clean up the screen and make the data easier for glancing. Calc only displays up to two decimal points by default. Initially, OO.o Calc was the worst performer when it came to properly displaying the test. Open standards aside, as far as Excel compatibility is concerned, GNUmeric is the tightest package on the list for being free, simple, and functional. The latest version reports improvements in this area. Apparently, GNUmeric hasn't worked out its ODF compliance quite yet, specifically in the release we tested. ods files created in other Linux spreadsheet apps with formatting intact, and vice versa. The one strange thing that I did notice was GNUmeric's inability to open. This file however, lost most of its formatting when opened in Excel 2007. xlsx file type, since GNUmeric was the only app with that option at the time of testing. Additionally, I saved the spreadsheet created in GNUmeric as the new. xls file also displayed perfectly when opened from within Excel 2007. xls file opened perfectly in GNUmeric, displaying exactly the same as it did within Excel. Those with poor vision will most certainly appreciate this.

#Lotus symphony spreadsheet functions software

The interface, file body, and text are all bigger than any other spreadsheet software on our list.