Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Charts with prefix multipliers (kilo, mega, nano)|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||3.3.0 or older (OOo)||Keywords:||rfe_eval_ok|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description ivand 2004-06-06 17:31:22 UTC
If you read often some graphs, you know how annoying it is to read numbers like "914000000". Even "9.14E+8" is not comfortable for making impression of data if you are doing your daily engineering tasks rather than rocket science. But wait! "914M" looks much better! Many Europeans (like me) are rather used to prefix multipliers like "k" for "kilo~", "M" for "mega~". In informal documents you can see prefixes in unexpected context like currency. 1 Mâ‚¬ stands for 1,000,000 â‚¬ indeed. Unix guys are familiar with "-h" option for "ls" or "df" commands. Electrical engineers are going insane when they have to read condenser capacities that are usually in pico~ to micro~ Farads. I believe that if there was some option to display values on charts with these prefixes as well (say Scale Property: checkbox "Use Prefix Multipliers"), it would be a definitive engineer's choice and huge advantage over competitors' charting tools. As an example of well-readable graph I am attaching a graph of an audio measurement made by a specialized software so you can see how easy it is to read the X scale. I am sure you guys are familiar with prefixes, but just in case... the URL points to some article on the topic :-)
Comment 1 ivand 2004-06-06 17:32:08 UTC
Created attachment 15702 [details] a chart with prefix multipliers
Comment 2 kla 2004-06-08 09:09:14 UTC
kla->bh: I think its an good idea.
Comment 3 bettina.haberer 2004-11-29 18:19:59 UTC
Reassigned to Ingrid.
Comment 4 IngridvdM 2005-04-25 16:01:05 UTC
This looks like a good idea, but details have still to be specified.
Comment 5 differenceengineer 2007-11-08 14:31:28 UTC
I would like to suggest a refinement to this idea. I would like this to be an option under "Format Cells" in the "Numbers" tab. I propose that an additional Category is required called something like "Engineering" which would mean that a number like 9.14E+8 was displayed as 914M in the cells of the spreadsheet. If these numbers were used to generate a graph then the same format could be used.
Comment 6 IngridvdM 2008-07-22 14:20:51 UTC
reset to new