https://issues.apache.org/ooo/show_bug.cgi?id=93881
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from orcmid <[email protected]> --- This is not necessarily a bug, as already mentioned. I opened a fresh spreadsheet in Apache OpenOffice 3.4.1 Calc. (My installation is en_US and it is on Windows XP SP3 also en_US. I have not changed the decimal separator anywhere. In cell A1 I entered "1.8e6" (without the quotes in all cases here). The cell was presented as "1.80E+006" and the value shown in it when I put the mouse over the cell is "1800000". Notice that the formatting and the value for the cell were determined by default, based on what I entered. In cell B1, I entered "=1.8e6". This *displays* as "1800000" and the value of the cell is shown as "=1800000". In column C I set the cell format of all cells as Text. In cell C1 entered "1.8e6" again and the result is "1.8e6" left justified. For good measure, I entered "=1.8e6" in cell C2 and the value shown is "=1.8e6". There is no way to over-ride an existing cell format of text unless the format is changed. Now, a cell can easily have its format default to text by incorrect entry of a number or any previous entry being of format text. Then putting "1.8e6" in the cell will result in that being taken as text, not a number. Having made an entry using a decimal point that is not recognized could also have the effect of defaulting the cell format. With regard to the settings for decimal separator, it is valuable to check Tools | Options | Language Settings | Languages (as internationalized) for what is being used as the "Decimal Separator Key" and also what is set as the User interface and the Locale Setting languages. According to the help, this determines what is entered when the Numeric Pad "." key is pressed. So another variation is between using the "." and "," keys and using the Numeric Pad decimal key. What fun. To confirm a bug, it is going to be necessary to control these variations and see what then occurs. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
