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