Groovy-Clear Non Numeric data in Formula Rows

Summary

SetFormattedValue() and SetData() functions are not working as expected

Content

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:

operation.grid.dataCellIterator('Employee Name').each 

{ 

DataCell cell ->

      if(cell.getMemberName("Position")=="Position")

      {

            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 */