Issue 87468 - Scientific notation with signed exponent in formulas broken.
Summary: Scientific notation with signed exponent in formulas broken.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: DEV300m4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
: 91315 95823 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-03-26 14:47 UTC by rolmol
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rolmol 2008-03-26 14:47:52 UTC 
When typing "1E-2" (minus quotation marks) in a cell it works as expected, 
however using the same code in an expression or equation is broken: "=1E-2" 
results in the error message:

OOo-dev Calc found an error in the formula entered.  Do you want to accept the 
correction proposed below? =E1-2

[Yes] yields the proposed correction, [No] results in #NAME?

Reproducible: Always (regardless of which *negative* number entered)
Steps to reproduce: Empty cell, type "=1E-2" without quotation marks
Expected result: "1E-2" to be interpreted as 0,01.
Comment 1 frank 2008-03-26 20:46:48 UTC 
Hi Thomas,

side effect of the simple calculation entry ?

frank
Comment 2 ooo 2008-03-27 13:46:58 UTC 
This is more a side effect due to changes to the formula compiler.
Comment 3 jumbo444 2008-06-14 13:19:31 UTC 
An easy workaround is to type "1e-02" instead of "1e-2". But it is totally user
unfriendly !
Comment 4 jumbo444 2008-06-14 14:11:13 UTC 
Corrected in OOo3DEVm14
Comment 5 ooo 2008-06-16 11:11:37 UTC 
No, it's not, still present in DEV300_m18. When 1e-2 was entered in a formula,
e.g. =1e-2, a message box pops up, attempting to "correct" the  formula to =E1-2
Comment 6 ooo 2008-06-27 16:55:32 UTC 
In cws calcfixes30:

sc/source/core/tool/compiler.cxx  1.79.46.1
Comment 7 ooo 2008-07-02 12:58:42 UTC 
Reassigning to QA for verification.
Comment 8 Regina Henschel 2008-07-02 21:10:51 UTC 
*** Issue 91315 has been marked as a duplicate of this issue. ***
Comment 9 oc 2008-07-03 15:11:53 UTC 
verified in internal build cws_calcfixes30
Comment 10 Regina Henschel 2008-11-05 19:47:32 UTC 
*** Issue 95823 has been marked as a duplicate of this issue. ***
Comment 11 thorsten.ziehm 2009-07-20 15:56:16 UTC 
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues