You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
if I'm not completely wrong, when reading the attached example XLSX File with version 2.10, some (but not all!) of the formulas on first sheet, fetched by StreamingCell.getCellFormula() are returned as zero-length Strings.
It seems the formulas are not properly read in each case by the StreamingReader, even if the cell itself gets marked as CellType "formula".
In the attached example the formulas at cells B5, A8 and A9 are properly read, the formulas at cell C5, D6 and A10, A11... are not
The example implementation (see below) outputs for me (cells B5 and C5):
[...]
read template cell 4 1
celltype FORMULA
type n
isFormulaType true
formula content SUM(B8:B107)
♥♥♥♥♥♥♥♥♥ FINE! ♥♥♥♥♥♥♥♥♥
read template cell 4 2
celltype FORMULA
type n
isFormulaType true
formula content
!!!!!!!!! MISSING FORMULA! !!!!!!!!!
[...]
I added a fix for this in my fork and released v3.2.1. I will update pjfanning#73 with descriptions of how it works but it's pretty much automatic (in normal case).
if I'm not completely wrong, when reading the attached example XLSX File with version 2.10, some (but not all!) of the formulas on first sheet, fetched by StreamingCell.getCellFormula() are returned as zero-length Strings.
It seems the formulas are not properly read in each case by the StreamingReader, even if the cell itself gets marked as CellType "formula".
In the attached example the formulas at cells B5, A8 and A9 are properly read, the formulas at cell C5, D6 and A10, A11... are not
The example implementation (see below) outputs for me (cells B5 and C5):
Example File
example.xlsx
Java Code
The text was updated successfully, but these errors were encountered: