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 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?  

  • 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.

3 Replies

  • 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!