Created attachment 120482 [details] File with problem In cell G3 formula is =F3*L3, where L3 is percent value. Instead value i get error:522. For ods, xlsx this problem doesn't exist
A hard recalculate (Shift+Ctrl+F9) or even a simple reload solves the problem. Not sure yet what's going on there..
Does turning off OpenCL fix the problem ??? Maybe the same as bug 94924 then ?!
This is indeed due to OpenCL being enabled, though it is not OpenCL that fails.. @tml (as you were lately working on OpenCL and group calculation): Breaking in ScFormulaCell::Interpret() in if(bRunning) and going up the stack reveals that calculation was entered through ScFormulaCell::InterpretFormulaGroup() and ScGroupTokenConverter::convert() and ScColumn::FetchVectorRefArray(). In appendBlock() of sc/source/core/data/column2.cxx for sc::element_type_formula blocks the sc::FormulaResultValue is checked for ScErrorCodes::errCircularReference and the formula cell is reset (with comment "This cell needs to be recalculated on next visit."). However, if the calculation dependencies involved other cells that already resulted in errCircularReference which then is propagated, resetting only that cell doesn't help, actually all cells that it depends on and their predecessors would have to be reset as well. This first happens for cell J4 on sheet 2 (ScAddress ScFormulaCell::aPos == {nRow = 3, nCol = 9, nTab = 1}) To me that approach can not work as the reverse dependency information is not available and I'd entirely disable handling sc::element_type_formula in appendToBlock() and immediately return false instead. Other opinions?
I'm trying some different approach first.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d46203b55d92185ab2c1d3ac79761100d26aaee3 Resolves: tdf#95748 no group interpreter when calculations are running It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=14096319475eca0c738cbd71267a1f2123361897&h=libreoffice-5-1 Resolves: tdf#95748 no group interpreter when calculations are running It will be available in 5.1.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/20328 for 5-0
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e389e2b2d9bc87e451628e6f3f227d0eb781cf8b&h=libreoffice-5-0 Resolves: tdf#95748 no group interpreter when calculations are running It will be available in 5.0.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.