Bug 808609 - implement IFERROR() functions
implement IFERROR() functions
Status: CLOSED UPSTREAM
Product: Red Hat Enterprise Linux 6
Classification: Red Hat
Component: libreoffice (Show other bugs)
6.3
All All
medium Severity medium
: beta
: 6.4
Assigned To: Eike Rathke
Desktop QE
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2012-03-30 16:15 EDT by David Jaša
Modified: 2012-04-02 08:49 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2012-04-02 08:49:30 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
FreeDesktop.org 34729 None None None Never
Debian BTS 662798 None None None Never

  None (edit)
Description David Jaša 2012-03-30 16:15:51 EDT
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 06:13:07 EDT
erack, seeing as you were involved in OFFICE-3468 I presume you know the situation here :-)
Comment 2 Eike Rathke 2012-04-02 08:49:30 EDT
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.