WEEKNUM <-works in formula vs ISOWEEKNUM <- does not work.

Sep 23, 2016 at 8:24 PM
Hi,

If I use the code:
worksheet.Cells["A" + i].Formula = "=WEEKNUM(B" + i + ")";
my spreadsheet properly displays the WEEKNUM as calculated by =WEEKNUM(B2)

However, if I use the code:
worksheet.Cells["A" + i].Formula = "=ISOWEEKNUM(B" + i + ")";
my spreadsheet displays. #NAME? stating an invalid name. The weird thing is that in the cell, it displays correctly as =ISOWEEKNUM(B2) and if I click on the cell and then click on the formula bar and press [enter] Excel displays the correct ISOWEEKNUM. (Without changing anything.)

Is this a problem with Excel or Epplus? Any suggestions on how to workaround?

Thanks in advance...

Robert