fdo#35539: Don't evaluate error cells as values during filtering.

E.g., if filtering for cells < 5, we should skip error cells.  Previously,
error cells are unintentionally treated as having a numeric value of 0.

1 files changed, 6 insertions, 0 deletions

diff --git a/sc/source/core/data/table3.cxx b/sc/source/core/data/table3.cxx
index ffd5d6f390d8..b0d261f15e17 100644
--- a/sc/source/core/data/table3.cxx
+++ b/sc/source/core/data/table3.cxx
@@ -1157,7 +1157,13 @@ public:
             return false;
 
         if (pCell)
+        {
+            if (pCell->GetErrorCode())
+                // Error values are compared as string.
+                return false;
+
             return pCell->HasValueData();
+        }
 
         return mrTab.HasValueData(nCol, nRow);
     }