https://bz.apache.org/bugzilla/show_bug.cgi?id=68974
Bug ID: 68974
Summary: Unable to edit cell type on excel file that was
generated via Apache Poi API
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: jengl...@xifin.com
Target Milestone: ---
Created attachment 39695
--> https://bz.apache.org/bugzilla/attachment.cgi?id=39695&action=edit
Generic excel file that shows the cell type issue
To give a quick synopsis, I'm using Apache POI API to generate an excel file. I
first collect and print all the data needed into a csv file. I then import the
csv file into an excel file using an excel template. When the excel file is
finished generating, everything looks as expected. However, when I attempt to
change the cell type for any cell, the change never takes effect. I think it
might the result of importing all data as String values onto the excel file,
but I'm not really sure.
I need the ability to update the cell type for specific cells so that our
clients can add their custom formulas to the excel after it's been generated.
For example, if A1 is a numeric cell with a value = 123.45 and I add the
formula to an empty cell '=SUM(A1)', the result the formula return '0'. I've
even tried changing the cell type of A1 to Numeric, but the formula still
returns 0. Can someone please confirm if these is a bug, or if there is
anything I can do to allow the manually cell type edits to take effect after
the excel file has been generated?
I've attached a generic xlsx file that shows the issue that I am referring to.
I'm trying to run SUMIF formula to subtotal amounts that have a certain value
in a description column.
Thank you.
--
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
