If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Output Excel Formula in CA 11 / 12

Started by absolutemusik, 03 Dec 2023 03:58:53 AM

Previous topic - Next topic

absolutemusik

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