https://bugs.freedesktop.org/show_bug.cgi?id=64387
Priority: medium
Bug ID: 64387
Assignee: [email protected]
Summary: Implement IFNA and IFERROR as defined in Open Document
Format
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Implement IFNA and IFERROR as defined in Open Document Format for Office
Applications
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05-part2.pdf
6.15.6 IFNA
Summary: Return X unless it is an NA, in which case return an alternative value
Syntax: IFNA( Any X ; Any Alternative )
Returns: Any
Constraints: None.
Semantics: Computes X. If ISNA(X) is true, return Alternative, else return X.
Thus this is semantically equivalent to IF(ISNA(X); Alternative; X), except
that X is only computed once. If X or Alternative is a cell reference to an
empty cell, it is treated as the empty string "".
6.15.5 IFERROR
Summary: Return X unless it is an Error, in which case return an alternative
value
Syntax: IFERROR( Any X ; Any Alternative )
Returns: Any
Constraints: None.
Semantics: Computes X. If ISERROR(X) is true, return Alternative, else return
X. Thus this is semantically equivalent to IF(ISERROR(X); Alternative; X),
except that X is only computed once. If X or Alternative is a cell reference to
an empty cell, it is treated as the empty string "".
anchor:IFERROR
This will contribute towards LO compliance with the standards for OpenDocument
Large Group Formula Evaluator. In addition since N() and T() now propagate
errors, this will enable spreadsheets that no longer work to be enhanced
without extensive rework (adding new columns or rows, or measures to avoid
formula overflow and slowing down of the application due to double
computation).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
