Dear All,
We have 12 numeric columns for which we have specified "format mask" as "999G999G999G999G990D000". But, when user double clicks the cell first time in IG, then user is seeing empty cell, even though data is there in cell. This is happening because of format mask. Its adding empty spaces.
I can't move formatting to query level, because these columns have "aggregate" definitions on them (like SUM). So it has to be Numeric column type.
I was able to reproduce this issue on sample IG application https://apex.oracle.com/pls/apex/f?p=18384:30: (enter any username). Double click on "Salary" cell for "MILLER" employee. then you will see empty cell, even though there is data. Looks like its happening only for first time and only in Firefox browser. But empty spaces are always there in all browsers.
Question: Is there any way to trim these white spaces, w/o breaking aggregate definitions defined on the column? Thank you.
Best Regards,
Srihari