https://bugs.freedesktop.org/show_bug.cgi?id=78929
Ewald Anderl <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #2 from Ewald Anderl <[email protected]> --- 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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
