[Libreoffice-bugs] [Bug 52366] New: Numeric calculation of cells with mixed data-types leads into a calculation error

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52366

             Bug #: 52366
           Summary: Numeric calculation of cells with mixed data-types
                    leads into a calculation error
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.4 release
          Platform: x86-64 (AMD64)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: supp at aquintos.com


- create a new spreadsheet document
- put the numeric value 2 into cell A1
- put the formula =A1-A2 into cell B1
  - you'll get a "2" in B1
- now enter the formula =IF(1=1;"";"") into cell A2
  - B1 contains an error

As an empty string is often use as some kind of a default value it's irritating
the formula isn't calculatable.

Works perfekt with OOo 3.0 and Excel (didn't check it with former version of
LibO).

May be I missed a setting? (neither online-help, nor google, nor preferences
helped me on this topic)

Please allow empty strings to be used in numeric operations (again).
Btw.: just tested it on LibO 3.5.5, too.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.