Brain, I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing
<cfset col1 = #'query1.col1#> On Tue, Aug 16, 2011 at 4:47 PM, Brian Cain <[email protected]> wrote: > > The single quote does not appear. It is a special formatting rule for > excel. It makes the column display as a character field by default. It is > used specifically to handle leading zeros. > > Brian Cain > > On Tue, Aug 16, 2011 at 3:22 PM, funand learning <[email protected] > >wrote: > > > > > If I use a single quote as leading character, then thta single quote > would > > appear in excel sheet right? At what point should I remove the quote? Can > > anything be done on database side. I mean can the query be formatted in > any > > way? > > > > On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain <[email protected]> wrote: > > > > > > > > You could also try using a single quote as your leading character. > This > > is > > > how would would enter it in excel without changing the column > formatting. > > > > > > BC > > > > > > On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies <[email protected]> > > > wrote: > > > > > > > > > > > This is an excel issue, not a CF issue. If you set the data type of > the > > > > column to text it does not happen.. > > > > > > > > > > > > > > > > > > http://www.google.ca/search?hl=en&client=firefox-a&hs=vpO&rls=org.mozilla%3A > > > > > > > > > > > > > > en-GB%3Aofficial&biw=1920&bih=1084&q=excel+truncates+leading+zero&btnG=Searc > > > > > > > > > > > > > > h&oq=excel+truncates+leading+zero&aq=f&aqi=&aql=&gs_sm=s&gs_upl=0l0l0l18408l > > > > 0l0l0l0l0l0l0l0ll0l0 > > > > > > > > Brook > > > > > > > > -----Original Message----- > > > > From: fun and learning [mailto:[email protected]] > > > > Sent: August-16-11 10:35 AM > > > > To: cf-talk > > > > Subject: coldfusion spreadsheet leading zeroes issue > > > > > > > > > > > > Hi All - > > > > > > > > I am facing an issue with coldfusion9 spreadsheet functions. It cuts > of > > > > leading zeroes. This is what I am trying. I am getting array of data > > and > > > > using spreadsheetaddrows. When I am constructing an array, am using > > > quotes > > > > so as to preserve the zeroes but with no effect. Adding some > characters > > > > like > > > > "~" helps. But when I am adding space, coldfusion is not preserving > the > > > > spaces. Is there a better way to handle this issue? > > > > > > > > Thanks > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
