Ask Your Question

Currency formatting in calc lost after saving and reopening [closed]

asked 2014-09-27 21:13:10 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 11:49:33.884734

2 Answers

Sort by » oldest newest most voted

answered 2014-09-27 23:02:24 +0200

marco gravatar image

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?

edit flag offensive delete link more


With works for me also with currency.

m.a.riosv gravatar imagem.a.riosv ( 2014-09-27 23:29:21 +0200 )edit

answered 2014-09-27 22:37:45 +0200

m.a.riosv gravatar image

updated 2014-09-27 23:30:09 +0200

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-27 21:13:10 +0200

Seen: 441 times

Last updated: Sep 27 '14