Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support configurable formula escaping character for csv export? #481

Open
alexyang2920 opened this issue Sep 13, 2024 · 2 comments
Open

Comments

@alexyang2920
Copy link

Currently, JasperReports uses a space character to escape formulas in CSV files to prevent CSV injection. You can see the implementation details here.
It would be beneficial if JasperReports allowed users to configure the escape character.

@shertage
Copy link
Collaborator

shertage commented Sep 19, 2024

Hi @alexyang2920 ,
could you please let us know more details (some use cases maybe) about the necessity of a configurable escape character?

Thank you,
Sanda

@alexyang2920
Copy link
Author

Originally we were thinking if we could prepending a single quote which could be hidden in excel, however it looks like the single quote still shows unless you double click the excel cell, however it's still be good to make it configurable in case someone want to use single quote or other characters.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants