Bug 54441 - MIN function not working properly
Summary: MIN function not working properly
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-03 13:55 UTC by martin.tobias
Modified: 2013-12-12 16:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
ods file (13.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-09-06 08:27 UTC, martin.tobias
Details

Note You need to log in before you can comment on or make changes to this bug.
Description martin.tobias 2012-09-03 13:55:09 UTC
=MIN(1.03,H15)shows 1.03 when H15 is 1.0 and -2

have tried with =min(H15,1.03) and same results

seems to work correctly with on some other lines of same sheet, actually this is part of following formula

=IF(B11="icl pen",IF(F11=4,4*ROUND(K10*0.25*MIN(H11,1.03)+0.0075,2),K10),K10)
Comment 1 Regina Henschel 2012-09-05 21:10:13 UTC
I cannot confirm it.

Please attach a document, that shows the error.
Which local do you use?
Which language has the spreadsheet?
What settings do you use in Tools > Options > LibreOffice Calc > Formula, sections Formula syntax and Separators?
Comment 2 martin.tobias 2012-09-06 08:27:01 UTC
Created attachment 66713 [details]
ods file
Comment 3 Regina Henschel 2012-09-06 15:37:08 UTC
I still cannot see any error.

What cell is wrong?

What value do you see in that cell?

What value do you expect in that cell? Calculate it here, manually, step-by-step.
Comment 4 martin.tobias 2012-09-06 16:10:05 UTC
Sorry, I have now realised a mistake that I made

I was moving a MS Works DB to ODS via csv, and had to interpret the formulae loghand, since I have found no way of copying formulae between these unlike systems

Sorry for any inconvenience caused
Comment 5 Regina Henschel 2012-09-06 17:17:46 UTC
So closing.