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 46973] IllegalArgumentException when calling Name.isDeleted().
Date Mon, 06 Apr 2009 20:07:48 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46973


Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #2 from Josh Micich <josh@gildedtree.com>  2009-04-06 13:07:46 PST ---
It appears that the attached workbook has a defined name "UPSState" with all
other properties uninitialised.  Excel silently ignores the name, and if you
re-save, the name is removed.  It seems like the offending record was created
via POI, using code like this:

Workbook wb = new HSSFWorkbook();
wb.createSheet("Sheet1");
Name n = wb.createName();
n.setNameName("UPSState");
wb.write(new FileOutputStream("bad-name.xls");

It would be a big change to make POI do the same as Excel (delete the name and
adjust all formulas), so it was just fixed to avoid the
IllegalArgumentException.  For uninitialised defined names, isDeleted() will
return false and getRefersToFormula() will return null. 

Fixed in svn r762479 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=762479 )junits
added

-- 
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