3.2.0

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?
JohnW
December 18,
Found this post, which I used to solve this problem: http://www.activewidgets.com/javascript.forum.12384.5/formats-applied-to-empty-cells.html

"I guess I should add special case for null or empty values but for now you can ... "

I feel like this is a very common problem, so I would agree with that statement, though it is easy to fix, it seems like it should just be built in.
JohnW
December 18,

This topic is archived.

See also:


Back to support forum