Bug 58377

Summary:	FORMATTING: Different spacing between currency symbol and number depending on cell containing number or formula
Product:	LibreOffice	Reporter:	Karl <kkoenig11>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	serval2412, stgohi-lobugs
Priority:	medium
Version:	3.6.4.3 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	example with inconsistent formatting between LO versions

Description Karl 2012-12-16 23:12:37 UTC

Problem description:
The padding between the currency symbol and a number, when using the format code "[$€]* #.##0,00" (without the quotation marks), depends on whether a cell contains a number or a formula.

Steps to reproduce:
1) Enter in cell A1 any number
2) Enter in any other cell, e.g. cell A2, the formula "=A1"
3) Mark both these cells. Format - Cells. Tab "Numbers". Format Code "[$€]* #.##0,00". Ok.

Current behavior:
* the currency symbol in cell A1 is left-aligned while the number is right-aligned
* the currency symbol in cell A2 is immediately left-adjacent to the right-aligned number

Expected behavior:
consistent alignment, independent of the fact whether a number or a formula result is being displayed

Additional observation:
* When saving as "ODF Spreadsheet (.ods)" (immediately after 3)), closing and re-opening that file, the format code silently gets altered to "[$€]#.##0,00" such that the problem does not present itself then.
* When saving as "Microsoft Excel 97/2000/XP/2003 (.xls)" (immediately after 3)), closing and re-opening that file, the format code is preserved and the problem persists.

Platform:
Ubuntu 10.04 64-bit, Windows 7 64-bit

Comment 1 john.pratt 2012-12-21 16:51:44 UTC

Cannot reproduce the inconsistency within either 3.5.7.2 or 4.0 beta 2 on windows XP.

However, 3.5.7.2 displays the euro symbol immediately to the left of the number (which is itself right aligned) in both cases, whereas 4.0 beta 2 displays the number right aligned and the euro symbol left aligned.

Comment 2 john.pratt 2012-12-21 16:52:24 UTC

Created attachment 71942 [details]
example with inconsistent formatting between LO versions

Comment 3 Karl 2013-01-26 15:25:06 UTC

I confirm that the inconsistency reported in the original report does neither occur with 3.5.7.2 nor 4.0 beta 2 (Ubuntu 10.04 64-bit, Windows XP 32-bit and Windows 7 64-bit), but it does with LibreOffice 3.6.4.3.

(Due to observation 1 in original report I can not attach an *.ods file for easier reproduction of the issue, the steps to reproduce will have to suffice.)

Comment 4 A (Andy) 2013-12-27 13:16:48 UTC

Not reproducible with LO 4.1.4.2 (Win7 Home, 64bit)

I don't know if this bug still existed in LO's 3.6.x latest release, but because LO 3.6.x has already reached the End of Life status (no more updates) I would propose to close this issue.

Comment 5 Julien Nabet 2014-02-01 22:15:44 UTC

Following the 2 last comments, I put it as WFM.