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,
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.
Hi Dimitar,
any update on the above issue please...
Excel Sheet attached as well
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
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.