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
Value displayed is 3.14E+00, which corresponds to Format code 0.00E+00
Value should be displayed as 3.14E+ 0 with a blank instead of the first '0'
User Profile Reset: No
Excel correctly treats this format code.
Version: 184.108.40.206.alpha0+ (X86_64) / LibreOffice Community
Build ID: 94caaf5c9e2917a3202cf515d61eaa9399b2c2b5
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
And OOo 3.3.
Laurent Balland committed a patch related to this issue.
It has been pushed to "master":
tdf#156449 Preserve '0' or '?' in exponent
It will be available in 24.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.