Excel files, OnlyOffice and Nextcloud Woes

Discussion of issues you faced using ONLYOFFICE
Post Reply
rustys9999
Posts: 2
Joined: Tue Jul 13, 2021 11:35 pm

Excel files, OnlyOffice and Nextcloud Woes

Post by rustys9999 » Thu Jul 15, 2021 12:50 am

This may be a Nextcloud issue and not an OnlyOffice issue. I just don't know.

My company is transitioning to OnlyOffice because we've moved to Nextcloud as our cloud solution, and Nextcloud uses OnlyOffice as its spreadsheet read/write feature. We have a large number of preexisting Excel-created files that we need to continue to use before we start creating files from scratch in OnlyOffice. And so, a large number of users are downloading Excel-created xlsx files stored in Nextcloud and attempting to use them in Excel, only to find that (at the very least), the dropdown list validation formulas have been mangled and therefore the dropdown lists don't work. For instance, a data validation formula in the native Excel file that looks like this:

='DD_Sheet1'!$A1#

Becomes this when they have simply downloaded the untouched file from Nextcloud to their local hard drive:

=ANCHORARRAY('DD_Sheet1'!$A1)

It probably has something to do with the fact that the specified cell (A1) for the dropdown has this formula...

=TRANSPOSE(SORT(OFFSET(Sheet1!$A$8,MATCH('Sheet2'!G15,Sheet1!$I$8:$I$750,0)-1,0,COUNTIF(Sheet1!$I$8:$I$750,'Sheet2'!G15))))

...which I assume contains functions not recognized or crossed over to OnlyOffice.

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

Re: Excel files, OnlyOffice and Nextcloud Woes

Post by Kate » Fri Jul 16, 2021 2:13 pm

Hello,

Please note that this forum http://cloud.onlyoffice.org/ is intended to discuss the ONLYOFFICE (SaaS) cloud solution, desktop editors and mobile applications: http://www.onlyoffice.com/cloud-office.aspx

If you are using an open source solution, we ask you to publish your post (also attaching a screenshot) on our specialized forum dedicated to discussing the ONLYOFFICE server solution: http://dev.onlyoffice.org/, so that our specialists can understand the problem and suggest a solution.

If you are using a paid solution and have a license key, please contact us in our support system https://onlyofficesupport.zendesk.com/

Best regards

Post Reply