diff -up old/dociter.cxx new/dociter.cxx
--- old/dociter.cxx	2008-01-31 23:34:22.000000000 +0800
+++ new/dociter.cxx	2008-02-22 14:42:22.000000000 +0800
@@ -392,6 +392,13 @@ BOOL ScValueIterator::GetThis(double& rV
 								bNumValid = FALSE;
 								return TRUE;							// gefunden
 							}
+                            else if ( bTextAsZero && !((ScFormulaCell*)pCell)->IsValue() )
+                            {
+                                rValue = 0.0;
+                                nRow--;
+                                bNumValid = FALSE;
+                                return TRUE;
+                            }
 						}
 					}
 					break;