[Libreoffice-bugs] [Bug 135551] New: =min() wrong results and intelerance to text in fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135551
           Summary: =min() wrong results and intelerance to text in fields
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kestutis.snieska at gmail.com

Description:
    The cell in the O column is =min(HRowNumber:NRowNumber). The result for
DIN912 M10x240 and M10x260 are "out of space": arbitrary values, not any of the
values it is applied to.

The document is made with LibreCalc 6.4.5.2 on Windows 7 with Russian Locale
(the formula is entered in russian, originaly, but even if I open it on a
machine with english locale and correct it, it still misbehaves).
Interestingly, If import it to google sheets, it does misbihave there too. (I
have already reported it to google).   
    Here is the link to the .ods file:
https://drive.google.com/file/d/1ufnc-POvKPANO83aTZNaRvUZqLIpn1jX/view?usp=sharing

   A bit older version of the spreadheet
(https://drive.google.com/file/d/1mzZmbnXj25-L2CDeP7au1UTlXUHBEA8O/view?usp=sharing
, 
   does not exibit the error if I open it on another machine with
English/Lithuanian locale, do a colum inster and appy the formula(=min()).
Tested it with LibreOffice 6.3.6.2 (x64), Portable Apache OpenOffice 4.7 and
Google Calc).

   Something is wrong with my LibreOffice, which does not like ascii strings in
cells using =min() : if the text is present, it shows error "#ЗНАЧ!" (#VALUE!).
If I delete the text, then it shows another error: "#ДЕЛ/0!
" (#DIV/0). Interestingly, that same document, when imported to google docs,
does behave the same: same mistakes, same strange values with the mentioned
strings.

Steps to Reproduce:
see the document (it misbehaves in the O column).

Actual Results:
1) =min and =mina is afraid of text cells
2) sometimes assigns strange values (totally non-existant in the selected
range).

Expected Results:
1) =min() ignores text cells
2) =min() assigns the minimum value of the range it applies to.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Версия: 6.4.5.2 (x86)
ID сборки: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
Потоков ЦП: 2; ОС: Windows 6.1 Service Pack 1 Build 7601; Отрисовка ИП: по
умолчанию; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

-- 
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/20200808/3a8086e9/attachment.htm>