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

            Bug ID: 86999
           Summary: Calc add a "0" in the cell reference of a LEFT() or
                    RIGHT() function
           Product: LibreOffice
           Version: 4.2.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 110449
  --> https://bugs.freedesktop.org/attachment.cgi?id=110449&action=edit
Simple Calc sheet with the formula

when inserting a new LEFT() function, Calc insert the "0" character at the cell
formula and the function return the Err:509

For example, I enter the formula "=LEFT(A2,2)", click on "Enter". The cell
containing the formula shows "Err:509" and if I select it, the formulat
contained is "=LEFT(A20,2)". Editing the formula does not helps.

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