Hi! I kindly need help on how to create an interactive table that works like excel sheet
Hi! I kindly need help on how to create an interactive table that works like excel sheet
TitusR
Posts: 2Questions: 1Answers: 0
I need a table that I can manipulate data which affect other cells on same column downwards. example by changing a number value on a row it gives the sum in the next row same column
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Like this? Or do you mean formula based. If formula based, then that functionality isn't built into DataTables, although there is no reason why you couldn't have a simple loop to spin over the cells in the column and update then per whatever formula / function you need.
Allan
I need to sum time(hh:mm:ss) values of specific columns downwards to monitor activities of the day 24hours and if I change time in one row it update the rest below it automatically. I have given example below
That's actually a little tricky in DataTables since rows can be reordered and filtered. What you would have to do is use a callback like in this example.
That's just a simple counter, but you could extend it to do a summation.
Allan