Re: difference in displaying a numeric value in POI

2013-01-15 Thread safo 2000 

if this is poi:cell type=numeric numberformat=##,0.00 
value=1075483609/ rounding,how would the ...609 round to ...648

One is rounding and one is doing an Integer function

hi,

i am trying to write a numeric value using POI and i get the strange
results:

 poi:cell type=numeric numberformat=##,0.00 value=1075483609/

 cfset x=#NumberFormat('1075483609','999,999,999,999.99')#
 poi:cell type=string value=#x#/

if you run the above you get 1,075,483,648.00   1,075,483,609.00
respectively. notice that the last three digits are different, can someone
explain this?

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:353874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: difference in displaying a numeric value in POI

2013-01-14 Thread Eric Roberts 

One is rounding and one is doing an Integer function

-Original Message-
From: safo 2000 [mailto:safokas...@hotmail.com] 
Sent: Monday, January 14, 2013 1:02 AM
To: cf-talk
Subject: difference in displaying a numeric value in POI


hi,

i am trying to write a numeric value using POI and i get the strange
results:

 poi:cell type=numeric numberformat=##,0.00 value=1075483609/

 cfset x=#NumberFormat('1075483609','999,999,999,999.99')#
 poi:cell type=string value=#x#/

if you run the above you get 1,075,483,648.00   1,075,483,609.00
respectively. notice that the last three digits are different, can someone
explain this?

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:353867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

difference in displaying a numeric value in POI

2013-01-13 Thread safo 2000 

hi,

i am trying to write a numeric value using POI and i get the strange results:

 poi:cell type=numeric numberformat=##,0.00 value=1075483609/

 cfset x=#NumberFormat('1075483609','999,999,999,999.99')#
 poi:cell type=string value=#x#/

if you run the above you get 1,075,483,648.00   1,075,483,609.00 respectively. 
notice that the last three digits are different, can someone explain this?

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:353849
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm