Ubuntu
libreoffice package

  1. Bug #1263326
  2. Comment #6

Comment 6 for bug 1263326

Revision history for this message
Ray DeCampo (rdecampo) wrote : Re: #VALUE doesn't propagate correctly subtracting text from numbers

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".