Using excel NumberFormat in coldfusion
Hi All - As suggested by a couple of coldfusion developers a weeks ago, I am using xml to generate excel sheets from coldfusion. I am stuck with the following issue. Style ss:ID=s71 Borders Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Left ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ /Borders NumberFormat ss:Format=#,##0/ /Style The number format within Style tags above has pound signs which Coldfusion does not like. Escaping them does not produce the desired result. Can anyone suggest a work around for this issue? ~| 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:346616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using excel NumberFormat in coldfusion
##,0 doesn't work? -Original Message- From: fun and learning funandlrnn...@gmail.com Sent: Tuesday, August 09, 2011 3:18 PM To: cf-talk cf-talk@houseoffusion.com Subject: Using excel NumberFormat in coldfusion Hi All - As suggested by a couple of coldfusion developers a weeks ago, I am using xml to generate excel sheets from coldfusion. I am stuck with the following issue. Style ss:ID=s71 Borders Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Left ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ /Borders NumberFormat ss:Format=#,##0/ /Style The number format within Style tags above has pound signs which Coldfusion does not like. Escaping them does not produce the desired result. Can anyone suggest a work around for this issue? ~| 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:346617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using excel NumberFormat in coldfusion
Double # for each # you want to use... -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, August 09, 2011 2:19 PM To: cf-talk Subject: Using excel NumberFormat in coldfusion Hi All - As suggested by a couple of coldfusion developers a weeks ago, I am using xml to generate excel sheets from coldfusion. I am stuck with the following issue. Style ss:ID=s71 Borders Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Left ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ /Borders NumberFormat ss:Format=#,##0/ /Style The number format within Style tags above has pound signs which Coldfusion does not like. Escaping them does not produce the desired result. Can anyone suggest a work around for this issue? ~| 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:346620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm