https://bugs.documentfoundation.org/show_bug.cgi?id=155239
Bug ID: 155239 Summary: EDITING: "--" not interpreted as convert TRUE to 1 Product: LibreOffice Version: 7.4.6.2 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: chrispratt6...@gmail.com Description: TLDR: Feature request to copy Excel's "--" command which converts TRUE/FAlSE to 1/0. For the purpose of functions like "=SUM(A1:A4)" Excel does not natively convert TRUE/FALSE to 1/0, unlike LibreOffice. Excel uses a double minus sign to do this conversion (i.e. "=SUM(--(A1:A4))"). LibreOffice currently doesn't support "--" and the cell encountering the "--" will throw a error. This creates a file which Excel can open but LibreOffice cannot. The request is to add support for "--" purely for reasons of compatibility with excel. Steps to Reproduce: In a blank file in LibreOffice enter the equation "=SUM(--(F1:F4))" it will throw a #VALUE! error. In a blank file in Excel enter the equation "=SUM(--(F1:F4))" it will show "0" Actual Results: N/A Expected Results: N/A Reproducible: Always User Profile Reset: No Additional Info: N/A -- You are receiving this mail because: You are the assignee for the bug.