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.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/512413
Title:
[Upstream] Calc database functions gives Err:504 when external sheet
is used
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
