External File cell referencing issue in xlsx

NI3
Posts: 73
Joined: Fri Apr 07, 2017 5:12 am

External File cell referencing issue in xlsx

Post by NI3 » Wed May 31, 2017 7:38 am

One of the cell in abc.xlsx is referring to some another external xyz.xlsx file through cell referencing. I uploaded abc.xlsx file on OnlyOffice server, after editing its content, on downloading that file the link to xyz.xlsx is lost. So what might be the issue and its solution?

Maxim
Posts: 1786
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Post by Maxim » Wed May 31, 2017 9:51 am

Hello NI3!
Onlyoffice doesn't support cell reference between files.

NI3
Posts: 73
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Post by NI3 » Wed May 31, 2017 10:07 am

Is there any scope to consider this feature in future release?

Maxim
Posts: 1786
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Post by Maxim » Wed May 31, 2017 12:19 pm

I have no information.

NI3
Posts: 73
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Post by NI3 » Thu Jun 01, 2017 7:21 am

Hi,

When an xlsx file with file cell referencing is edited in OnlyOffice and downloaded, file referencing is lost and the file can not be opened in MS Office. This issue occurs even if file referencing cell isn't edited. Why is this happening?

Maxim
Posts: 1786
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Post by Maxim » Thu Jun 01, 2017 7:56 am

Hello NI3!
Attach please these two files: original and edited with Onlyoffice to analyze.

NI3
Posts: 73
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Post by NI3 » Thu Jun 01, 2017 11:47 am

Please find attached zip. It contains abc.xlsx and xyz.xlsx files. A1 cell of abc.xlsx is referring to A1 cell of xyz.xlsx through external cell referencing. After editing abc.xlsx file in OnlyOffice, the file was no longer able to be opened from MS Office.
Attachments
SampleData.zip
(12 KiB) Downloaded 71 times

NI3
Posts: 73
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Post by NI3 » Mon Jun 05, 2017 6:45 am

Hi Maxim,

As per your request, I have attached sample files in which I am facing issue for cell referencing. Please look into the issue at the earliest.

Thank you.

Maxim
Posts: 1786
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Post by Maxim » Mon Jun 05, 2017 7:19 am

Hello NI3!
I have redirected your issue to our developers last week....i will inform you as soon as i receive reply

Maxim
Posts: 1786
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Post by Maxim » Mon Jun 05, 2017 8:25 am

Hello NI3!
Thank you for the information! We have detected the bug, we will fix it next release that the file was no longer able to be opened from MS Office.

Post Reply