Author Topic: XLS to XLSX conflict  (Read 219 times)

DDP021

  • Sr. Member
  • ****
  • Posts: 258
    • View Profile
XLS to XLSX conflict
« on: April 04, 2018, 06:40:41 AM »
Hello, we have a application defined with the VIEW set to User Defined and the file extension as XLS...The application is now in the process of converting their data to XLSX...The issue now is, after updating the application to now have XLSX as the file extension and attempting to open an existing version that was created as an XLS on their side, we get the error "Excel cannot open the .XLSX because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file' ....And if we change the application definition back to XLS, then anything loaded that was created as an XLSX gets the same type of error message.  Anyone know of a workaround?...I tried to do a 'wildcard' on the file extension on the application definition by using XLS* but after doing so, NOTHING would open...lol......

Nolan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
Re: XLS to XLSX conflict
« Reply #1 on: April 04, 2018, 08:08:09 AM »
It sounds like you used the same application id.   Not a good idea.  I suggest you create a new application id for XLSX and map both to the same folder.  User won't know the difference but OnDemand will pull the correct extension.
J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

DDP021

  • Sr. Member
  • ****
  • Posts: 258
    • View Profile
Re: XLS to XLSX conflict
« Reply #2 on: April 04, 2018, 08:14:17 AM »
Yes that is correct....And we figured that we would need to create a new app and app grp with the new XLXS file extension on the application definition and then map both app groups to folder so both XLS and XLSX versions can be viewed...Thanks for the reply