Why does the spreadsheet change some numbers in cells to ###

when saving a spreadsheet numbers in cells are changed to ####

The number is too big to fit in the cell width. Either drag the column header to widen the cells, or right click in the header and select a width option.

You may find [Tutorial] Ten concepts that every Calc user should know (View topic) • Apache OpenOffice Community Forum useful reading if you are new to spreadsheets.