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: 188.8.131.52.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
and all the way back to 6.0, 4.0, 3.5 - this was never good.
Created attachment 181566 [details]
The example file saved as xlsx
Created attachment 181567 [details]
The first comment box in Calc and its XLSX version in Excel
Created attachment 181568 [details]
The second comment box in Calc and its XLSX version in Excel
Version: 184.108.40.206.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