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: [email protected]
For additional commands, e-mail: [email protected]
