poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48969] New: IllegalStateException reading fields with VLOOKUP formula after editing with OO
Date Tue, 23 Mar 2010 17:32:00 GMT
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: dev@poi.apache.org
        ReportedBy: mwildam@gmail.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message