[Libreoffice-bugs] [Bug 47932] New: : Formula if

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Mon Mar 26 22:54:08 PDT 2012


             Bug #: 47932
           Summary: : Formula if
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.5 RC1
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: zwik at interka.pl

Created attachment 59102
  --> https://bugs.freedesktop.org/attachment.cgi?id=59102
example sheet

Problem description: 

Steps to reproduce:
1. N12 and O12 - number value
2. =if ((N12-O12)>0;N12-O12;CHAR(32))
3. polish version =JEŻELI((N12-O12)>0;N12-O12;ZNAK(32))
4. this bu is happen in versions above 3.3.3

Current behavior:

when (N12-O12)<0, calc return me #ARG!

Expected behavior:

empty cell (with white space)

Platform (if different from the browser): 

Windows Vista, XP, 7.

Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101

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

More information about the Libreoffice-bugs mailing list