Skip to main content
FionaG
Newcomer
May 4, 2026 7:12 AM UTC
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?  

MarcusHAnswer
Expert
May 4, 2026 10:06 AM UTC

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

View in thread

3 replies

FionaGAuthor
Newcomer
May 4, 2026 7:13 AM UTC

Sorry it was typo, I meant XFSetCell.

MarcusHAnswer
Expert
May 4, 2026 10:06 AM UTC

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

    FionaGAuthor
    Newcomer
    May 4, 2026 11:43 PM UTC

    Thank you so much for your help!

    Terms & ConditionsAccessibility statement