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: [email protected]
Reporter: [email protected]
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.
