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 attach
Ray DeCampo, thank you for your comments. I'm comparing the results to
Excel from a feature parity expectation perspective, so this is why my
expectations were different. However, LibreOffice has on a number of
occasions developed past Excel for the better (ex. making functions more
precise than eq
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
Christopher, the calculation in H6 of H5-D6 is protected by the IF()
function, ensuring that we do not use H5-D6 when D6 is "". In fact, the
cell has the proper value when other things are changed that should not
affect this bug. As I stated in my original description, this includes
ordering the