Tabulator Cell Range Ctrl-C and Ctr-V produce strange behaviour when column bottomCalc option is added. I tested it with the demo of Range Clipboard on https://tabulator.info/docs/6.2/range section , when there is no bottomCalc option added is OK as the demo shows, but if you add bottomCalc option to the column definition, it will also copy the footer which is the bottomCalc value to the clipboard. And if you ‘paste to fill’ the other cell, it will fill the cell under the cell you want to paste with the bottomCalc value ( for example sum ) which is very strange. What we expect should be the same like what Excel does.
I am using Tabulator Version 6.2.1. To demonstrate the problem, I just modified a little bit the demo of Range Clipboard on https://tabulator.info/docs/6.2/range section with bottomCalc option added. AS shown in this jsfiddle page:
jsfiddle
https://jsfiddle.net/guidry/n9o8jrac/1/
The screen shots:
Ctrl-C
Cell Range Copy screenshot
Ctr-V
Cell Range Paste screenshot
To Reproduce the issue, this is what I have tried:
1.Range select the second column of the first row(the value is 12).
2. Press Ctrl-C.
3. Select the second column of the second row(the value is 1).
4. Press Ctrl-V.
5. You will see the value of the second column of the second row is 12 which is correct, but the value of the second column of the third row becomes 407(the sum of this column) which is not what we want.
We hope the cell value under the cell we want to paste or fill to will not be affected. Could anyone kindly fix that problem or tell me what to do? Thank you.