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 ?
Forums Home / Spread / SpreadJS
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 ?
Posted 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
Posted 5 February 2022, 3:13 pm EST
hi Teams,
i want merge multiple columns on one row and give me an example ?
thanks
Posted 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