[Libreoffice-bugs] [Bug 131536] New: FILEOPEN XLSX TEXT formula gives different result than in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131536
           Summary: FILEOPEN XLSX TEXT formula gives different result than
                    in Excel
           Product: LibreOffice
           Version: 4.3.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org

Created attachment 158936
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158936&action=edit
Example file from Excel

Attached document contains a TEXT formula that was made in Excel. 
If it is called using the empty string as third parameter, embedded in an IF
formula, it gives back a Err:502 result, unlike Excel. 
However if the same formula is called using “0” as third parameter, the error
is not present. 
The problem does not appear until the result from TEXT is used in an IF
formula, so the example file contains a breakdown of the complex IF formula as
well.

Steps to reproduce:
1.      Open attached document.

Actual results:
The formula in D10 gives TRUE in Excel, but Err:502 in Calc.
The same formula with a small change in the TEXT formula is in E10, gives 1 in
Calc.

Expected results:
The formula in D10 gives 1 in Calc.

LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: b07d429f8610c4df93dffa72552f4f759ec0b74f
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Also in:

Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: GL; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)

Version: 4.3.0.4
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0

In 4.0 - 4.2 even worse, since the Err:502 appears as result of the simpler
formulas, not only IF.

-- 
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/20200324/e7c051bc/attachment.htm>