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

            Bug ID: 157169
           Summary: LibreOffice calculates the formula incorrectly
                    (Incorrect value in cell).
           Product: LibreOffice
           Version: 7.5.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: sommer...@gmail.com

Description:
LibreOffice calculates the formula incorrectly (Incorrect value in cell).

Steps to Reproduce:
1. Open the attached document bug01.ods.

2. You will see the following table:
A1: 9,41
A2: 8,09
B1: =A1*655,957
The cell B1 shows the value 6172,555537, which is correct.

3. Select the cell B1.

4. Click with the left mouse button at the button-right corner of B1 and move
the mouse upwards, so that B2 will be filled with the formula =A2*655,957

Actual Results:
B2 shows the value 6172,55537

Expected Results:
B2 shows the value 5306,69213


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.6.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:7.5.6~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to