https://issues.apache.org/bugzilla/show_bug.cgi?id=49397
Summary: VLOOKUP, OFFSET and COUNTA functions doesn't evaluate
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: blocker
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=25538)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25538)
the excel file
Hi,
Overview:
I have a problem that when i read in an excel file and evaluate a function, he
always returns the value 0.
I attached the excel file. It has 2 sheets. The first sheet is "Bereik" and the
second sheet is "Meetnet". In the sheet "Meetnet" in the second column i need
this function that refers to the first sheet to know the intern id for the
selected "Bereik" in "Meetnet".
Reproduce:
I attached a txt file with the code to reproduce the problem. I'm sorry but i
couldn't do more because of the lack of time her at work.
Expected result:
The program should return the iternal id's of "Bereik". For example when the
first column in "Meetnet" is "Europees" then the second column in "Meetnet"
should have the value 3 because that's the id of "Europees" in the sheet
"Bereik".
The problem accured on Windows 7 instead of Windows Vista.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
