resolved fdo#62250 absent value cell values are not NaN, set to 0.0

Change-Id: I41459d72adbaa8f6c0c7c22447f6eba5eb8be3e1

1 files changed, 6 insertions, 0 deletions

diff --git a/sc/source/filter/xml/xmlcelli.cxx b/sc/source/filter/xml/xmlcelli.cxx
index 5a2e3aa174f0..e2ac747035eb 100644
--- a/sc/source/filter/xml/xmlcelli.cxx
+++ b/sc/source/filter/xml/xmlcelli.cxx
@@ -1157,6 +1157,12 @@ void ScXMLTableRowCellContext::PutValueCell( const ScAddress& rCurrentPos )
     }
     else  //regular value cell
     {
+        // fdo#62250 absent values are not NaN, set to 0.0
+        // PutValueCell() is called only for a known cell value type,
+        // bIsEmpty==false in all these cases, no sense to check it here.
+        if (::rtl::math::isNan( fValue))
+            fValue = 0.0;
+
         // #i62435# Initialize the value cell's script type if the default
         // style's number format is latin-only. If the cell uses a different
         // format, the script type will be reset when the style is applied.