GetUsedRange macro function return empty range [bug]

Desktop editors
1

Do you want to: Report a bug

  1. Fill in cells C3 and D4

  2. Run the macro
    Api.GetActiveSheet().GetUsedRange().Select();

  3. the range A1:D4 will be selected

  4. Delete the value in cell D4

  5. Run the macro

  6. The range A1:D4 will be selected instead of A1:C3

The expected behavior was similar to VBA function ActiveSheet.UsedRange - search for the last filled cell by columns and rows.

OS version: Win10 x64
App version: 8.1.1.27 (x64 exe)
Downloaded from: ONLYOFFICE website.

2

Hello @Rinzler

We will take closer look at this behavior. I’m keeping you posted about the results.

4

Thank you for reporting this issue. Bug was registered on this behavior, we are already working on it.

Sorry for inconvenience.