https://bugs.documentfoundation.org/show_bug.cgi?id=152724
--- Comment #1 from ady <[email protected]> --- Simplified test to reproduce. 1_ New Calc spreadsheet; enter the numbers (one in each cell): -12 0 1 2_ Select the cells, Ctrl+1, type in the following custom Format Code in the Numbers Tab: _-?0;-?0;_-?0;@ (underscore, minus, question mark, zero, semicolon, minus, question mark, zero, semicolon, underscore, minus, question mark, zero, semicolon, at sign) and accept/OK the new format. 3_ Save the file. Note that the format is still the same as it was just introduced and it is displayed accordingly. 4_ Close the file. Reopen it. The cells are displayed differently (e.g. the zero value is not shown). 5_ Ctrl+1. See that the Format Code is changed, and it is NOT equivalent to what was introduced: ? -> # 0 -> # _- -> " " Less than 2 minutes to reproduce and confirm. -- You are receiving this mail because: You are the assignee for the bug.
