When exporting reports into Excel after disabling ActiveX, the format of cells containing dates does not correspond to the cell format and is in the "dd/mm/yyyy H:MM" format instead of a format defined by our locale settings. Changing the cell date format does not help.

If we put cursor on the cell with date and double click on it, the the date is automatically changed to “dd.mm.yyyy”. However we can’t click manually on each date cell in the exported report since there can be thousands of rows. So we need to have a way to export reports with dates in a correct format.

Could you please help us to set up export file so that the date cells will be in the format “dd.mm.yyyy” as they used to be?

This is a result of not using ActiveX. Without it we are not able to export dates in client Locale. Microsoft Excel can convert them but does not do this automatically - it needs to receive a cell change trigger (the double-click) to change that cell according to its date format. There is a workaround to do this for an entire column instead of one cell at a time:

1. Export a report.
2. Select all values in the column you want to change formatting for and copy them into clipboard using Ctrl+C shortcut.

In Microsoft Excel, you can quickly select all values from the selected cell down by using the Ctrl + Shift + ↓ (Ctrl + Shift + Down arrow) shortcut.

1. Open a plain text editor such as Notepad. It has to be Notepad or another plain text editor, using Microsoft Word will not work.
2. Paste the values in the text editor using Ctrl+V shortcut.
3. Select all values in the text editor using Ctrl+A shortcut and copy them using Ctrl+C shortcut.
4. Paste the values back in the column using Ctrl+V shortcut.

This effectively overwrites all cell data in that column with the exact same data but Microsoft Excel will receive the change trigger in all cells and will change them all according to their format.

Invoicing > Analysis Reporting for Invoicing