https://bugs.documentfoundation.org/show_bug.cgi?id=99044

            Bug ID: 99044
           Summary: Formatting "shortcurcuit" if div/0 combined with max,
                    min, large or small.
           Product: LibreOffice
           Version: 5.0.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

If you take a range of cells and one of them is div/0 and you use a formula
like this formatting

value equals large(range,2)

then the complete range gets formatted, even if only 1 value is div/0.

You can't avoid that even with iserror as far as I have tested.

Maybe this is intended behaviour but I would expect that div/0 takes rank 1 and
the rest is ranked as usual.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to