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: 3.5.3 release
Hardware: x86 (IA32) Linux (All)
: medium critical
Assignee: Not Assigned
QA Contact:
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:
i915 platform:
i915 features:

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

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.