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