Issue 94487

Summary:	Spreadsheet doesn't handle odd root's of negative numbers
Product:	Calc	Reporter:	chrisccoulson <chrisccoulson>
Component:	programming	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P4	CC:	issues, rb.henschel
Version:	OOo 2.4.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description chrisccoulson 2008-09-30 17:40:58 UTC

This was initially reported at
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345

Entering the following formula in to a spreadsheet cell results in a #VALUE error:

=(-8)^(1/3)

The correct (and expected) result is '-2'.

Comment 1 Regina Henschel 2008-09-30 18:12:57 UTC

It is not as simple as you think. Please see my comment in issue 37129.

*** This issue has been marked as a duplicate of 37129 ***

Comment 2 Regina Henschel 2008-09-30 18:13:37 UTC

closing duplicate