| Summary: | exception on cell with both name and expression error | ||
|---|---|---|---|
| Product: | POI | Reporter: | Chris Winters <c_j_winters> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 3.0-dev | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
Can you provide a sample file and a unit test which shows the error? 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. |
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".