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@86-TDF, Branch:master, Time: 2021-09-09_07:27:56 Calc: threaded
Created attachment 175184 [details] example DOTX to test bug This DOTX file contains the field with the custom formula. It comes from a collection of templates by Robert Kingett: https://github.com/rkingett/writertools/releases
I confirm the behaviour with Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL Word count field should disply "7" but displays "70" But if you display field names (Strg+F9) you can see that there are two fields: "Statistics" and "ROUND(|-2)" I can't compare with Word 2016, because I get a Syntax Error So not sure for 100%, if it is a bug or not.
@NISZ Team, I thought you might be interested in this issue
With word 2010 I get "!Syntax error" in the field. @Xisco, do you have actual version of Word?
Stragu, which version of MS Word do you use?
You don’t have to worry about spending hours looking for someone to write my assignment and clarifying your draft because <a href="https://buyessay.net/">buyessay.net</a> our experienced writers and researchers will do all the work for you.
Version of MS Word is: Microsoft 365 Apps for enterprise Version 2202 (Build 14931.20132 Click-to-Run)
Both with the latest and 7.0 I just see 00 and it does not update when adding words. Office.com opens the file as read only and I don't know how to change that. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8389048cb41291917449e87b2901d6133bce3373 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 21 December 2022
Word 2016 always shows 0 when text is added
Created attachment 184370 [details] same example document, with 588 words Using MS Word and showing the syntax with "right click > toggle field codes": { =ROUND({ NUMWORDS },-2) } One needs to add dozens of words and then Ctrl + A, F9 to update the field and see a change. (Or right-click on the field and "update field".) In a new version of the document with many words added (588 words in this new attachment), saved with MS Word, one can see that LO splits the formula into the "Statistics - Words" field (a simple word count, which does update with Tools > Update > Update all) directly followed by the static "ROUND(|-2)" field, showing the value "600" last calculated by Word. Word version: Microsoft® Word for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit LO version: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 29c2bba1f3ef216d226c97197185066880fc1ab5 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Same in: OpenOffice.org 3.3.0 OOO330m20(Build:9567)
Dear Stéphane Guillou (stragu), To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug