[ANGULAR] CSV exported data coming with special character Â

[shashank.yadav]

Hi Team,

How to restrict CSV exported data to bring special character  which represents hierarchical data?
Instead of that, is there any way that we can replace with space?
Also, we want to understand why it implemented this way. Is it a bug at Bryntum end?

Reproducible on Demo link: https://bryntum.com/products/gantt/examples/exporttoexcel/
(click on export to CSV)

exportcsv.png (143.64 KiB) Viewed 385 times

Thanks,
Shashank
Hatch Digital

[shashank.yadav]

It looks like UTF8Encoding is not enabled while interacting with zipcelx.
Is there any way that Bryntum Gantt can handle that?
Any thoughts?

Thanks,
Shashank
Hatch Digital

[khattakdev]

Hey there,

Did you make any modification to demo before downloading it?
Downloading with the default state works for me.

[shashank.yadav]

No I haven't. I have attached the exported CSV. Is there any way you could help us, please.

[Animal]

The file is encoded using UTF-8

The reading software must use UTF-8 decoding when converting bytes to characters.

[ghulam.ghous]

Hi Shashank,

Thanks for reporting this issue. I was able to repro this issue on Windows machine in excel. Though it was not reproducible on Mac. I have created a ticket here to fix/investigate the issue here https://github.com/bryntum/support/issues/8690. You can subscribe to it keep track of updates.

Regards,
Ghous

[shashank.yadav]

Thank you Ghous.

[shashank.yadav]

Hi Ghous,

Do we have any ETA on below ticket, please?
I could see we have released two Gantt version after raising this ticket, but couldn't find fix for same.

https://github.com/bryntum/support/issues/8690

Thanks,
Shashank Yadav
Hatch Digital

[ghulam.ghous]

Hi Shashank,

We have marked this ticket blocking and high priority. The fix is going to be available in the 5.6.9 patch release. Our previous patch release was a hotfix for a really bad bug.

Regards,
Ghous

[sergey.maltsev]

Hi, Shashank!

This config
https://bryntum.com/products/grid/docs/api/Grid/util/TableExporter#config-indentationSymbol
defaults to '\u00A0\u00A0\u00A0\u00A0'.

This outputs spaces in cvs as non-breaking spaces
This works for xlsx export, but breaks csv.

Try using this config in app

    features : {
        excelExporter : {
            // Choose the date format for date fields
            dateFormat : 'YYYY-MM-DD HH:mm',

            exporterConfig : {
                indentationSymbol : '    '
            }
        }
    }

We are investigating what can be done to fix that