Spreadsheet function returning array

Docs
1

Do you want to: Ask a how-to question
For feature suggestions, describe the result you would like to achieve in detail.
For bug reports, provide the steps to reproduce and if possible a minimal demo of the problem.
Document Server version:
Type of installation of the Document Server (docker, deb/rpm, exe)
OS: osx
Browser version: chrome

Hello,

I am trying to make the spreadsheet function UNIQUE work by implementing the example provided here : UNIQUE Function - ONLYOFFICE

Unfortunately, only the first value is returned in the cell (as shown in the screenshot)

image
image818×615 32.2 KB

If someone can provide a hint on what I am doing wrong that would be much appreciated

thanks,
joost

2

Hello @grsjst
Sorry for the late reply.
In this scenario you should use array formula + hit Ctrl + Shift + Enter key combination.
I prepared short video with demonstration: Monosnap

Also you can find useful information here: Insert array formulas - ONLYOFFICE

3

Dear Alexandre,

Many thanks for your response and taking the time to produce a video demonstration.

I did use the ctrl-shift-enter combination (also the first time) and it rightly includes the brackets. However, the result (still) is incorrect I am afraid. I made a video of my own that I am happy to share (it seems i am unable to upload it here).

I am using a mac (os 12.2.1) on chrome (99.0.4844.83 (Official Build) (x86_64).

The onlyoffice suite runs on the OnlyOffice Cloud (onlyoffice.eu)

thanks,
Joost

4

Hello @grsjst
Please upload your video test to any external storage and provide us with a download link.

5

here you go: FileSender

6

Sorry, my advice wasn’t clear. Please check my test one more time. You should select a range of cells. There is no automatic display of function values in several cells in our editor. So, if one cell is selected, the first value is written into it only.

7

Thanks much Alexandre! I got it to work now.

Your instructions were clear in retrospect, i should have paid better attention. My apologies for that :slight_smile:

1 Like
8

So, the algorithm is

  • print the range
  • calculate manually how many unique values in that range
  • select this number of cells
  • CSE on UNIQUE()

Correct?

9

Hello @SergeiStPete
Yes, it’s correct. You have to select a range of cells where the result will be written and after that hit Ctrl+Shift+Enter when you specified the formula. As far as I can see, the recorded test is still available in this thread: Monosnap