Number format "#"

Classic Servoy
1

If I use just “#” as a number format, I would want and expect the number 0 to not display at all, however it does display as “0”. I would want this behavior only if the format were set to “0” or “#0”.

This is how it should work according to the documentation, and is also how it does work in other languages I am familiar with.

Additionally, it would be nice to be able to optionally specify separate formats for negative values and zero values, ala Excel and 4th Dimension, and to be able to specify different colors as well. This would allow for the common accounting practice of displaying negative values in parenthesis and/or in red, like “($1,234.56)”, for example. (I’ll post this as a feature request.)

  • Amary

Servoy 2.1-build 310, Mac OS X 10.3.5, Java 1.4.2-38

2

In the format # represents one digit, to hide the 0 make a text calculation which returns nothing when input is 0
About coloring, this is easy, make a calculation:
if (inputvalue < 0)
{
returns ‘’+inputvalue+‘’;
}
else
{
return ‘’+inputvalue;
}