https://bugs.documentfoundation.org/show_bug.cgi?id=160002
Bug ID: 160002
Summary: Indentation issue in currency formatted cells in Calc
Product: LibreOffice
Version: 24.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In a sheet in which cells are mainly set as currency, the currency symbol
(which was previously fully indented to the far left of the cell) was now
indented so much that it moves to the adjacent cell.
The only way to fix this is to re-format each cell (as currency still). This
moved the currency symbol together with the value (aka no indentation and no
spacing).
The format code of the cell pre re-formatting is:
_-[$€-2] * #,##0.00_-;-[$€-2] * #,##0.00_-;_-[$€-2] * -??_-;_-@_-
The format code of the cell post re-formatting is:
[$€-43A]#,##0.00;[RED]-[$€-43A]#,##0.00
I also tried to change the format code to the below, but this still pushed the
currency symbol way offset onto the adjacent cell:
[$€-43A]* #,##0.00;[RED]-[$€-43A]* #,##0.00
Steps to Reproduce:
1. Simply open a spreadsheet that was created in a previous version, which has
currency formatted cells, in the new release.
Actual Results:
The currency symbol is indented way off to the left, resulting in it
overlapping into the adjacent cell (and if any data in that cell, it overlaps
that data). Resizing the column won't have any affect.
Expected Results:
The currency should be perfectly indented to the left of the cell, while the
value should be indented to the right, with perfect spacing in between for
consistency.
Reproducible: Always
User Profile Reset: No
Additional Info:
No other information available.
--
You are receiving this mail because:
You are the assignee for the bug.
