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

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED
            Summary|EDITING: IF function not    |EDITING: speculative:
                   |evaluating correctly with   |trailing spaces appended to
                   |cell borders in .ods        |result with cell borders

--- Comment #11 from Eike Rathke <[email protected]> ---
Cell B2 has been stored to file with the result office:string-value="foobar   "
i.e. with trailing spaces, which also on Paste Special are preserved, hence the
condition B2="foobar" does not match. This has nothing to do with the IF
function. Unless B2 is recalculated (F9 on cell, Shift+Ctrl+F9 or recalculate
after load through Tools Options) to fix the result value, there's nothing we
can do.

If this was a specific bug in an earlier version (I have no idea how this could
be even related to cell borders) it got fixed in the mean time. Closing.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to