Discussion on:

Choose the right spreadsheet: Excel XP, Quattro Pro 9, or Calc 6

If you are going to compare spreadsheets, why not look at important features which everyone including Microsoft fails to consider--it would be a nice upgrade feature to get beyond teh 65000 row limitation--how many rows each of the spreadsheets allows.

I totally agree that Lotus 123 should have been considered. It was the original and the best and the others are merely poor rip-offs of the genuine article.
If I am ever forced to use excel I always turn on the Lotus transition, navigation and formula evaluation options - that makes excel almost useable.
TOC

But can you use Pivot Tables in Star office? So far I have not found a way of using them, especially when I want to pivot external data such as .CUB files.

These are some of the shallowest product reviews or comparisons I've ever seen. But hey look at the credentials of the author -what do you expect from an MCSE.

You hit the nail on the head with you observation regarding programming. It is truly the defining difference in a spreadsheet program. If you don't need to create applications or automate a spreadsheet than pretty much any one will do. But if you want that functionality Excel takes the cake (warts and all).

just type limits in excels help and ....
Worksheet and workbook specifications

Feature Specification
Maximum number of scenarios Limited by available memory; a summary report shows only the first 251 scenarios
Maximum number of changing cells in a scenario 32
Maximum number of adjustable cells in Solver 200
Maximum number of named views in a workbook Limited by available memory, although the Custom Views dialog box lists only the first 256 views
Number precision 15 digits
Largest allowed positive number 9.99999999999999E307
Smallest allowed negative number -9.99999999999999E307
Smallest allowed positive number 1E-307
Largest allowed negative number -1E-307
Maximum number of iterations 32,767
Maximum size of worksheet arrays 6,553 elements
Maximum number of colors in a workbook 56
Maximum number of cell styles in a workbook 4,000
Maximum number of custom number formats Limited by available memory
Maximum number of selected ranges 2,048
Maximum number of names in a workbook Limited by available memory
Maximum number of arguments in a function 30
Maximum number of nested levels of functions 7
Number of available worksheet functions 329
Maximum number of custom functions Limited by available memory
Maximum number of windows in a workbook Limited only by system resources
Maximum number of panes in a window 4
Maximum number of linked sheets Limited by available memory
Zoom range 10 percent to 400 percent
Maximum number of reports Limitedby available memory
Maximum number of sort references 3 in a single sort; unlimited when using sequential sorts
Maximum number of undo levels 16 (default)
Maximum number of fields in a data form 32
Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation December 31, 9999
Maximum number of PivotTables on a sheet Limited by available memory