Folks, Unfortunately spreadsheet programs store complex numbers as text, meaning one can't truncate to a reasonable length and so the cells all overflow. For Excel there is some lengthy Basic script to fix this but not for OO. Anybody know a trick how to get them into scientific notation with, say, four decimal points plus the exponent, for the real and for the imaginary part? -- Regards, Joerg

I haven't tried it but the text seems to indicate that it switches to scientific notation as needed. -- Jeff Liebermann 150 Felker St #D Santa Cruz CA 95060 Skype: JeffLiebermann AE6KS 831-336-2558

Format complex cell in OpenOffice?

May 22, 2013 21 Replies

Rate this thread:

Jasen Betts 13 years ago

It doesn't make any difference to the result.

?? 100% natural --- news://freenews.netfront.net/ - complaints: news@netfront.net ---

Vote

Fred Abse 13 years ago

True, but it's conventional the other way. Probably because of the way the formal derivation has been taught.

"For a successful technology, reality must take precedence over public relations, for nature cannot be fooled." (Richard Feynman)

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required