tags:

views:

44

answers:

1
+1  Q: 

How to format columns using ColdFusion?

Hi,

I am using SpreadsheetFormatColumns() to format the columns in a spreadsheet to "text", but I don't know how to do this, all the formats in the livedocs are for numbers, currency or dates... is there something like

SpreadsheetFormatColumns(mySpreadsheet, {dataFormat="text"}, "1-15")

out there? this is really bugging me...

Thanks

A: 

According to this chart use '@' (without quotes) for the text placeholder.

Ben Doom  2010-06-20 23:04:35
Thanks, turns out that 'text' is also a possibility (same output) but they need to be called AFTER you populate the rows (which doesn't make sense in my opinion) since now instead of having '01050094071094340000' (the desired output) I have '1.050094071094339e+18' this seems like a BIG issue (at least for me)Using a regular "automatic" format, it will remove all leading zeroes
raulriera  2010-06-21 00:11:55

related questions

Restarting ColdFusion mail queue
ColdFusion mail queue stops processing
in ColdFusion 8, can you declare a function as private using cfscript?
ColdFusion Template Request count optimization
How do I speed up data retrieval from .NET AD within ColdFusion
How to call a function dynamically that is part of an instantiated cfc, without using Evaluate()?
Using Google Maps in Coldfusion
We're manually mapping our internal data elements to external vendors' xml schema. there's gotta be a better way...
How do I turn a ColdFusion page into a PDF download?
Importing Access data into SQL Server using ColdFusion
jquery: JFrame plugin fails in IE 7
How do I programatically sanitise coldfusion cfquery parameters.
ColdFusion: Is it safe to leave out the variables keyword in a CFC?
How should you go about learning ASP.NET after life as a ColdFusion developer?
BOM not expected in CF but sent by IIS/SP
cfqueryparam with like operator in coldfusion
Is it possible to find code coverage in ColdFusion?
How can you test to see if two arrays are the same using CFML?
Why is my PDF footer text invisible?
Coldfusion - When to use the "request" scope?
How do I convert images between CMYK and RGB in ColdFusion (java)?
How do I use NTLM authentication with Active Directory
Dynamic Alphabetical Navigation
Wrapping lists into columns
How to get started "writing" a code coverage tool?