Bug 62878 - FILE SAVE / FILE OPEN : column indents are changed in xlsx file (from 5pt to 16pt every time I reopen)
Summary: FILE SAVE / FILE OPEN : column indents are changed in xlsx file (from 5pt to...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Limitations
  Show dependency treegraph
 
Reported: 2013-03-28 18:12 UTC by nospam1000
Modified: 2017-11-07 02:48 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS, file with A1, B1, C1, D1 column indentation set to 20pt (7.32 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-10 22:53 UTC, Bartosz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nospam1000 2013-03-28 18:12:08 UTC
LibreOffice 3.5.

I have 4 columns, all text Courier New 8pt.  I have the indent set at 5pt and optimal column width with an add of 0.0.  Every time I reopen the file the column indents are set to 16pt.

I am saving as xlsx.
Comment 1 A (Andy) 2013-05-09 09:02:21 UTC
Thank you for reporting this bug!

I have been able to confirm this issue.  It is reproducible with LO 4.0.2.2 (Win7 Home, 64bit).

Steps to Reproduce:
1. Open a new spreadsheet in CALC
2. Type "1" in the cells A1, B1, C1 and D1
3. Select these four cells and make a right mouse click on them and go to FORMAT CELLS
4. Go to the tab ALINGMENT and changed the Text Alignment / Horizontal from "Default" to "Left" and then change the Indent to 5pt and press OK
5. Select the columns A, B, C and D and go to the menu FORMAT -> COLUMN -> OPTIMAL WIDTH
6. Select Add = 0.0" and press OK
7. Save the file as a xlsx file (go to the menu FILE -> SAVE AS)
8. Close the file
9. Reopen the saved file
10. Go to the cells A1, B1, C1 and D1 and check the indent (go to the menu FORMAT -> CELLS -> tab ALIGNMENT)

Result: The Indent is changed to 15pt.
Comment 2 ign_christian 2013-05-10 02:32:47 UTC
reproducible with LO 4.0.3.3 (Win 7 Home Premium 32bit)

It's a very strange behaviour..when I test:
- save as .xlsx -> indent changed to 16pt
- save as .xls -> indent changed to 10pt

I remember that I previously saw that bug while opening .xls which created by Open Office and MS Office
Comment 3 A (Andy) 2015-03-07 20:55:46 UTC
Reproducible with LO 4.4.1.2, Win 8.1

xlsx -> indent changed to 15pt
xls -> indent changed to 10pt
Comment 4 tommy27 2016-04-16 07:22:40 UTC Comment hidden (obsolete)
Comment 5 Bartosz 2016-12-10 22:53:26 UTC
Created attachment 129474 [details]
ODS, file with A1, B1, C1, D1 column indentation set to 20pt
Comment 6 Bartosz 2016-12-10 23:06:35 UTC
This is an limitation of the OOXML format. The indentation is saved in .xlsx,  as integer value, where an increment of 1 represents 3 spaces.
https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.alignment.aspx

Unfortunately we cannot do much to fix that bug.