Double # for each # you want to use...
-----Original Message-----
From: fun and learning [mailto:[email protected]]
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="#000000"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#000000"/>
</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
