Yes, thanks Leigh that is great cheat to get into production with! Hopefully it doesn't break to soon if ever, -- Jon
-----Original Message----- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, May 26, 2010 9:02 PM To: cf-talk Subject: Re: Spreadsheet manipulation - clearing/deleting cell contents I am not sure if the Spreadsheet functions support the concept of a "blank cell". You could cheat and use the underlying POI functions. But I too am curious if anyone knows a supported method of doing this. // ... variables.sheet = variables.spObj.getWorkBook().getSheetAt( 0 ); for (i=2;i LTE qryTarget.Recordcount; i=i+1) { SpreadsheetSetCellValue(variables.spObj, 'overflowoverflow overflowoverflow overflowoverflow overflowoverflow ', i, 1 ); // data starts at row 1. so physical and logical rows are the same variables.row = variables.sheet.getRow( i-1 ); variables.cell = variables.row.getCell( 1 ); variables.cell.setCellType( variables.cell.CELL_TYPE_BLANK ); // .... } -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm