https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #4 from J English <jengl...@xifin.com> ---
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 is a very slimmed down version of my original code. We normally
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 String.

One thing, you might also notice though, and maybe this might be a question for
Microsoft, if you attempt to change the cell type for one of the modified
cells, the change never take effect. I wasn't sure if there was anything in POI
that might be locking the cell type because I am able to update to cell style.
For example, try manually changing the cell type to something random like
'Percentage' and you'll see what I'm referring to. 

Can you please advise if you think the cell type issue might be a POI thing? I
think that if the cell type can be updated, it should resolve the issue with
the manually added formulas.

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

Reply via email to