← Back to team overview

desktop-packages team mailing list archive

[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used

 

Launchpad has imported 6 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=34267.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-02-14T18:52:25+00:00 The-inf wrote:

I've received file, made in MS Office 2003 (original.xls in attachment).
When I'm opening it in MS Office 2007 or OpenOffice.org 3.0.0 it works fine (msoffice2007.jpg)
In LibreOffice (3.3 release and 3.3.1 rc1):
When I'm opening it without updating links, in sheet "взвеш дистрибуция" I see Err:504 (original_504.jpg)
When I'm opening it with updating links I see Err:502 (original_502.jpg)
I've tried to re-save this file in .xlsx (saved_as_xlsx.xlsx) and open it in LibreOffice and get an Err:509 (saved_as_xlsx_509.jpg)

Sorry for Russian in spreadsheet and screenshots.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/5

------------------------------------------------------------------------
On 2011-02-14T19:13:53+00:00 The-inf wrote:

attachment is 5.51mb, so uploaded it to rapidshare
http://rapidshare.com/files/447934714/archive.zip

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/6

------------------------------------------------------------------------
On 2011-02-16T20:49:29+00:00 Iamtester8 wrote:

Reproduced with LO 3.3 RC4 Ubuntu 10.04 x86 except not error 509 but
freezing on saved_as_xlsx.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/7

------------------------------------------------------------------------
On 2011-03-11T17:43:58+00:00 Paulo de Souza Lima wrote:

That does not happens only with MsOffice files. That happens with any
formula which tries to link an external spreadsheet. That happens also
in Ubuntu Linux (32bit/64bit), and it was reported before (one year ago)
at https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/512413.

The issue has not been treated yet, at least in LibreOffice 3.3.1.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/8

------------------------------------------------------------------------
On 2011-03-11T17:51:49+00:00 Paulo de Souza Lima wrote:

(In reply to comment #3)
> That does not happens only with MsOffice files. That happens with any formula
> which tries to link an external spreadsheet. That happens also in Ubuntu Linux
> (32bit/64bit), and it was reported before (one year ago) at
> https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/512413.
> 
> The issue has not been treated yet, at least in LibreOffice 3.3.1.

Steps to reproduce the error:
1 - create an empty spreadsheet called teste.ods and save it.
2 - create another spreadsheet called test1.ods and save it in the same folder as teste.ods.
3 - Place the following formula to any cell in test1.ods: =IF('file:///[path_to_the_folder]/teste.ods'#$Planilha1.A9=C9;'file:///[path_to_the_folder]/teste.ods'#$Planilha1.B9;15)
4 - Save test1.ods.

Even if you mark all cells in both spreadsheets as numeric format, the
error still happens.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/9

------------------------------------------------------------------------
On 2011-12-23T19:47:47+00:00 Björn Michaelsen wrote:

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org
/RFC-Operation-Spamzilla-tp3607474p3607474.html

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/512413/comments/11


** Changed in: df-libreoffice
       Status: Confirmed => Incomplete

-- 
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:
  New
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