Tested with LO 4.3.2.2, win7. Steps from comment 4, closing as worksforme because no Err:XXX appear. Tested with .ods, .xlsx and .xls.
-- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org 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: Invalid Status in “libreoffice” package in Ubuntu: Confirmed 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 : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
