Ask Your Question

change the link to a validity drop-down field in calc

asked 2017-02-08 16:11:45 +0200

ARYLIOA gravatar image

I am new to LibreOffice and created a calc spreadsheet using a drop-down list for one of the fields. I used a separate spreadsheet for the list. I have that working but have decided I would like to rename and relocate the linked file I use to populate the drop down. E.g. I would like to change the link from

'file:///N:/Test/Household Inventory/Locations.ods'#$Sheet1.$A$1:$A$50


'file:///N:/Common LibreOffice Files/Household Inventory Locations.ods'#$Sheet1.$A$1:$A$50

There are over 2500 records in the spreadsheet and renaming each row's link would obviously be a real pain. I tried to use find and replace, but that did not work. Is there a way to change those links with a single edit of some sort, or by another command?

(I am in the process of converting many Access databases to LibreOffice. I have found a way around my this bad design choice by linking a single source file as a secondary sheet in multiple spreadsheets. But I dread editing each of the rows in this "completed" spreadsheet manually.)


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-02-08 23:35:48 +0200

m.a.riosv gravatar image

For the cells with same dropdown list, select them and edit all at once.

edit flag offensive delete link more


Thank you. Much too simple for me to have stumbled upon it. New software imposes temporary stupid sometimes. It worked perfectly and easily.

Thanks again.

ARYLIOA gravatar imageARYLIOA ( 2017-02-11 16:44:54 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-02-12 12:58:55 +0200 )edit
Login/Signup to Answer

Question Tools


Asked: 2017-02-08 16:11:45 +0200

Seen: 89 times

Last updated: Feb 08 '17