[Libreoffice-bugs] [Bug 144651] New: Field using ROUND formula works in MS Office but broken in LibreOffice

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144651

            Bug ID: 144651
           Summary: Field using ROUND formula works in MS Office but
                    broken in LibreOffice
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stephane.guillou at member.fsf.org

Description:
A field that shows the document's number of words rounded to the closest 100 in
MS Office shows instead the number of words with an extra 0 in LibreOffice.

The formula used for the field is "ROUND(|-2)".

Steps to Reproduce:
1. Open attached DOTX file
2. Add some text in the body

Actual Results:
The word count field displays the number of words with an extra 0 (for example,
if the document has 99 words, it says "990 words").

Expected Results:
The word count displays the number of words rounded to the closest 100 (for
example, if the document has 99 words, it says "100 words").


Reproducible: Always


User Profile Reset: No



Additional Info:
One might have to update the fields with Ctrl + A and F9 to make sure the word
count field is current.

Template works as expected in MS Office .

Reproduced in:

Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded

and

Version: 7.0.6.2
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.6-0ubuntu0.18.04.1_lo1
Calc: threaded

and

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 3749d9af3745c0eaff7239e379578e4e2af89e9d
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2021-09-09_07:27:56
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210921/0fe03536/attachment.htm>