Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
650
SummaryCellExported event - unable to override value
posted

I want to put something else in there besides what the summary value thinks should go in there - but no matter what I do, it doesn't 'take'.

 

I tried using both actual decimals and strings - same result, the value I put in is completely ignored, even though after that line of code runs the Value is what I put in there. When I see the spreadsheet though, it's not there.

 

How do get the override to work?

 

Private Shared Sub TotalExported(ByVal sender As Object, ByVal e As SummaryCellExportedEventArgs)

            e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).Value = "100.00"

    End Sub

  • 53790
    posted

    Hello Marinka,

    I try to reproduce your scenario in a small sample and I think that everything works properly. Could you please take a look at the attached sample for more details. If you think that your scenario is not the same, please feel free to modify my sample and revert it back to me. I`ll be glad to research it. Please note that in my sample I use the latest version of our assemblies - 11.1.20111.2061. If you are using older version, you could download the latest available from our site: Infragistics.com -> MyIG - > MyKeys and Downloads. Please let me know if you have any questions,

    Regards

    WorksheetExcelExport.zip