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.
Dear thelandarian, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
I can confirm that the described bug only exists when saving as XLSX. After reopening. Cell padding is reset to 1 pt; any change made before saving is disregarded. When saving as ODS and reopening, the cell padding stays at the new values, as expected. I tested with LibreOffice 7.6.5.2
Bug 140185 comment 17: "Marking as INVALID - request is for something not possible in MSO formats." *** This bug has been marked as a duplicate of bug 140185 ***