Want this question answered?
You can have a maximum of 2292 columns in an OpenOffice spreadsheet.
No - OpenOffice does not require registration of any kind.
A "cell" is a single field in the spreadsheet application 'Calc'
False ! Open Office Calc is quite happy to save files in .xls format !
The maximum number of collums available is 2292.
You could use the Calc program. I did one for a friend last using Open Office Calc. I designed the background etc, and used fomule in the spreadsheet to change the date by one day to the required number each month.
Absolutely - I use them regularly. The spreadsheet part of OpenOffice is 'Calc'
You would use a formula such as ... =sum(a3/10) or =sum(b12*a3)
The maximum number of rows is 1048576 and the maximum columns is 2292. Therefore the total number of cells available is 2,403,315,564 !
I tried to duplicate your 'error' - and it didn't do it on my copy of writer (OpenOffice version 3.3) - However, in the Calc program, it did change the format. The solution there, was to re-format the cell.
It includes :- Base - Database Calc - Spreadsheet Draw - Design Impress - Presentation Math - Formula editor Writer - Word-processor
Please check out openoffice at http://www.openoffice.org/. Open Office Calc is a spreadsheet program very similar to Excel.