To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75638
User swubuntu changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |REOPENED
--------------------------------------------------------------------------------
Resolution|DUPLICATE |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed May 2 12:16:48 +0000
2007 -------
Reopening.
Issue #35822 has been closed for the following reason: "we act in the same way
as Excel does"
This is not true! When creating a concatenate by a formula, Excel automatically
sets the number format of the cell. Calc does not change the number format of
the cell, although Calc displays the value as if the number format had been set.
In order to restore the display of the value in standard format, in Excel one
can set the number format of the cell back to standard. In Calc you cannot reset
the number format of the the cell to standard, it still is standard.
The only way to update the wrong display in Calc is Shift-Ctrl-F9.
Suggestion:
When Calc displays a value in a certain number format by taking over the format
of a referred cell the display should be automatically updated when the number
format of the referred cell changes.
Alternatively:
Behave like Excel. This means, taking over the number format from the referred
cell must result in a change of the number format as if the user had set the
format via the cell format dialoque.
This is an RFE. Please don´t close a reasonable RFE by referring to an invalid
DEFECT. Thank you. :-)
---------------------------------------------------------------------
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]
