How to get the changed value of each column

How to get the changed value of each column

Posted by: nguyentuyen1322 on 15 January 2022, 6:57 am EST

• 

  nguyentuyen1322

  • Post Options:
  • Link
    Copy

  Posted 15 January 2022, 6:57 am EST

  Hi Teams,

  i want to get the changed value of each column in spreadjs

  How can i do it ?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 17 January 2022, 8:05 am EST

  Hi,
  
  You can get the dirty cells collection by using the getDirtyCells method. You can filter the collection to get the dirty cells of a particular column.
  
  Please refer to the following sample that demonstrates the same:https://jscodemine.grapecity.com/share/m8FCj32oEkew_hVddNWYWA/
  
  getDirtyCells: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~getDirtyCells.html
  
  Regards

• 

  nguyentuyen1322

  • Post Options:
  • Link
    Copy

  Posted 6 February 2022, 12:13 am EST

  hi Teams,

  i want merge multiple columns on one row and give me an example ?

  thanks

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 7 February 2022, 1:52 am EST

  HI,

  You may use the automerge method. Please refer to the following code snippet and let me know if you face any issues.

  
     var range = new GC.Spread.Sheets.Range(0, 0, 1, 2);/* select only single row */
      sheet.autoMerge(range, GC.Spread.Sheets.AutoMerge.AutoMergeDirection.column, GC.Spread.Sheets.AutoMerge.AutoMergeMode.restricted);
  
  

  You may also use the addSpan method on specified range. Please refer to the following code snippet.

  sheet.addSpan(0,0,1,2)
  

  autoMergeDemo: https://www.grapecity.com/spreadjs/demos/features/cells/auto-merge/column-auto-merge/purejs

  cell Spans demo: https://www.grapecity.com/spreadjs/demos/features/cells/cell-span#demo_source_name

  Regards,
  
  Avinash