Engineering Notation in Spreadsheets

Isn't StarOffice the same as OpenOffice? A couple of days ago I posted info on a solution I found. It isn't overly simple, but it works and there is a like to a macro that will at least let you assign it to a button if you want.

Rick

I'd forgotten that it could do this but there's an app for Windows and OS X that handles engineering suffixes and significant figures properly. That is, enter "1/pi^2" and get "101.3m" as the result, or try "1/2n" and get "500.0M". Also hex/binary, unit conversions, and user-defined functions. Quite the handy little tool.

Is that Windows and OS X or Excel under those two OS?

Rick

Windows and Mac OS X. It's a stand-alone "console calculator" for quickies like > 1/(2*pi*234.5k*67.8p) ans = 10.01k Not an Excel add-on (and not Linux, other than under Wine).

the

range

hack to

find a

Not in the least, it is the remnants of WordPerfect, a spreadsheet (maybe old Lotus 123), some Corel image applications and something else. Never was open source. I used to have a copy.

I guess I got them confused a long time ago. StarOffice is free, as in "free beer" though, right? Or maybe I've just plain got it mixed up entirely. I seem to recall having a free copy of StarOffice a long time ago.

BTW, that should be "and there is a *link* to a macro" in the paragraph above.

Rick

StarOffice was the original Sun product, which stank. They open-sourced it, and a fork became OpenOffice. Later StarOffice versions were based on OpenOffice, and according to Wiki, you can still buy an OpenOffice version from Oracle if you really want to.

WordPerfect got bought by Corel, and is still available AFAIK. Not the same product at all.

Cheers

Phil "DOS WP 5.1+ forever" Hobbs

The early ancestry is a little messy but by EOL, when Oracle killed it, StarOffice was essentially the paid version of OpenOffice. WordPerfect passed through Novel, ended up with Corel, and is still around. The spreadsheet app in the suite is Quattro Pro. The original Quattro was a DOS app by Borland, launched shortly after Lotus 1-2-3 came out; thus the name.

normalizes the

range

hack to

find a

(maybe

Never

Though i never saw one that does not mean that no such thing existed. You might have obtained a free (pirated) copy, StarOffice never was as anal as M$.

(maybe

Never

time

paragraph

Not sure what you are talking about, perhaps SunOffice? OpenOffice never had anything to do with StarOffice AFAIK.

Actually the purchase chain is rather more twisted, i seem to recall that Borland was in there somewhere. Corel was about the fourth owner of WP and second owner of the suite.

See:

normalizes the

range

hack to

find a

(maybe

Never

time

No, the twain (StarOffice - OpenOffice) never met.

See my other recent response.

?-)

Read the Wikipedia page on StarOffice. It has the whole story.

Cheers

Phil Hobbs

the

you

(maybe

Never

in

time

and

paragraph

open-sourced

based

never

Hmmm. I wish i really thought it is accurate, it is wikipedia after all.

?-)

I bought it a year before they started giving it away. $79 down the drain, because it is one piece of stock that pays out nothing.

Well, the debian openoffice binary is still called soffice :)

Toward the bottom of this page...