Download it now!
Bug 130104 - FILESAVE: XLSX: problem with align+indent
Summary: FILESAVE: XLSX: problem with align+indent
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
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-02-25 13:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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
Description:
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: 6.4.0.0.alpha1+ (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-3.3.0.4
Comment 5 Xisco Faulí 2020-01-21 16:04:23 UTC
Reproduced in


Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

but not in

Version 4.1.0.0.alpha0+ (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 6.3.4.2) 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.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=af169a601dee381b17d1e87c346f2d97bad9a69f
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 

https://bugs.documentfoundation.org/show_bug.cgi?id=112220
Comment 9 Kevin Suo 2020-02-25 13:54:35 UTC
*** Bug 112220 has been marked as a duplicate of this bug. ***