Description: I am attempting to create a spreadsheet with specific cell padding of 5.0 pt for top, left, right, and bottom. When I apply the borders and cell padding, they get successfully applied to the document. However, after I save and close, then reopen the document, the cell padding reverts to the default 1.0 pt. Steps to Reproduce: 1.Select one or more cell 2.Right-click and select Format Cells... 3.In the Borders tab, in the Padding section, change the padding (note that changing left padding produces the most visible result). 4.Type text in the affected cell(s). Observe the correct padding. 5.Save the document, then exit LibreCalc. 6.Open the newly saved document. 7.Observe that the changed padding in the modified cells have been reverted. 8.Select the cells, do Format Cells..., go to the Borders tab and observe that padding has been reverted to 1.0. Actual Results: The padding for the modified cells is the default 1.0 pt. all around, despite being changed to 5.0 and saving with the aforementioned change. Expected Results: The cells should maintain the 5.0 pt. padding. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 12; OS: Windows 10.0 Build 22635; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Applying the padding to _one_ cell, no repro with 7.5.3.2 nor with 24.8 alpha. The only difference in my tests is that I use mm instead of pt. Now, if you are trying to apply to _all_ cells, there are several reports about similar failing attempts (not specifically related to border padding).
Works fine here Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 25276df12abd9d002f7f899900434617b256f745 CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to thelandarian from comment #0) > 5.Save the document, then exit LibreCalc. By any chance, are you saving the file as ODF, or as XLSX? Just a hunch, this is about saving / exporting as XLS(x), not saving as ODF.