Issue 80861 - Calc fails to update number-format of referencing cells, document has to be saved and reloaded
Summary: Calc fails to update number-format of referencing cells, document has to be s...
Status: CLOSED DUPLICATE of issue 75638
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-20 18:51 UTC by norbert2
Modified: 2007-10-12 12:50 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2007-08-20 18:51:52 UTC 
Hi.

Please ...

- open a blank spreadsheet

- enter "10" into cell A1

- apply Currency-format to cell A1

- enter "=A1" into cell A2:

Note that the Currency-format is adopted for A2. This is ok.

(Right-click A2 "Format Cells...", in the tab "Numbers" you can see, that
"Standard"-format is selected. This is in my oppinion ok: Calc uses format of
referenced cell if format "Standard" is applied. )

- right-click cell A1 "Default" in order to remove Currency-format

Note that A2 still uses Currency-format!
- open a blank spreadsheet

- enter "10" into cell A1

- apply Currency-format to A1

- enter "=A1" into cell A2:

Note that the Currency-format is adopted for A2. This is ok.

(Right-click A2 "Format Cells...", in the tab "Numbers" you can see, that
"Standard"-format is still selected.)

- save the spreadsheet as ods-file

- close the spreadsheet

- reload the saved spreadsheet:

Now A2 uses correctly the format of A1.



(Note: If you do the same steps but use xls-format instead of ods-format, A2
gets Currency-format applied in the saved xml-file.)
Comment 1 norbert2 2007-08-20 18:53:52 UTC 
Please forgive me for Priority P2. But I want to have this issue to be quickly
confirmed. :-)

Feel free to set it to P3, although I think this should be fixed as soon as
possible.
Comment 2 norbert2 2007-08-20 19:04:33 UTC 
Sorry there is a copy&paste problem in my initial description. Here are the
correct steps again:



- open a blank spreadsheet

- enter "10" into cell A1

- apply Currency-format to cell A1

- enter "=A1" into cell A2:

Note that the Currency-format is adopted for A2. This is ok.

(Just for understanding Calc's handling of number-formats for cells containing
references:
Right-click A2 "Format Cells...", in the tab "Numbers" you can see, that
"Standard"-format is selected. This is in my oppinion ok: Calc uses format of
referenced cell if format "Standard" is applied. )

- right-click cell A1 "Default" in order to remove Currency-format:
Note that A2 still uses Currency-format!

(Right-click A2 "Format Cells...", in the tab "Numbers" you can see, that
"Standard"-format is still selected.)

- save the spreadsheet as ods-file

- close the spreadsheet

- reload the saved spreadsheet:

Now A2 uses correctly the format of A1.

------------------
(Note: If you do the same steps but use xls-format instead of ods-format, A2
gets Currency-format applied in the saved xml-file.)
Comment 3 frank 2007-10-12 12:49:56 UTC 
double to Issue 75638 and basically to Issue 35822

*** This issue has been marked as a duplicate of 75638 ***
Comment 4 frank 2007-10-12 12:50:17 UTC 
closed oduble