Created attachment 117948 [details] sample xlsx Steps: 1) Open attached file 2) Notice that B3 and C3 have number formats ending in '.??' 3) Save as ODS 4) Reopen and notice that B3 and C3 number formats now end in '.00' This problem only happens when saving to ODF. Version: 5.1.0.0.alpha1+ Build ID: 78a11f79d8eb5cd1d2b18c288852dec7e3d57a21 TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-10_05:59:19 Locale: en-US (en_US.UTF-8)
Hi Yousuf, I reproduce with LO 5.1.0.0.alpha1+ Build ID: 56050b75941355285911c0293a3c02fc403d0c89 TinderBox: Win-x86@39, Branch:master, Time: 2015-08-13_05:36:16 Locale: fr-FR (fr_FR) Also with LO 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80, so probably inherited from OOo. Os: Windows7 Home Premium.
I don't think is right "question marks" there. LibreOffice help " Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers. "
Hi Miguel Ángel, Excel uses '?' also to align numbers on the decimal separator, by leaving a sspace instead of insignifiant zero. Calc actually replace space by a zero. https://support.office.com/en-au/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4 Jacques
Created attachment 117995 [details] Excel Displaying with "# ###.??" user defined format
@eike, moggi: any ideas why this isnt saved into ODS?
*** This bug has been marked as a duplicate of bug 40517 ***