Apache OpenOffice (AOO) Bugzilla – Issue 112671
Cell format changing on me after save and close
Last modified: 2013-02-21 19:23:06 UTC
I am having a problem where some of the cell formats are changing on me after I save and close a spreadsheet and reopen on another occasion. The main issue seems to be the changing of decimal places, leading zeros and thousands separator. I assign the cells to 2 decimal places, no leading zeros and check the thousands separator box. When I am formatting the cells, I highlight an entire row by clicking on the row letter designation, then format cells. I save and close the spreadsheet, and when I reopen it later, they will change to zero decimal places, 1 leading zero and the thousands separator box will uncheck. This is my first issue report, I hope I followed the procedure correctly and apologise in advance if I did not do it as I should have.
Format is preserved in Rev. 1400866.