[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: libreoffice (Ubuntu) Status: Confirmed => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: df-libreoffice Status: Confirmed => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
Sorry, I made a mistake, this is not the right place for this issue! -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
I'm able to reproduce this bug with SUMIF() and LibreOffice 4.0.2.2 installed by default with Ubuntu 13.04 :( All my previous sheets were done with the default LibreOffice version of Ubuntu 12.04 and a lot have external sheets linked :( Is there a workaround? Regards, Jacques. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: libreoffice (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: libreoffice (Ubuntu) Status: Incomplete => New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: df-libreoffice Status: Incomplete => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
Lucio, regarding your comments https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/512413/comments/13 : >"The steps to reproduce are the same described in my first mail in this thread." Unfortunately, the steps provided are not click for click, as advised in https://wiki.ubuntu.com/LibreOfficeBugWrangling , and remain as ambiguous as when you first wrote them. You are welcome to provided click for click instructions, so this may be marked Triaged as soon as possible. Thank you for your understanding. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
I can confirm that the bug is still present in LibreOffice 3.5.4.2 under Ubuntu 10.04 AMD64. The function results in the "Err:504" error. The steps to reproduce are the same described in my first mail in this thread. Extensions installed: - American English spell checking - Dizionario ortografico italiano - Fornitore di script per Python - PDF importer -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
lucio, thank you for reporting this bug and helping make Ubuntu better. Please answer these questions: * Is this still reproducible? * If so, what specific steps should we take to recreate this bug? * Do you have any extensions installed? If so, which? As well, according to this report, you are not using the most recent version of LibreOffice in a supported Ubuntu release. Please upgrade to the most recent version and let us know if you are still having this issue. Thank you for your understanding. Helpful Bug Reporting Link: https://help.ubuntu.com/community/ReportingBugs#Bug_Reporting_Etiquette ** Changed in: libreoffice (Ubuntu) Status: New => Incomplete ** Tags added: jaunty lucid regression-potential -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: openoffice.org (Ubuntu) Status: Confirmed => Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 512413] Re: [Upstream] Calc database functions gives Err:504 when external sheet is used
** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/512413 Title: [Upstream] Calc database functions gives Err:504 when external sheet is used To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/512413/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs