Skip to main content
TripleClamp
TripleClamp
Inspiring
October 24, 2018
Question

cfspreadsheet failing from spreadsheet generated from SQL Reports 2016

  • October 24, 2018
  • 2 replies
  • 940 views

cfspreadsheet seems to have an issue with .xlsx files generated by SQL Server Reporting Services 2016.

If I try to run cfspreadsheet, I get the following error:

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

The spreadsheeet is nothing fancy generated from SQL Reports, just about 15 columns, no subtotals, etc...straight row by row data.

If I create a new spreadsheet, and copy the data from the SQL Reports generated into the new blank spreadsheet, cfspreadsheet will work.

Currently on ColdFusion 10,285437

Anyone run into this before?  A bug somewhere in Coldfusion Apache POI routines?

    This topic has been closed for replies.

    2 replies

    TripleClamp
    TripleClampAuthor
    Inspiring
    October 25, 2018

    Response received from bug tracker:

    CF10 is not longer supported. Please upgrade to a supported version of CF.

    Time to upgrade...

    WolfShade
    WolfShade
    Legend
    October 25, 2018

    Typical.  According to Adobe:

    Product                              Version                                                  Available                    End of CORE               End of Extended

    ColdFusion10.x 5/15/20125/16/20175/16/2019

    So, core support ended last year, which means what?  They don't care, even though extended support goes into next year.

    I've been looking at Lucee, and it's looking better and better, all the time.

    V/r,

    ^ _ ^

    B
    Bardnet
    Inspiring
    October 25, 2018

    Extended support is for users paying additional money.

    By the time CF10 was released POI probably wasn't outdated. POI is one of the libraries that can simply be replaced, has always worked.

    OP says he exports the files from SQL Server 2016; that was released four years after CF10

    WolfShade
    WolfShade
    Legend
    October 24, 2018

    Hello, YZ250F,

    It may be an outdated POI library.  Adobe has a reputation of releasing CF Server with outdated javascript for things like CFFORM and the lot, I would not be surprised if they released CF10 with an outdated POI.

    I'd file a bug report https://tracker.adobe.com and see what they say.  Although don't expect a quick fix - Adobe also has a reputation for trying to not fix things and use excuses for why not.

    V/r,

    ^ _ ^

    TripleClamp
    TripleClampAuthor
    Inspiring
    October 24, 2018

    Sounds good.  I even copied over the basic shading and colors of the SQL Report Excel version into the new blank spreadsheet and it worked.  I'll go ahead and log a bug, thanks.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices