Further research reveals the issue is with formatting, in particular borders, affecting the value of cells. I will attach a new spreadsheet demonstrating the issue. I have also filed a bug at LibreOffice:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 Steps to reproduce: See attached spreadsheet (bug-format-affects-value.ods). The first line has no formatting and behaves as expected. The second line has a border on cell B2 and the value of that cell is affected. Current behavior: Cell C2 displays the value "Failed". If the value of cell B2 is copied and pasted as text the value pasted is "foobar ". Expected behavior: Cell C2 displays the value "Passed" like the cell C1. If the value of cell B2 is copied and pasted as text the value pasted is "foobar". ** Bug watch added: LibreOffice Bugzilla #72969 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 ** Attachment added: "Simplified example spreadsheet demonstrating the issue" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: #VALUE doesn't propagate correctly subtracting text from numbers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs