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.

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

Copy with header & paste format not matching grid format #4222

Open
DinoMiller opened this issue Sep 29, 2021 · 1 comment
Open

Copy with header & paste format not matching grid format #4222

DinoMiller opened this issue Sep 29, 2021 · 1 comment
Labels
bug Something isn't working

Comments

@DinoMiller
Copy link

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)
ExcelPasted
TextPasted

SQLIteStudio version 3.3.3.

@pawelsalawa
Copy link
Owner

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)

@pawelsalawa pawelsalawa added the bug Something isn't working label Sep 29, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants