[Libreoffice-bugs] [Bug 130458] New: Cannot evaluate an cell with an empty result from a formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130458
           Summary: Cannot evaluate an cell with an empty result from a
                    formula
           Product: LibreOffice
           Version: 3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: moyanocasco.franciscom at gmail.com

Description:
Hello,
    I'm trying to do an simple IF sentence on a cell. For Example:
    On C2, I put this formula
       =IF(B2;1;0)
    Normally, if B2 has some value, will return 1, on the other cases
(FALSE,0,empty cell) will return 0.

    Now, if B2 is the result from a formula, lets say =MID(A2;1;10), and A2 is
empty, B2 will be empty, BUT, C2 will not give me any result from the if (not
1, not 0)

Steps to Reproduce:
1.Make A2 empty
2.Put on B2 =MID(A2;1;10)
3.Put on C2 =IF(B2;1;0)

Actual Results:
Not 1 or 0 result on C2

Expected Results:
It should be 0


Reproducible: Always


User Profile Reset: No



Additional Info:
Versión: 6.3.3.2.0+
Id. de compilación: 30(Build:2)
Subprocs. CPU: 4; SO: Linux 4.12; Repres. IU: predet.; VCL: kde5; 
Configuración regional: es-ES (es_ES.UTF-8); Idioma de IU: es-ES
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/20200205/e9b168b1/attachment.htm>