Forums Ultimate UI for Windows Forms
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
Close
Anonymous
65
UltraGridExcelExporter leaves old values in OpenXML Excel when I replace them in CellExportedEventHandler
posted

Hi,

I'm doing an excel export from a simple UltraGrid with one cell. In the CellExportedEventHandler I'm changing the value of the current cell to a new value. If I extract the resulting Excel file and open the .\UltraGridExcelExport_CellExported.xlsx\xl\sharedStrings.xml I can see the new value and the old value too. This is bad in two ways.

  1. If I'm replacing a lot of cell values, the resulting Excel file will be unnecessarily big.
  2. If I'm replacing characters, that are not readable by Excel, they are still in there and prevent opening the file.

Attached you can find a small example project.

It would be nice if someone knows a solution for this problem.

Kind regards

Sascha

UltraGridToExcelExport.zip
Parents
No Data
Reply
  • 9298
    Verified Answer
    posted

    Sascha.

    I suggest that you upgrade your application to the latest version of NetAdvantage.  I upgraded your sample and tested it with versions 2011 volume 1 and 2011 volume 2 and I did not see the old value in the  sharedStrings.xml files but only the new value.  Please try this and let me know if it improves things for you.

Children