Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.7.0
-
Component/s: None
-
Security Level: Jimmy
-
Labels:None
Description
Steps to Reproduce
1. load formulaNamedRange.xlsx file
2. check B7
Current Result
#VALUE
Expected Result
it's A
Debug Information
- The named range condition_result, contains a 2 cells reference B2:C2
- Excel can evaluate a named range as a single value
- keikai-376.xlsx
is a user case
Workaround
- change B2:C2 to 1 cell, B2
Attachments
Issue Links
- relates to
-
KEIKAI-457 evaluating IF() produces a NullPointerException
-
- Closed
-