https://bz.apache.org/bugzilla/show_bug.cgi?id=65520
Bug ID: 65520
Summary: evaluate result is 0 when a cell type is mistook as
string
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: 57783...@qq.com
Target Milestone: ---
Created attachment 37989
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37989&action=edit
file and debug img
i am reading a xls file with cell value("=SUM(J15:CX15)"),
in excel the result is ok,but when i read it with poi,the result is 0.
i tried to find the problem and i see it maybe caused by the celltype of J15 to
CX15,most of the type is string.
my poi version is 3.17,and i tried to change that to 4.1.2,but that not
work.how can i get the correct result?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
