Bug 40517

Summary:	User-defined number format lost after saving
Product:	LibreOffice	Reporter:	GerardF <gerard.fargeot>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	jmadero.dev, jumbo4444, thomas-libo
Version:	3.4.3 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

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.