Bug 93469 - FILESAVE: ODS - User defined number formats with question marks not retained
Summary: FILESAVE: ODS - User defined number formats with question marks not retained
Status: RESOLVED DUPLICATE of bug 40517
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Number-Format
  Show dependency treegraph
Reported: 2015-08-16 17:12 UTC by Yousuf Philips (jay) (retired)
Modified: 2017-05-02 23:35 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

sample xlsx (4.32 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-08-16 17:12 UTC, Yousuf Philips (jay) (retired)
Excel Displaying with "# ###.??" user defined format (3.09 KB, image/png)
2015-08-18 12:06 UTC, Jacques Guilleron

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2015-08-16 17:12:15 UTC
Created attachment 117948 [details]
sample xlsx

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)
Comment 1 Jacques Guilleron 2015-08-17 15:16:17 UTC
Hi Yousuf,

I reproduce with 
LO Build ID: 56050b75941355285911c0293a3c02fc403d0c89
TinderBox: Win-x86@39, Branch:master, Time: 2015-08-13_05:36:16
Locale: fr-FR (fr_FR)
Also with LO 
Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80, so probably inherited from OOo.
Os: Windows7 Home Premium.
Comment 2 m.a.riosv 2015-08-17 22:58:56 UTC
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.
Comment 3 Jacques Guilleron 2015-08-18 11:01:08 UTC
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.

Comment 4 Jacques Guilleron 2015-08-18 12:06:13 UTC
Created attachment 117995 [details]
Excel Displaying with "# ###.??" user defined format
Comment 5 Yousuf Philips (jay) (retired) 2015-08-18 19:15:53 UTC
@eike, moggi: any ideas why this isnt saved into ODS?
Comment 6 Katarina Behrens (Inactive) 2016-01-07 13:41:30 UTC

*** This bug has been marked as a duplicate of bug 40517 ***