Dates cells filter in exported Excel reports

[Lech Kulikowski]

Hello,

Please try to set the following option:
StiOptions.Export.Excel.AllowExportDateTime = true;

Thank you.

[MariusN]

Hello,

Please try to set the following option:
StiOptions.Export.Excel.AllowExportDateTime = true;

Thank you.

That is set by Default by the new version of Stimulsoft, (Just check on the example report I sent you, it is in there). Anything else, please?
ELSE
If you see the mistake in my report, can you please advise?

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.

Thank you.

[MariusN]

Hello,

We couldn't reproduce the issue.

Thank you.

Yes, it is a Date, but the filter options do not see it as a date.

2023-09-06_08-47-58.png (26.05 KiB) Viewed 10133 times

Filter...

2023-09-06_08-50-46.png (10.51 KiB) Viewed 10133 times

What it should do, when correct,
Example 1

2023-09-06_08-52-40.png (2.08 KiB) Viewed 10133 times

Example 2

2023-09-06_08-53-53.png (12.43 KiB) Viewed 10133 times

[MariusN]

Dears @ Support,

Please assist with an issue we are having. When exporting a report to an excel file and the report contains a date field, excel is not recognizing it as a proper date field. We found that we cannot properly filter the date fields. Only after making any change to the field will excel recognize it as a date field and we can filter it normally. Please see the below screenshots and attached files.

Can you please help?
Thanks in advance

PLEASE refer to the original post explaining the exact problem...

[Lech Kulikowski]

Hello,

By default, this option turned off. And your report does not have this option.

We enable this option, export and everything works.
Here's an example of your report in the attachment. We simplified it a lot, because in the Excel file the column names are very different from the report.

Thank you.

[MariusN]

Hello,

By default, this option turned off. And your report does not have this option.

We enable this option, export and everything works.
Here's an example of your report in the attachment. We simplified it a lot, because in the Excel file the column names are very different from the report.

Thank you.

Thank you it works

[Max Shamanov]

Hello,

You are Welcome!