Bug 118623

Summary:	EDITING Formula not working with empty cell
Product:	LibreOffice	Reporter:	remi
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal
Priority:	medium
Version:	6.0.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description remi 2018-07-08 16:31:39 UTC

Description:
If an empty cell is present in the range of a formula (for example MAX) the formula take into account only the first cell.

Steps to Reproduce:
1. Create a calc table
2. Add 1 in B1
3. Add 2 in C2
4. Write formula =MAX(B1;Z1) in A1

Actual Results:
Result of formula in A1 is 1

Expected Results:
Result of formula in A1 should be 2


Reproducible: Always


User Profile Reset: No



Additional Info:

Comment 1 himajin100000 2018-07-08 16:41:28 UTC

WRONG:
=MAX(B1;Z1)

CORRECT: 
=MAX(B1;Z2)

and the correct formula returns 2

Comment 2 remi 2018-07-08 16:43:24 UTC

Sorry not an issue, the formula need a : not a ; ...

I thought that was working before but apparently no...