Formatting Hyperlinks

From NeoWiki

Revision as of 09:50, 7 October 2007 (edit) Jgd (Talk | contribs) (new English page about Formatting hyperlinks in Writer and in Calc) ← Previous diff		Current revision (09:43, 20 October 2007) (edit) (undo) RoyFocker (Talk | contribs) m (→Formatting Hyperlinks in Calc - link to spanish version)
(4 intermediate revisions not shown.)
Line 1:		Line 1:
-	{{fixme}}
	===Formatting Hyperlinks in Writer===		===Formatting Hyperlinks in Writer===
-	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:	+	If for some reason, in the {{menu|AutoFormat}} submenu of the {{menu|Format}} menu, you have unchecked the {{menu|While Typing}} item, a URL you enter in a Writer document, directly or by copying and pasting from your browser, is not clickable. To make it clickable, follow these steps:
-	*Select the hyperlink, and copy it by pressing the {{key|Cmd-C}} keys	+	*Select the hyperlink.
-	*Go to the {{menu|Format}} menu and select {{menu|Character…}}	+	*Go to the {{menu|Format}} menu, then to the {{menu|AutoFormat}} submenu and click on the {{menu|Apply}} item.
-	*In the {{window|Character}} window, click on the {{prefName|Hyperlink}} tab	+	The text of the hyperlink is now blue and underlined. The URL is clickable.
-	**In the field {{section|URL}} paste your URL by pressing {{key|Cmd-V}}	+
-	*Click {{button|OK}}.	+
-	The characters of the hyperlink are blue and underlined. The URL is clickable.	+
	===Formatting Hyperlinks in Calc===		===Formatting Hyperlinks in Calc===
-	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.	+	When you directly enter a URL in a cell 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.
	Let's suppose that the range A1:A100 contains URLs which are not clickable.		Let's suppose that the range A1:A100 contains URLs which are not clickable.
Line 22:		Line 18:
	*:The link which appears in B1 is clickable.		*:The link which appears in B1 is clickable.
	*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.		*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.
-	*:The characters of the links are black. You can change the color following this way :	+	The link text is black. You can change the color following this way :
	*Select the cells, then choose the {{menu|Cells…}} in the {{menu|Format}} menu		*Select the cells, then choose the {{menu|Cells…}} in the {{menu|Format}} menu
	*In the {{window|Format Cells}} window, click on the {{prefName|Font Effects}}		*In the {{window|Format Cells}} window, click on the {{prefName|Font Effects}}
Line 28:		Line 24:
	:'''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}}.		:'''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}}.
-	{{botlangbarEN|[[Fr:Formater les Hyperliens |Français]]}}	+	{{botlangbarEN|[[Fr:Formater les Hyperliens |Français]] [[Es:C%C3%B3mo_formatear_hiperv%C3%ADnculos|Español]]}}
	[[Category:Tips and Hints]][[Category:NeoOffice]]		[[Category:Tips and Hints]][[Category:NeoOffice]]

---

Current revision

Formatting Hyperlinks in Writer

If for some reason, in the AutoFormat submenu of the Format menu, you have unchecked the While Typing item, a URL you enter in a Writer document, directly or by copying and pasting from your browser, is not clickable. To make it clickable, follow these steps:

• Select the hyperlink.
• Go to the Format menu, then to the AutoFormat submenu and click on the Apply item.

The text of the hyperlink is now blue and underlined. The URL is clickable.

Formatting Hyperlinks in Calc

When you directly enter a URL in a cell 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.

Let's suppose that the range A1:A100 contains URLs which are not clickable.

• Select a cell in an empty column, for instance B1
• Click on the Function Wizard icon, on the left of the formula bar
• In the Category drop-down menu, choose Spreadsheet, then HYPERLINK
• Click on Next >>
  • In the URL field, enter A1, or click in the cell A1
  • In the CellText field, enter A1, or click in the cell A1
  • Click OK

  The link which appears in B1 is clickable.

• 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 in NeoWiki.

The link text is black. You can change the color following this way :

• Select the cells, then choose the Cells… in the Format menu
• In the Format Cells window, click on the Font Effects
• In the Font Color drop-down menu, choose the color you desire (generally blue)

Don't delete the column A, but hide it: select it and go to the Format menu, then to the Column submenu. Select Hide.