Bug 150250 - FILESAVE XLSX Comment box inner spacing not saved
Summary: FILESAVE XLSX Comment box inner spacing not saved
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Comments
  Show dependency treegraph
 
Reported: 2022-08-03 15:44 UTC by Gabor Kelemen (allotropia)
Modified: 2022-08-07 20:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (14.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-08-03 15:44 UTC, Gabor Kelemen (allotropia)
Details
The example file saved as xlsx (5.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-03 15:44 UTC, Gabor Kelemen (allotropia)
Details
The first comment box in Calc and its XLSX version in Excel (101.20 KB, image/png)
2022-08-03 15:49 UTC, Gabor Kelemen (allotropia)
Details
The second comment box in Calc and its XLSX version in Excel (123.76 KB, image/png)
2022-08-03 15:53 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2022-08-03 15:44:07 UTC
Created attachment 181565 [details]
Example file from Calc

Attached file contains two comment boxes with some text.
For the first, I set custom spacing to borders, for the second I left the defaults.
When saved to XLSX and reloaded, these are lost and replaced with default values. In Excel, these defaults are greater than in Calc, so the text does not fit inside the comment boxes anymore.

1. Open attached file, it has two comment boxes. First one (A1) has Left: 0.2 cm, Right: 0.3 cm, Top: 0 cm, Bottom: 0.15 cm. The second one (A9) has default 0.1 cm for all. 
See Format - Text box and Shape - Text dialog.
2. Save as XLSX and open it:
2/A: in Calc both boxes have 0.1 cm borders.
2/B: in Excel both boxes have 0.25 cm left/right and 0.13 cm top/bottom internal margins.

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 86b2bfd34a4f07c54f03c8c8dfe48e0810834628
CPU threads: 14; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded

and all the way back to 6.0, 4.0, 3.5 - this was never good.
Comment 1 Gabor Kelemen (allotropia) 2022-08-03 15:44:40 UTC
Created attachment 181566 [details]
The example file saved as xlsx
Comment 2 Gabor Kelemen (allotropia) 2022-08-03 15:49:27 UTC
Created attachment 181567 [details]
The first comment box in Calc and its XLSX version in Excel
Comment 3 Gabor Kelemen (allotropia) 2022-08-03 15:53:16 UTC
Created attachment 181568 [details]
The second comment box in Calc and its XLSX version in Excel
Comment 4 Ezinne 2022-08-07 20:14:50 UTC
Reproducible in:

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: a9d225df2f8772e21435523ca20df1ece37390e4
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-NG (en_NG); UI: en-US
Calc: threaded