SetCellValue is not in HistoryManager

[Frank]

Hello,

I'm using ActiveSheet.SetText and ActiveSheet.SetNumber to set for cells in a Spreadsheet.

These changes do not appear in the HistoryManager and therefore I cannot use Undo and Redo for these.

Waht do I have to do to have also the value changes from my code in Historymanager?

Kind regards

Frank     

[Arulpriya Ramalingam]

Hi Frank,

Thank you for using Syncfusion products.

We could reproduce the reported scenario at our end and forwarded the use case to our development team for further validation. We need some more time to analyze and we will update you the details on 31st December 2020.

Regards,

Arulpriya

[Balamurugan Thirumalaikumar]

Hi Frank, 

 

Thank you for your patience. 

 

We are currently working on it. We will check update you the proper details on or before October 18,2021. We appreciate your patience until then. 

 

Regards, 

Balamurugan.T 

[Balamurugan Thirumalaikumar]

Hi Frank,  

 

Thank you for the patience.  

 

We have checked reported issue at our end,Initially we need to add the value into HistoryManager and then set a Text or Number (using SetText or SetNumber API) based on CurrentCell range.Please refer below code snippet and sample.  

 

Code Snippet  

this.Sheet.ActiveGrid.CurrentCell.MoveCurrentCell(2, 2);
this.Sheet.HistoryManager.Push(new HistoryCellValueCommand(Sheet.ActiveSheet[2, 2], this.Sheet, string.Empty, "!0!B2"));
this.Sheet.ActiveSheet.SetText(2, 2, "Hi");
this.Sheet.ActiveGrid.InvalidateCells();   

  

Sample link- https://www.syncfusion.com/downloads/support/directtrac/general/ze/SpreadSheettest-194249933.zip 
  

Thanks & Regards,  

Balamurugan Thirumalaikumar