https://bugs.documentfoundation.org/show_bug.cgi?id=156449
Bug ID: 156449
Summary: Number format: scientific notation do not respect '?'
(blank) in exponent
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A number format like "0.00E+?0" should display PI() like "3.14E+ 0", as '?'
should be replace by a blank if exponent is less than 10. But Calc treats '?'
as a '0' and display "3.14E+00".
Steps to Reproduce:
1. In Calc, Format > Cells > Numbers
2. Set Format code to 0.00E+?0
3. Display a value between 1e-9 and 1e10, like PI(), to have only 1 digit in
exponent
Actual Results:
Value displayed is 3.14E+00, which corresponds to Format code 0.00E+00
Expected Results:
Value should be displayed as 3.14E+ 0 with a blank instead of the first '0'
Reproducible: Always
User Profile Reset: No
Additional Info:
Excel correctly treats this format code.
--
You are receiving this mail because:
You are the assignee for the bug.
