<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 - Loss of Information in Quattro Pro Files"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122775">122775</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Loss of Information in Quattro Pro Files
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>emperdue@comcast.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have just started using this product to convert old Quattro Pro files (WQ1,
WQ2)into Excel XLSX files. I can run Quattro Pro for DOS directly on a Windows
7 PC, and the files contain correct information. When I open those same files
with LibreOffice on a Windows 10 PC, I find that numbers smaller than about
1E-6 are not imported accurately. Once numbers are smaller than about 1E-8,
they are set to zero in LibreOffice. This is on import, before conversion to
XLSX files. My only recourse thus far is to open the file both in Quattro Pro
and in LibreOffice, so I can manually make repairs in LibreOffice and then
convert the file to XLSX. I think LibreOffice is not carrying enough decimal
places during number import and conversion.
Steps to Reproduce:
1.Build a DOS Quattro Pro WQ2 file containing numbers ranging from 0 to 1E-14,
using several significant figures in those numbers.
2.Import the Quattro Pro file into LibreOffice.
3.Observe the error in conversion. If you cannot do this, I can provide a
suitable Quattro Pro file.
Actual Results:
Actual Imported
1.10E-06 1.10E-06
6.76E-07 6.80E-07
4.07E-07 4.10E-07
2.45E-07 2.40E-07
1.41E-07 1.40E-07
7.24E-08 7.00E-08
3.72E-08 4.00E-08
1.91E-08 2.00E-08
8.51E-09 1.00E-08
4.47E-09 0.00E+00
2.29E-09 0.00E+00
1.41E-09 0.00E+00
9.55E-10 0.00E+00
Expected Results:
Imported numbers should match Actual numbers
Reproducible: Always
User Profile Reset: No
Additional Info:
That's all I know to say. I don't know how to answer the next two items.</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>