Try the fastest and simplest way to install ONLYOFFICE

External File cell referencing issue in xlsx

External File cell referencing issue in xlsx

Postby 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?
NI3
 
Posts: 57
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Postby Maxim » Wed May 31, 2017 9:51 am

Hello NI3!
Onlyoffice doesn't support cell reference between files.
Maxim
 
Posts: 1077
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Postby NI3 » Wed May 31, 2017 10:07 am

Is there any scope to consider this feature in future release?
NI3
 
Posts: 57
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Postby Maxim » Wed May 31, 2017 12:19 pm

I have no information.
Maxim
 
Posts: 1077
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Postby 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?
NI3
 
Posts: 57
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Postby Maxim » Thu Jun 01, 2017 7:56 am

Hello NI3!
Attach please these two files: original and edited with Onlyoffice to analyze.
Maxim
 
Posts: 1077
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Postby 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 14 times
NI3
 
Posts: 57
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Postby 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.
NI3
 
Posts: 57
Joined: Fri Apr 07, 2017 5:12 am

Re: External File cell referencing issue in xlsx

Postby 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: 1077
Joined: Tue Oct 11, 2016 2:34 pm

Re: External File cell referencing issue in xlsx

Postby 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.
Maxim
 
Posts: 1077
Joined: Tue Oct 11, 2016 2:34 pm

Next

Return to Miscellaneous

Who is online

Users browsing this forum: No registered users and 1 guest

cron