https://bugs.freedesktop.org/show_bug.cgi?id=78929

          Priority: medium
            Bug ID: 78929
          Assignee: [email protected]
           Summary: Macros: Calc setFormula() does not appear to be
                    working
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.2.3.3 release
         Component: BASIC
           Product: LibreOffice

Created attachment 99362
  --> https://bugs.freedesktop.org/attachment.cgi?id=99362&action=edit
Document with test cases (code) to reproduce the problem, screen shots to
clarigy the discussion, and further details regarding the behavior and the
impact.

Problem description:

The “setFormula()” method in Calc appears to be broken. It will work for very
simple formulas (e.g. “= 1”) but displays an “Err:508” in the cell for even
slightly more complex formulas ( e.g. “=and(c2,e2)” ). I have tested this in
both Linux and Windows environments and the problem occurs in both.

Steps to reproduce:
  -- oCell.setFormula("= and(c2,e2)") will create an "Err:508" message
  -- see attached included document for additional information and examples.

Current behavior:
   -- Using the setFormula() method will set the formula but in MOST cases will
leave the cell showing a "Err:508" message. This can then lead to other very
bad behavior. See the attached document for a further description and screen
shots.

Expected behavior:
Working setFormula().


Operating System: All
Version: 4.2.3.3 release

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

Reply via email to