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

Excel output date format #367

Open
mm-ing opened this issue Nov 4, 2022 · 0 comments
Open

Excel output date format #367

mm-ing opened this issue Nov 4, 2022 · 0 comments

Comments

@mm-ing
Copy link

mm-ing commented Nov 4, 2022

After grid export to excel a grid column formatted as date looks like a date now, but actually it's a string without the possibility to use the excel filter features for datetime.

Annotation example:
[GridColumn(Position = 10, Title = "Value Date", Format = "{0:dd/MM/yyyy}")]

We changed the ExcelWriter.cs a little bit and got the expected output.
Please substitute the ExcelWriter with the modified one and the problem will be solved.

ExcelWriter.zip

@mm-ing mm-ing changed the title Excel output data format Excel output date format Nov 4, 2022
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

1 participant