Description: INT table formula has Expression is faulty when opened in LO. Steps to Reproduce: 1. Create a new docx in Word. 2. Insert a Table. 3. Insert INT() formula to some of the cells. 4. Save and open it in LO. Actual Results: The cells which had and INT formula now have ** Expression is faulty ** instead of what was in them in Word. Expected Results: All the cells should have the same data in them. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.3.0.0.alpha0+ Build ID: 17dd2662ccfa9d04efbea74e5d7548db5b2126d4 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Created attachment 149179 [details] Screenshot of the original document side by side in Word and Writer.
Created attachment 149180 [details] Document with INT table formulas.
Formulas: debug:7354:7354: =INT(5,21) debug:7354:7354: =INT(C1)
(In reply to Xisco Faulí from comment #3) > Formulas: > > debug:7354:7354: =INT(5,21) I'm not sure what is meant by this 2 argument example for INT. In Word, INT seems to only take one argument.
(In reply to Michael Warner from comment #4) > (In reply to Xisco Faulí from comment #3) > > Formulas: > > > > debug:7354:7354: =INT(5,21) > > I'm not sure what is meant by this 2 argument example for INT. In Word, INT > seems to only take one argument. That's 5.21 with a Hungarian decimal separator which is comma instead of English dot. So 5.21 rounded down to the nearest integer is 5.
Ah, I see. Thank you.
Still reproducible in Version: 7.2.0.0.alpha0+ Build ID: 84af20ef3ea72190784e9e7be820684c2558ba8c CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Proposed patch in https://gerrit.libreoffice.org/c/core/+/133091
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/27953931d4f6a8c69b98a90c63db81ebb27cdf63 tdf#123381: sw: add table formula INT It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I guess we can close this issue as RESOLVED FIXED @laszlo, Thanks for reviewing the patch
*** Bug 137749 has been marked as a duplicate of this bug. ***