[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Beluga changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #7 from Beluga --- Set to NEEDINFO because of comment 5. Ewald: change to RESOLVED WORKSFORME, if it's ok for you. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.documentfoundation.org/show_bug.cgi?id=78929 LeMoyne Castle changed: What|Removed |Added CC||olig...@gmail.com --- Comment #8 from LeMoyne Castle --- *** Bug 82610 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.documentfoundation.org/show_bug.cgi?id=78929 Jacques Guilleron changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #9 from Jacques Guilleron --- Set the Status to WORKSFORME. Jacques -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.documentfoundation.org/show_bug.cgi?id=78929 LeMoyne Castle changed: What|Removed |Added Status|RESOLVED|NEW Resolution|WORKSFORME |--- --- Comment #10 from LeMoyne Castle --- Setting back to NEW because SetFormula() and Formula property should work. expected: setFormula should work for the functions from the 'built-in' Analysis Add-In the same way the native calc functions work. actual: calc 'built-in' Analysis Add-In functions placed on sheet in Basic with oCall.setFormula() require modification in calc ui in order to compile and work correctly. So far, setFormula has failed for *every* Analysis AddIn function I have tried (see dup Bug#82610). Additionally, localization or special syntax may be required to get some calc functions to work in setFormula (even native funcs? -- h/t Jacques Guilleron). - It is tempting to go with resolved+workaround because oCell.FormulaLocal = "dec2hex(A1)" does work. However, I'm not sure FormulaLocal is in the published API (maybe I just didn't find it). Besides, setFormula() and Formula = should simply work without the user needing to edit the cell in calc. Additionally, want to make sure can access other functions that should(?) be available in calc: e.g. Basic library.module.functions that are both placed on sheet and called from sheet through the scripting interface. - Thanks Kaya for the workaround (use FormulaLocal) and thanks to Ewald for the multi-page initial report, and again, a tip of the hat to Jacques Guilleron. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.documentfoundation.org/show_bug.cgi?id=78929 LeMoyne Castle changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=82 ||610 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.documentfoundation.org/show_bug.cgi?id=78929 --- Comment #11 from tommy27 --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Ewald Anderl changed: What|Removed |Added Severity|normal |major CC||ecand...@hotmail.com -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Joel Madero changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||jmadero@gmail.com Ever confirmed|0 |1 --- Comment #1 from Joel Madero --- Please provide much simpler explanation. While we appreciate the extensive documentation - we have hundreds and hundreds of bugs to go through and having to read 4 pages of explanation is just too time consuming. Please just write a simple set of instructions (on the bug report itself) and attach the simplest test case you possibly can. Also, is this a regression or a new problem? Marking as NEEDINFO - once you provide much simpler steps and a much simpler test case, mark the bug as UNCONFIRMED and we'll try to confirm. Thanks for understanding - we truly to appreciate the effort you put into your explanation, just our volunteer teams are stretched much to thin to dedicate that much time to just reading about a single bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 --- Comment #4 from Kaya Uluer --- I confirm that I faced with the same problem in Libreoffice 4.2.4.2 Build ID: 420m0(Build:2) I try to set a formula with the following line; oCell.SetFormula("=HYPERLINK(sheet1.A1,""Sheet1"")") than, the result is Err:508 But if I edit the formula with spreadsheet formula bar without any changes (just add a space character and delete it again and press enter) than, the formula is working good without any error messages -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Jacques Guilleron changed: What|Removed |Added CC||guillero...@aol.com --- Comment #5 from Jacques Guilleron --- Hello Ewald, I change coma into formula with semicolon and it seems that works. LO 4.2.7.0.0+ Build ID: 92216be6ce13990b8ea6b6264c656d2bc1746401 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-07-14_16:21:42 Windows 7 Home Premium. Can you try it too? Jacques -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 --- Comment #6 from Kaya Uluer --- I tried FormulaLocal property instead of SetFormula method and it is working now. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Ewald Anderl changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #2 from Ewald Anderl --- Below is an updated bug description along the lines that you requested. I have also answered the questions that you had in your comment. Please let me know if this meets your needs. I do not know of a way to modify the original bug description so I have added it here: Problem description: The “setFormula()” method in Calc appears to be broken. It will work for very simple formulas (e.g. “= true”) but displays an “Err:508” in the cell for even slightly more complex formulas ( e.g. “=and(a1,b1)” ). The problem occurs in both Linux and Windows environments. Steps to reproduce: 1. In LibreOffice, open Tools --> Macros --> Organize Macros --> pick any module to edit 2. Type (or cut/paste) the following program in to the empty “Sub” of your choice (Main will do) Dim oDoc'new Calc doc for this test Dim oSheet'points to first sheet oDoc = StarDesktop.loadComponentFromURL( "private:factory/scalc", "_blank", 0, Array() ) oSheet = oDoc.getSheets().getByIndex(0) oSheet.getCellByPosition(0, 0).setFormula("= true")'Works oSheet.getCellByPosition(1, 0).setFormula("= true")'Works oSheet.getCellByPosition(2, 0).setFormula("= and(a1,b1)")'Err:508 3. Run this Macro Current behavior: Cell C3 displays “Err:508” Expected behavior: Cell C3 should display “TRUE” Operating System: All Version: 4.2.3.3 release Answers to questions: I can not personally confirm whether this is regression or a new problem. I strongly believe that this is regression since I was following code examples in documentation that appear to have worked for some people at some point. I am new to LibreOffice starting with version 4.2.3.3. One additional note. I would suggest that this is far from a simple bug. It has far broader scope, is more extensive, and creates far more damage in code than the simple exmaple that I have provided above would indicate. Even more so the case before it was narrowed down and cornered as described in the document. I have updated the document to include the simple bug report / description at the front along with a button that will run through the rest of the test cases. I will upload this as well. Sorry for the confusion that my original report may have caused, I am new to LibreOffice and its bug reporting process. My intent was to help the developers identify the complete problem quickly and provide help in narrowing down the source. Please let me know if you need additional information. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 78929] Macros: Calc setFormula() does not appear to be working
https://bugs.freedesktop.org/show_bug.cgi?id=78929 Ewald Anderl changed: What|Removed |Added Attachment #99362|0 |1 is obsolete|| --- Comment #3 from Ewald Anderl --- Created attachment 99423 --> https://bugs.freedesktop.org/attachment.cgi?id=99423&action=edit Updatd with overview and single button to run remaining test cases -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs