[Bug 105726] Handle numbers with format string behind as real Physical quantities

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=105726

rainerbielefeld <ra...@bielefeldundbuss.de> 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 <ra...@bielefeldundbuss.de> ---
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.