[Libreoffice-bugs] [Bug 107892] New: MAX.SI function doesn't work with negative values

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107892
           Summary: MAX.SI function doesn't work with negative values
           Product: LibreOffice
           Version: 5.3.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: R125600 at hotmail.com

Description:
Selecting a range and looking for the max value gives 0 when all the values are
<0, not the greatest negative value

Steps to Reproduce:
1. set a column with title "Zone2" for example
2. set aside a column with <0 numbers
3. place in a cell the title from first column
4. place in a cell forumla

Actual Results:  
value is 0

Expected Results:
value is the max available value.
It works fine with MIN.SI and positive values


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170516/8a657711/attachment-0001.html>