Bug 42297 - exception on cell with both name and expression error
Summary: exception on cell with both name and expression error
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2007-04-30 06:50 UTC by Chris Winters
Modified: 2015-03-01 21:47 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Chris Winters 2007-04-30 06:50:41 UTC
When reading a workbook, a formula cell with both a missing variable and an
expression error (e.g. "=A1 missing_var") will cause 3.0-alpha3-20061212 to throw 
    UnsupportedOperationException:  Unknown Ptg in Formula: 0x49 (73)
In contrast, 2.5.1 issues a warning and returns empty cell.

Like 2.5.1, 3.0-alpha3 issues a warning and returns empty cell if only one error
is present in the cell, for example "=A1 B1" or "=A1 + missing_var".
Comment 1 Dominik Stadler 2014-07-28 20:25:33 UTC
Can you provide a sample file and a unit test which shows the error?
Comment 2 Dominik Stadler 2015-03-01 21:47:05 UTC
No update for a long time => closing this for now. If this is still a problem for you please verify with a recent version of POI and reopen this bug with more information, ideally a unit-test that can be used to reproduce the problem.