HI All,
I want to show the sum of band1 cellvalue as band0 cellvalue.
for example:
Band0 -> col1 col2 col3
1 2 8 (sum of 2 rows value of col3)
Band1 -> col1 col2 col3
1 2 4
any pointers please.
With Thanks & Regards
Amjath
Hello, Amjath
I am just checking about the progress of your issue. If you require my further assistance on this matter don't hesitate to ask me.
Thank you for using Infragistics Components.
Hi Mitko,
still Im facing issues with calcmanager in excel export aftering using useexcelformula in excelexporter as well.
for few columns am gettting object reference error.
please help me on this.
Hello Amjath,
I’ve modified my sample in order to test export functionality and I was able to export Grid with formulas to Excel with the help of the UltraGridExcelExporter, using the following line:
ultraGridExcelExporter1.Export(ultraGrid1,"../../ExcelUltraCalcManager.xls");
Can you please test my sample and let me know if it works for you, can you please modify my sample in order to demonstrate your issue.
I am waiting for your feedback.
Hi Dimiter,
Thanks for your help..
please find the attached solution which will able to reproduce the issue with excelexport.
its happening only in the following case:
Parent Band (group by col2 of child) col1 (sum of childband col1)
Child1 10, ABC
Child2 20, CBD
Im waiting for you response, i need to fix this one
please do the needful
WIth Thanks & REgards
Excel Sheet attached as well
Thank you for the provided sample. I was able to reproduce the issue using Infragistics NetAdvantage 10.3, so I tested your sample with the latest service release of Infragistics 13.1 (). So with this service release everything works properly and the formula was calculated correctly for all cells of the exported excel, please see the video of my test on the following link:
http://www.youtube.com/watch?v=eRucaY5gJPg&feature=youtu.be
It seems that this was an old issue which has been already fixed, so my suggestion is to upgrade to Infragistics 13.1.
Please let me know if you have any further questions.
Thanks a lot Dimitar, it worked perfectly...
u guys r grt.
I am just checking about the progress of your issue. Let me know If my workaround worked for you? Do you need my further assistance on this issue?
It seems that your issue is related to a development issue in 10.3 regarding the grouping of the rows. And I managed to find a workaround for your case. If you remove the grouping in the FormulaExporting event of the UltraGridExcelExporter and add it again in the FormulaExported event of the exporter everything will be displayed properly in the excel worksheet, please see the attached sample.
I hope this suggestion helps you solve your issue. If you have any additional questions don’t hesitate to ask them.
Hi Dimitar any update on the workaround for the issue mentioned with excelexport
Many Thanks
Hi Dimitar,
Thanks a lot.
can you please let us know, if there were any work around exists, as we are very close to the relase and Im not sure abt the migrate the app to version 13.1.
please suggest some work around for time being.