Export to CSV with CSV injection in C# code - Issue with (-) index

Question

Export to CSV with CSV injection in C# code - Issue with (-) index

devasena123490 opened this issue 2 years ago · 4 comments

Hi Team,

I've implemented a logic to export data to CSV using C# and it has negative values (example: -10.0000)
As per CSV injection, I added (') in the front . Something like below.

        if(value.StartsWith("-"))
        {
            value = value.Replace("\"", "\"\"");
            return $"\"\'{value}\"";
        }
        
        When I export to CSV , I could see the (') in excel cell. But I have to format that from the code. How to fix that? I dont want to see (') when I export to CSV

Answer 1 · 2022-08-26T18:36:03.000Z

Hi @ALL, Can someone look into this issue? Please

Answer 2 · 2022-10-13T20:44:32.000Z

I am not sure this qualifies as an UI-Grid defect

Answer 3 · 2022-12-13T10:28:24.000Z

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

Answer 4 · 2023-01-12T10:37:03.000Z

This issue has been automatically closed because it has not had recent activity. If you believe that this is still an issue in the latest version, feel free to re-open it. Thank you for your contributions.