Currency formatting in calc lost after saving and reopening

[marco]

I’m using calc 4.1.6.2 on crunchbang linux 11 on one computer, and calc 4.2.6.3 on Ubuntu 14.04 on another. On both computers, when I format a row as currency, the formatting in the empty cells in the row always switches back to number when I save and reopen the spreadsheet. To reproduce:

1. Open a new spreadsheet.
2. Format all of column A to currency.
3. Enter some numbers in the the first few cells of column A. They are formatted as currency.
4. Save and close the spreadsheet.
5. Open the spreadsheet.
6. Enter a number in the next available empty cell in column A and press Enter. It is not formatted as currency.

I haven’t been able to find a single reference to this b googling, although it seems like a pretty serious bug. If it’s not a bug, can anyone see what I’m doing wrong?

[mariosv]

Don’t switch back for me. After reload and if previous to enter a number you can verify what format cell has with Ctrl+1 you can see it’s date.

But I don’t think it is a bug, when you enter a date in a cell, date format is applied, same when you enter a number in cell with date format, it changes to a number format.

[marco]

i just checked, and it works fine for dates for me too. did you try it with currency (money) as i did? does it work for you? if it does, what version of libreoffice and what operating system are you using?

[mariosv]

With 4.1.6.2+4.2.6.3 works for me also with currency.