Open Office Calc question
 

One for the Open Office gurus out there...........

There appears to be a limit on the number of columns, which is limiting a sheet I am developing. About the 300 mark, seems low, and it will not let me add/insert any more.

Is there a setting to change this? What am I missing?


Snooze :ugh:

I think the max size for a spreadsheet in OpenOffice 2.0 Calc is 256 columns x 65,536 rows - like previous Excel versions.

Apparently, Excel 2007 sheets can be 16,385 columns x 1,048,576 rows.

Not enough columns? Just used tabbed worksheets to increase the "width" of your spreadsheet.

Thanks Stagger,

Not the answer I was hoping for...............:hmm:

I've reworked the design using separate sheets for different staff categories. I'd been hoping to keep data entry on one sheet since the data didn't vary by category.

Now to see how it translates into .xls format...............


Snooze