The upper left square in the table can be clicked to highlight all and copy, but it doesn't include the headers. What option should we set to include the headers, not just the data rows? Thanks

I am getting this error while importing import DataGridXL from '@datagridxl/datagridxl2'; Is there any way to use this in Angular.

Also, It would be helpful, If anyone has Angular implementation code for latest version.

Thanks

Uncaught TypeError TypeError: Cannot read properties of undefined (reading 'ctrlKey')
at move (datagridxl2.js:8:96248)     at <anonymous> (datagridxl2.js:8:104181)     at uo (datagridxl2.js:8:77401)

Ticket /198

Cell value: Hi my “name” is Rogerio Copy value from cell: “Hi my “”name”” is Rogerio”

These double quotes probably come from PapaParse parse/unparse methods. Check if we need to have these double quotes. Copying Hi my “name” is Rogerio from Google Spreadsheets does not result in double quotes.

Perhaps introduce a new option:

var grid = new DataGridXL("grid", {
  addQuotesToCopiedValues: false
});

From Zendesk Ticket 185:

Copying three cells in a single rows (A B C) copies "A\tB\tC\n" (Windows 10, Excel) instead of "A\t\B\tC" (expected, as seen in Excel Online). This \n character has DataGridXL believe that there are 2 rows copied, instead of just one. It somehow also clears any value in the first cell of this second row.

Copying 2 cols of empty cells copies only first col. Copying 3 cols of empty cells copies first 2 columns only. Same goes for copying vertical cells: 2 cells copies first cell, 3 cells copies cells 1 and 2, but not 3.

If grid is placed in a page/node that has text-align: center, the column nodes are centered as well. it seems there is no style on the dom node to prevent this .

We're using quite a bit of methods to parse and print tsv and csv. Papaparse is only 20kb minified, and it's heavily tested. They have solved edge cases that we have yet to encounter. Discuss!

When copying a cell range from G. Sheets, cell values that contain newlines are formatted in quotes ("..."). Do the same for DGXL2 in handleCopy/handleCut handlers (in getCellRangeText method specifically). Also, adjust paste/handlePaste so any quoted values are parsed as a single cell value. (In TSV, a newline is considered a new row of values.)

Cell values that contain newlines should have them be replaced with ↵ symbol, so a cell value is always rendered in a single line!

(Same as DGXL1: https://github.com/DataGridXL/DataGridXL/issues/1)

This might be an OS feature that we need to leave alone, or... we need to fix it. Investigate...

This happens in Safari and in Chrome on MacOS, so quite likely to be a native macOS thing.

Give TypeScript users some love and include a definitions file, to prevent annoying errors and to make including DGXL in TS projects not a pita.

See #38

https://codepen.io/datagridxl/pen/VwdXPRN?editors=1010

getData returns an bunch of invalid objects {undefined: 150}. Probably something goes wrong when using columns.

Example: copy 2x2 empty cells from Excel Online to DGXL in this Codepen demo: https://codepen.io/datagridxl/pen/mdXxXPR. It doesn't work in DGXL; it works in HoT though.

When pasting the values in the "Check Formatting" textarea, the copied string is "". It seems that HoT reads other data than the copied string. Perhaps the clipboard object holds more detailed Excel info, as they cannot possibly interpret "" as meaning 2x2 empty cells.

https://news.ycombinator.com/reply?id=30920492&goto=item%3Fid%3D30919257%2330920492

Been using AgGrid but looking for a replacement. I tried to load a CSV of 100k items here and got a "RangeError: Maximum call stack size exceeded."

https://www.datagridxl.com/demos/import-csv-data

See where the error comes from and determine a recommended max number of rows.

According to this Stackoverflow thread, it's because of document.fullscreenEnabled. It seems that in Codesandbox, the iframe document has fullscreenEnabled set to false.