Embedded link
Hi, I've got a link to one of my files embedded in a spreadsheet. I don't know how it got there and I want to get rid of it. It's not associated with any cell but it is always in the same place in the spreadsheet. I can't select it by right clicking my mouse and left clicking opens windows explorer at the referenced file. Can anyone tell me how to remove this embedded link, please? John.
Re: Embedded link
Hi John, it depends on what kind of link this is. If you dragged a document from the systems file manager then this object might be embedded as OLE object. If you doubleclick onto this object then the assigned application will open as object within the spreadsheet. To remove the object just select it and press the delete button. If it is a hyperlink then allocate the cell cursor to a cell next to the cell containing the hyperlink, then use the keyboard to go the the cell, press the F2 function (edit mode) key and delete the content of that cell If it is a form control object (eg. a button or a combo box) then select the select button in menu item /View/Toolbars/Form Controls/, select that object in design mode (on) and press the delete button. Kind regards, Joost Am 22.08.2022 um 11:51 schrieb John Mehta: Hi, I've got a link to one of my files embedded in a spreadsheet. I don't know how it got there and I want to get rid of it. It's not associated with any cell but it is always in the same place in the spreadsheet. I can't select it by right clicking my mouse and left clicking opens windows explorer at the referenced file. Can anyone tell me how to remove this embedded link, please? John. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Embedded link
Thank you Joost. It was a form control object and is now deleted. Kind Regards, John. On Mon, Aug 22, 2022 at 12:00 PM Joost Andrae wrote: > Hi John, > > it depends on what kind of link this is. > > If you dragged a document from the systems file manager then this object > might be embedded as OLE object. If you doubleclick onto this object > then the assigned application will open as object within the > spreadsheet. To remove the object just select it and press the delete > button. > > If it is a hyperlink then allocate the cell cursor to a cell next to the > cell containing the hyperlink, then use the keyboard to go the the cell, > press the F2 function (edit mode) key and delete the content of that cell > > If it is a form control object (eg. a button or a combo box) then select > the select button in menu item /View/Toolbars/Form Controls/, select > that object in design mode (on) and press the delete button. > > Kind regards, Joost > > Am 22.08.2022 um 11:51 schrieb John Mehta: > > Hi, > > > > I've got a link to one of my files embedded in a spreadsheet. I don't > know > > how it got there and I want to get rid of it. It's not associated with > any > > cell but it is always in the same place in the spreadsheet. I can't > select > > it by right clicking my mouse and left clicking opens windows explorer at > > the referenced file. > > > > Can anyone tell me how to remove this embedded link, please? > > > > John. > > > > > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
