Issue 104407

Summary: Cell padding not retained after close/reopen
Product: Calc Reporter: nyputerguy <rgrakowsky>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P5 (lowest) CC: elish, issues
Version: OOo 3.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 3.4.1
Developer Difficulty: ---

Description nyputerguy 2009-08-21 13:33:07 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...
Comment 1 raal 2009-11-17 19:10:44 UTC 
Reproducible with OOO320m4.
Comment 2 sniekest 2010-12-29 09:45:54 UTC 
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?
Comment 3 Edwin Sharp 2013-03-23 19:54:06 UTC 
As given in description.
Rev. 1400866