You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Diana Lockie <yk...@hotmail.com> on 2014/05/25 23:16:13 UTC
Linked fomulas to other xls spreadsheets stopped working
Hi there,
I have been using your OpenOffice for many years now and I always save my files as XLS format. I have link formulas between weeksheets and they worked OK in the past. Today when I open my files and accept the update links prompt from the file that contains the links, my links now show the #Ref errors. I tried creating the link again but it doesn't work except if my link is to a cell that contains text, if the cell contains formula, no longer works.
I down loaded your newest version 4.1, repeated all the steps and same thing happens. I then tried saving the source file as the ods format and update the links, keeping the target file as Xls format, that seems to fix the issue. I then tried to change the source file back to Xls and update the links, same issue occurred.
Is this a bug?
I have Window Vista. If you need more info, please let me know. Please look into this.
Thank you for the free products and looking into this issue.
Diana