<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - [OPENCL] SUMPRODUCT returns wrong value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=103532#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - [OPENCL] SUMPRODUCT returns wrong value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=103532">bug 103532</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>