TableSheet Master-Detail Editing

TableSheet Master-Detail Editing

Posted by: Guenther.Faerber on 21 September 2021, 2:21 am EST

• 

  Guenther.Faerber

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 September 2021, 2:21 am EST

  Hi,
  
  I am trying to create a master-detail report using tableSheet, where the user selects on sheet1 in a readonly tablesheet a record, and then he can edit it in a detail vertical input form , for instance on the same sheet, on another sheet or using a popup form.

  In other words I would like to determine the current selected record in the master-list, so that in the detailed form the according record is offered for editing.
  
  Alternatively there might be a way to extend the master tableSheet action buttons to explicitly click on an edit-button, which then binds the record data to the detailed form for editing.

  Can you give me some hints, how we can achieve this in one way or another?
  
  Many thanks and BR Guenther

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 22 September 2021, 3:19 am EST

  Hi,

  For this, you need to use the selection changed event. Please refers to the following code snippet and lets us know if you face any issues.

  
  /*set initial selection */
  var selection = {row:0, col: 0, rowCount:1, colCount:1};
      spread.bind(GC.Spread.Sheets.Events.SelectionChanged, function(e, args) {
          selection = args.newSelections[0];
      });
  
  /*when you need to get the selected just use following code snippet*/
      document.getElementById("btn"),addEventListener("click",()=>{
          console.log(spread.getSheetTab(0).getDataView().getRowData(selection.row));
      });
  
  
  

  sample: https://jscodemine.grapecity.com/sample/lbFg4Ja_W0iRgbTnB3lRsg/

  regards
  
  Avinash