Description: Number can have in their decimal part '?' to indicate a decimal digit, which will be replaced by a space if not necessary, whereas '#' is replaced by nothing and '0' by a zero. Scientific numbers have the same behavior. But if such format is saved in ODF, '?' are replaced by '#' and decimal alignment is lost. Steps to Reproduce: 1. Define a scientific format with '?' in decimal part such as 0.???E+00 Format > Cells > Numbers, type code in Format Description 2. Save and Reload 3. Check format Actual Results: '?' are replaced by '#' which gives 0.###E+00 Expected Results: Format should not be modified as it is correctly in initial step Reproducible: Always User Profile Reset: Yes Additional Info: In xmlnumfe.cxx, it seems that SvXMLNumFmtExport::WriteScientificElement_Impl does not care if there are some decimal replacement.
Hi Laurent, Reproduced with LO 6.0.4.2 Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: CL and LO 3.5.3.2 Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 where ??? characters are replaced by 000.
Actually, it is an enhancement, as this behavior is not defined in ODF standard.
Does formatting as 0.??E+0 really make sense? Instead of 1.00E+45 or 1E+45 1. E+45 looks very odd to me.
Ping? Any opinion on the previous comment 3?
Dear Laurent BP, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
Created attachment 153443 [details] Some examples using such format Hi Eike, sorry for the delay (In reply to Eike Rathke from comment #3) > Does formatting as 0.??E+0 really make sense? Instead of 1.00E+45 or 1E+45 > 1. E+45 > looks very odd to me. User may expect some alignment, with engineering notation for instance: ##0.???E+00 Examples attached