Issue 85533 - ROUNDDOWN(ref) returns 0 for ref=-1
Summary: ROUNDDOWN(ref) returns 0 for ref=-1
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2008-01-23 21:32 UTC by villeroy
Modified: 2008-01-23 23:06 UTC (History)
2 users (show)

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

Attachments
Rounding tests (15.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-01-23 22:31 UTC, villeroy 		no flags Details
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 villeroy 2008-01-23 21:32:36 UTC 
ROUNDDOWN(ref) returns 0 for ref=-1
whereas
ROUNDDOWN(-1) returns -1
Comment 1 Regina Henschel 2008-01-23 21:55:29 UTC 
I cannot reproduce it.
Please show the cell in high precision to make sure, that the number is really
-1 and not -0,99999 for example.
Please attach a spreadsheets, which shows this error.
Comment 2 villeroy 2008-01-23 22:01:41 UTC 
Type "-1" into a cell and round it down. Then do the same with a constant
argument =ROUNDDOWN(-1). Any other positive or negative integer behaves
consistently.
Comment 3 Regina Henschel 2008-01-23 22:23:54 UTC 
I cannot reproduce it, OOo2.3.1 and OOH680_m4 on WinXP.
Which OS do you use? Do you use an original OOo?
Comment 4 villeroy 2008-01-23 22:29:27 UTC 
I use Sun's 2.3.1 with Ubuntu 6.06. I'll attach a file.
Comment 5 villeroy 2008-01-23 22:31:15 UTC 
Created attachment 51125 [details]
Rounding tests
Comment 6 villeroy 2008-01-23 22:52:14 UTC 
After reloading the document, the result is calculated correctly. I can not
reproduce the error any more, but I swear it has been there.
Comment 7 Regina Henschel 2008-01-23 23:05:51 UTC 
So I will close it for now. Feel free to reopen it, if you can give a way to
reproduce it. Please see issue 69749 in addition for problems with precision of
floating point numbers.
Comment 8 Regina Henschel 2008-01-23 23:06:32 UTC 
closing