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.
The cells which had and INT formula now have ** Expression is faulty ** instead of what was in them in Word.
All the cells should have the same data in them.
User Profile Reset: No
LibreOffice details: Version: 220.127.116.11.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
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.
(In reply to Xisco Faulí from comment #3)
> 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.