Sheet does not editable and keys are not working while any ajax request is sent

Sheet does not editable and keys are not working while any ajax request is sent

Posted by: arun.gupta on 28 June 2018, 9:55 pm EST

• 

  arun.gupta

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 June 2018, 9:55 pm EST

  There is an issue comes in chrome only while I’m making an ajax request from one sheet to another sheet and replace the previous one then in second sheet i cant type, undu, redu or even mouse is not working it edit when i double click on grid. I tried

  var activeSheet=spreadsheet.getActiveSheet();
  
  activeSheet.getCell(1, 1).locked(false);
  
  activeSheet.setIsProtected(true);

  but it doesn’t work.
  
  Please let me know is there any function to stop this prevention in the sheet or this is a bug.
  
  Here is the link
  
  https://www.screencast.com/t/JFam5GccDN

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 1 July 2018, 11:43 pm EST

  Hello,

  You are using the code to lock the activesheet which should not be causing the issue.
  
  Could you please elaborate about your use case?

  Thanks,
  
  Deepak Sharma

• 

  arun.gupta

  • Post Options:
  • Link
    Copy

  Posted 2 July 2018, 2:19 pm EST

  Initially when a sheet is loaded everything is work fine but when I pressed next button to move next module then the new sheet is loaded and initialize spreadjs plugin and its binding functions again then this not editable issue occurs.

  Here is the code of initialization -

  $(“#msexcel_log”).wijspread({ sheetCount:1});
  
  spreadsheet=$(“#msexcel_log”).wijspread(“spread”);
  
  var fbx = new $.wijmo.wijspread.FormulaTextBox(document.getElementById(‘formula_box’));
  
  fbx.spread(spreadsheet);
  
  spreadsheet.grayAreaBackColor(“white”);
  
  spreadsheet.scrollbarShowMax(false);
  
  spreadsheet.scrollbarMaxAlign(true);
  
  spreadsheet.showResizeTip(3);
  
  spreadsheet.showDragDropTip(true);
  
  spreadsheet.showScrollTip(3);
  
  spreadsheet.repaint();
  
  spreadsheet.bind(“EnterCell”, selectionChanged);

  spreadsheet.bind(“EnterCell”,cell_record);
  
  spreadsheet.bind(“SelectionChanged”,cell_record);
  
  spreadsheet.bind(“ClipboardChanged”,cell_record);
  
  spreadsheet.bind(“EditChange”,cell_record);

  spreadsheet.bind(“SelectionChanged”, SelectionOperationChanged);
  
  spreadsheet.bind(“EditChange”,selectionKeyChanged);
  
  spreadsheet.bind(“ActiveSheetChanged”,sheetSelectionChanged);
  
  spreadsheet.bind(“RowHeightChanged”,cellRowHeightChange);
  
  spreadsheet.bind(“ColumnWidthChanged”,cellColumnWidthChange);
  
  spreadsheet.bind(“DragFillBlockCompleted”,cellDragFillBlockCompleted);
  
  spreadsheet.bind(“SheetTabDoubleClick”,sheetTabDoubleClicked);
  
  spreadsheet.bind(“ClipboardChanged”,clipboardChanged);
  
  spreadsheet.bind(“ClipboardPasted”,clipboardPasted);
  
  spreadsheet.bind(“DragDropBlockCompleted”,dragDropBlockCompleted);
  
  spreadsheet.autoFitType($.wijmo.wijspread.AutoFitType.Cell);
  
  spreadsheet.allowUndo(true);
  
  spreadsheet.useWijmoTheme = true;
  
  spreadsheet.repaint();

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 3 July 2018, 10:47 pm EST

  Hi Arun,

  SpreadJS version 3.0 is not supported anymore. I would suggest you to please test this issue with latest version of SpreadJS which can downloaded from:
  
  https://www.grapecity.com/en/spreadjs

  Let me know in case the issue still persists.

  Thanks,
  
  Deepak Sharma

• 

  arun.gupta

  • Post Options:
  • Link
    Copy

  Posted 9 July 2018, 3:00 pm EST

  Hi Deepak,

  Is there any function is not available in SpreadJS version 3.0 for this issue because i cant move to the latest version, or if any other solution is available so please suggest me.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 10:11 pm EST

  Hi Arun,

  Could you please provide me your sample application to debug this issue?

  Thanks,
  
  Deepak Sharma