Bug 808609 - implement IFERROR() functions
Summary: implement IFERROR() functions
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: Red Hat Enterprise Linux 6
Classification: Red Hat
Component: libreoffice
Version: 6.3
Hardware: All
OS: All
medium
medium
Target Milestone: beta
: 6.4
Assignee: Eike Rathke
QA Contact: Desktop QE
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-03-30 20:15 UTC by David Jaša
Modified: 2012-04-02 12:49 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-04-02 12:49:30 UTC
Target Upstream Version:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Debian BTS 662798 0 None None None Never
FreeDesktop.org 34729 0 None None None Never

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.


Note You need to log in before you can comment on or make changes to this bug.