Issue 26697 - scientific number display although standard is selected
Summary: scientific number display although standard is selected
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1RC
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: falko.tesch
QA Contact: issues@sc
: 29081 (view as issue list)
Depends on:
Reported: 2004-03-18 20:43 UTC by norbert2
Modified: 2004-06-02 15:23 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

scientific_standard.sxc (5.05 KB, application/vnd.sun.xml.calc)
2004-03-18 20:43 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-03-18 20:43:06 UTC
Please have a look at the attached spreadsheet:

There, the right cell is = the left cell. Although the right cell has
standard-format, it is shown in scientific-mode!
Its not possible to have the right cell shown with standard format.

In Excel the right cell automatically is witched to scientific-mode when set
equal to the left cell. And so in Excel the right cell can be set back to
standard, what really displays the content standard.

Please fix this.
Comment 1 norbert2 2004-03-18 20:43:32 UTC
Created attachment 13920 [details]
Comment 2 frank 2004-03-19 10:54:39 UTC
Hi Norbert,

the prio was to high, I corrected this. Also this is not a bug but an Feature of
Calc. Default in this case is the format fitting best to the result of the
calculation. If you use scientific notification for the source cell normally the
best format to fit the result is scientific. So my opinion is to close this as

Falko, please give us your comment and decide how to proceed.

Comment 3 norbert2 2004-03-21 09:10:59 UTC
As I remember, Excel changes the format of the cell where the formula has been
entered. And this can be changed (back) by the user, if it is wanted.

This is, in my oppinion, much smarter than the way it is currently handeled by Calc.

Please adopt this behaviour for Calc!
Comment 4 norbert2 2004-03-22 07:26:47 UTC
I think you really can close this issue. Now I think the fact that Calc 
keeps "Standard" is better than Excel does. ;-) Sorry.

(Now I saw that the behaviour of Excel has the problem that changing the format 
of the source cell need to change the formula cell's format, too. So Calcs 
behaviour is better.)

So do NOT change this and please forget this issue.

I close this issue.
Comment 5 norbert2 2004-03-22 07:28:54 UTC
Sorry I can't close it.

Please close this (my) issue!
Comment 6 frank 2004-03-23 08:47:43 UTC
closing on request by submitter.

Comment 7 frank 2004-03-23 08:48:01 UTC
closed wontfix
Comment 8 frank 2004-06-02 15:23:23 UTC
*** Issue 29081 has been marked as a duplicate of this issue. ***