Im sorry, Forgot to mention that you could try CFPOI instead of cfspreadsheet.
http://code.google.com/p/cfpoi/ When you create a cell with cfPoi you can also format the cells. On Sun, Jul 17, 2011 at 9:13 PM, Richard White <[email protected]> wrote: > > >Did you try setCellValue(HSSFRichText) ? > > interesting, can you elaborate a bit further, my research on this has not > led me to understanding how this could work? > > >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. > > this is possible although on some spreadsheets there are approx 400 columns > and 1000's of rows all with these possible problems so would have to loop > through every cell setting this, which could of course take a lot of > processing time. although if there is no alternative then this is the best > solution. > > thanks for your suggestions > > > >-- > >/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:346253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
