RE: Using excel NumberFormat in coldfusion

2011-08-09 Thread Bill Franklin 

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. 

 
   <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"/>
  

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

RE: Using excel NumberFormat in coldfusion

2011-08-09 Thread Jason Fisher 

"##,0" doesn't work?


-Original Message-
From: fun and learning 
Sent: Tuesday, August 09, 2011 3:18 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. 

 
   <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"/>
  

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

Using excel NumberFormat in coldfusion

2011-08-09 Thread fun and learning 

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. 

 
   




   
   
  

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