Our APEX application is used to report data from our DataWareHouse.
We have some interactive report which is showing different dates and those dates are split with different formats in different columns.
We are showing the Quartal information with a Format Mask = 'Q' and the Month with a Format Mask = 'Mon'.
It all works fine within the APEX application.
BUT when we export the report data to Excel over the standard Download functionality of the Interactive Report, the exported Data is weird:
- the Quartal column is empty (no data at all)
- the Month column is showing wrong value for the month of March. It displays Feb. instead of Mar. and the underlying data in Excel is "29-Feb-1900". Whereas the value in Excel should be "01-Mar-1900". This seems to be related to the fact we are in a leap year and for some strange reason March 1st is mapped to February 29th.
The issue must be with the Excel Export function as there is no such issue when exporting to CSV.
The stack used is made of:
- Java 21.0.5
- ORDS 24.3
- APEX 24.1.5
- Oracle DB 19.16
- Microsoft 365 Excel version 2408 (Build 17928.20216)
The charset of the DB is UTF-8
Note that we already had the same issue with APEX 22.2.9
Further investigation is showing that our DWH is storing the Month information by changing the day to 01, keeping the month as is in the original date and setting the year to 1900. This issue seems to be related to the year being 1900.
Did anyone experience the same kind of issue?