If jTF.URL"" Then URLcount = URLcount + 1
Sub formatPreservingRemoveLinkageFromCellTextFieldURLContent(Optional pRgs) dialog box select or remove multiple items from an Excel drop down list. Having location=application the issue vanishes. a basic range based data validation in LibreOffice Calc using a drop down. In the dialog, select the new attributes, and click OK. Right-click the 'Internet Link' or 'Visited Internet Link' character style, and choose Modify. Strangely the Sub works for me as expected also for cells containing more than one link and having differently attributed text portions if I start it from the IDE, but hangs if I call it via the UI. Open the Styles and Formatting window (F11) Click the Character Styles icon. If the following macro is location=document: Also, in the format menus is there a way to tell certain cells to NEVER insert a hyperlink Many thanks, -T Hrbrgr July 31, 2021, 4:25pm 2 Select the cell (s), choose Format>Delete Direct Formatting from the menu. The text of the hyperlink needs to remain. Click on Extract -> Replace formulas with Text strings to initiate the script. 5 To remove specific character formatting, click Format, select the Font tab. Select the cell (s), row (s) or column (s) in your spreadsheet that contain the HYPERLINK functions. If l2.TextField.supportsService(".textfield.URL") Then I want to leave all other formatting in tact but remove just the hyperlinks. components (Writer, Calc, Draw, Impress, Base) have this toolbar. If IsMissing(pRgs) Then pRgs = ThisComponent.CurrentSelection Formatting of text portions not preserved. See yourself and post your better ideas: Sub removeLinkageFromCellTextFieldURLContentIgnorigPartialFormatting(Optional pRgs)
#Libreoffice calc remove hyperlink code
To remove links (more than one per cell probably) from a cell preserving diffrent formatting of parts is rather complicated, and due to strange observations the code I ended up with may not be exactly reliable. It’s rather simple to “destroy” the links if partial formatting of cell texts is meaningless. However, I made a tour into the API, and have to admit that I didn’t find an easy way to do by user code for Calc what’s needed. One may be the fact that hyperlinks are very differently implemented in Calc and in Writer (e.g.) I cannot see the reasons for the delay with this obviously relevant feature. tdf#66694 is more than 7 years old, and has a respectable ‘See also’. There surely are additional threads in the bug tracker. Quoting : “’…this inability to remove a hyperlink is a known bug.’ Link, please?”
0 kommentar(er)
