Skip to Content
Former Member
Mar 01, 2011 at 02:11 PM

Issue with Export to excel in WAD on 0CALYEAR and 0FISCYEAR


Hi Gurus,

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

Please suggest!