Running a view/query that features a join between two tables, then copying the output grid, does not format the rows properly - it does not format the rows the same way you see it in the grid on the screen. Each joined row from the two tables, that should appear as a single row - appears on two separate rows in the output file - the joined rows form the two tables should be provided in the same rows in the output file just like shown in the output grid on the screen.
1.) Create two tables with a large number of columns (enough columns to make the output grid extend off the right edge of the screen, say a total of 20 columns).
2.) Join the tables on a common column in a query or view.
3.) Run the view or query to get a tabular grid.
Copying the output grid :
1.) Select all rows and columns in the grid by clicking the cell in the upper left corner of the grid
2.) Right click the selection for the context menu.
3.) Select "Copy" or "Copy with headers."
4.) Paste into an Excel worksheet or text editor.
Does the "Long comment" contain new line characters in cell values?
(I'm not saying it justifies this issue - I'm just trying to find out what is causing the problem)
Bug:
Running a view/query that features a join between two tables, then copying the output grid, does not format the rows properly - it does not format the rows the same way you see it in the grid on the screen. Each joined row from the two tables, that should appear as a single row - appears on two separate rows in the output file - the joined rows form the two tables should be provided in the same rows in the output file just like shown in the output grid on the screen.
1.) Create two tables with a large number of columns (enough columns to make the output grid extend off the right edge of the screen, say a total of 20 columns). 2.) Join the tables on a common column in a query or view. 3.) Run the view or query to get a tabular grid.
Copying the output grid : 1.) Select all rows and columns in the grid by clicking the cell in the upper left corner of the grid 2.) Right click the selection for the context menu. 3.) Select "Copy" or "Copy with headers." 4.) Paste into an Excel worksheet or text editor.
Windows 10 version 1809 (OS Bulid 17763.1577)
SQLIteStudio version 3.3.3.