PDA

View Full Version : Open Office Calc question


Capt Snooze
25th Apr 2007, 04:13
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:

stagger
25th Apr 2007, 07:25
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.

Capt Snooze
2nd May 2007, 01:18
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