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)
LibreOffice Calc broke this spreadsheet.
LibreOffice Calc don't need support this feature. Not destroying spreadsheet is enough.
User Profile Reset: No
Created attachment 157293 [details]
Sample document before open in Calc
Created attachment 157294 [details]
Step 1 screenshoot
Created attachment 157295 [details]
Step 3 screenshoot
Thank you for reporting the bug. I can confirm the bug present in
Version: 184.108.40.206.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
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
but not in
Version 220.127.116.11.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
I found this problem on version 6.1.4 originally. This behavior was my motivation for upgrade (to 18.104.22.168) and it doesn't help.
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 <email@example.com> 2013-05-31 10:05:55 +0200
committer abdulmajeed ahmed <firstname.lastname@example.org> 2013-05-31 10:27:14 +0200
Fix fdo#51835 Indent changes in Calc forces alignment to left
It looks like duplicate to
*** Bug 112220 has been marked as a duplicate of this bug. ***
Set importance to HIGH MAJOR as this causes format loss.
format loss is different than data loss