https://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&action=history&feed=atomFormatting Hyperlinks - Revision history2024-03-29T13:40:57ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12416&oldid=prevRoyFocker: /* Formatting Hyperlinks in Calc */ link to spanish version2007-10-20T09:43:09Z<p><span class="autocomment">Formatting Hyperlinks in Calc -</span> link to spanish version</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 09:43, 20 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 24:</strong></td>
<td colspan="2" align="left"><strong>Line 24:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:'''Don't delete the column A, but hide it: select it and go to the''' {{menu|Format}} '''menu, then to the''' {{menu|Column}} '''submenu. Select''' {{menu|Hide}}.</td><td> </td><td style="background: #eee; font-size: smaller;">:'''Don't delete the column A, but hide it: select it and go to the''' {{menu|Format}} '''menu, then to the''' {{menu|Column}} '''submenu. Select''' {{menu|Hide}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{botlangbarEN|[[Fr:Formater les Hyperliens |Français]]}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Formater les Hyperliens |Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[Es:C%C3%B3mo_formatear_hiperv%C3%ADnculos|Español</ins>]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td></tr>
</table>RoyFockerhttps://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12284&oldid=prevJgd: /* Formatting Hyperlinks in Writer */little precision and better method2007-10-10T17:15:13Z<p><span class="autocomment">Formatting Hyperlinks in Writer -</span>little precision and better method</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 17:15, 10 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">When </del>you <del style="color: red; font-weight: bold; text-decoration: none;">enter </del>a URL in a Writer document, directly or by copying and pasting from your browser, <del style="color: red; font-weight: bold; text-decoration: none;">it </del>is not clickable. To make it clickable, follow these steps:</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">If for some reason, in the {{menu|AutoFormat}} submenu of the {{menu|Format}} menu, </ins>you <ins style="color: red; font-weight: bold; text-decoration: none;">have unchecked the {{menu|While Typing}} item, </ins>a URL <ins style="color: red; font-weight: bold; text-decoration: none;">you enter </ins>in a Writer document, directly or by copying and pasting from your browser, is not clickable. To make it clickable, follow these steps:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Select the hyperlink<del style="color: red; font-weight: bold; text-decoration: none;">, and copy it by pressing the {{key|Cmd-C}} keys</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">*Select the hyperlink<ins style="color: red; font-weight: bold; text-decoration: none;">.</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Go to the {{menu|Format}} menu <del style="color: red; font-weight: bold; text-decoration: none;">and select </del>{{menu|<del style="color: red; font-weight: bold; text-decoration: none;">Character…</del>}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Go to the {{menu|Format}} menu<ins style="color: red; font-weight: bold; text-decoration: none;">, then to the </ins>{{menu|<ins style="color: red; font-weight: bold; text-decoration: none;">AutoFormat</ins>}} <ins style="color: red; font-weight: bold; text-decoration: none;">submenu and </ins>click on the {{<ins style="color: red; font-weight: bold; text-decoration: none;">menu</ins>|<ins style="color: red; font-weight: bold; text-decoration: none;">Apply</ins>}} <ins style="color: red; font-weight: bold; text-decoration: none;">item</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">*In the {{window|Character}} window, </del>click on the {{<del style="color: red; font-weight: bold; text-decoration: none;">prefName|Hyperlink}} tab</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">The text of the hyperlink is <ins style="color: red; font-weight: bold; text-decoration: none;">now </ins>blue and underlined. The URL is clickable.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">**In the field {{section|URL}} paste your URL by pressing {{key|Cmd-V}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">*Click {{button</del>|<del style="color: red; font-weight: bold; text-decoration: none;">OK</del>}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The text of the hyperlink is blue and underlined. The URL is clickable.</td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12170&oldid=prevLorinda: a little more polish; remove fixme.2007-10-07T12:25:40Z<p>a little more polish; remove fixme.</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:25, 7 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{fixme}}</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">When you enter a URL in a Writer document, directly or by copying and pasting from your browser, it is not clickable. To make it clickable, follow these steps:</td><td> </td><td style="background: #eee; font-size: smaller;">When you enter a URL in a Writer document, directly or by copying and pasting from your browser, it is not clickable. To make it clickable, follow these steps:</td></tr>
<tr><td colspan="2" align="left"><strong>Line 7:</strong></td>
<td colspan="2" align="left"><strong>Line 6:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">**In the field {{section|URL}} paste your URL by pressing {{key|Cmd-V}}</td><td> </td><td style="background: #eee; font-size: smaller;">**In the field {{section|URL}} paste your URL by pressing {{key|Cmd-V}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|OK}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|OK}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The <del style="color: red; font-weight: bold; text-decoration: none;">characters </del>of the hyperlink <del style="color: red; font-weight: bold; text-decoration: none;">are </del>blue and underlined. The URL is clickable.</td><td>+</td><td style="background: #cfc; font-size: smaller;">The <ins style="color: red; font-weight: bold; text-decoration: none;">text </ins>of the hyperlink <ins style="color: red; font-weight: bold; text-decoration: none;">is </ins>blue and underlined. The URL is clickable.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12169&oldid=prevLorinda: /* Formatting Hyperlinks in Writer */ just a little polish2007-10-07T12:24:27Z<p><span class="autocomment">Formatting Hyperlinks in Writer -</span> just a little polish</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:24, 7 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{fixme}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{fixme}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Writer===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">When you enter a URL in a Writer document, directly or by copying and pasting from your browser, it is not clickable. To <del style="color: red; font-weight: bold; text-decoration: none;">get </del>it clickable, <del style="color: red; font-weight: bold; text-decoration: none;">you can </del>follow these steps:</td><td>+</td><td style="background: #cfc; font-size: smaller;">When you enter a URL in a Writer document, directly or by copying and pasting from your browser, it is not clickable. To <ins style="color: red; font-weight: bold; text-decoration: none;">make </ins>it clickable, follow these steps:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Select the hyperlink, and copy it by pressing the {{key|Cmd-C}} keys</td><td> </td><td style="background: #eee; font-size: smaller;">*Select the hyperlink, and copy it by pressing the {{key|Cmd-C}} keys</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu and select {{menu|Character…}}</td><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu and select {{menu|Character…}}</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12168&oldid=prevLorinda: /* Formatting Hyperlinks in Calc */ just a little polish2007-10-07T12:23:34Z<p><span class="autocomment">Formatting Hyperlinks in Calc -</span> just a little polish</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:23, 7 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 10:</strong></td>
<td colspan="2" align="left"><strong>Line 10:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td><td> </td><td style="background: #eee; font-size: smaller;">===Formatting Hyperlinks in Calc===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">When you <del style="color: red; font-weight: bold; text-decoration: none;">enter </del>directly a URL in a <del style="color: red; font-weight: bold; text-decoration: none;">cellule </del>of a spreadsheet, it is automatically replaced with a clickable hyperlink. But if you copy/paste such a URL, it is pasted in the default text format. It has been reported that if you add "by hand" a space at the end of the URL, the hyperlink turns clickable. However, if you have many URLs in a same column, the following method is faster.</td><td>+</td><td style="background: #cfc; font-size: smaller;">When you directly <ins style="color: red; font-weight: bold; text-decoration: none;">enter </ins>a URL in a <ins style="color: red; font-weight: bold; text-decoration: none;">cell </ins>of a spreadsheet, it is automatically replaced with a clickable hyperlink. But if you copy/paste such a URL, it is pasted in the default text format. It has been reported that if you add "by hand" a space at the end of the URL, the hyperlink turns clickable. However, if you have many URLs in a same column, the following method is faster.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Let's suppose that the range A1:A100 contains URLs which are not clickable.</td><td> </td><td style="background: #eee; font-size: smaller;">Let's suppose that the range A1:A100 contains URLs which are not clickable.</td></tr>
<tr><td colspan="2" align="left"><strong>Line 22:</strong></td>
<td colspan="2" align="left"><strong>Line 22:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*:The link which appears in B1 is clickable.</td><td> </td><td style="background: #eee; font-size: smaller;">*:The link which appears in B1 is clickable.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Fill the column B, from B1 to B100, by clicking on the little black square in the right bottom of the cell B1, then dragging the cursor to cell B100. See [[Selecting and Filling a Cell Range|Selecting and Filling a Cell Range]] in NeoWiki.</td><td> </td><td style="background: #eee; font-size: smaller;">*Fill the column B, from B1 to B100, by clicking on the little black square in the right bottom of the cell B1, then dragging the cursor to cell B100. See [[Selecting and Filling a Cell Range|Selecting and Filling a Cell Range]] in NeoWiki.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">*:</del>The <del style="color: red; font-weight: bold; text-decoration: none;">characters of the links are </del>black. You can change the color following this way :</td><td>+</td><td style="background: #cfc; font-size: smaller;">The <ins style="color: red; font-weight: bold; text-decoration: none;">link text is </ins>black. You can change the color following this way :</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Select the cells, then choose the {{menu|Cells…}} in the {{menu|Format}} menu</td><td> </td><td style="background: #eee; font-size: smaller;">*Select the cells, then choose the {{menu|Cells…}} in the {{menu|Format}} menu</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*In the {{window|Format Cells}} window, click on the {{prefName|Font Effects}}</td><td> </td><td style="background: #eee; font-size: smaller;">*In the {{window|Format Cells}} window, click on the {{prefName|Font Effects}}</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Formatting_Hyperlinks&diff=12165&oldid=prevJgd: new English page about Formatting hyperlinks in Writer and in Calc2007-10-07T09:50:19Z<p>new English page about Formatting hyperlinks in Writer and in Calc</p>
<p><b>New page</b></p><div>{{fixme}}<br />
===Formatting Hyperlinks in Writer===<br />
When you enter a URL in a Writer document, directly or by copying and pasting from your browser, it is not clickable. To get it clickable, you can follow these steps:<br />
*Select the hyperlink, and copy it by pressing the {{key|Cmd-C}} keys<br />
*Go to the {{menu|Format}} menu and select {{menu|Character…}}<br />
*In the {{window|Character}} window, click on the {{prefName|Hyperlink}} tab<br />
**In the field {{section|URL}} paste your URL by pressing {{key|Cmd-V}}<br />
*Click {{button|OK}}.<br />
The characters of the hyperlink are blue and underlined. The URL is clickable.<br />
<br />
===Formatting Hyperlinks in Calc===<br />
When you enter directly a URL in a cellule of a spreadsheet, it is automatically replaced with a clickable hyperlink. But if you copy/paste such a URL, it is pasted in the default text format. It has been reported that if you add "by hand" a space at the end of the URL, the hyperlink turns clickable. However, if you have many URLs in a same column, the following method is faster.<br />
<br />
Let's suppose that the range A1:A100 contains URLs which are not clickable.<br />
*Select a cell in an empty column, for instance B1<br />
*Click on the Function Wizard icon, on the left of the formula bar<br />
*In the {{menu|Category}} drop-down menu, choose {{prefName|Spreadsheet}}, then {{prefName|HYPERLINK}}<br />
*Click on {{button|Next >>}}<br />
**In the {{prefName|URL}} field, enter A1, or click in the cell A1<br />
**In the {{prefName|CellText}} field, enter A1, or click in the cell A1<br />
**Click {{button|OK}}<br />
*:The link which appears in B1 is clickable.<br />
*Fill the column B, from B1 to B100, by clicking on the little black square in the right bottom of the cell B1, then dragging the cursor to cell B100. See [[Selecting and Filling a Cell Range|Selecting and Filling a Cell Range]] in NeoWiki.<br />
*:The characters of the links are black. You can change the color following this way :<br />
*Select the cells, then choose the {{menu|Cells…}} in the {{menu|Format}} menu<br />
*In the {{window|Format Cells}} window, click on the {{prefName|Font Effects}}<br />
*In the {{menu|Font Color}} drop-down menu, choose the color you desire (generally blue)<br />
:'''Don't delete the column A, but hide it: select it and go to the''' {{menu|Format}} '''menu, then to the''' {{menu|Column}} '''submenu. Select''' {{menu|Hide}}.<br />
<br />
{{botlangbarEN|[[Fr:Formater les Hyperliens |Français]]}}<br />
[[Category:Tips and Hints]][[Category:NeoOffice]]</div>Jgd