Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Handle numbers with format string behind as real Physical quantities | ||
---|---|---|---|
Product: | Calc | Reporter: | spooch <rath> |
Component: | formatting | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | elish, issues, rainerbielefeld_ooo_qa, rath |
Version: | 3.3.0 or older (OOo) | ||
Target Milestone: | --- | ||
Hardware: | Unknown | ||
OS: | All | ||
See Also: | https://issues.apache.org/ooo/show_bug.cgi?id=122210 | ||
Issue Type: | FEATURE | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
spooch
2009-10-08 13:19:07 UTC
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" Please attach example. Hi Edwin, an example you can find in comment 1. For everybody who does not know the concept of Physical quantities I added a link in the same comment. Some theory / background can be found in explications for Chemacro <http://www.dartmouth.edu/~pchem/chemacro.html>, what enables Excel to understand Physical units, and SimpleGroupware <http://www.simple-groupware.de/cms/Spreadsheet/Features>, what also includes understanding of units. May be you know '=CONVERT_ADD', what has some basic understanding of Physical units, but that's far away from intention of this report. No more comments or explications will be required, the only question is whether we want to do that, because of concerns, also in Comment 1. I wonder whether AOO still has something like the old UX / User-Experience, who should think about this. |