Copy paste functionality of ParamQuery grid is compatible with any spreadsheet application like MS Excel i.e., data can be copied from ParamQuery Grid and pasted to other spreadsheets and vice versa.
Please note:
during initialization: By default all the rows and columns in a Range or Selection of cells are copied.
Columns can be skipped from copied data by setting column.copy to false.
Similarly rows can be skipped from copied data by setting pq_copy
property to false.
in run time: rows and columns can be conditionally skipped in run time e.g. skip hidden rows and columns while copying. To ahieve that,
we convert column.copy
property to javascript getter, which can be defined in the grid initialization object.
Furthermore columnTemplate
can be used to propagate getter copy property to all columns.
columnTemplate: { get copy(){ return !this.hidden; } }
or by updating existing grid initialization object (before initialization of grid)
Object.defineProperty(obj.columnTemplate, 'copy', { enumerable: true, get (){ return !this.hidden; } })
Similarly it can be set up for rows by using their counterpart properties,
rowTemplate
, rowData.pq_hidden
, rowData.pq_copy
.
pq_paste
property to false.
column.paste
can be linked to column.hidden
property by using javascript getters
which can be defined in the grid initialization object. We use columnTemplate to propagate paste property to all columns.
columnTemplate: { get paste(){ return !this.hidden; } }
or by updating existing grid initialization object (before initialization of grid)
Object.defineProperty(obj.columnTemplate, 'paste', { enumerable: true, get (){ return !this.hidden; } })
Similarly it can be set up for rows by using their counterpart properties, rowTemplate, rowData.pq_hidden, rowData.pq_paste.
When an image is copied, it is stored on the clipboard, making it transferrable across grids, web-based platforms (e.g., Google Sheets, web forms, CMS tools), desktop applications (e.g., PowerPoint, Excel), and even design software.
For example:
Copy a picture from a data grid and paste it into web-based tools (e.g., Google Docs) or platforms like image editors (Canva, Photoshop).
Similarly, copy images from the web or other software and paste them into grids.
Hyperlinks consist of two components: the display text and the underlying URL.
When copied from the grid, both pieces of information are preserved on the clipboard.
This allows the hyperlink to be pasted into other applications in a way that maintains
its functionality. For example, copying a hyperlink with display text
"Google"
and URL "https://google.com"
will ensure that
both the visible label and the target link are available when pasting into applications
that support rich text or hyperlink data.
When numbers or dates are copied, both their underlying values and their display formats are preserved. This means that if a cell contains a numeric value or a date with a specific format (for example, currency, percentage, or a custom date style), the clipboard will retain both the raw value and the applied formatting. As a result, when you paste the copied content into a compatible application, it will appear exactly as it did in the original source, while still maintaining the original value for calculations or further processing.