Bug 123377 - IF function returns Expression is faulty in Writer
Summary: IF function returns Expression is faulty in Writer
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 123359 (view as bug list)
Depends on:
Blocks: Regressions-expression-is-faulty
  Show dependency tree / graph
 
Reported: 2019-02-12 00:33 UTC by Xisco Faulí
Modified: 2020-06-08 07:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file (9.33 KB, application/vnd.oasis.opendocument.text)
2019-02-12 00:37 UTC, Xisco Faulí 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2019-02-12 00:33:49 UTC 
Steps to reproduce:
1. Open attached document

Result: The if function returns Expression is faulty.

Reproduced in

Version: 6.3.0.0.alpha0+
Build ID: 202d9af5ab4291a8f867791293477a18ae48051d
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Xisco Faulí 2019-02-12 00:35:29 UTC 
Regression introduced by

https://cgit.freedesktop.org/libreoffice/core/commit/?id=d667e3210b12c7ce3b3727e2a0e369a520fbaaa4

author	Julien Nabet <serval2412@yahoo.fr>	2015-11-22 17:42:08 +0100
committer	Mike Kaganski <mikekaganski@hotmail.com>	2015-11-24 22:03:10 +0000
commit d667e3210b12c7ce3b3727e2a0e369a520fbaaa4 (patch)
tree dbceb51cdab2c9205e483a859a34f1a838cbc9e6
parent 994d80fd53bc264cef92017dba5cbab1241e5a5b (diff)
tdf#61228: Wrong function names in Formula Writer are considered as SUM

Bisected with bibisect-macosx-64-5.1

Adding Cc: toJulien Nabet
Comment 2 Xisco Faulí 2019-02-12 00:37:04 UTC 
Created attachment 149175 [details]
Sample file
Comment 3 Xisco Faulí 2019-02-12 00:51:07 UTC 
*** Bug 123359 has been marked as a duplicate of this bug. ***
Comment 4 Julien Nabet 2019-02-12 10:37:20 UTC 
I've got no idea how to fix this.
Feel free to revert the patch.
Comment 5 Mike Kaganski 2020-06-08 07:49:37 UTC 
This behaviour is now completely correct (rightfully complaining about unknown "IF" function that is absent in Writer [1]), while it used to return a bogus result previously. The change is intentional and wanted result of the fix for tdf#61228.

If such a function is needed, it's a totally different issue.

[1] https://help.libreoffice.org/6.4/en-US/text/swriter/02/14020000.html