https://bugs.documentfoundation.org/show_bug.cgi?id=168673
--- Comment #7 from Mike Kaganski <[email protected]> --- (In reply to Dominik Stadler from comment #6) > Thanks for the discussion, in the reproducer, the reproducer was slightly > wrong, the updated content now comes out as > > Time-Formatted: > 0 =COUNTIFS($A$7:$A$11;"="&$A11) > 0 '=COUNTIFS($A$7:$A$12;"="&$A11) > > Decimal-Formatted: > 0 '=COUNTIFS($A$17:$A$21;"="&$A21) > 1 '=COUNTIFS($A$17:$A$22;"="&$A21) > > > Whereas processing in Excel results in "1" for all of them. I still see Decimal-Formatted: 1 '=COUNTIFS($A$17:$A$21;"="&$A21) 1 '=COUNTIFS($A$17:$A$22;"="&$A21) and that may be because when you copy the date from A11, and paste to A21, it keeps the exact value; but when it goes through save-and-reload, it is rounded to 0,00100081018518519. > Having an "equals" fail due to precision is strange, are there two different > ways of transforming the data to string before comparing? Not quite understand the question. Which two ways are meant? We only discussed one way of transforming the data to string. -- You are receiving this mail because: You are the assignee for the bug.
