how to get the changed value of each column

Posted by: nguyentuyen1322 on 14 January 2022, 9:57 pm EST

  • Posted 14 January 2022, 9:57 pm EST

    Hi Teams,

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

    How can i do it ?
  • Replied 16 January 2022, 11:05 pm 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
  • Replied 5 February 2022, 3:13 pm EST

    hi Teams,

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

    thanks
  • Replied 6 February 2022, 4:52 pm 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels