[Libreoffice-bugs] [Bug 89216] Annoying feature: empty cell treated as zero within range/ array

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=89216

--- Comment #12 from Teraslilja <m-Matti-a.Lehtonen at IKI.Fi> ---
(In reply to Xisco Faulí from comment #11)
> Hello Teraslilja,
> Thanks for the patch.
> Could you please submit the patch to gerrit as described here:
> https://wiki.documentfoundation.org/Development/gerrit/SubmitPatch?

The patch(es) above won't work any more. The object passing a cell range to
basic macro has been changed. So I have written a new patch that I will submit
later this week.

diff --git a/sc/source/core/tool/interpr4.cxx
b/sc/source/core/tool/interpr4.cxx
index b2dc0adee55e..518a1475a5f2 100644
--- a/sc/source/core/tool/interpr4.cxx
+++ b/sc/source/core/tool/interpr4.cxx
@@ -3544,11 +3545,12 @@ bool ScInterpreter::SetSbxVariable( SbxVariable* pVar,
const ScAddress& rPos )
                 }
                 break;
             default :
-                pVar->PutDouble( 0.0 );
+                pVar->PutEmpty();
         }
     }
     else
-        pVar->PutDouble( 0.0 );
+        pVar->PutEmpty();
+
     return bOk;
 }

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171002/025ac109/attachment.html>