Identifying whether a cell is Readonly

Identifying whether a cell is Readonly

Posted by: chinmay.patil on 22 January 2019, 11:59 am EST

• 

  chinmay.patil

  • Post Options:
  • Link
    Copy

  Posted 22 January 2019, 11:59 am EST

  Hi Team,

  I’m facing a issue while pasting data into a column of flex-sheet.
  
  Some of the rows of the flex sheet are read-only rows. Thus, while pasting data into one of the column, i want to skip those cells of that column which are read-only.
  
  I’m trying to use “pastingCell” event handler in which i wish to skip those cells which pass the isReadOnly check. Can you please help what check can be used.
  
  i have tried (e.panel.rows[e.row].isReadOnly || e.panel.columns[e.col].isReadOnly) however if doesn’t work

  Thanks,
  
  Chinmay

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 23 January 2019, 2:46 am EST

  Hi,

  Could you please let us know how you are making the rows read-only?
  
  If we make the flexSheet rows read-only by setting the isReadOnly property of the row then FlexSheet doesn’t allow pasting in the read-only cells out of the box and we do not need to perform any additional check.
  
  However, there is currently an issue which converts transforms the read-only rows to editable after the pasting is performed. Internal tracking Id for the issue is: 363215.
  
  Till the issue is fixed, you may workaround it at your end by restoring the read-only state of the row after pasting is done.
  
  Please refer to the following sample which demonstrates the same:
  
  https://stackblitz.com/edit/js-oyhjvm?file=index.js

  ~Sharad