Premium support for our pure JavaScript UI components


Post by 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
exportcsv.png (143.64 KiB) Viewed 331 times

Thanks,
Shashank
Hatch Digital


Post by 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


Post by khattakdev »

Hey there,

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

Arsalan
Developer Advocate


Post by shashank.yadav »

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

Attachments
Launch SaaS Product (3).zip
(1.33 KiB) Downloaded 22 times

Post by Animal »

The file is encoded using UTF-8

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


Post by 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


Post by shashank.yadav »

Thank you Ghous.


Post by 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


Post by 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


Post by 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


Post Reply