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

            Bug ID: 120560
           Summary: Calc Spreadsheet arithmetic error depending on cell
                    width
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
I installed version 6.1.2.1 on a Windows 8.1 Toshiba laptop.  The error occurs
when the cell width exceeds 1.25".  

In a wide cell, I typed:
     =267.52-266.54 

The result is: 
     0.979999999999961 

I get the same result when I put the values in two cells, and do the
subtraction by reference.  




Steps to Reproduce:
1. set cell width to exceed 1.25"
2. type:    =267.52-266.54
3. hit <ENTER> 

Actual Results:
0.979999999999961

Expected Results:
0.98 


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

===================

Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: en-US (en_US); Calc: group threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to