https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #9 from J English ---
Your recommended solution worked! Thanks again for all your help guys
--
You are receiving this mail because:
You are the assignee for the bug.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #8 from J English ---
Yes, the reason is that we import data from a csv file, which stores the data
as comma-delimited String values; thus, when we import the data, all values are
imported as a Strings and I use POI to populate the
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #7 from sfis...@gmail.com ---
honestly, the real solution is coerce the values going into the cells to
double, that way the underlying framework does not change the cell type to
string.
from reading the javadoc of the various
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #6 from J English ---
PJ, my bad I forgot to answer your original question. Yes, I did try
re-ordering the code by setting the cell type after the cell value, but it
displayed the following data in the excel file, which seemed
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
PJ Fanning changed:
What|Removed |Added
Resolution|--- |INFORMATIONPROVIDED
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #4 from J English ---
Thank you both for your inputs.
Yes, there are no formulas included the code because I have a customer that
wants to add their own custom formulas to the spreadsheet after the file has
generated.
Also, the
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #3 from PJ Fanning ---
*** Bug 68974 has been marked as a duplicate of this bug. ***
--
You are receiving this mail because:
You are the assignee for the bug.
-
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
--- Comment #2 from Nick Burch ---
I can't see any formula setting in your code
If you set a formula with POI and we don't evaluate it properly, that's our bug
(or possibly one of our limitations)
If you open a file in Excel, it looks fine,
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
PJ Fanning changed:
What|Removed |Added
OS||All
Status|NEW