[Libreoffice-commits] .: Branch 'libreoffice-3-5' - sc/source

[Kohei Yoshida]

 sc/source/core/data/table3.cxx |    6 ++++++
 1 file changed, 6 insertions(+)

New commits:
commit 9b131261507efd93a3eb17c0109cdab6972248d0
Author: Kohei Yoshida <kohei.yoshida at suse.com>
Date:   Mon Dec 12 14:18:59 2011 -0500

    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.

diff --git a/sc/source/core/data/table3.cxx b/sc/source/core/data/table3.cxx
index ffd5d6f..b0d261f 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);
     }