To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80861 Issue #|80861 Summary|Calc fails to update number-format of referencing cell |s, document has to be saved and reloaded Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|norbert2
------- Additional comments from [EMAIL PROTECTED] Mon Aug 20 17:51:52 +0000 2007 ------- 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.) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]