SetValue with empty string produce zero value in cell

[joselmm]

This issue is unique.

• I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

version 8.0.1.31 (x64 exe)

Expected Behavior

I expect the cell value to be "" (without any value) after executing the macro code

Actual Behavior

The cell value is 0 after executing the code.

Reproduction Steps

Create a macro with the code:

(function() { var range = Api.GetActiveSheet().GetSelection(); range.SetValue(""); })();

Additional information

The same problem happens in docs space, i found this issue here too: https://forum.onlyoffice.com/t/setvalue-with-empty-string-produce-zero-value-in-cell/5224