I have excel templates with formulas. I save them as .mht and load them on the WebFOCUS server to use with my application. Seems the new version of EXCEL 2007 no longer preserves formulas in .mht. So, how do I get my EXCEL template into WebFOCUS with the formulas intact?This message has been edited. Last edited by: Kerry,
Dev Studio /7.6.11/7.7.02M MVS/USS AIX/SOLARIS Windows WF Client 7.6.8/7.6.11
January 22, 2010, 12:46 PM
Francis Mariani
Unfortunately, and this is really ridiculous, you need to keep around an old version of Excel!
"Single File Web Page (*.mht; *.mhtml) - Excel 2007 no longer stores Excel-specific feature information in this file format. You can open a file in this format, preserving any Excel-specific features that were created in an earlier version of Excel. However, you can save such a file (or any other workbook) in this file format for publishing purposes only." (Whatever this means!)
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 25, 2010, 10:06 AM
<JG>
In WebFOCUS .mht file created in Excel 2007 are totally unusable for any purpose.
WebFOCUS 7.7/8.0 will hopefully fix it.
January 25, 2010, 12:23 PM
leo13
I just ran across the same issue last week. Fortunately we still have one computer in our office that has Office 2003. It's not any fun to have to run to that machine to make edits to my template file but at least it works (or my current project would be totally pointless). I hope IBI decides to address this issue (and the larger issue of not creating Office 2007 formats in general) very soon.