September 03, 2013, 02:38 PM
hainguyenDoes WebFocus support excel 2013 output ?
One of my requirement from customers is set the output file to Excel 2013. I checked and saw that it just support until Excel 2007. My WF version is 7703.
September 03, 2013, 03:16 PM
DougEXL2K works fine Excel 2010 / 76x. Not sure what Excel 2013 is (yet). Have you tried to open an EXL2K formatted output in Excel 2013?
September 03, 2013, 05:59 PM
hainguyenMy customers's desktop use Excel 2013. Whenever they do export to Excel2K, they got the message box said the file is in the incorrect format. Then it open back to Excel 2007. I don't know if WF have the option to let report only be exported to Excel 2013 or Excel 2000.
September 30, 2013, 04:10 PM
LaureWe are attempting to export to format EXL2K and the clients have Excel 2013 installed. WebFOCUS release 7.7.03. We get the Microsoft Excel message box 'Unable to read file' but when OK is clicked the file is opened just fine.
This only happens if the resulting Excel file is MULTIPLE tabs. Single TAB files open fine.
The clicking of the OK button is a large annoyance to my customers. Does anyone know how to either avoid the message box, or perhaps suppress it from appearing? BTW we use EXL2K format for the FORMULA option that is not available with EXL07. Sample code follows:
-*-------------------------- issue is related to multiple tab excel output file
SET COMPOUND=BYTOC
-*
TABLE FILE CAR
PRINT *
BY COUNTRY
BY MODEL
ON TABLE NOTOTAL
-*----------------- both EXL2K and EXL2K FORMULA result in message box from Excel.
-*ON TABLE PCHOLD FORMAT EXL2K
-*ON TABLE PCHOLD FORMAT EXL2K FORMULA
-*----------------- EXL07 works without issue
-*ON TABLE PCHOLD FORMAT EXL07
END
October 01, 2013, 09:34 AM
njsdenThis is due to "Extension hardening" in MS Excel.
We currently use Excel 2007 which also complains about the file format used by EXL2K. We made the message go away by a simple change on each user's desktop registry:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"ExtensionHardening"=dword:00000000
You may want to search about "Extension hardening" and how it is applicable particularly to Excel 2013.
October 01, 2013, 11:30 AM
Tom FlynnWell, I guess that's OK for a small group; how about over 1000 users at a University???
IBI should add that code to the WebFOCUS THISFOCI.bat file so we "don't" have to manually add to a user's desktop.
OR,
am I barking up the wrong tree???
Tom