https://bugs.documentfoundation.org/show_bug.cgi?id=159031
Bug ID: 159031
Summary: Calc "IF" statement incorrect value return when higher
than column "N" input entered.
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using Calc on a large spreadsheet "IF" formula will return "#VALUE!" when
column used in formula is greater than column "N".
example: =IF(N42>0,N42-N41,"") will return correct value if N42 has a value
greater than 0 and a blank if 0.
example: =IF(O42>0,O42-O41,"") will return correct value if O42 has a value
greater than 0 but will return #VALUE! if O42 is 0.
This seems to be true for all columns "O" and greater.
Steps to Reproduce:
1.use "IF" statement
2. reference column "O" or higher
3. use "" for a blank return as last part of formula
Actual Results:
See description for results
Expected Results:
Should be a blank return if the input value is 0
Reproducible: Always
User Profile Reset: No
Additional Info:
cdeefe4 Version 7.5.9.2, tag libreoffice-7.5.9.2 by Xisco Fauli ยท
--
You are receiving this mail because:
You are the assignee for the bug.
