How to save data in a cell before save workbook.
using (var ms = new MemoryStream()) { xamSpreadsheet.Workbook.Save(ms); ms.Position = 0;
}
But all latest changes in current cell not saved. Because cell in edit mode. How to end edit mode and save all changes before xamSpreadsheet.Workbook.Save(ms) ?
Hello Igor Ma,
I am very glad that you have manage to resolve your issue.
If you require any further assistance, please do not hesitate to ask.
Sincerely,
Radko Kolev
Infragistics Inc.
www.infragistics.com/support
Thank you, it works.
Hello Ig Ma,
Thank you for your post. You can try invoking the ExitEditModeAndUpdateActiveCell command to have the xamSpreadsheet exit editing mode and commit the new value. For example:
var command = new SpreadsheetCommand(SpreadsheetCommandType.ExitEditModeAndUpdateActiveCell);
command.Execute(this.spreadSheet);
Please do not hesitate to let me know if you have any further questions on this matter.