Issue 46076 - The number formatting of a cell is not maintained after the cell contents have been modified.
Summary: The number formatting of a cell is not maintained after the cell contents hav...
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 51635 106923 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-03-27 07:16 UTC by mbarry
Modified: 2017-05-20 11:25 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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".