Bug 158263

Summary: LibreOffice Calc can not calculate
Product: LibreOffice Reporter: marris1967
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: normal    
Priority: medium    
Version: 7.6.2.1 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Picture of my calculation

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.