Speadsheet CELL("CONTENTS" function no longer works?

Discussion of the "Documents" module
Post Reply
yoasty
Posts: 5
Joined: Tue Apr 18, 2017 1:59 pm

Speadsheet CELL("CONTENTS" function no longer works?

Post by yoasty » Wed Mar 06, 2019 2:00 pm

I am not sure why, but I think the CELL function has just disappeared. One of my sheets use it, but I had not opened it for a while.


Is it deprecated? Removed? Functionality changed?

Thanks,
Y.

Kate
Posts: 200
Joined: Mon Feb 09, 2015 11:17 am

Re: Speadsheet CELL("CONTENTS" function no longer works?

Post by Kate » Mon Mar 11, 2019 1:36 pm

Hello,

What ONLYOFFICE solution you are using?

Please, attach a screenshot of your problem

yoasty
Posts: 5
Joined: Tue Apr 18, 2017 1:59 pm

Re: Speadsheet CELL("CONTENTS" function no longer works?

Post by yoasty » Tue Mar 19, 2019 3:18 pm

I have attached my example file. It works fine in (G Suite, MS-Office-online and offline, libreoffice, zoho) and until recently Onlyoffice online and offline.
I always try to keep my formulae in formats that work in all.
The onlyoffice one stopped working but I did not open it for about a year, so I do not really know when.

The sheet can basically transpose some rows and columns. You feed it the coordinates of the top-left column and it will transpose from there if you copy the cells down.
The basic use allows creating a table for a database with the possible answers in specified columns.

I shared it through this link. https://personal.onlyoffice.com/product ... 4MTQ2NjMi0

I think it is easiest to import it in G Suite, Libreoffice or MSO to compare it.
Thanks,
Y.

yoasty
Posts: 5
Joined: Tue Apr 18, 2017 1:59 pm

Re: Speadsheet CELL("CONTENTS" function no longer works?

Post by yoasty » Thu Apr 04, 2019 6:24 pm

Not spotted?

Post Reply