Planning functionality in Stratum.Viewer includes a check for and removal of characters that are considered invalid. Only the valid characters from values that you enter or paste into measure item cells will display after you have entered the values or after the paste has been completed. The format given to the planning values, such as a monetary or percent symbol, will be determined by the Format String property for the measure item.
Characters that are considered valid are the numbers 0 through 9, a single period symbol, a single dash mark -, and the parentheses marks ( and ). The period is the only supported decimal symbol. The dash and parentheses marks are the only supported negative number formats. If you use both parentheses marks and a dash mark, such as (-1234.10), then the value will be treated as a positive number.
If your typed in or pasted values include letters or symbols such as &, %, $, #, and so forth, the characters will be excluded by Stratum.Viewer. For example, if you copied then pasted a value of 12345TQZB, the value displayed after the paste would be 12345.
A warning message will display if none of the values for a paste are considered valid. For example, a warning message would display if you attempted to paste a value of “Abc”, 1234.50.50, or - - 1234.50.