No - OpenOffice does not require registration of any kind.
You can have a maximum of 2292 columns in an OpenOffice spreadsheet.
A "cell" is a single field in the spreadsheet application 'Calc'
Please check out openoffice at http://www.openoffice.org/. Open Office Calc is a spreadsheet program very similar to Excel.
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.
False ! Open Office Calc is quite happy to save files in .xls format !
To hide zero values in OpenOffice Calc, you can go to the menu and select "Tools," then "Options." Under "OpenOffice Calc," choose "View" and check the box for "Zero values" to hide them. Alternatively, you can use a custom number format by selecting the cells, right-clicking to choose "Format Cells," and then entering a format like 0;-0;;@, which will display numbers normally but hide zeros.
The maximum number of collums available is 2292.
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 !
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)
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.
To change picture alignment in OpenOffice Calc, first select the image you want to adjust. Then, right-click on the image and choose "Position and Size" from the context menu. In the dialog that appears, you can adjust the alignment settings under the "Position" tab, specifying horizontal and vertical alignment options. After making your adjustments, click "OK" to apply the changes.