To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=5930





------- Additional comments from [EMAIL PROTECTED] Mon Mar 17 12:08:33 +0000 
2008 -------
Hi all!

I'm attaching a very simple demo spreadsheet that shows how you can use vlookup
to apply a 'unit prefix' to a list of numbers.

I hope it will be useful for you.

You'll notice that it's quite convenient to have the same prefix for a whole
column. It makes it simpler to compare different values. 

Conclusion, the best would be to be able to choose between 

- normal engineering notation (as described above, noted 1. 10^3)
- eng. Notation + prefix  ( 1k, 1M, 1G, ...), and let oo chose the prefix
- eng. Notation + prefix, but let the user chose the prefix  (like in the demo
sheet)



---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to