[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 --- Additional comments from [EMAIL PROTECTED] Fri Oct 12 11:49:54 + 2007 --- *** Issue 80861 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 User fst changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Wed May 2 11:20:59 + 2007 --- Hi, this is a double to Issue 35822. Saskia and Frank *** This issue has been marked as a duplicate of 35822 *** - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 User fst changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed May 2 11:22:20 + 2007 --- closed double - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
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 + 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 User fst changed the following: What|Old value |New value Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Wed May 2 12:36:49 + 2007 --- 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 - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |requirements Status|REOPENED |NEW --- Additional comments from [EMAIL PROTECTED] Wed May 2 12:37:20 + 2007 --- 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 - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 User kpalagin changed the following: What|Old value |New value CC|''|'kpalagin' Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Sun Mar 25 15:31:28 + 2007 --- Confirming problem A - number format gets updated on either reopen or Shift- Ctrl-F9. - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75638 Issue #|75638 Summary|Number format inkonsistent when using formula Component|Spreadsheet Version|OOo 2.2 RC3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|swubuntu --- Additional comments from [EMAIL PROTECTED] Thu Mar 22 09:44:27 + 2007 --- Situation A: One cell, having a special number format, contains some numeric value. A second cell, having no special number format (number format is Standard), contains a formula that is referencing to the first cell. The result of the formula in the second cell shows up using the number format of the first cell. Nice feature. Problem A: When you change the number format of the first cell, the result in the second cell is still being shown using the old number format of the first cell. In order to refresh the application of the number format in the second cell you need to retype the formula or you need to save, close and reopen the document. To reproduce this bug, try the attached document problemA.ods: (1) You can see the value 100 twice shown in number format Currency. (2) Note that A1 contains the numeric value 100 and has the number format Currency. Note that B1 contains a formula and has the number format Standard. (3) Change the number format of A1 from Currency to Percent. (4) Note that B1 is still showing Currency-Format. (5.1) Retypte the formula (=A1) in B1 OR (5.2) Save, close and reopen the document. (6) Note that finally B1 is showing Percent-Format as well. Situation B: Now we have an Excel spreadsheet. One cell, having a special number format, contains some numeric value. A second cell, having no special number format (number format is Standard), contains a formula that is referencing to the first cell. The result of the formula in the second cell shows up using _no_special_ number format. Problem B: Even if you save the Excel file as ODF an reopen it, it still does not apply the special number format of the first cell in the second cell. This is very confusing, since now we do have a document similar to Sitation A but its behaviour is different. To reproduce this bug, try the attached document problemB.xls: (1) You can see the value 100 shown in number format Currency in A1 and you can see the value 100 shown in no special number format in B1. (2) Note that A1 contains the numeric value 100 and has the number format Currency. Note that B1 contains a formula and has the number format Standard. (3) Note that this is a different behaviour to situation A using an ODF document as discribed above. (4) Save the document as an ODF. Reopen it. (5) Note that B1 still does not apply the special number format of A1. (6) Note that this still is a different behaviour to situation A using an ODF document as discribed above. - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
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 Attachment data| |Created an attachment (id= | |43853) File for reproducti | |on of problem A as discrib | |ed --- Additional comments from [EMAIL PROTECTED] Thu Mar 22 09:45:35 + 2007 --- Created an attachment (id=43853) File for reproduction of problem A as discribed - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
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 Attachment data| |Created an attachment (id= | |43854) File for reproducti | |on of problem B as discrib | |ed --- Additional comments from [EMAIL PROTECTED] Thu Mar 22 09:46:19 + 2007 --- Created an attachment (id=43854) File for reproduction of problem B as discribed - 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]
[sc-issues] [Issue 75638] Number format inkonsistent when using formula
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 Issue type|DEFECT|ENHANCEMENT --- Additional comments from [EMAIL PROTECTED] Thu Mar 22 10:13:21 + 2007 --- 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. - 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]
