Hi All -
I am creating multiple sheets of data using cfspreadsheet and using the
script here
http://cfsimplicity.com/16/forcing-values-to-be-inserted-into-spreadsheets-as-textto
force few columns to be treated as text. The issue I am facing is,
when
number of records for all the sheets combined reaches few thousands, the
columns I am using for text formatting are automatically getting bolded
font and gray background. I was wondering if anyone has faced this issue
and if there is a way to fix this? Below is the code
<cfset REQUEST.gen_Excel = spreadsheetNew("Sheet1","true")>
<cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,"Sheet1")>
<cfscript>
REQUEST.gen_Excel= spreadsheetAddRowsForceTextFormat
(
spreadsheetObject=REQUEST.gen_Excel,
data=query1,
columnNumbersToFormatAsText=[1,3,4,5],
addedHeaderRow=true
);
</cfscript>
<cfset REQUEST.gen_Excel = spreadsheetNew("Sheet2","true")>
<cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,"Sheet2")>
<cfscript>
REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat
(
spreadsheetObject=REQUEST.gen_Excel,
data=query1,
columnNumbersToFormatAsText=[1,3,4,5],
addedHeaderRow=true
);
</cfscript>
<cfset REQUEST.gen_Excel = spreadsheetNew("Sheet3","true")>
<cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,"Sheet3")>
<cfscript>
REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat
(
spreadsheetObject=REQUEST.gen_Excel,
data=query3,
columnNumbersToFormatAsText=[1,3,4],
addedHeaderRow=true
);
</cfscript>
<cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,"Sheet1")>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:358667
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
