Apache OpenOffice (AOO) Bugzilla – Issue 46076
The number formatting of a cell is not maintained after the cell contents have been modified.
Last modified: 2017-05-20 11:25:59 UTC
After selecting a format for a particular cell, the format is not maintained after modifying the contents of the cell. 1) Start Open Office Writer. 2) Select table from the menu and select insert and table. 3) Select ok to create a two by two table. 4) Type the number 1 in both of the cells in the second row. 5) Right-click on the left cell and choose number format. 6) Choose currency from the Category and the 4th entry from the Format such that the format code is: [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00. 7) Right-click on the right cell and choose number format. 8) Type BOOLEAN in the format code field. 9) The left field should contain $1.00 and the right field should contain TRUE. 10) Modify both field, the left by changing the value to 10, and the right changing the value to 0. Notice that you must follow the format procedure again to reformat the field.
ES->OS: between enhancement and bug and maybe 2 ptoblems: 1) bug: changing the value of a cell formatted as boolean always resets the format to Standard. 2) Feature: changing the value of a cell formatted as (for example) currency resets the format to Text *when the Number Recognition is ON*. -> the number recognition shouldn't overwrite the format set to the cell. Please tell me if you want to split this issue.
*** Issue 51635 has been marked as a duplicate of this issue. ***
This is a duplicate of bug #54397.
*** Issue 106923 has been marked as a duplicate of this issue. ***
Reset assigne to the default "issues@openoffice.apache.org".