Skip to main content
F
FionaG
Newcomer
May 4, 2026
Solved

Submitting zero in excel

  • May 4, 2026
  • 2 replies
  • 0 views

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?  

Best answer by MarcusH

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

2 replies

F
FionaGAuthor
Newcomer
May 4, 2026

Sorry it was typo, I meant XFSetCell.

M
MarcusHAnswer
Expert
May 4, 2026

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

    F
    FionaGAuthor
    Newcomer
    May 4, 2026

    Thank you so much for your help!

    Terms & ConditionsAccessibility statement