[Discuss] OpenOffice Calc Maximum Columns

[Alan Wardroper]

This from http://wiki.services.openoffice.org/wiki/FAQ:Calc
What is the maximum number of cells in an OpenOffice.org spreadsheet?

The maximum number of rows per sheet is 65536 (32000 in releases 1.x). The
maximum number of columns per sheet is 256. The maximum number of cells per
sheet is 16,777,216. The maximum number of sheets per workbook is 256, which
altogether makes it 4,294,967,296 cells per workbook, theoretically. Most
certainly the machine doesn't have enough addressable memory available to
put content in all cells.
Not sure about tht last part...I have 16 GB RAM in this 64-bit dual-dual
Linux box.


On 11/22/06, pw <p.willis at telus.net> wrote:
>
> Hello,
>
> Does anyone know, off the top of their head, if OpenOffice Calc is able
> to handle more than 256 columns?
>
> MS Excel has always had this limitation making it rather painful to
> use data with more columns.
>
>

-- 
==================
Alan Wardroper