Did you try setCellValue(HSSFRichText) ?
Or you could try to put a ' in front of the value as a workaround.
A company I work for always sends me "leading zero" data formatted with the
(') since the sheets are created with an older application.
--
/Kevin Pepperman
â"An open mind that demands no evidence will let in an awful lot of
rubbish"
-QualiaSoup
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
