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...
The second parameter on the XFSetCell function is StoreZeroAsNoData. Set that to False and it should save the zero values as zero.
