tracker issue : CF-4203406

select a category, or use search below
(searches all categories and all time range)

CFSPREADSHEET Fails to read .XLSX created by SQL Server Reporting Services 2016

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CustomerSupport

Reporter/Name(from Bugbase): Grant Magar / ()

Created: 10/24/2018

Components: Document Management, Office Integration

Versions: 10.0

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: ColdFusion 10,285437 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 1

Problem Description:
Created basic report in SQL Server Reporting Services 2016.  Download results to Excel file (.xlsx).  Try to use cfspreadsheet to upload the file and get error:

OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! 

Steps to Reproduce:
Create SQL Server Reporting Services report, run, and download results to Excel file (.xlsx). Use <cfspreadsheet action="read" src="#customfile#" query="qry_currStudentImportData" sheet="1" headerrow="1" columns="1,2,3,4,5"/> in attempt to read.

Actual Result:
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! 

Expected Result:
Results in Query qry_currStudentImportData

Any Workarounds:
Download results to Excel file (.xlsx).  Create a new empty spreadsheet.  Copy data from SQL Server Reporting Services .xlsx to the new empty spreadsheet.  cfspreadsheet then works.



can read the attached excel files with 2016,0,06,308055, 2018,0,01,311282 and 11,0,14,307976. did not verify this on CF10. CF10 is not longer supported. Please upgrade to a supported version of CF.
Comment by Piyush K.
29844 | October 25, 2018 07:58:39 AM GMT
Is this an issue on newer versions of CF?
Comment by James M.
29884 | October 31, 2018 03:56:06 PM GMT