TechNote

cfspreadsheet tag and related functions: known issues and limitations

Issue

There are some known limitations and issues when using <cfspreadsheet/> in ColdFusion 9. Please see the table below for more details.

Issue	Comments/Solution
If data in an Excel spreadsheet is auto-filtered and is read as query, ColdFusion <cfspreadsheet> tag reads all the rows instead of only the filtered rows.	None.
To allow the <cfspreadsheet> tag to read the cell content in an Excel spreadsheet, Read permission must be given to the locked cells.	You should give permission to read locked cells from excel for cfexcel tag to read.
You might encounter the following issues related to spreadsheets: - SpreadSheetAddImage: Trying to add image to a an Excel file that has images results in the removal of existing images and corruption. <cfspreadsheet action="update"> will not update the images to the new Spreadsheet file.	An issue exists with the POI library that causes this: https://issues.apache.org/bugzilla/show_bug.cgi?id=44916
Excel spreadsheets that are corrupted when read with <cfspreadsheet> tag may show loss of data.	Correct the corrupted source spreadsheet file.
When you write using cfspreadsheet, some Excel files may show increased file size.	This is due to a known issue with the POI library.
Retrieving a cell (in an spreadsheet file) that contains fraction elements, using <cfspreadsheet> tag, might not provide appropriate results.	This is due to a known issue with the POI library: https://issues.apache.org/bugzilla/show_bug.cgi?id=4567
<cfspreadsheet> does not allow adding a column/row to merged columns/rows.	None.
When you retrieve scientific notations from an Excel spreadsheet using the tag <cfspreadsheet>, the '+' (plus) sign might be lost.	This is due to a known issue with the POI library: https://issues.apache.org/bugzilla/show_bug.cgi?id=45678
Writing the same Excel 2007 object twice into a file using <cfspreadsheet> tag results in the following exception: org.apache.xmlbeans.impl.values.XmlValueDisconnectedException.	To resolve this issue, read the file again and then write. Also see: https://issues.apache.org/bugzilla/show_bug.cgi?id=46662
The functions SpreadSheetAddFreezePane and SpreadsheetAddSplitPane and are not supported for Excel 2007 XML file format.	None.