https://issues.apache.org/ooo/show_bug.cgi?id=105726
rainerbielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rainerbielefeld_ooo_qa@biel | |efeldundbuss.de Version|recent-trunk |pre AOO 3.4.0 Summary|multiplier in cell |Handle numbers with format |formatting for generating |string behind as real |own formats |Physical quantities --- Comment #1 from rainerbielefeld <[email protected]> --- I am not sure whether I understand the request. Current situation: A Number with a measuring unit is more or less a number with a string behind it, the string is meaningless for calculations, So if you add 2 values with different "units", you get some nonsense ("Current Situation") Current situation should be 1 km 1 km + 1 m + 1 m --------- --------- 2 1001 m If Calc would understand the concept of "Physical quantities" <http://en.wikipedia.org/wiki/Physical_quantity> we would get the "should be " result. With that concept additionally changing unit of "1.23 km" to "m" would lead to result "1230 m". And the result of a division of an electrical voltage [V] by an electrical current [A] would result in an electrical resistance [Ω] And alc would resist to add an electrical resistance [Ω] to an electrical current [A] As an engineer I like that concept, but I wonder whether any Spreadsheet software for normal office use does that, and whether that might be too sophistic for user "Average Joe" -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
