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 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.
Sincerely,
Radko Kolev
Infragistics Inc.
www.infragistics.com/support
Thank you, it works.
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.