Forum Discussion

FionaG's avatar
FionaG
New Contributor
5 hours ago

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 only workaround I have is to submit a 0.0001 record into OS via excel XFGetCell formula instead.  

Is there any proper change in setting that would allow me to do this?  

2 Replies

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    2 hours ago

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