Empty Cells should be Empty, not Error
I'm writing an application using AW 2.5.5, and I've run into a problem with the way cell formats work. I'm using setCellData, and applying various AW.Formats to all of the columns.
Basically, the point of my using the grid is for users to enter data into it. There's a ton of empty cells at the start -- which the users need to populate with their data -- and AW treats these empty cells as errors, and uses the ErrorText and ErrorValues I've assigned in the AW.Formats for all of them.
The problem is, these aren't errors, they're just not filled in yet. I would like to be able to use the setErrorText and setErrorValue AW.Formats options for the situations where the users actually have entered incorrect data, but to prevent #ERR (or whatever message I would set for the ErrorText) from showing up in every single empty cell, I have to setErrorText to an empty string, "", which essentially makes this feature useless to me.
Does anyone have suggestions or could point me somewhere for advice on how to default it to certain text("") and value(0) on empty cells, but using the ErrorText/ErrorValue for cells that have data that does not match the AW.Formats?
Basically, the point of my using the grid is for users to enter data into it. There's a ton of empty cells at the start -- which the users need to populate with their data -- and AW treats these empty cells as errors, and uses the ErrorText and ErrorValues I've assigned in the AW.Formats for all of them.
The problem is, these aren't errors, they're just not filled in yet. I would like to be able to use the setErrorText and setErrorValue AW.Formats options for the situations where the users actually have entered incorrect data, but to prevent #ERR (or whatever message I would set for the ErrorText) from showing up in every single empty cell, I have to setErrorText to an empty string, "", which essentially makes this feature useless to me.
Does anyone have suggestions or could point me somewhere for advice on how to default it to certain text("") and value(0) on empty cells, but using the ErrorText/ErrorValue for cells that have data that does not match the AW.Formats?
JohnW
December 18,