База Знаний: Интероперабельность. MS Excel. Фиксация ссылки в формуле

В Microsoft Office	В OpenOffice.org
Зафиксировать ссылку в формуле с помощью спецсимвола $
{{#switch:f4	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = F4 }} {{#if:| +  {{#switch:{{{2}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{2}}} }} }}{{#if:| +  {{#switch:{{{3}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{3}}} }} }}{{#if:| +  {{#switch:{{{4}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{4}}} }} }}{{#if:| +  {{#switch:{{{5}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{5}}} }} }}{{#if:| +  {{#switch:{{{6}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{6}}} }} }}	{{#switch:shift	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = Shift }} {{#if:F4| +  {{#switch:f4	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = F4 }} }}{{#if:| +  {{#switch:{{{3}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{3}}} }} }}{{#if:| +  {{#switch:{{{4}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{4}}} }} }}{{#if:| +  {{#switch:{{{5}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{5}}} }} }}{{#if:| +  {{#switch:{{{6}}}	shift = ⇧ Shift	up = ↑	down = ↓	> = →	< = ←	enter = ↵ Enter	cmd = ⌘ Cmd	command = ⌘ Cmd	opt = ⌥ Opt	option = ⌥ Opt	tab = Tab ⇆	backspace = ← Backspace	<< = ← Backspace	bs = ← Backspace	* = *	# = #	; = ;	: = :	#default = {{{6}}} }} }}