Bug 158263 - LibreOffice Calc can not calculate
Summary: LibreOffice Calc can not calculate
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-18 10:00 UTC by marris1967
Modified: 2023-11-21 13:21 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Picture of my calculation (28.32 KB, image/jpeg)
2023-11-18 10:03 UTC, marris1967
Details

Note You need to log in before you can comment on or make changes to this bug.
Description marris1967 2023-11-18 10:00:42 UTC
Description:
Hey
The sum of my calculation was wrong. It counted 0,30 wrong. Not much but it is a bug. I used the fx function.

-----------------------------------------------------------------------
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: sv-SE (sv_SE); UI: sv-SE
Calc: CL threaded

Actual Results:
I am a middle aged woman who just try to calculate some stuff. :-)

Expected Results:
I am a middle aged woman who just try to calculate some stuff. :-)


Reproducible: Didn't try


User Profile Reset: No

Additional Info:
I am a middle aged woman who just try to calculate some stuff. :-)
Comment 1 marris1967 2023-11-18 10:03:27 UTC
Created attachment 190898 [details]
Picture of my calculation

The sum 19184,50 is actually 19184,80 when I use a calculator.
Comment 2 Werner Tietz 2023-11-18 13:20:34 UTC
nice picture!
But it tells nothing, please attach a Example.ods which shows the Data inclusive your Formula wich returns wrong calculations.
Comment 3 marris1967 2023-11-20 17:36:48 UTC
If You count the posts on the picture You will see it doesn't add up. I cant show You my calculator to prove there is a bug. The difference is small but the sum shows 0,30 difference.
Comment 4 ady 2023-11-20 18:43:58 UTC
(In reply to marris1967 from comment #3)
> I cant
> show You my calculator to prove there is a bug.

The picture and minimal description is clear, but there is no way that the potential bug could be solved without having the actual spreadsheet file.

You could make a copy of the original file and then edit such copy in order to eliminate any private and/or unneeded data, and leaving only the minimal data that would reproduce the problem. Save that minimal sanitized copy.

With such minimal file, click on the "Add an attachment" link so as to add it to the report. Please be aware that such file would be publicly available. See also

https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission

Unfortunately, without a sample spreadsheet file, there will be no other choice but to close the report.
Comment 5 marris1967 2023-11-20 19:02:56 UTC
Thank You for Your time but it seems a bit too much details for an old person like me.:-) I guess I have to double check with a calculator when I use important numbers. I just wanted to inform You about a bug. Have a nice evening!
Comment 6 QA Administrators 2023-11-21 03:12:36 UTC Comment hidden (obsolete)
Comment 7 ady 2023-11-21 13:21:05 UTC
I am setting this report as "insufficient data". If a similar problem shows up again and the (sanitized) spreadsheet file can be attached, don't hesitate to reopen the report.