This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

max number of rows & vba scripting support

Posted by: Anonymous [ip: 195.241.94.180] on October 12, 2007 07:30 AM
What about the limit in number of rows in Calc? Is it still around 65000? I had a large spreadsheet last night and I thought I managed to open it completely in MS Excel while Calc gave me just around 65000 rows.

Then what keeps me from introducing Calc at my office is that in the financial services, excel is so widely used and I have come across spreadsheets with vba macros which I can't get working under Calc. It's no blame though because I know how MS feels about open source but that is the only thing that keeps me from doing it. If I only could send the excel spreadsheet to a Calc developer....(but he would have to sign a nda with me because I would be jeopardizing my employer's intellectual property)

#

Return to Office shootout: OpenOffice.org Calc vs. Microsoft Excel