[kexi] [Bug 384493] Exporting a query to the clipboard divides the content of a field

2017-10-02 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] Exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|3.1 |---

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] Exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

Summary|exporting a query to the|Exporting a query to the
   |clipboard divides the   |clipboard divides the
   |content of a field  |content of a field

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|UNCONFIRMED |RESOLVED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #12 from Jarosław Staniek  ---
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.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Albrecht Will
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #11 from Albrecht Will  ---
Thanks, it works well! - a much easier way, but you should know.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #10 from Jarosław Staniek  ---
Does the paste to LO work for you if you use " and tabs?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Albrecht Will
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #9 from Albrecht Will  ---
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.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #8 from Jarosław Staniek  ---
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"""

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #7 from Jarosław Staniek  ---
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.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #6 from Jarosław Staniek  ---
Created attachment 107756
  --> https://bugs.kde.org/attachment.cgi?id=107756&action=edit
Expected options

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #5 from Jarosław Staniek  ---
Libre office and Excel (and probably many other apps) expect tab delimiters and
" quotes for clipboard CSV format.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Albrecht Will
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #4 from Albrecht Will  ---
Created attachment 107753
  --> https://bugs.kde.org/attachment.cgi?id=107753&action=edit
directly csv

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Albrecht Will
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #3 from Albrecht Will  ---
Created attachment 107752
  --> https://bugs.kde.org/attachment.cgi?id=107752&action=edit
over clipboard

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|--- |3.1

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Jarosław Staniek
https://bugs.kde.org/show_bug.cgi?id=384493

Jarosław Staniek  changed:

   What|Removed |Added

 CC||[email protected]

--- Comment #2 from Jarosław Staniek  ---
Thanks Albrecht, could you please paste the content to a .txt file and attach
it too?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 384493] exporting a query to the clipboard divides the content of a field

2017-09-08 Thread Albrecht Will
https://bugs.kde.org/show_bug.cgi?id=384493

--- Comment #1 from Albrecht Will  ---
Created attachment 107751
  --> https://bugs.kde.org/attachment.cgi?id=107751&action=edit
screenshot from calc

-- 
You are receiving this mail because:
You are watching all bug changes.