Issue 24121 - Error in operation on cell...
Summary: Error in operation on cell...
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P1 (highest) Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-05 20:50 UTC by josanabr
Modified: 2004-02-11 14:35 UTC (History)
2 users (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 josanabr 2004-01-05 20:50:57 UTC 
Greetings,

i'm an user of spreadsheet in it i keep the qualifications of my students. I got
a problem when i put this formula in a cell (e10):

=(b10+c10)/2*,75+d10*,25

the values in:
b10 = 5
c10 = 4,9
d10 = 5

the result that i got is: 4,94642

but, in the same computer using kcalc the result is: 4.9625. This difference is
important when i have to round up with 4.94 is aprox 4.9, with 4.96 is aprox 5.

Thanks for your attention.
Comment 1 lcn 2004-01-05 21:47:56 UTC 
No problem on OOo 1.1.0 on French win2k SP4.

What distro of linux do you use ?
Did you tested on an other computer with Linux ?
Do you mix comma/dot as decimal separator ?
Comment 2 askoning 2004-01-06 09:42:42 UTC 
Cannot reproduce on OOo 1.1.1a / Redhat 9.
Decimal commas yield errors, with decimal points I get the correct answer.

Can you attach a sample document with the error?
Comment 3 askoning 2004-01-06 09:43:36 UTC 
Added myself to CC
Comment 4 frank 2004-01-09 15:52:24 UTC 
Hi,

I'm sorry to tell you that I also can't reproduce the described behaviour.

I've checked it on Sun's Java Desktop System (Linux based on SUSE 8.2) with OOo
1.1.0 .

Have you compiled the Office suite by yourself, maybe on an gentoo Linux system
? This sounds like problems with compiler flags for optimizations.

Frank
Comment 5 flibby05 2004-02-10 16:39:53 UTC 
result here with OOo1.1.1b official linux from Sun: 4,96
-> WFM
Comment 6 frank 2004-02-11 14:35:22 UTC 
Hi,

as noone can reproduce this behaviour and the document asked for never arived,
I've to assume this was an user error and this Issue can be closed.

So I do it.

Frank
Comment 7 frank 2004-02-11 14:35:40 UTC 
closed wfm