Bug 157094 - Calc miscalculating addition subtraction multiplication division in row
Summary: Calc miscalculating addition subtraction multiplication division in row
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-04 20:15 UTC by sziraki.tamas
Modified: 2023-09-06 13:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample file (7.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-09-04 21:23 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sziraki.tamas 2023-09-04 20:15:27 UTC
Description:
Calc calculates this row of math operations incorrectly with or without brackets.
7+7:7+7×7-7=
In the Calc the result is 49, but the correct result is 50.

Actual Results:
Just try it!

Expected Results:
The same as before.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: hu
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 m_a_riosv 2023-09-04 21:23:38 UTC
Created attachment 189351 [details]
Sample file

In Calc the result is 50, your formula needs to be adapted.
=7+7/7+7*7-7
Comment 2 sziraki.tamas 2023-09-05 19:08:17 UTC
(In reply to m.a.riosv from comment #1)
> Created attachment 189351 [details]
> Sample file
> 
> In Calc the result is 50, your formula needs to be adapted.
> =7+7/7+7*7-7

Ouch! Sorry, and thanks.
Comment 3 m_a_riosv 2023-09-05 22:12:45 UTC
With this kind of dudes, please go first to ask.libreoffice.org
Comment 4 ady 2023-09-06 02:56:40 UTC
(In reply to m.a.riosv from comment #3)
> With this kind of dudes, please go first to ask.libreoffice.org

FWIW, by "dudes" you probably meant "doubts". I'm just mentioning this because someone might (mis)understand comment 3 as rude in some way.
Comment 5 m_a_riosv 2023-09-06 08:59:14 UTC Comment hidden (off-topic)
Comment 6 ady 2023-09-06 13:28:37 UTC Comment hidden (off-topic)