Posted 26 February 2020, 8:41 pm EST
Hello Ashwin,
Thank you for the quickly reply, there is one more situation here, follow the steps bellow to reproduce.
- Ctrl + click line 2
- Ctrl + click line 4
- Ctrl + click line 6
- Ctrl + Shift + click line 2
- Now if you call getClipString will receive 7 lines of data, the last step adds new a range from row index 1 to 4
Final selectedRanges:
[
{"_row":1,"_col":0,"_row2":5,"_col2":5},
{"_row":1,"_col":0,"_row2":1,"_col2":5},
{"_row":3,"_col":0,"_row2":3,"_col2":5}
]
Result of “getClipString(null, false, true)”
Id Country Active Downloads Sales Expenses
1 UK true 32,359 70,413.99 32,160.35
2 UK true 9,023 76,119.55 13,897.23
3 Italy true 5,626 45,115.54 29,850.35
4 Germany true 173,490 63,762.70 31,049.53
5 UK false 183,252 58,187.13 41,618.51
1 UK true 32,359 70,413.99 32,160.35
3 Italy true 5,626 45,115.54 29,850.35
regards