In .Cells 5.1.2.6, I have some graphs and a pivot table in an XLS file which I open as the prototype (template, see attached PivotTemplate.XLS). I then add additional sheets and save the resulting file. When I save in XLS it works fine (see Marketing_Programs_Effectiveness.xls) but when I save the identical in-memory representation as XLSX it creates a bad file. If I allow Excel to repair the file the pivot table is missing (see Marketing_Programs_Effectiveness.xlsx).
Also, notice that on the "Graphs" worksheet the font sizes are different between the XLS and XLSX saved files. We would expect them to be the same as the source XLS file rather than larger as in the XLSX. Can this be fixed in the XLSX?
The source file which you have provided us is not in the proper format. Please see the attached error messag screen shot. Please provide us the correct file so that we can further investigate this issue.
Thanks for looking at the problem. You misunderstand our source file. We use undefined named ranges in the source file and then create those named ranges during our processing phase. This works fine for graphics and many other uses, for both XLS and XLSX, and is likely not responsible for the Pivot Table problem.
Please focus on the two output files, which are made from exactly the same in-memory data, the only difference being in the file format specified in the Save call.
A simple open/save operation is done with your template xls file. I have attached my generated xlsx file. It opens fine in MS Excel 2007 without any issue.
Actually, the XLSX file you provided is corrupted. I can't open it in Excel 2003. After conversion, "Excel found unreadable content ...". If I recover and open the file, it says that "Repairs were made to PivotTable report ...".
If I open the XLSX in Excel 2010, while it does open, the pivot table does not function correctly. Compare the operation of the pivot in the XLS with the XLSX. Under "Customer Location", in the XLS, you see the correct choices of (All), East, and West. In your XLSX, you only see (All) and East. And, there are no dropdowns in row 12.
After a while, looking at the XLSX Cust Pivot sheet crashes Excel 2010.
"Actually, the XLSX file you provided is corrupted. I can’t open it in
Excel 2003. After conversion, “Excel found unreadable content …”. Well, MS Excel 2003 cannot open XLSX files, you need to have Excel 2007 or greater versions to open a XLSX file.
Also, "If I open the XLSX
in Excel 2010, while it does open, the pivot table does not function
correctly. Compare the operation of the pivot in the XLS with the
XLSX. Under “Customer Location”, in the XLS, you see the correct
choices of (All), East, and West. In your XLSX, you only see (All) and
East. And, there are no dropdowns in row 12."
Thanks for providing us details. After conducting test, I can find the issue as you have described. I have re-opened your issue and we will fix it soon.
"Well, MS Excel 2003 cannot open XLSX files, you need to have Excel 2007 or greater versions to open a XLSX file."
Actually, the Excel 2003 XLSX to XLS converter (Office compatibility pack) provided by Microsoft works very well, as long as you don't use any Excel 2007+ features in the XLSX. I use this often during testing.
Thanks for the update. While this fixed the crashing problem first observed in v5.1.3.2, it does not fix the "unreadable content" problem. When opening in Excel 2010:
"Excel found unreadable content..."
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache) Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view) Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
Could you tell us your source file is
Marketing_Programs_Effectiveness.xls or Marketing_Programs_Effectiveness.xlsx
in your attached files archive?
Or preferably could you provide your sample code or application?
A simple open xls and save to xlsx operation is done with his template xls
file. The source xls file and the generated xlsx file are attached. Moreover, the Marketing_Programs_Effectiveness_generated.xlsx file is opened successfully in
Excel 2010 and Excel 2007 as we tested. i.e., Marketing_Programs_Effectiveness.xls —> save to -->
Marketing_Programs_Effectiveness_generated.xlsx
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan