Bug 134765 - ROUND will not work with nested subcalls
Summary: ROUND will not work with nested subcalls
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
 
Reported: 2020-07-13 00:09 UTC by Michael Warner
Modified: 2021-02-09 12:22 UTC (History)
3 users (show)

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


Attachments
Example MS Word Document (13.33 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2020-07-13 00:09 UTC, Michael Warner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Warner 2020-07-13 00:09:25 UTC
Created attachment 162945 [details]
Example MS Word Document

When importing an MS Word document that contains a table with a formula that contains a ROUND call with nested subcalls to other functions, the formula is not imported correctly. For example, ROUND(MIN(A1,B1), MAX(C1,D1)) will not be translated correctly.
Comment 1 Mike Kaganski 2020-07-13 03:20:57 UTC
... but it will not import just any formula with function - be it ROUND or SUM; be it simple or nested. So why that level of precision?

Writer has a very different formula syntax: it should be like "2.3456 round 3", not "round(2.3456, 3)". As far as I know, we don't try to convert the function syntax from/to Word syntax to Writer syntax both on load ans save.
Comment 2 Michael Warner 2020-07-13 14:19:05 UTC
I should add that this will still be the case after my proposed patch which converts simpler calls to ROUND() and other functions to Writer syntax. 

https://gerrit.libreoffice.org/c/core/+/98614

What I am pointing out in this bug is that patch will make the formula import situation better, but not completely resolve it.