[Libreoffice-bugs] [Bug 34729] New: Office 2007 IFERROR Function Conversion to Calc

[bugzilla-daemon at freedesktop.org]

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

           Summary: Office 2007 IFERROR Function Conversion to Calc
           Product: LibreOffice
           Version: LibO 3.3.1 release
          Platform: All
        OS/Version: Windows (All)
            Status: NEW
          Severity: enhancement
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: landyman at gmail.com


Office 2007 contains a function called IFERROR. IFERROR is a shortcut function
and is not recognized by LibreOffice (or Office 2003 for that matter). 

Here is what I suggest:
1. Either create the IFERROR function to be the same as below, or
2. When importing/opening an Excel 2007 document that uses IFERROR, convert it
using the following information:

Office 2007:
IFERROR(value, value_if_error)

value = argument that is checked for an error
value_if_error = the value to return if the value evaluates to an error. 

If the evalutation value does not return an error, then the evaluation of value
is returned.

LibreOffice suggestion:
IF(ISERR(value),value_if_error,value)

Thanks.

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