Created attachment 141376 [details] screenshot Steps to Reproduce: 1. Create a new spreadsheet in MSO 2010, type in 123456789 in a cell. 2. Format the cell as comma-separated value by clicking the “," toolbar icon. Then click the align-center toolbar icon to set the cell align center. 3. Save the file and open with LibreOffice. Current Result: Cell value flow right out of cell boundary. Expected Result: Cell value is aligning center. 版本:5.4.6.2 Build ID:4014ce260a04f1026ba855d3b8d91541c224eab8 CPU 线程:4; 操作系统:Linux 4.15; UI 渲染:默认; VCL: gtk2; 区域语言:zh-CN (zh_CN.UTF-8); Calc: group
Created attachment 141377 [details] test xlsx file attached is a sample xlsx file. It is noted that the bug also exists when copy-paste the cell content into a ods file.
Bug already exists in: Version: 5.3.7.2 Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059 CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; VCL: gtk2; Layout Engine: new; Locale: zh-CN (zh_CN.UTF-8); Calc: group But not in: 5.3.6.7.2
Works for me with Version: 5.4.6.2 (x64) Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group and Version: 6.0.3.2 (x64) Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: es-ES (es_ES); Calc: CL Other version are EOL they won't receiving new patches.
Moving back to UNCONFIRMED. @m.a.riosv: As I mentioned in my original bug report, the bug exists in the newest version (i.e., 5.4.6.2). It also exists in the 6.0 verson. You should test it in the same OS before closing it as WORKSFORME.
By the way, this may be locale dependent.
If it could be locale dependent please can you test with English?, I can't reproduce with: Version: 6.0.3.2 (x64) Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: en-US (es_ES); Calc: CL Have you tested with Menu/Help/Restart in Safe Mode.
Resetting user profile resolves the issue. Thus it was caused by the modification of user profile by a certain version. I don't know which version caused the corruption of my user profile. I am attaching the bad user profile in case some of you may be interested in. Close as WORKSFORME now.
Created attachment 141390 [details] user profile which may reproduce this issue You may reproduce this issue using the attached user profile. That being said, this is not confirmed to be a regression - Althrough I do not reproduce in 3.6.7 but reproduce in 5.x, 3.* and 5.* uses different user profile. Thus I am removing regression keyword.
Often the issues with profiles comes from an update. It's indeed difficult to know what could be the bad record. With the latest versions I haven't see this problem. Resetting only registrymodifications.xcu file usually solves the issues.
(In reply to m.a.riosv from comment #9) Could you please try to install zh_CN langpack to see if you can reproduce using the attached user profile?
(In reply to m.a.riosv from comment #9) > Resetting only registrymodifications.xcu file usually solves the issues. Yes, indeed.
Further investigation indicates that the issue is related to the setting in: Tools - Options - LibreOffice Calc - General - Use Printer Metrics for Text Formatting. When enable this option, this bug happens in all versions including 3.6.7.2.
Seems a duplicate of tdf#64518 what is marked as duplicate of tdf#66089. *** This bug has been marked as a duplicate of bug 66089 ***