https://bugs.documentfoundation.org/show_bug.cgi?id=150618
--- Comment #14 from Luboš Luňák <[email protected]> --- (In reply to Kevin Suo from comment #12) > (In reply to Luboš Luňák from comment #11) > > > This most probably takes 30s because the document uses <> operator in > > lookup operations... > > Maybe off-topic, but do you have any idea what settings should I apply to > avoid the use of <> operator in lookup operations, so that I can try to > optimize my formula? The way to stop a formula from using <> is to modify the formula, there's no option for that. Look e.g. at the SUMIFS formula in columns M and N in sheet FG Cost Calculation 2020-02. -- You are receiving this mail because: You are the assignee for the bug.
