Issue 15140 - rounding errors in imaginary (complex) number add-in functions
Summary: rounding errors in imaginary (complex) number add-in functions
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-06-01 05:35 UTC by tristanb
Modified: 2013-08-07 15:12 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 tristanb 2003-06-01 05:35:21 UTC 
hi,
the add-in functions that handle imaginary numbers have some rounding problems.

try:
=IMPOWER("5+3i";3) it returns 10.0000000000001+198i

also:
=IMEXP(COMPLEX(0;PI())) should equal -1, but has an imaginary compentent of 
about 3.2*10^-15.
Comment 1 frank 2003-06-02 10:22:36 UTC 
Hi Daniel,

one for the Addin site.

Frank
Comment 2 daniel.rentz 2003-06-02 11:29:38 UTC 
By the way: The same happens in Excel...
Setting target, started.
Comment 3 Unknown 2003-07-18 20:17:18 UTC 
The above is due to the inexact nature of floating point numbers. It's
a common problem.