https://issues.apache.org/bugzilla/show_bug.cgi?id=46973


Josh Micich <[email protected]> changed:

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




--- Comment #2 from Josh Micich <[email protected]>  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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to