Example - Excel Compatible Spreadsheet with DataView


Excel compatible copy/paste manager using DataView

Thanks to Celebio! (link to site)

This is basically the same example than example-spreadsheet.html, with the support of external excel-compatible software clipboard

Paste from Excel-compatible:

Each column to be pasted to must either have an editor, or there must be an overall getter/setter for the whole grid.
The issue is that to copy and paste a block from anywhere to anywhere, the data copied/pasted must be in text format. If data was copied direct, and if the columns of the copy/paste area were not aligned, we might end up copying say a date value into a column that has text data.
Enforcing the requirement for the editor is the way CellExternalCopyManager makes sure that pasted text data can be converter to and from the native data type of the column.

Copy for Excel-compatible:

Undo/redo support :

View Source: