Unable to Remove/Delete a Link Button in Calc

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Unable to Remove/Delete a Link Button in Calc

WA.TWORSX via AOL-2
AOO-Calc .1.5 on Win10x64 Home desktop

____________________________________________

After doing some revision to my Bowling Score Data spreadsheet, I find,
(what I think is), an unwanted button to a link that now spans from
column O thru column AP, in row 2.Those columns were previously hidden
while I was focusing my revision work in adjacent areas, i.e., columns A
thru N and columns AJ thru AT. Not sure if that is related to the cause
of this problem, but might be. I seem to recall that the button was
originally located within column AH, prior to hiding those columns. The
link is no longer valid, so when I click on the button in an attempt to
delete it, I am shown an error message saying that Windows cannot find
the file.

I deleted the existing row 2, but the unwanted button continues to
appear in (new) row 2.

The same problem occurs within row 16, except that the unwanted button
spans columns O thru AI. At one time, I probably had a button to a link
located within column AH, possibly in row 16. Again, the button remains
and breaks formulae below row 16 if I delete the entire row 16.


Help!




---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Unable to Remove/Delete a Link Button in Calc

WA.TWORSX via AOL-2

I believe that I have found a solution to my buttoned hyperlink problem,
after reading through info given here:

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Hyperlinks_and_URLs

The pertinent info is:

> A hyperlink button is a type of form control. As with all form
> controls, it can be anchored or positioned by right-clicking on the
> button in design mode. More information about forms can be found
> inUsing Forms in Writer
> <https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Using_Forms_in_Writer>.
>
>
> For the button to work , the spreadsheet must/not/be in design mode.
> To toggle design mode on and off, view the Form Controls toolbar
> (*View > Toolbars > Form Controls*) and click the*Design Mode
> On/Off*buttonFormDesignOffIcon.png
> <https://wiki.openoffice.org/wiki/File:FormDesignOffIcon.png>.
>
Once I became aware that a hyperlink button is a type of form control, I
toggled Design Mode On; that enabled me to *move* the buttoned hyperlink
anchored location point so that it no longer conflicts with existing
cell's data. Then, with Design Mode On, I could right-click and Cut it
from the .ods file !! To return to a default state, I then toggled
Design Mode Off.



On 1/29/2020 11:06 AM, WA.TWORSX via AOL wrote:

> AOO-Calc .1.5 on Win10x64 Home desktop
>
> ____________________________________________
>
> After doing some revision to my Bowling Score Data spreadsheet, I
> find, (what I think is), an unwanted button to a link that now spans
> from column O thru column AP, in row 2.Those columns were previously
> hidden while I was focusing my revision work in adjacent areas, i.e.,
> columns A thru N and columns AJ thru AT. Not sure if that is related
> to the cause of this problem, but might be. I seem to recall that the
> button was originally located within column AH, prior to hiding those
> columns. The link is no longer valid, so when I click on the button in
> an attempt to delete it, I am shown an error message saying that
> Windows cannot find the file.
>
> I deleted the existing row 2, but the unwanted button continues to
> appear in (new) row 2.
>
> The same problem occurs within row 16, except that the unwanted button
> spans columns O thru AI. At one time, I probably had a button to a
> link located within column AH, possibly in row 16. Again, the button
> remains and breaks formulae below row 16 if I delete the entire row 16.
>
>
> Help!
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to Remove/Delete a Link Button in Calc

Winston Lennon
Hi,

I  installed the file OpenSymbol_V1.7 in the c:\Windows\Fonts folder and
the formulas look OK now.


Sincerely,
Winston A.  Lennon




On Fri, Jan 31, 2020 at 9:57 AM WA.TWORSX via AOL
<[hidden email]> wrote:

>
> I believe that I have found a solution to my buttoned hyperlink problem,
> after reading through info given here:
>
>
> https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Hyperlinks_and_URLs
>
> The pertinent info is:
>
> > A hyperlink button is a type of form control. As with all form
> > controls, it can be anchored or positioned by right-clicking on the
> > button in design mode. More information about forms can be found
> > inUsing Forms in Writer
> > <
> https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Using_Forms_in_Writer>.
>
> >
> >
> > For the button to work , the spreadsheet must/not/be in design mode.
> > To toggle design mode on and off, view the Form Controls toolbar
> > (*View > Toolbars > Form Controls*) and click the*Design Mode
> > On/Off*buttonFormDesignOffIcon.png
> > <https://wiki.openoffice.org/wiki/File:FormDesignOffIcon.png>.
> >
> Once I became aware that a hyperlink button is a type of form control, I
> toggled Design Mode On; that enabled me to *move* the buttoned hyperlink
> anchored location point so that it no longer conflicts with existing
> cell's data. Then, with Design Mode On, I could right-click and Cut it
> from the .ods file !! To return to a default state, I then toggled
> Design Mode Off.
>
>
>
> On 1/29/2020 11:06 AM, WA.TWORSX via AOL wrote:
> > AOO-Calc .1.5 on Win10x64 Home desktop
> >
> > ____________________________________________
> >
> > After doing some revision to my Bowling Score Data spreadsheet, I
> > find, (what I think is), an unwanted button to a link that now spans
> > from column O thru column AP, in row 2.Those columns were previously
> > hidden while I was focusing my revision work in adjacent areas, i.e.,
> > columns A thru N and columns AJ thru AT. Not sure if that is related
> > to the cause of this problem, but might be. I seem to recall that the
> > button was originally located within column AH, prior to hiding those
> > columns. The link is no longer valid, so when I click on the button in
> > an attempt to delete it, I am shown an error message saying that
> > Windows cannot find the file.
> >
> > I deleted the existing row 2, but the unwanted button continues to
> > appear in (new) row 2.
> >
> > The same problem occurs within row 16, except that the unwanted button
> > spans columns O thru AI. At one time, I probably had a button to a
> > link located within column AH, possibly in row 16. Again, the button
> > remains and breaks formulae below row 16 if I delete the entire row 16.
> >
> >
> > Help!
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [hidden email]
> > For additional commands, e-mail: [hidden email]
> >
>