Bug 137750 - Implement IF Writer's table function for Word's table interoperability
Summary: Implement IF Writer's table function for Word's table interoperability
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Writer-Tables-Formulas Regressions-expression-is-faulty
  Show dependency treegraph
Reported: 2020-10-25 22:36 UTC by Roman Kuznetsov
Modified: 2022-04-29 11:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

IF table function DOCX example (10.28 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2020-10-25 22:37 UTC, Roman Kuznetsov

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2020-10-25 22:36:34 UTC
Implement IF Writer's table function for Word's table interoperability

Steps to Reproduce:
1. Open file from attach in LibreOffice
2. Look at error message in right table cell
3. There is a formula =IF(A1+B1<50;A1+B1;0) in that cell and it must show a correct result instead an error message

Actual Results:
we have only an error message instead of a result of formula

Expected Results:
we have implemented function IF and we have a correct result in table cell with a formula

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Roman Kuznetsov 2020-10-25 22:37:03 UTC
Created attachment 166716 [details]
IF table function DOCX example
Comment 2 Roman Kuznetsov 2020-10-25 22:37:44 UTC
László, possibly you will be interesting in it
Comment 3 Roman Kuznetsov 2020-10-26 16:35:30 UTC Comment hidden (obsolete)
Comment 4 Regina Henschel 2020-10-26 17:17:13 UTC
(In reply to Roman Kuznetsov from comment #3)
> Regina, should this Writer table function be in ODF standard? If yes, how
> can I add it to next version ODF draft?

There is nothing to do in the standard. It is a pure problem of implementation. But if switching to OpenFormula you have to follow the definitions of the standard. Using own namespace allows you to define functions so, that you get good interoperability with Word.
Comment 5 Buovjaga 2021-07-27 11:35:24 UTC