Bug 86409 - Coercion of empty cells
Summary: Coercion of empty cells
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-17 19:45 UTC by Domenico Somma
Modified: 2014-11-18 09:19 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 Domenico Somma 2014-11-17 19:45:59 UTC 
I'd like a clarification of this comportment:

In this example 	
	x	mean(x)	f(x)	mean f(x)
A	2		6	
B	2	2	6	6
C	2		6	

mean(x) is the arithmetic mean of A,B and C value of x
f(x) is A,B or C *3 and
mean f(x) is the arithmetic mean of A,B and C value of f(x)

If B value of x is 0 correctly:
	x	mean(x)	f(x)	mean f(x)
A	2		6	
B	0	1,33	0	4
C	2		6	

If I remove B value of x I expected this:
	x	mean(x)	f(x)	mean f(x)
A	2		6	
B		2		6
C	2		6	

But happens this:
	x	mean(x)	f(x)	mean f(x)
A	2		6	
B		2	0	4
C	2		6	

Is it a bug? Or is it expected?
Comment 1 Urmas 2014-11-18 07:07:27 UTC 
Of course it is not a bug. Functions of empty cells give numbers, not empty cells.
Use IF() if you need this behavior.
Comment 2 Domenico Somma 2014-11-18 09:19:51 UTC 
Thanks!!!