Further investigation reveals that the issue is that the cell D6 is incorrectly evaluated to the value " " instead of the value "". This can be verified by copying the cell D6 and pasting just the text into another cell. So perhaps it is related to the same issue that is causing the cells in the F column to change from "x" to "x " and then "x ".
-- 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