SetFormattedValue() and SetData() functions are not working as expected
I'm trying to clear Non Numeric Data in Formula Rows. The SetFormattedValue() and SetData() functions are not working as expected.
Hear is my Groovy Code:
DataCell cell ->
println(cell.Data) /* Able to print cell value to be cleared */
/*cell.setFormattedValue(null)*/ /* Not able to set the value of the cell to null/"#Missing" */
/*cell.setData(0)*/ /* Not able to set the value of the cell to 0 */
cell.setBgColor(16755370) /* Able to set the background of the cell to required color */