First time here? Check out the FAQ!
asked 2012-05-16 18:30:51 +0200Radioman
After upgrade from Ubuntu 10.10 to 12.04 my legacy spread sheet (originally an .xls) then a Open Office .xls and now a Libre Office .xls file asks to update links and then displays a dialogue box saying that the link to ...... is unavailable and will be ignored. Problem is that the link described is incorrect. The links (and there are many hundreds of them) are at a different location. Attempting to break link destroys all links in the spreadsheet. Attempting to modify the links seems to return the proper location but when the spread sheet reloads the links are all pointing at the wrong location. Any solutions would be greatly appreciated.
answered 2012-05-16 23:30:51 +0200Radioman
OK, for anyone who has also run into this "feature" discovered that the problem can be temporarily "WORKED-AROUND" by going to the Edit>Links menu and "modifying" the setting to the correct document whereupon the links update correctly. However, if a "reload" is done or the document is re-opened the link path again becomes corrupted. It's a workaround at least until the right guru discovers what the problem is and issues a patch.
answered 2012-05-17 00:00:56 +0200luyu
After you modify links to point to the right location, save the file and the links will be preserved. Reloading or reopening it before saving discards all changes.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-16 18:30:51 +0200
Seen: 233 times
Last updated: May 17 '12