Bug 117018 - Cell Content Should Align Center Rather Than Flowing Out of Cell Border (related to "Use Printer Metrics for Text Formatting")
Summary: Cell Content Should Align Center Rather Than Flowing Out of Cell Border (rela...
Status: RESOLVED DUPLICATE of bug 66089
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-15 08:42 UTC by Kevin Suo
Modified: 2018-04-16 09:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (169.94 KB, image/png)
2018-04-15 08:42 UTC, Kevin Suo
Details
test xlsx file (8.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-04-15 08:45 UTC, Kevin Suo
Details
user profile which may reproduce this issue (2.04 MB, application/x-7z-compressed)
2018-04-16 08:34 UTC, Kevin Suo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2018-04-15 08:42:34 UTC
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
Comment 1 Kevin Suo 2018-04-15 08:45:32 UTC
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.
Comment 2 Kevin Suo 2018-04-15 08:50:19 UTC
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
Comment 3 m.a.riosv 2018-04-15 12:28:24 UTC
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.
Comment 4 Kevin Suo 2018-04-16 08:04:14 UTC
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.
Comment 5 Kevin Suo 2018-04-16 08:09:36 UTC
By the way, this may be locale dependent.
Comment 6 m.a.riosv 2018-04-16 08:21:18 UTC
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.
Comment 7 Kevin Suo 2018-04-16 08:30:15 UTC
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.
Comment 8 Kevin Suo 2018-04-16 08:34:29 UTC
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.
Comment 9 m.a.riosv 2018-04-16 08:38:28 UTC
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.
Comment 10 Kevin Suo 2018-04-16 09:05:00 UTC
(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?
Comment 11 Kevin Suo 2018-04-16 09:11:08 UTC
(In reply to m.a.riosv from comment #9)
> Resetting only registrymodifications.xcu file usually solves the issues.
Yes, indeed.
Comment 12 Kevin Suo 2018-04-16 09:25:21 UTC
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.
Comment 13 m.a.riosv 2018-04-16 09:32:44 UTC
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 ***