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: libreoffice-bugs@lists.freedesktop.org Reporter: fenech.dan...@gmail.com 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.