The text alignment in comment is incorrect when the document is saved in XLSX format.
Steps to Reproduce:
1. Create a new spreadsheet in LibreOffice Calc.
2. Select a cell and choose Insert→Comment.
3. Type text.
4. Choose Format→Align→Centered (or Right or Justified).
5. Deselect the cell.
6. Choose View→Comments.
7. Save the file as XLSX.
8. Reload the file.
The text alignment in comment is Left.
The text alignment in comment should be Centered (or Right or Justified).
User Profile Reset: No
Build ID: fcc5fc76c33de566cb2d02be541dcbde29d1eb8a
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Created attachment 149111 [details]
Screenshot of the problem in Calc.
Created attachment 149112 [details]
Example file from Calc.(ODS)
Created attachment 149113 [details]
Example file from Calc.(XLSX)
Thank you for reporting the bug.I cannot reproduce the bug. The alignment stays even after saving in XLSX format.
Reproduced 6.3+ in Windows so I'll confirm. Not clear why Durgapriyanka couldn't reproduce.
Looks from LO 3.3 so implementation error. Works OK for XLS.
Filesave to XLSX was available only from LO 3.3 which is not the same as "inherited from OO 3.3".
Szabolcs Toth committed a patch related to this issue.
It has been pushed to "master":
tdf#123339 XLSX: fix horizontal alignment in comments
It will be available in 6.4.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Looks fine both in LO and MSO.