Bug 40497

Summary:	User-defined cell format in Calc was particularly broken
Product:	LibreOffice	Reporter:	russianneuromancer
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium
Version:	3.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
i915 platform:		i915 features:

Description russianneuromancer 2011-08-30 10:58:41 UTC

1. Open LibreOffice Calc.
2. Enter for example 1600 in any cell.
3. Open Cell Format of this cell.
4. Select user-defined and Default - English (USA) language.
5. Enter format code:
# ###.00 "something"
Result is correct: 1 600. something
6. So now try language with "," instead of ".". For example Russian.
Select Russian language in Cell Format window.
7. Enter format code:
# ###,00 "something"
Result is broken: 1,60something
8. You may guess the problem in the gap, but:
# ###,00"something"
Result is still broken: 1 600,00something
9. Some kind of solution:
# ###,00" something"
Result: 1 600,00 something
Now it's correct but it's just a workaround.

Comment 1 Björn Michaelsen 2011-12-23 12:39:19 UTC

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Comment 2 russianneuromancer 2012-02-29 11:25:38 UTC

Bug still present in LibreOffice 3.5 release.

Comment 3 ign_christian 2013-06-25 09:32:14 UTC

I think it's spesific to Languange used on that cell, different Languange generates different behavior.

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.