Bug 51254

Summary:	Wrong computation Using the MAX function in the formula =(B6+MAX(C6;D6))/2
Product:	LibreOffice	Reporter:	souidi <emsouidi>
Component:	Libreoffice	Assignee:	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.