https://bugs.documentfoundation.org/show_bug.cgi?id=159914
Bug ID: 159914
Summary: Chart anchor inconsistent in ODS to XLSX and XLS
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Spreadsheets containing anchored charts are not consistently converted between
file formats. When creating a chart anchored as "To Cell (resize with cell)" in
an .ods format, when saving as a new .xlsx formatted file, the charts anchor
converts to "To Cell".
To replicate this:
1. Create an new .ods with a simple chart/graph created in it
2. Right click the chart and select Anchor > To Cell (resize with cell)
3. Now save the file (as .ods)
4. Close the file
5. Open this saved .ods file
6. Now Save As an .xlsx format
7. Once again, close the file - it is important that we close the file here as
the property is seemingly unchanged if not closed and reopened
8. Open the newly saved .xlsx file
9. Right click the chart and open the Anchor sub-menu
10. The property here will have changed to "To Cell"
Understandably, it is highlighted when changing the file format that the
formatting may be lost in the new .xlsx file format, but I've noticed that the
conversion from .ods to .xlsx does not align with conversion from .ods to .xls,
which is causing issues to the expected behaviour as we have recently
deprecated .xls.
Therefore, ideally the chart conversion can either:
- align the same anchor between file formats, i.e "To Cell (resize with cell)"
anchor in .ods converts to the same anchor in .xlsx - this behaviour has proven
to work with images
- conversion to .xlsx should follow the behaviour of .xls, i.e. "To Cell
(resize with cell)" anchor in .ods converts to "To Page" in .xlsx/.xls, for
whatever reason
--
You are receiving this mail because:
You are the assignee for the bug.
