CODEWITHSUNDEEP
excelcoldfusioncfspreadsheet
James A Mohler
James A Mohler

Reputation: 11120

cfspreadsheet with large numbers needs to be formatted as a string

I have 16 digit number that needs to show all the digits. If I just key it into Excel I can put a ' in front of the number and it keeps the number from going into scientific notation. When I do the same in <cfspreadsheet> I get the number with a ' in front of it. I have also tried to use cell formatting:

<cfscript>
variables.hugenumber = {

color="dark blue;", 
dataformat = "0"
};
</cfscript>

Which doesn't help either

Upvotes: 1

Views: 827

Answers (1)

James A Mohler
James A Mohler

Reputation: 11120

It turns out that a format like this is needed:

<cfscript>
variables.hugenumber = {

color="dark blue;", 
dataformat = "################"
};
</cfscript>

Upvotes: 2

Related Questions