← Back to team overview

desktop-packages team mailing list archive

[Bug 512413]

 

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