https://bugs.documentfoundation.org/show_bug.cgi?id=168673
--- Comment #8 from Dominik Stadler <dominik.stad...@gmx.at> --- Yes, saving, editing or changing the precision sometimes affects this, although a simple safe-and-reload did not change it for me, adjusting precision of the cell-formats did. For time-format I did not find a way to make it work. With "two ways" I meant that the cell is compared with itself as part of COUNTIFS() and somehow this comparison ends up being "not equal", which indicates that the value is handled in two different ways, otherwise "precision" or "conversion to text" couldn't have an impact. -- You are receiving this mail because: You are the assignee for the bug.
