https://bugs.documentfoundation.org/show_bug.cgi?id=159544
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #16 from Regina Henschel <[email protected]> --- The method ScInterpreter::IterateParametersIfs() in interpr1.cxx tries to reduce the to be queried range. Such reduction is necessary to catch cases where the user has selected entire rows. The method uses the range in the first parameter pair. If this range has empty cell at the end, reducing is triggered, regardless of the criterion. Problem is, that the loop in #6204-#6474 goes backwards. Thus the range of the second parameter pair is reduced and the query results are only determined for the reduced range. Only after that, the reduction in the first row is reverted because the condition is a "query for empty cell". That is too late for the calculations for the second parameter pair. A solution might be to only take a range of a parameter pair that has a criterion other than "query for empty cell" for calculating the reduction. -- You are receiving this mail because: You are the assignee for the bug.
