<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - XLSX import: Different column widths on Linux vs Windows"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116738">116738</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLSX import: Different column widths on Linux vs Windows
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mikekaganski@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=141017" name="attach_141017" title="XLSX which has different column widths when imported on Windows vs Linux">attachment 141017</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141017&action=edit" title="XLSX which has different column widths when imported on Windows vs Linux">[details]</a></span>
XLSX which has different column widths when imported on Windows vs Linux
Original report: <a href="https://ask.libreoffice.org/en/question/151109">https://ask.libreoffice.org/en/question/151109</a>
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).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>