Created attachment 142927 [details] Example ods with custom Spacing to Contents properties set LibreOffice Calc loses the value of the custom Spacing to Contents Border property when the spreadsheet is saved as XLSX. Steps to reproduce: 1. Create a new Spreadsheet 2. Add some content to a cell (any random word or number will do) 3. Click on Format – Cells 4. Click on the „Borders” tab 5. Set a new value for the Spacing to Contents (eg. 5 mm) 6. Click on OK 7. Save the file as XLSX 8. Reload the file by clicking on File – Reload Actual results: The value of the Spacing to Contents property is reset to 0,35 mm Expected results: The custom value of the Spacing to Contents property should be preserved
Created attachment 142928 [details] The same file exported to xlsx
Created attachment 142929 [details] Screenshot of the files side by side
Repro. Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: 5b42a17dc99fba2ccf8dd8d0a8e0e4e836e30120 CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on June 22nd 2018 Arch Linux 64-bit LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
On a second look, we had to realize that Excel does not have an equivalent feature to this. So it's probably not a surprise that these settings can't be saved to xlsx, and likely this won't change.
Thanks, I will close the older one about XLS as well.