Pivot tables in spreadsheets

Discussion of the "Documents" module
Post Reply
Tatiana
Posts: 1
Joined: Thu Nov 09, 2017 7:24 am

Pivot tables in spreadsheets

Post by Tatiana » Tue Nov 21, 2017 7:55 am

I can not find Pivot tables in spreadsheets. Does ONLYOFFICE supports tables/pivots?

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

Re: Pivot tables in spreadsheets

Post by Kate » Wed Nov 29, 2017 1:25 pm

Dear Tatiana,

Using the version 5.0 of ONLYOFFICE Spreadsheet Editor you are able to open the pivot tables for viewing only.
We are planning to add the possibility to edit the pivot tables to the nearest releases (5.1-5.2).

tnbao
Posts: 1
Joined: Mon Apr 27, 2020 3:43 am

Re: Pivot tables in spreadsheets

Post by tnbao » Mon Apr 27, 2020 3:47 am

I don't find Pivot Table tab in spreadsheet

link image https://prnt.sc/s6ht9m

OnlyOffice version 5.5.1.78

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

Re: Pivot tables in spreadsheets

Post by Kate » Mon Apr 27, 2020 9:14 am

Hello,

The option of viewing and editing pivot tables is available only in online document editors. We recommend you to use ONLYOFFICE for Personal Use, free online document editors +2 Gb of disc space.

Should you have any question, feel free to contact us.

oreo
Posts: 3
Joined: Mon Feb 08, 2021 11:51 am

Re: Pivot tables in spreadsheets

Post by oreo » Sun Apr 11, 2021 10:11 pm

@Kate, how do you know (s)he's not using an online version?

I'm also using 5.5.1 within Nextcloud, I do have the Pivot table table but no option allows to create them as specified in the documentation, the first button is Select, all previous elements are missing (not even grayed out). What does that mean?

Image

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

Re: Pivot tables in spreadsheets

Post by Kate » Mon Apr 12, 2021 10:01 am

Hello,

Please note, the full support of pivot tables was released in 6.0 version. We recommend that you update ONLYOFFICE version first. Here is the link https://github.com/ONLYOFFICE/DocumentServer .

Best regards!

Klaas Vaak
Posts: 4
Joined: Fri May 07, 2021 10:11 am

Re: Pivot tables in spreadsheets

Post by Klaas Vaak » Sat May 08, 2021 5:25 am

On MacOS, OnlyOffice 6.2 only saves a pivot table as a non-editable flat table when a filter is applied and the file is then closed/reopened.

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

Re: Pivot tables in spreadsheets

Post by Kate » Mon May 10, 2021 9:27 am

Hello Klaas,

Please specify your OS version and send the video demonstrating the issue.

We do appreciate your cooperation,
Best regards,

Post Reply