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 Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/512413
Title:
[Upstream] Calc database functions gives Err:504 when external sheet
is used
Status in LibreOffice Productivity Suite:
Incomplete
Status in “libreoffice” package in Ubuntu:
Incomplete
Status in “openoffice.org” package in Ubuntu:
Won't Fix
Bug description:
Binary package hint: openoffice.org
Openoffice 3.1.1, Karmic AMD64
When using database functions (eg DB.MEDIA -translated- DB. MEAN) i
gest an error if I refer to data contained in external sheet.
Steps to reproduce:
1) create "prova1" sheet with source data (attached)
2) create "prova2" sheet with DB.MEDIA function (attached)
DB.MEDIA function
"=DB.MEDIA('file:///home/lucio/Comodo/prova1.ods'#$Foglio1.D1:E5,'file:///home/lucio/Comodo/prova1.ods'#$Foglio1.D1,'file:///home/lucio/Comodo/prova1.ods'#$Foglio1.G2:G3)"
returns Err:504
when running in "prova1" DB.MEDIA funtion works
when running a non-DB function (eg. SUM) no problems appear
ProblemType: Bug
Architecture: amd64
Date: Mon Jan 25 18:15:16 2010
DistroRelease: Ubuntu 9.10
Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified:
var/lib/openoffice/basis3.1/program/services.rdb]
ProcEnviron:
LANGUAGE=it_IT.UTF-8
PATH=(custom, no user)
LANG=it_IT.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-18.55-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-18-generic x86_64
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
