Forum Discussion

FionaG's avatar
FionaG
New Contributor
20 days ago
Solved

Submitting zero in excel

I am trying to submit zero via excel add-in using XFGetCell formula into MTD/periodic view.  Excel/Spreadsheet does not seem to allow it.  I can put in zero into the same POV via a data form. The o...
Excel Add In
  • MarcusH's avatar
    MarcusH
    20 days ago

    The second parameter on the XFSetCell function is StoreZeroAsNoData. Set that to False and it should save the zero values as zero.

MarcusH's avatar
MarcusH
Valued Contributor
20 days ago

The second parameter on the XFSetCell function is StoreZeroAsNoData. Set that to False and it should save the zero values as zero.

FionaG's avatar
FionaG
New Contributor
19 days ago

Thank you so much for your help!