https://bugs.documentfoundation.org/show_bug.cgi?id=170840
--- Comment #15 from ady <[email protected]> --- (In reply to jlucschoon from comment #11) > Created attachment 205598 Test A: > - If we put a non-numerical value Test B: > - If we put an error, for example =1/0 for #DIV/0! Please be aware that bibisecting these 2 different Tests could / would end up with different commit ranges, because the behavior of each of these Tests changed in different versions of LO. _ For Test A in LO 3.3 and 4.0.0.3, putting a letter in cell A6 and in cell C8, will cause a delay (from the macro) after both changes, and both will end in numerical results in D7 and in F7, respectively. _ For Test A in LO 5.0.6.3 and in a recent LO Dev 26.8, putting a letter in cell A6 and in cell C8, will cause a delay (from the macro), but only the second change (cell C8) will end in numerical result in F7; the change in cell A6 ends up with a #VALUE! error in cell D7. NOTE: cell D7 is an array formula, whereas cell F7 is not. The "SOM" macro is _not_ performing the same SUM operation. In D7, with the original numbers in attachment 205598, the array formula results in 81, whereas the non array formula would result in 11 – both results as expected. _ For Test B in LO 3.3 and in a recent LO Dev 26.8, putting '=1/0' or '=NA()' (without quotation marks) in cell A6, will cause a delay (from the macro) for the first set of ranges A5:A10+B5:B10 (result in D7). But when changing cell C8, the reaction is immediate (no delay) for the range C5:10 (result in F7). The reason might be the array vs. non-array formula. -- You are receiving this mail because: You are the assignee for the bug.
