[Libreoffice-bugs] [Bug 142905] New: LEFT() and empty space at the beginning in .xlsx

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142905

            Bug ID: 142905
           Summary: LEFT() and empty space at the beginning in .xlsx
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: prempa at gmail.com

Created attachment 172963
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172963&action=edit
First LEFT may refers to a blank cell

If LEFT() formula inserts spaces at the beginning of the string (because the
cell it refers to is blank) and is saved as .xlsx, when you reopne the file,
the string ignores spaces until it is recalculated.

By copying and pasting before the recalculation the leading spaces are missing.

Saving in .ods the formula works correctly and the copy and paste works as
expected.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210617/0bced119/attachment.htm>