tracker issue : CF-4203406

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

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.

Attachments:

Comments:

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