Skip to content

Cell#getCachedFormulaResultTypeEnum returns incorrect value #153

@chkal

Description

@chkal

Hi!

First of all thank you very much for this awesome library. We are currently having trouble parsing very large Excel file with POI and came across your library. It is basically working great! Impressive work! So thank you.

Unfortunately we ran into one issue. We are having troubles parsing Excel files containing formulas. Our existing code basically checks the cell type and if it finds CellType.FORMULA, it will use cell.getCachedFormulaResultTypeEnum() to get the effective cell of of the cached formula result saved with the file.

Well, the issue seems to be, that cell.getCachedFormulaResultTypeEnum() also returns CellType.FORMULA instead of something like CellType.NUMERIC. As our code is recursive, we are running into a StackOverflowError.

I hope to find some time in the next days to have a deeper look at your code myself, but any help would be highly appreciated.

PS: I tried both 1.2.1 and the latest snapshots.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions