Description: In Calc, the values entered into "Format Cells > Borders > Padding" are not saved. The default values for "Padding" are 0.35mm. If these are increased to (for example) 2.0mm, the open spreadsheet is modified as expected. If the spreadsheet is then saved and re-opened, the values revert to the default of 0.35mm. All other Cell Format settings are saved as expected. Steps to Reproduce: 1.Select "Format > Cells > Borders" and change values for Padding. Click "OK" and verify that the changes modify the display. 2.Save the file then close Calc 3.Re-open the file. Select the relevant cells then select "Format > Cells > Borders". Confirm that the values for "Padding" have reset to the default of 0.35mm. Actual Results: The values for "Padding" always revert to 0.35mm Expected Results: The values selected (2.00mm) should have been retained after the file was saved. Reproducible: Always User Profile Reset: No Additional Info: All other settings in "Format Cells" was saved as expected.
I am going to assume that you are actually saving the file as xls(x), and not as ods. If this is not the case, please clarify. IIRC (but I could be misremembering), the cell padding values are not supported in xls(x). I think this has been already reported before. If my aforementioned assumption and my memory are correct, then this is not a bug, but rather a limitation of the xls(x) file formats. Again, I could very well be wrong / misremembering.
Thank you for your prompt response. You are entirely correct - the problem occurred when I was saving the spreadsheet in .xlsx format. I have now switched to .ods and the cell format is saved correctly. I use .xlsx as my default because there are still some Office365 users who are confused by the .ods extension. However, this document is only for personal use so I am happy to use .ods.
I am changing the Summary field according to comment 2.
*** This bug has been marked as a duplicate of bug 140185 ***