[Libreoffice-bugs] [Bug 116738] New: XLSX import: Different column widths on Linux vs Windows

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116738

            Bug ID: 116738
           Summary: XLSX import: Different column widths on Linux vs
                    Windows
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 141017
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141017&action=edit
XLSX which has different column widths when imported on Windows vs Linux

Original report: https://ask.libreoffice.org/en/question/151109

The attachment shows the problem: when imported on Linux (without installed
Calibri font), column A has width of 0.81 cm, while on Windows (with Calibri
font installed), the column width is 0.65 cm.

The suspicion is that the difference is related to the fact that XLSX stores
column width in character width units, and the used font is absent on system
(so some other font is possibly used for width calculations). But even if this
is the case, this is the bug, since in specific case of Calibri font, we bundle
Carlito, which is expected to be metrically compatible, and is used for Calibri
substitution; so it should be used for width calculations. Either it is not
used here, or the font still has some metrical incompatibility.

Tested on Version: 6.0.3.2 (x64)
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL

vs

Version: 6.0.2.1
Build ID: 1:6.0.2~rc1-0ubuntu0.16.04.1~lo1
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

(the original report was against 5.4.6.2 on Linux Mint v.18)

I mark it as a Linux problem, but actually it looks more like a general problem
which happens to manifest itself on Linux for this specific font (I guess it
would be the the problem also on Windows if required font was missing).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180402/1e8f9978/attachment.html>