Dear all,
I do understand that it was a nightmare for reports export to Excel with all formula not working with the 2007 format (XML). I have tried to do something like printing them as "Rich Text" item as in Cognos 10 with "EXCEL 97" output. It is no longer working in Cognos 11 / 12.
Sample Output of Cognos in Excel:Quantity | Unit Cost | Total Cost
===================================
256 | 15.62 | =(B2*C2)
92 | 49.69 | =(B3*C3)
162 | 80 | =(B4*C4)
Does anyone with work around? It is because the finance / accounting users will use the Excel to do other calculation. Please share your clues if any. Actually, I have tried a number of Python library openpyxl / win32com. Openpyxl was failed to create a "real" xls and win32com can create format "56" /
"39" (Excel 97). The formulas are still reading as text with win32com.
Thanks in advance.
Regards,
AM