Page 2 of 2
Re: Dates cells filter in exported Excel reports
Posted: Fri Sep 01, 2023 12:46 pm
by Lech Kulikowski
Hello,
Please try to set the following option:
StiOptions.Export.Excel.AllowExportDateTime = true;
Thank you.
Re: Dates cells filter in exported Excel reports
Posted: Tue Sep 05, 2023 11:09 am
by MariusN
Lech Kulikowski wrote: ↑Fri Sep 01, 2023 12:46 pm
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?
Re: Dates cells filter in exported Excel reports
Posted: Tue Sep 05, 2023 8:06 pm
by Lech Kulikowski
Hello,
We couldn't reproduce the issue.
Thank you.
Re: Dates cells filter in exported Excel reports
Posted: Wed Sep 06, 2023 6:54 am
by MariusN
Lech Kulikowski wrote: ↑Tue Sep 05, 2023 8:06 pm
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 12844 times
Filter...
- 2023-09-06_08-50-46.png (10.51 KiB) Viewed 12844 times
What it should do, when correct,
Example 1
- 2023-09-06_08-52-40.png (2.08 KiB) Viewed 12844 times
Example 2
- 2023-09-06_08-53-53.png (12.43 KiB) Viewed 12844 times
Re: Dates cells filter in exported Excel reports
Posted: Wed Sep 06, 2023 6:56 am
by MariusN
Abed Hamodi wrote: ↑Thu Jun 27, 2019 11:20 am
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...
Re: Dates cells filter in exported Excel reports
Posted: Wed Sep 06, 2023 2:39 pm
by 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.
Re: Dates cells filter in exported Excel reports
Posted: Thu Sep 07, 2023 3:28 am
by MariusN
Lech Kulikowski wrote: ↑Wed Sep 06, 2023 2:39 pm
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
Re: Dates cells filter in exported Excel reports
Posted: Thu Sep 07, 2023 5:58 am
by Max Shamanov
Hello,
You are Welcome!