Bug 51254

Summary: Wrong computation Using the MAX function in the formula =(B6+MAX(C6;D6))/2
Product: LibreOffice Reporter: souidi <emsouidi>
Component: LibreofficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG QA Contact:
Severity: critical    
Priority: medium CC: acdrferreira, gerard.fargeot
Version: 3.5.3 release   
Hardware: x86 (IA32)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: File embedding an example of 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

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.