[Libreoffice-bugs] [Bug 122775] New: Loss of Information in Quattro Pro Files

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122775
           Summary: Loss of Information in Quattro Pro Files
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: emperdue at comcast.net

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.

-- 
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/20190117/6a1f7227/attachment-0001.html>