Bug 51254 - Wrong computation Using the MAX function in the formula =(B6+MAX(C6;D6))/2
Summary: Wrong computation Using the MAX function in the formula =(B6+MAX(C6;D6))/2
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: x86 (IA32) Linux (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-20 03:21 UTC by souidi
Modified: 2012-06-21 13:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
File embedding an example of Bug (15.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-20 03:21 UTC, souidi 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description souidi 2012-06-20 03:21:07 UTC 
Created attachment 63256 [details]
File embedding an example of Bug

Hi,
Using the MAX function in the formula =(B6+MAX(C6;D6))/2 it gives correct computation for some arrows but wrong for others. See attachement please.
Thank you very much for your help
Pr. Souidi
Comment 1 GerardF 2012-06-21 10:12:55 UTC 
Select B6:D22, then Ctrl+M (Clear formatting) and you will see many numbers are not numeric but string.
MAX ignores text.

This is not a bug.
Comment 2 Alberto Ferreira 2012-06-21 13:29:42 UTC 
Hi,

I thing that text should be convert before MAX ou any other function that use numbers.

Aferreira