Hi,
What is the correct way to set a cell to
#N/A in FPSpreadsheet?
I tried the following options:
- molWS.WriteNumber(ARow, ACol, Nan); ==> doesn't work
- molWS.Writeform WriteCellValueAsString(ARow, ACol, '#N/A'); ==> doesn't work
- molWS.Writeform WriteText(ARow, ACol, '#N/A'); ==> doesn't work
- molWS.WriteFormula(ARow, ACol, '#N/A'); ==> it works, but is it the way to go?
Would it be different if I wanted to set a cell to
#NUM! or
#VALUE! ?
Thanks!