Frozen row/column undo

Frozen row/column undo

Posted by: nvitqrlfeqbusuabfa on 11 November 2021, 7:02 am EST

• 

  nvitqrlfeqbusuabfa

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 November 2021, 7:02 am EST

  Hello.

  I would like to ask whether it is possible to undo/redo frozen rows/columns:

  
  sheet.frozenRowCount(1);
  sheet.frozenColumnCount(1);
  
  

  When I execute above code undoManager’s undoStack is empty from which I understand that it is not undoable. What can I do to achieve this though? Is there any workaround?

  Thank you in advance!

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 12 November 2021, 5:21 am EST

  Hi,

  For enabling the undo for custom action. You need to create a custom command. Please refer to the following code snippet and demo that explains the basic use of custom action.

  
  		var command = {
  			canUndo: true,
  			execute: function(spread, options, isUndo) {
  				var Commands = GC.Spread.Sheets.Commands;
  				if (isUndo) {
  					Commands.undoTransaction(spread, options);
  					return true;
  				} else {
  					Commands.startTransaction(spread, options);
  					spread.suspendPaint();
  					var selections = options.selections;
  					var value = options.backColor;
  					selections.forEach(function(sel) {
  						sheet.getRange(sel.row, sel.col, sel.rowCount, sel.colCount).backColor(value);
  					});
  					spread.resumePaint();
  					Commands.endTransaction(spread, options);
  					return true;
  				}
  			}
  		};
  		var selections = sheet.getSelections();
  		var commandManager = spread.commandManager();
  		commandManager.register('changeBackColor', command);
  		commandManager.execute({
  			cmd: 'changeBackColor',
  			sheetName: spread.getSheet(0).name(),
  			selections: selections,
  			backColor: 'rgb(130, 188, 0)'
  		});
  
  

  Demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/custom-action#demo_source_name

  Regards
  
  Avinash

• 

  nvitqrlfeqbusuabfa

  • Post Options:
  • Link
    Copy

  Posted 15 November 2021, 4:11 am EST

  Thank you Avinash.

  Yes I have read about custom commands and how to add the to undo stack. However not everything works as expected. If you replace change of background color from your example and try freezing instead, you will see that this custom command wouldn’t be added to undo stack after execution.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 17 November 2021, 2:51 am EST

  Hey,

  you can undo or redo an action by using the startTransaction() method, undoTransaction() method and the endTransaction() method.

  Here is a sample: https://jscodemine.grapecity.com/sample/8icf7k5HtESO1jj849yjiA/

  Here is a list of actions that you can undo:

  https://www.grapecity.com/spreadjs/docs/v14/online/undo.html

  Demo to undo/redo custom operations:

  https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/custom-action#demo_source_name
  
  endTransaction: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~endTransaction.html
  
  startTransaction: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~startTransaction.html
  
  undoTransaction: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Commands~undoTransaction.html
  
  Thanks