https://issues.apache.org/bugzilla/show_bug.cgi?id=48969
Summary: IllegalStateException reading fields with VLOOKUP
formula after editing with OO
Product: POI
Version: 3.6
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I have an existing XLS file from a customer with VLOOKUP-Formulas referencing a
separate sheet.
I can read the cached values using
value = cell.getStringCellValue();
where cell contains a formula =VLOOKUP(.... - for example:
=VLOOKUP($D3;$Entity.$A$1:$B$1048576;2;FALSE())
(I am not going to re-evaluate the value because references can be also to a
separate file I didn't get from the customer.)
So far so good - looks fine. Now the thing is, that I am on Linux (Ubuntu 9.10)
and there are a few invalid (invalid in they way that they contain data I don't
want to process) lines and I just deleted them using Open Office Calc v3.1.1
build 9420.
After I saved the file with Open Office all columns containing a
VLOOKUP-formula throw an IllegalStateException when I try to call
value = cell.getStringCellValue();
I tested the same saving the OO XLS file as XLSX - and there it works. So this
is a workaround.
--
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]
