https://bugs.freedesktop.org/show_bug.cgi?id=58377
Priority: medium
Bug ID: 58377
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Different spacing between currency symbol
and number depending on cell containing number or
formula
Severity: normal
Classification: Unclassified
OS: All
Reporter: kkoeni...@web.de
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
