Bug 808609

Summary:	implement IFERROR() functions
Product:	Red Hat Enterprise Linux 6	Reporter:	David Jaša <djasa>
Component:	libreoffice	Assignee:	Eike Rathke <erack>
Status:	CLOSED UPSTREAM	QA Contact:	Desktop QE <desktop-qa-list>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.3
Target Milestone:	beta
Target Release:	6.4
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-04-02 12:49:30 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description David Jaša 2012-03-30 20:15:51 UTC

Description of problem:
implement IFERROR() function in spreadsheet formulae as defined in:
http://tools.oasis-open.org/issues/browse/OFFICE-3468

there is threefold motivation for it:
  * it's defined in ODF
  * it's much more convenient and error-resistant to write IFERROR(expr;value)
    instead of IF(ISERROR(expr);value;expr)
  * it's extensively uses in documents created in other spreadsheets (Gnumeric,
    MS Excel) and it is a compatibility issue when interoperating with users
    of said programs

Version-Release number of selected component (if applicable):
libreoffice-calc-3.4.5.2-9.el6.x86_64

How reproducible:


Steps to Reproduce:
1. 
2.
3.
  
Actual results:


Expected results:


Additional info:

Comment 1 Caolan McNamara 2012-04-02 10:13:07 UTC

erack, seeing as you were involved in OFFICE-3468 I presume you know the situation here :-)

Comment 2 Eike Rathke 2012-04-02 12:49:30 UTC

This feature request is tracked upstream with https://bugs.freedesktop.org/show_bug.cgi?id=34729, no need to have yet another one in our tracker.