CSV Export does not handled by Excel correctly

[Areg Vrtanesyan]

Hi

I have noticed that CSV export is not handled by Excel correctly if field description has new lines in it together with commas and quotes.

The only way that I have found to workaround it is to:

• Open file in text editor like Notepad++
• Add separator value at the first line like "sep=|" - no quotes
• Replace first line column name separator from comma to |
• Search and replace "," combination with "|"
• Check for occasional empty new lines ...

Then I can open it in Excel and analyse data.

Could some kind improvement be added for this?

May be sanitise descriptions for new lines, commas and quotes?

Regards, Areg

[[ANS] Alexey Dorofeyev]

Hi Areg,

We're now working on a large update and will fix this.

[Areg Vrtanesyan]

Any ETA on that please?

[[ANS] Alexey Dorofeyev]

July, i guess

[Areg Vrtanesyan]

Hi

Do you have any news about this?

Regards, Areg

[Areg Vrtanesyan]

Hi

Just wondering if you have any news about this?

Regards, Areg

[[ANS] Alexey Dorofeyev]

Hi Areg, we're finally released new version of our app with this bug being fixed.