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 -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
