You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID> on 2020/01/29 16:06:25 UTC
Unable to Remove/Delete a Link Button in Calc
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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Unable to Remove/Delete a Link Button in Calc
Posted by Winston Lennon <sa...@gmail.com>.
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
<wa...@verizon.net.invalid> 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: users-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: users-help@openoffice.apache.org
> >
>
Re: Unable to Remove/Delete a Link Button in Calc
Posted by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID>.
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: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>