In calc, I'm getting logical results (true/false) instead of numeric results for simple formulas like =2/4. It worked fine until recently, possibly until the last upgrade (I'm on 4.4.5.2 now). This influences also existing spreadsheets, so I'm basically stuck. Debia sid. Tried to ask for assistance on IR and on https://ask.libreoffice.org/en/question/56957/logical-results-boolean-instead-of-numeric-ones-in-calc/ without reply, so I resolved to open a ticket.
Please attach a sample document. Setting to NEEDINFO. Once you attach a simple document please set to UNCONFIRMED.
Created attachment 118324 [details] file required Please find it herewith attached. I do not think it matters much, however: the files which worked in previous versions stopped working now. Thanks for looking into this.
Set format of the cell to Numeric or All and recalculate the sheet (ctrl+shift+F9). Cell format is boolean. Closing as notabug.
Done, the result is 1, even if not formatted as boolean. The issue is not formatting, but the type of calculation, which tests the logical validity of the expression, not its numeric result. Not resolved here.
Please note that the same issue remains when removing user config (~/.config/libreoffice), so it does not seem a local issue.
(In reply to Paolo Cavallini from comment #4) > Done, the result is 1, even if not formatted as boolean. > The issue is not formatting, but the type of calculation, which tests the > logical validity of the expression, not its numeric result. > Not resolved here. Did you recalculate the sheet (ctrl+shift+F9) ?
Yes
Can't confirm. Ubuntu 15.04 x64 LibreOffice 5.0.0.5 A hard recalculate resolves the issue. If one more QA member fails to confirm then this is environment specific and thus NOTOURBUG. I'll try to find another person to test. I would suggest asking ask.libreoffice.org as well.
(In reply to raal from comment #3) > Set format of the cell to Numeric or All and recalculate the sheet > (ctrl+shift+F9). Cell format is boolean. Closing as notabug. I confirm this.
With a third QA member not being able to confirm the issue (hard recalculate resolves the problem after setting the format to number) I am closing this as NOTABUG. Please do the following: 1. Test with 5.0.0.5 2. Fresh profile; If those fail please reach out to user mailing list or ask site. Thanks
Thanks for this. Unfortunately I cannot test with LO5, as it is blocked by GCC5 transition in Debian sid. I'm positive is an issue with my version.
I just tested with 4.4.5.2 on Ubuntu 15.04 and it works fine (same as before, set to number, hard recalc, everything is fine)
So I'm lost: retried once more, I confirm that here it does not work. It seems a local issue, but I have no clue about what to check. Thanks.
Further note: I noticed that LO inserts extra spaces in the formula every time I open it, like: = 2 + 2 Could this depend from some parsing lib?
I confirm that the issue has disappeared in LO5