Issue 35822 - When changing cell formatting, concatenate doesn't update
Summary: When changing cell formatting, concatenate doesn't update
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.3
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2004-10-19 19:34 UTC by fitirocz
Modified: 2007-05-02 12:20 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description fitirocz 2004-10-19 19:34:14 UTC
This is under Windows XP Pro SP2 and OOo1.1.3

1) in cell A1, enter 300
2) in cell B1, enter "hello"
3) in cell A2, enter formula =CONCATENATE(A1,B1)
4) hit enter
5) click on cell A1
6) on the toolbar click the "Number Format:Percent" button

The value of cell A1 changes to 30000.00%.
However the concatenated value stays the same and does not
update with the formatting changes.
Comment 1 frank 2004-10-20 09:34:36 UTC

changing the format of a1 is changing a view of a value, not the underlying data
itself. As we act in the same way as Excel does, I have to close this Issue as

Comment 2 frank 2004-10-20 09:34:53 UTC
closed invalid
Comment 3 frank 2007-05-02 12:20:58 UTC
*** Issue 75638 has been marked as a duplicate of this issue. ***