Apache OpenOffice (AOO) Bugzilla – Issue 104407
Cell padding not retained after close/reopen
Last modified: 2013-03-23 19:54:06 UTC
Hello! Our office has a mix of Excel and OO so I'm pretty much forced to save my spreadsheets in xls format. When working on a spreadsheet and adjusting the left cell spacing, if I close and reopen the file, the settings are not retained. Steps to reproduce: - Open/create a new spreadsheet - Enter text in a few cells (vertically) - Highlight those cells, right-click and select Format Cells - Click on the Borders tab - Under 'Spacing To Contents', uncheck Syncronize - Set the left padding to 3.0pt and click OK - Save the file as XLS (97/2000/XP format) - Close the file - Reopen the file You should see that the cell padding is gone and the settings under Format Cells --> Borders --> Spacing To Contents has reverted to the defaults. This is a clean install of OO 3.1.0 on Vista Home SP2 w/ no changes to the default options after installation (eg Tools --> Options) Not exactly an earth shattering issue, more like a minor annoyance. Any light you could shed on this issue would be appreciated. Thank you in advance...
Reproducible with OOO320m4.
Testing OpenOffice.org 3.3 RC8 on Windows XP SP3: Saving to .ods, padding is kept, Saving to 97/2000/XP .xls -- padding is lost. Microsoft Excel 2000 seems not to have such an option for text alignment in the cell as padding. It might be possible to export the testcase as "Align left(ident)" and some ident value. Does Excel in the MS Office XP and 97 supports it?
As given in description. Rev. 1400866