To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=43959
Issue #:|43959
Summary:|Scientific notation: Zero is prepended to format that
|does not contain leading zero and decimal point
Component:|Spreadsheet
Version:|OOo 1.1.4
Platform:|Opteron/x86_64
URL:|
OS/Version:|Linux
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|formatting
Assigned to:|spreadsheet
Reported by:|quartertone
------- Additional comments from [EMAIL PROTECTED] Wed Mar 2 20:20:35 -0800
2005 -------
Issue:
When re-opening a saved oocalc file, a zero ("0") is added to the scientific
notation format of a cell if the cell's number formatting is in Scientific
notation and does not contain both a decimal point and a leading zero ("0") or
placeholder ("#").
Duplication:
1. Create new spreadsheet (oocalc) file.
2. Enter a number in a cell.
3. Open cell formatting dialog (Right-click -> Format Cells) [or] (Format Menu
-> Cells), and select Numbers tab.
4. Enter custom number format:
0E+0
or
.0E+0
5. Save file, and close.
6. Re-open the saved file.
7. Result: Cell's formatting changes as follows:
".0E+0" becomes "#.0E+0". Subsequent save/re-open of this format has no
effect.
"0E+0" becomes "00E+0". Subsequent save/re-open of this format continues to
add a zero to the number format. ie - next iteration is "000E+0"
Why this should be fixed:
Formatting a number in scientific notation shows exactly how many digits are
significant. Openoffice currently (apparently) has a minimum of two (2)
significant figures for scientific notation. In expressing error/uncertainty
values in calculations, it is important that the error value have only one
significant digit.
---------------------------------------------------------------------
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]
