Bug 122739 - Calc: Multiplication Bug, will display 0 even when multiplying an error message.
Summary: Calc: Multiplication Bug, will display 0 even when multiplying an error message.
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OpenCL
  Show dependency treegraph
 
Reported: 2019-01-15 16:23 UTC by twisterddfsl83823
Modified: 2022-03-20 16:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample of problem (29.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-15 16:24 UTC, twisterddfsl83823
Details
Image of problem (99.40 KB, image/png)
2019-01-15 16:25 UTC, twisterddfsl83823
Details

Note You need to log in before you can comment on or make changes to this bug.
Description twisterddfsl83823 2019-01-15 16:23:24 UTC
Description:
I upgraded from 6.0.7 to 6.1.4 Windowsx64 and my spreadsheet broke.
The problem is the spreadsheet will fails to multiply one column by 7 and instead displays 0.  I haven't been able to figure out what exactly is triggering it. Removing rows, changing numbers sometimes gets it working again, and then when I reopen the file, the correct numbers disappear.
I copied the data over where it's just multiplying the results and it still has the problem, but if I remove enough rows, the problem disappears.  


Other things I've tried that didn't work:
* Safe mode. 
* Having another column be equal to the first and then multiplying that col.


Steps to Reproduce:
1. Open sample file.



Actual Results:
error * 7 = 0
-0.1 * 7 = 0

Expected Results:
-0.1 * 7 = -0.7 
error * 7 = error



Reproducible: Always


User Profile Reset: Yes



Additional Info:
This is really specific, I try different things and the problem can reappear and disappear because of data entry or data removal... only to reappear latter.
Comment 1 twisterddfsl83823 2019-01-15 16:24:05 UTC
Created attachment 148339 [details]
Sample of problem

Simplified file with problem.
Comment 2 twisterddfsl83823 2019-01-15 16:25:23 UTC
Created attachment 148340 [details]
Image of problem
Comment 3 twisterddfsl83823 2019-01-15 16:38:15 UTC
Just test 6.1.3, and the problem was there as well.  Will try to find the 6.0 version and try it next.
Comment 4 twisterddfsl83823 2019-01-15 17:08:28 UTC
6.1.0.3 Has the problem as well.
6.2.0.2 The problem disappears.
Comment 5 Eike Rathke 2019-01-15 18:01:59 UTC
Can't reproduce, E4:E8 are Err:502 results in all release versions I tried.
Try if disabling Tools -> Options -> LibreOffice -> OpenCL, "Allow use of OpenCL" fixes things for you.
Comment 6 Oliver Brinzing 2019-01-15 18:05:21 UTC
(In reply to twisterddfsl83823 from comment #0)
> error * 7 = 0

do you mean "Err:502" e.g. in cell D4?

root cause for this error seems to be:
"ROW(B4)-D$1+1" will evalute to "-2" -> 4-7+1

(In reply to Eike Rathke from comment #5)
Can't reproduce, E4:E8 are Err:502 results in all release versions I tried.

confirming - erro is shown in lo 6.2 too
Comment 7 twisterddfsl83823 2019-01-15 18:16:34 UTC
In my screenshot, I was getting zeros all through column E.
Comment 8 twisterddfsl83823 2019-01-15 18:28:12 UTC
(In reply to Eike Rathke from comment #5)
> Can't reproduce, E4:E8 are Err:502 results in all release versions I tried.
> Try if disabling Tools -> Options -> LibreOffice -> OpenCL, "Allow use of
> OpenCL" fixes things for you.

Disabling OpenCl fixes problem.
Comment 9 twisterddfsl83823 2019-01-15 18:35:31 UTC
Fixed problem by disabling openCL for libreoffice 6.1 series.
My graphics card info:
Radeon software: 18.12.1.1
HD 7800 series 2GB

I'll check to see if upgrading my graphics driver does anything for this issue.
Comment 10 twisterddfsl83823 2019-01-15 20:39:21 UTC
No change in behavior upgrading to latest drivers from AMD.

I'm just going to turn off opencl.  Not sure what the status should be set to.
Comment 11 Oliver Brinzing 2019-01-16 17:27:02 UTC
adding to OpenCL Meta issue
Comment 12 b. 2020-03-08 13:45:06 UTC
looks 'wfm' with below versions, even with 'threaded' and openCL enabled, 

D8: Err:502  |  E8: Err:502
D9: -0,01    |  E9: -0,05

deviation from expected E9: -0,07 results from D9 being something as -0,00703... rounded for display, 

Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: GL; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

and: 

Version: 7.0.0.0.alpha0+ (x64)
Build ID: 10e20a77ce302a0475a661ad1886f2ca83c55f3f
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL
Comment 13 QA Administrators 2022-03-09 03:46:29 UTC Comment hidden (obsolete)
Comment 14 Roman Kuznetsov 2022-03-20 16:32:20 UTC
No repro in

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 51fb84829afbc1c0957fd1a489085613ad199f1a
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL Jumbo

Closed as WFM