Issue 104407 - Cell padding not retained after close/reopen
Summary: Cell padding not retained after close/reopen
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1
Hardware: PC All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-08-21 13:33 UTC by nyputerguy
Modified: 2013-03-23 19:54 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description nyputerguy 2009-08-21 13:33:07 UTC

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 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