[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-08 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 PJ Fanning changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|---

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #8 from J English --- Created attachment 39698 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39698&action=edit zip file contains a simple test class and an excel template Hi PJ, Hopefully this is a lot simpler than the pr

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #7 from J English --- OK got it. No worries. I'll try uploading much simpler version of the code. I'll keep you posted. -- You are receiving this mail because: You are the assignee for the bug.

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #6 from PJ Fanning --- I am not going to look any further at that sample. It is far too complicated. -- You are receiving this mail because: You are the assignee for the bug. ---

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #5 from J English --- Sorry, please use this version of the test class. This version has the correct file names for the csv file, excel template file, and output file. Thank you import java.io.File; public class TestExcelWrite

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #4 from J English --- Created attachment 39697 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39697&action=edit zip file that contains class, test class, csv file, excel template, and output files Thank you for your help. I

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-03 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #3 from PJ Fanning --- If you want Excel to calculate the formulas when you open the workbook, you need to call. workbook.setForceFormulaRecalculation(true); POI has some basic support for calculating formula results but a lot of

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-03 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #2 from PJ Fanning

[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-03 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 J English changed: What|Removed |Added OS||All --- Comment #1 from J English --- I a