Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Number format inkonsistent when using formula | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | niederbayern <eva-email> | ||||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, kpalagin | ||||||
Version: | OOo 2.2 RC3 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
niederbayern
2007-03-22 10:44:27 UTC
Created attachment 43853 [details]
File for reproduction of problem A as discribed
Created attachment 43854 [details]
File for reproduction of problem B as discribed
Problem B has been clarified. Sorry for that. Please focus on problem A. Thank you. Problem A can be resolved by pressing Shift-Ctrl-F9. Changing Issue type from DEFECT to ENHANCEMENT though. It is not favorable that one must press Shift-Ctrl-F9 every time after changing a number format, especially because the user might not know about other cells in his spreadsheet, that take over the number format from referenced cells. Confirming problem A - number format gets updated on either reopen or Shift- Ctrl-F9. Hi, this is a double to Issue 35822. Saskia and Frank *** This issue has been marked as a duplicate of 35822 *** closed double 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. :-) Hi, the problem is just that the mentioned Issue deals exactly with this, a view setting doesn't trigger a recalculation. But Ok, let's re-assign to the requirements team. Frank Hi, the problem is just that the mentioned Issue deals exactly with this, a view setting doesn't trigger a recalculation. But Ok, let's re-assign to the requirements team. Frank *** Issue 80861 has been marked as a duplicate of this issue. *** |