The number formatting engine in Gnumeric is very powerful: it can be used to display numbers in various formats as well as providing the user with the ability to specify colors based on various simple conditions.
The available catagories of pre-defined formats are :
General A swiss army knife of a format. It will attempt to display a value it the 'best' way possible. The choice of format depends on the size of the cell and gnumeric's estimate of what 'type' of value is being displayed (number, date, time ...). Number Displays numbers with 0-30 digits after the decimal place. Negatives can be displayed normally, within parenthises, or turning Red. Optionally a delimiter can be added every third order of magnitude (thousand, million, ...). Both the decimal point and the thousands seperator have internationalization support. Currency Is very similar to Number, with the addition of a currency symbol. Currently known symbols include '$' and the three letter abreviations of a ll major currencies. Accounting A specialization of Currency which pays more attention to the alignment of negative numbers. It ensures that A small amount of space is prepended to positive numbers so that that align with negatives. ie ' 600.123 ' : Note the spaces for the positive number '-500.456 ' : in 1 format for negatives. '(500.456)' : in another. Date The various permutations and combinations of predefined date representations big to expose the underlying format specification language . The short version is that years can be 2 or 4 digit (yy or yyyy). Months can be as many digits as needed (m), always 2 digits (mm), or as the short form (mmm). Days can be as many digits as needed (d) or two digits (dd). The various other characters offer a choice of seperators. Time As with dates predefined time formats are selected using their specification. Hours (h), minutes (mm), seconds (ss). Sometimes it is necessary to display more than 24 hours, or more that 60 minutes/seconds without the values incrementing the display unit of the next larger measure (ie 25 hours instead of 1day + 1hour). For that instance you can use '[h]', '[m]' or '[s]'. Percentage Multiplies a value by 100 and appends a percent. Can be used with 0-30 digits after the decimal place. Scientific Formats the value using scientific notation and 0-30 digits after the decimal place. No provision for controling the exponent are provided at this time. Text Treats numeric values as text. This will show a number with as much precision as available and will lose knowledge of whether it represented a date, or time. Custom This provides a list of the format specifica |