The CSV parser assumes the end of row for each new line, even when the cell is wrapped with double quotes. Reproducible: Always Steps to Reproduce: 1. From Calligra sheets 2. Open a CSV file with new lines in cells Actual Results: Each new line within cell content creates a new row, causing blank columns and other problems. Expected Results: The new lines should be treated as contents for the table cell. In libs/widgets/KoCsvImportDialog.cpp
Created attachment 73911 [details] Contains Qt project with extracted code and python script for comparison The Qt-based test files aren't using QTableWidget as in the actual file, instead it's using QStandardItemModel for less bloaty testing.
Created attachment 73930 [details] Rewrite parser loop to handle multiline Difficult to understand the per-character state machine loop. My patch works for quote-escapes, empty cells and multi-line as long as quotes are adjacent to delimiters.
Created attachment 73954 [details] Handles content between quote escapes by inclusion Combine escaped content with last cell or take the next cell if the delimiter is not adjacent to the quotes.
Dear Bug Submitter, This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond. Thank you for helping us make KDE software even better for everyone!
Dear Bug Submitter, This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand. Thank you for helping us make KDE software even better for everyone!
Still a problem using version 3.1.0 (Fedora packages)