DocumentServer icon indicating copy to clipboard operation
DocumentServer copied to clipboard

Any formula referencing row or column with some calculations can't be saved without array

Open DenisKuplyakov opened this issue 8 months ago • 1 comments

This issue is unique.

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

Operating System

other (specify in description)

Version information

8.3.3.21 (snap)

Expected Behavior

  1. If I use formula =2:2 in cell C3 I will get value from C2.
  2. If I use formula =2:2+2 in cell C3 I will get value from C2 plus 2.
  3. If I use formula =B:B in cell C3 I will get value from B3.
  4. If I use formula =B:B+2 in cell C3 I will get value from B3 plus 2.

Actual Behavior

  1. If I use formula =2:2 in cell C3 I get value from C2.
  2. If I use formula =2:2+2 in cell C3 I get value from A2 plus 2, and formula is broadcasted to the left as array formula if I hit Enter instead of Ctrl+Shift+Enter.
  3. If I use formula =B:B in cell C3 I get value from B3.
  4. If I use formula =B:B+2 in cell C3 I get value from B1 plus 2, and OnlyOffice hangs if I hit Enter instead of Ctrl+Shift+Enter.

Reproduction Steps

See attached video.

https://github.com/user-attachments/assets/8af1ac32-b26f-45f9-a429-7c86e3e57077

Additional information

Operating System: Linux (snap)

DenisKuplyakov avatar Apr 17 '25 20:04 DenisKuplyakov

Hello @DenisKuplyakov,

I created bug 74215 for your problem. When some fixes will be done we'll text you here in this issue. Thank you for the report!

Problem can be reproduced in DocumentServer.

Dmitry-Kov avatar Apr 24 '25 11:04 Dmitry-Kov