Issue 46076

Summary: The number formatting of a cell is not maintained after the cell contents have been modified.
Product: Writer Reporter: mbarry <realoracle>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description mbarry 2005-03-27 07:16:54 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.
Comment 1 eric.savary 2005-03-27 14:11:03 UTC
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.
Comment 2 michael.ruess 2005-07-07 07:48:35 UTC
*** Issue 51635 has been marked as a duplicate of this issue. ***
Comment 3 oreg 2007-09-15 01:40:42 UTC
This is a duplicate of bug #54397.
Comment 4 Oliver Specht 2009-11-30 07:55:28 UTC
*** Issue 106923 has been marked as a duplicate of this issue. ***
Comment 5 Marcus 2017-05-20 11:24:51 UTC
Reset assigne to the default "issues@openoffice.apache.org".
Comment 6 Marcus 2017-05-20 11:25:59 UTC
Reset assigne to the default "issues@openoffice.apache.org".