Issue 27000 - Bad calculation of -A1^2 (e.g. -4^2)
Summary: Bad calculation of -A1^2 (e.g. -4^2)
Status: CLOSED DUPLICATE of issue 24271
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: issues@www
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-26 14:54 UTC by oldium
Modified: 2004-03-29 09:08 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 oldium 2004-03-26 14:54:29 UTC 
I've found a bug, but this may be a feature. When you want to compute =-4^2 (or
anything: =-A1^2 for any number at the A1 cell), you get 16, which is
mathematically wrong (same result in MS Office). It is like -1*4^2 or 0-4^2,
which gives correct -16.
Comment 1 lcn 2004-03-27 01:55:06 UTC 
Duplicate of issue 24271.
... Exactly same value -4^2...  ^^
Comment 2 stx123 2004-03-27 08:52:38 UTC 
changing component to Spreadsheet
Comment 3 frank 2004-03-29 09:07:50 UTC 
closed double

*** This issue has been marked as a duplicate of 24271 ***
Comment 4 frank 2004-03-29 09:08:09 UTC 
closed double