https://bugs.documentfoundation.org/show_bug.cgi?id=145732
Bug ID: 145732
Summary: Formula that works in Excel, but not calc
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This is a simple formula, but will fail without manipulation in Calc...
HEre it is in Excel:
=IF(B28=0,"",(B28:N28))
In Calc, it requires teh additional "SUM"
=IF(B28=0,"",SUM(B28:N28))
No big deal, but seems to be a formula that should work without the "SUM"
Steps to Reproduce:
1.Type formula as it is in Excel
2.Fails
3.
Actual Results:
USe the formula stated above, as you would in Excel, and it requires the
additional SUM
Expected Results:
Not #VALUE
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
