Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Incorrect rendering of pasted multiline values #24

Closed
DataGridXL opened this issue Feb 8, 2022 · 1 comment
Closed

Incorrect rendering of pasted multiline values #24

DataGridXL opened this issue Feb 8, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@DataGridXL
Copy link
Owner

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.)
@DataGridXL DataGridXL added the bug Something isn't working label Feb 8, 2022
@DataGridXL
Copy link
Owner Author

Fixed. getCellRange text "escapes" double quotes inside cell values with another double quote, which apparently is the standard in TSV (Google Sheets does this).

tsvStringToArray private method has been completely replaced to take multiline values into account. (according to this solution: https://stackoverflow.com/a/57105078/775103)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@DataGridXL