Comment 15 for bug 512413

Revision history for this message
Lucio (lumatemp-nospam) wrote :

I actually cannot figure out where is the ambiguity. The database to work on has to be provided in an attached worksheet as I did with "Prova1.ods". The following step is to create the DB.MEDIA function is a separate file as I did with "Prova2.ods". The DB.MEDIA (DAVERAGE) function is:

=DB.MEDIA('PATH_TO/prova1.ods'#$Foglio1.D1:E5;'PATH_TO/prova1.ods'#$Foglio1.D1;'PATH_TO/prova1.ods'#$Foglio1.G2:G3)

considering the syntax of the function DB.MEDIA (DAVERAGE):

DAVERAGE(Database; DatabaseField; SearchCriteria)

Database consists into

a b
1 1
2 1
3 1
100 0

in Prova1 sheet

DatabaseField consists into D1 in Prova1 sheet

SearchCriteria consists into

b
1

in Prova1 sheet

I am not able to be more specific.