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.
Reproduced in: Version: 24.2.0.0.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 Calc: threaded And OOo 3.3.
Laurent Balland committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/443027cd71aef3eb45bbf3631869ea63457f2c81 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.