[Libreoffice-bugs] [Bug 103532] [OPENCL] SUMPRODUCT returns wrong value

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=103532

--- Comment #8 from b. <newbie-02 at gmx.de> ---
from some 'digging into' ... 

file provided has at least one cell which has a wrong value stored in it, T20:
<text:p>20,0025562025061</text:p> (the content.xml file stores the formula and
the value / string). 

perhaps autocal was off, or the version used was buggy. that makes any
investigation difficult as plenty changes on sheet or in settings will correct
the problem - by triggering recalculation - without having been the cause for
it. 

values brought to screen differ acc. to the settings in 'formula - recalculate
on load' (despite that normally shouldn't affect this file (neither 'ex$el' nor
'not saved with LO'), but it does, at least with 6.4.0.1). 

questionable behaviour of 'recalculate on load' is discussed elsewhere. for me
with 6.4.0.1: 

'always recalculate' comes up with refreshed and correct values, 
'prompt user' doesn't prompt but recalculates, correct, 
'never recalculate' comes up with wrong - stored - values. 

for further investigation a new file with new description is needed, or the
original system and settings where the original bug was 'found', i doubt that
being accessible. 

thus pls. recheck and set to 'wfm - provided file was buggy' or similar. 

reg. 

b.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191227/271ec936/attachment.htm>