Bug 157169 - LibreOffice calculates the formula incorrectly (Incorrect value in cell).
Summary: LibreOffice calculates the formula incorrectly (Incorrect value in cell).
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-09 15:58 UTC by sommerluk
Modified: 2023-09-09 17:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
bug01.ods (11.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-09-09 15:59 UTC, sommerluk 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description sommerluk 2023-09-09 15:58:26 UTC 
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
Comment 1 sommerluk 2023-09-09 15:59:01 UTC 
Created attachment 189462 [details]
bug01.ods
Comment 2 Mike Kaganski 2023-09-09 17:39:54 UTC 
This is not a bug.
In your file, the automatic calculation is turned off (see Data->Calculate->AutoCalculate). This means, that whenever the cell contains a formula, and the also a pre-calculated value, it will not re-calculate again. When you enter a formula into a blank cell, it has no pre-calculated value, so calculates regardless; but when you copy an existing cell with a formula nad a value, it will be kept.