Copying a multi-selection of non-adjacent cells into the think-cell datasheet does not work. When multi-selecting several non-adjacent cells, e.g., by pressing the control key and subsequently clicking on cells, and then copy/pasting these cells into think-cell's internal datasheet, unselected cells in between are pasted as well.
This is a design limitation of Excel. think-cell's internal datasheet is based on Excel, but is a separate Excel process. The problem can also be reproduced without think-cell when copy/pasting non-adjacent cells into a separate Excel process.
Result: The unselected cells A2 and A4 are pasted as well.
“This behavior is by design.
When you use the clipboard for copy and paste, you are using a feature that is designed to work across all office applications. Since this is the case, the clipboard uses HTML code for storing and then pasting data. The HTML code is limited to a range select and you get all the data in the range including the cells you did not select. It is creating a table in HTML code and uses this table for the paste action. This allows the clipboard to share data from Excel to other office applications such as Word, Power Point, and other instances of Excel outside this workbook.
When you use Ctrl-C and then follow it up with Ctrl-V instead of using the clipboard you are using an internal Excel single instance copy feature that allows Excel to copy only the selected cells. This gives you the desired behavior. The clipboard has limits due to the fact that it shares with all office applications. The limit to the clip board was planned due to the huge amount of data that would be required to do a simple copy and paste. Large copy actions would overwhelm the system and cause huge slowdowns in performance. The HTML copy is a stripped down version of the internal copy and therefore there are differences and limits.” (Microsoft Office Support)