Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Groovy-Clear Non Numeric data in Formula Rows — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Groovy-Clear Non Numeric data in Formula Rows

Accepted answer
21
Views
13
Comments
edited Aug 24, 2020 6:15PM in Planning 13 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!