Issue 32688 - Scientific cell format to snap to common multiples
Summary: Scientific cell format to snap to common multiples
Status: CLOSED DUPLICATE of issue 5930
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 680m47
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2004-08-06 17:20 UTC by miketashcorpnet
Modified: 2010-11-10 17:43 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description miketashcorpnet 2004-08-06 17:20:53 UTC
This is a feature/enhancement request to the OOCalc cell formats. For the
scientific format, please add an option to cause the scientific format to favor
certain exponential terms. This is requested because most scientific work ends
up working on powers of 1000 (meters vs kilometers vs millimeters vs
micrometers) and it would be helpful to be able to get the scientific cell
format to round to the nearest thousand. I.E.:

.0123 -> 12.3 E-3
.123 -> 123.0 E-3
1.23 -> 1.23 E+0
12.3 -> 12.3 E+0
123  -> 123.0 E+0
1230 -> 1.23 E+3

And so on. This helps with data analysis since there's many fewer conversions to
do in one's head while reviewing results. My suggestion is to add a checkbox for
rounding the exponent to the nearest power of 3 or adding an additional entry
box for what it's rounding to.
Comment 1 Regina Henschel 2004-08-06 17:48:14 UTC
Your wish has been already expressed in issue 5930. 
Comment 2 miketashcorpnet 2004-08-06 19:42:10 UTC
I agree that this is a dupe, but I can't figure out how to make it as a dupe to
close it out.
Comment 3 frank 2004-08-08 16:26:43 UTC
So I will do it.


*** This issue has been marked as a duplicate of 5930 ***
Comment 4 frank 2004-08-08 16:27:08 UTC
closed double
Comment 5 wotnalovent 2010-11-10 17:43:12 UTC
Created attachment 73569