Bug 40517 - User-defined number format lost after saving
Summary: User-defined number format lost after saving
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.4.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-31 09:27 UTC by GerardF
Modified: 2014-12-30 11:30 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:

Attachments

Description GerardF 2011-08-31 09:27:26 UTC 
LibreOffice 3.4.3 under Windows vista. (French UI)

Step to reproduce :
1. In cells A1 to A3, enter decimal number like
1,1
1,12
1,123
(comma is decimal separator in french)

2. Format > Cell > Numbers, format code :
0,???
Police : Courier New

Numbers are aligned with comma.

3. Save.

Re-open the file, format is loss.
replaced by 0,000
Comment 1 Thomas Arnhold 2013-05-01 00:42:34 UTC 
Can confirm the behavior with "0,???" in German and "0.000" with US English.

But why don't you use "#,###" which is the right placeholder? With this it works.

I don't know what the exact intention of the question mark is here.
Comment 2 Urmas 2013-05-01 03:19:47 UTC 
Question mark is used for alignment at decimal separator.
Comment 3 Laurent BP 2014-12-30 11:30:48 UTC 
Confirmed with Version: 4.4.0.1.0+
Build ID: 4774b2f0e6a0e895d1e63256147eaff59efd0eda
TinderBox: Win-x86@51-TDF, Branch:libreoffice-4-4, Time: 2014-12-28_16:31:35
Locale: fr_FR

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.