Embedded link

[John Mehta <jo...@gmail.com>]

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

[John Mehta <jo...@gmail.com>]

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 <Jo...@gmx.de> 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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>

Re: Embedded link

[Joost Andrae <Jo...@gmx.de>]

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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org