UltraGridExcelExporter leaves old values in OpenXML Excel when I replace them in CellExportedEventHandler

State See Verified Answer
Replies 2 replies
Subscribers 6 subscribers
Views 587096 views
Users 0 members are here

UltraGrid

Anonymous posted over 12 years ago

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.

If I'm replacing a lot of cell values, the resulting Excel file will be unnecessarily big.
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

65

Offline Anonymous posted over 12 years ago in reply to Michael S.

Hi Michael,

I have tested it with v11.2 and you are right. The issue has been solved with the new version. In fact this is a simple solution but for us it means paying again 800 € for a new licence. :-(

Never mind, I thank you for your answer.

Regards

Sascha
Cancel
Reply

Cancel
9298

Verified Answer
Michael S. posted over 12 years ago

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.
Cancel
Reply

Reject Answer

Cancel