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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from PremPa <prempa at gmail.com> ---
(In reply to Xisco Faulí from comment #1)
> Hello PremPa,
> thanks for reporting this issue.
> Could you please explain the steps to reproduce the issue using the attached
> file ?

Sure.

If I open the attached file I see the cell R2 with no blank spaces at the
beginnig.
Now if I press F9 the cell is recalculated and the first 5 spaces related to
the formula LEFT(M3&"     ";5) appears

If I save in ods everything works correctly.

If you want to try in a new fil just type in A1

=LEFT(A2&"     ";5)&LEFT(B2&"     ";5)&LEFT(C2&"     ";5)

leave A2 empty, type something in B2 and in C2, save in xlsx and reopen: the
first five spaces doesen't are there
Press F9 and they will appear.

-- 
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/1607b0fa/attachment.htm>