Created attachment 117948 [details]
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.
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)
I reproduce with
LO 22.214.171.124.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 126.96.36.199
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.
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.
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 ***