ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

SetValue with empty string produce zero value in cell #1565

Open joselmm opened 2 months ago

joselmm commented 2 months ago

This issue is unique.

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. Video_1714387721

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