| Summary: | Exporting a query to the clipboard divides the content of a field | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | Albrecht Will <albrecht.will> |
| Component: | Migration/Import/Export | Assignee: | Kexi Bugs <kexi-bugs> |
| Status: | CLOSED WORKSFORME | ||
| Severity: | normal | CC: | adam, inksi, staniek |
| Priority: | NOR | ||
| Version: | 3.0.2 | ||
| Target Milestone: | --- | ||
| Platform: | Arch Linux | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: |
screenshot from form
screenshot from calc over clipboard directly csv Expected options |
||
Created attachment 107751 [details]
screenshot from calc
Thanks Albrecht, could you please paste the content to a .txt file and attach it too? Created attachment 107752 [details]
over clipboard
Created attachment 107753 [details]
directly csv
Libre office and Excel (and probably many other apps) expect tab delimiters and " quotes for clipboard CSV format. Created attachment 107756 [details]
Expected options
I am not sure the format is invalid because " character is used which protects against issues when newline character is used. It works with Excel and LibreOffice but if you import via file. It is invalid for clipboard as mentioned above. Side note for myself: Let's look what are our default options for clipboard handling. It's not best thing that we don't warn if user changes them in case of clipboard. So summing up, the content https://bugs.kde.org/attachment.cgi?id=107752&action=edit is almost OK except it contains no quotations, what is exactly the reason why applications can't detect the value contains new line. When I have " quotations set in the options, relevant fragment of the csv is: "a) Tabakwarenhandlung b) Schankwirtschaft """Centralhotel""" Ok I understand the use of quotations. If its not too hard, what about changing a break within a db-cell into a space. When you EXPORT a db-content then such formal things ar not essentially. Look at my attachment out off my form. I used it there for a better presentation. But this is only my actual limited perception. Does the paste to LO work for you if you use " and tabs? Thanks, it works well! - a much easier way, but you should know. OK then, so I would see these conclusions that can lead to improvements: - warn the user about unsafe settings for clipboard content - add a checkbox that for sets clipboard-safe content - add option to replace newlines with spaces in cell values on export These would be separate tickets that I can add. Thanks Albrecht. |
Created attachment 107750 [details] screenshot from form The content of a field from type "a) text 1 (linebreake) b) text 2" will be devided. The linebreake starts a new sentence in calligra writer or Libre Office. Exporting to a csv-file the linebreake appears in the desired cell.