Unit calculation and dimension verification
As explained in the comment (see #374 (closed)) Gnumeric does not support unit calculations and/or verification. I would like to ask for such support. Gnumeric should support two modes of operation:
- Unit calculations - formulas return both numeric values (as they do today) and units (possibly in a minimized/reduced form) based on units assigned to "input" cells.
- Dimension verification - the "output" cell is assigned a unit and Gnumeric checks if the dimension (e.g. length, time, temperature) returned by the formula in this cell matches. Please note, that "input" cells may be assigned different units of the same dimension. For example, it should possible to add inches to light years and present the result as centimeters. However, if angstroms are added to pounds-per-square-inch an error should be reported.