Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1")

You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1")
sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1"))

Edit: Sorry - forgot a )

You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1"))
sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1)")

Edit: Sorry - forgot a ) - this time for sure