Bug 130104 - FILESAVE: XLSX: problem with align+indent (cell indent increases on each save)
Summary: FILESAVE: XLSX: problem with align+indent (cell indent increases on each save)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected
: 112220 (view as bug list)
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2020-01-21 09:24 UTC by jdobry
Modified: 2020-11-19 14:04 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Sample document before open in Calc (7.67 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-01-21 09:26 UTC, jdobry
Step 1 screenshoot (23.87 KB, image/png)
2020-01-21 09:27 UTC, jdobry
Step 3 screenshoot (10.39 KB, image/png)
2020-01-21 09:28 UTC, jdobry

Note You need to log in before you can comment on or make changes to this bug.
Description jdobry 2020-01-21 09:24:56 UTC
MSOffice is able to format cell to align right (or left) with indentation.
LibreOffice Calc broke this spreadsheet more and more on every save (it not need modification save is enough)

Steps to Reproduce:
1. Create XLSX document in MSoffice. Only one cell with formatting -> align to right, indent > 0 and save it. (Example document is in attachment, screenshot in attachment)
2. Open this document on LibreOffice calc, save it and close.
3. Repeat step 2 several times. Content of cell move to the left out of boundary. (screenshot in attachment)

Actual Results:
LibreOffice Calc broke this spreadsheet.

Expected Results:
LibreOffice Calc don't need support this feature. Not destroying spreadsheet is enough. 

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 jdobry 2020-01-21 09:26:26 UTC
Created attachment 157293 [details]
Sample document before open in Calc
Comment 2 jdobry 2020-01-21 09:27:38 UTC
Created attachment 157294 [details]
Step 1 screenshoot
Comment 3 jdobry 2020-01-21 09:28:16 UTC
Created attachment 157295 [details]
Step 3 screenshoot
Comment 4 Durgapriyanka 2020-01-21 15:56:07 UTC
Thank you for reporting the bug. I can confirm the bug present in

Version: (x86)
Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

But,not in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 5 Xisco Faulí 2020-01-21 16:04:23 UTC
Reproduced in

Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

but not in

Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 6 jdobry 2020-01-21 16:28:32 UTC
I found this problem on version 6.1.4 originally. This behavior was my motivation for upgrade (to and it doesn't help.
Comment 7 Aron Budea 2020-02-03 04:07:57 UTC
This isn't really a regression, as previously the indent wasn't applied properly, but the point of change could be bibisected using repo bibisect-42max.

author		abdulmajeed ahmed <aalabdulrazzaq@kacst.edu.sa>	2013-05-31 10:05:55 +0200
committer	abdulmajeed ahmed <aalabdulrazzaq@kacst.edu.sa>	2013-05-31 10:27:14 +0200

Fix fdo#51835 Indent changes in Calc forces alignment to left
Comment 8 jdobry 2020-02-25 08:39:56 UTC
It looks like duplicate to 

Comment 9 Kevin Suo 2020-02-25 13:54:35 UTC
*** Bug 112220 has been marked as a duplicate of this bug. ***
Comment 10 Kevin Suo 2020-11-18 12:40:42 UTC
Set importance to HIGH MAJOR as this causes format loss.
Comment 11 Xisco Faulí 2020-11-18 12:50:37 UTC
format loss is different than data loss