Bug 118623 - EDITING Formula not working with empty cell
Summary: EDITING Formula not working with empty cell
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-08 16:31 UTC by remi
Modified: 2018-07-08 16:43 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 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...