Apache OpenOffice (AOO) Bugzilla – Issue 29081
"Standard"-format is not updated to correct format if the user changes the source-cell's format, where it references to
Last modified: 2004-06-03 14:18:04 UTC
Please open the attached spreadsheet. (It was produced by entering a exponential number into A1 and then I set B1 "=A1".) B1 still has "Standard" format applied but shows in exponential style. I think that this behaviour is OK (maybe better than the behaviour of Excel.) But if you... - change the format of A1 for example to "Standard" (german Calc): B1 still shows exponential-format. The behaviour of keeping "Standard"-format for cells that reference to other cells only makes sense, if you correctly update the format of them, after the format of the source cell has changed !!! If you now delete for example the "1" of ="B1" and add it again and confirm, the format is updated. (That this is a bug can also be seen in the fact, that if I now press undo, the new format still is shown.) So we can call this a bug. It's not an enhacement request! -> You should update the format of "Standard"-format cells if the cell where it references to has changed the format.
Created attachment 15200 [details] reference_standard.sxc
Hi Norbert, this Issue is the same as 26697 which is closed upon your request. This Issue here is not a new one because setting the cell into Edit mode, altering it's content and closing it again is the same as entering a new formula, so the new format of the cell is taken into account. No bug, no RFE but a double. Sorry. Frank *** This issue has been marked as a duplicate of 26697 ***
closed double
Hi Frank, No, I mean something other here: In issue 26697 I mean the problem that: "Its not possible to have the right cell shown with standard format." Here I wish that Calc dynamically adopts the format of the sorce cell to the formula cell! So pleas re-open this.
With dynamically I mean that if I change the format of the source cell, the formula cells automatically also adopts this format.
FT: Cells the refence to other cell do not inherit their number format. This is for a good reason: Imagine that your cells reference on plain numbers from a database. Those numbers are your revenue data which are supposed to display in $ . If the above would apply, you could _never_ have you data formatted as currency.