Currency formatting in calc lost after saving and reopening

I’m using calc on crunchbang linux 11 on one computer, and calc 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?

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.

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?

With works for me also with currency.