I have an issue here with Export to excel in WAD. When I click on Export to excel and open the excel sheet, 0CALYEAR is showing blank in the excel sheet but when I click on the cell the data 2010 shows up in the formula bar.
FYI - We recently had a patch upgrade from P17 to P22.
When I check my old excel sheet for the same report, I see that the same cell is showing the "format cell" option as "Text" but now its showing up as "custom". When I manually change it to text the current excel sheet is showing up the year in the cell.
This is happening with all WAD that has 0CALYEAR and 0FISCYEAR