LibreOffice Help – 24.2/text/scalc/01 — Slovak @ TDF Weblate - LibreOffice: <bookmark_value>CELL function</bookmark_value> <bookmark_value>cell information</bookmark_value> <bookmark_value>information on cells</bookmark

Translation

Context 04060104.xhp bm_id3155509 help.text

English

BsfYR

Slovak

Needs editing

Skip

Context	English	Slovak
04060104.xhp par_id3154670 help.text	<item type="input">=N("abc")</item> returns 0	<item type="input">=N("abc")</item> vráti 0
04060104.xhp par_id3519089 help.text	=N(1/0) returns #DIV/0!	=N(1/0) vráti #DIV/0!
04060104.xhp bm_id3156275 help.text	<bookmark_value>NA function</bookmark_value> <bookmark_value>#N/A error;assigning to a cell</bookmark_value>	<bookmark_value>NA funkcia</bookmark_value><bookmark_value>chyba #N/A; priradenie bunke</bookmark_value>
04060104.xhp hd_id3156275 help.text	NA	NA
04060104.xhp par_id3156161 help.text	<ahelp hid="HID_FUNC_NV">Returns the error value #N/A.</ahelp>	<ahelp hid="HID_FUNC_NV">Vráti chybovú hodnotu #N/A.</ahelp>
04060104.xhp par_id3149563 help.text	NA()	NA()
04060104.xhp par_id3154481 help.text	<item type="input">=NA()</item> converts the contents of the cell into #N/A.	<item type="input">=NA()</item> konvertuje obsah bunky na #N/A.
04060104.xhp bm_id3151255 help.text	<bookmark_value>TYPE function</bookmark_value>	<bookmark_value>TYPE funkcia</bookmark_value>
04060104.xhp hd_id3151255 help.text	TYPE	TYPE
04060104.xhp par_id3155900 help.text	<ahelp hid="HID_FUNC_TYP">Returns the type of value, where 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array.</ahelp>
04060104.xhp par_id3148400 help.text	TYPE(Value)	TYPE(Hodnota)
04060104.xhp par_id3150830 help.text	<emph>Value</emph> is a specific value for which the data type is determined.
04060104.xhp hd_id3154363 help.text	Example (see example table above)	Príklad (pozri tabuľku vyššie)
04060104.xhp par_id3153357 help.text	<item type="input">=TYPE(C2)</item> returns 2 as a result.	<item type="input">=TYPE(C2)</item> vracia ako výsledok 2.
04060104.xhp par_id3148980 help.text	<item type="input">=TYPE(D9)</item> returns 1 as a result.	<item type="input">=TYPE(D9)</item> vracia ako výsledok 1.
04060104.xhp bm_id3155509 help.text	<bookmark_value>CELL function</bookmark_value> <bookmark_value>cell information</bookmark_value> <bookmark_value>information on cells</bookmark_value>	<bookmark_value>CELL funkcia</bookmark_value><bookmark_value>informácie o bunke</bookmark_value>
04060104.xhp hd_id3155509 help.text	CELL	CELL
04060104.xhp par_id3153196 help.text	<ahelp hid="HID_FUNC_ZELLE">Returns information on address, formatting or contents of a cell.</ahelp>	<ahelp hid="HID_FUNC_ZELLE">Vráti informáciu o adrese, formátovaniu alebo obsahu bunky.</ahelp>
04060104.xhp par_id3147355 help.text	CELL("InfoType" [; Reference])
04060104.xhp par_id3154716 help.text	<emph>InfoType</emph> is the character string that specifies the type of information. The character string is always in English. Upper or lower case is optional.	<emph>Informácia</emph> je reťazec znakov , ktorý špecifikuje typ informácií. Reťazec znakov je vždy v angličtine. Veľké alebo malé písmená sú voliteľné.
04060104.xhp par_id3150636 help.text	InfoType	Informácia
04060104.xhp par_id3149344 help.text	Meaning	Význam
04060104.xhp par_id3156204 help.text	Returns the number of the referenced column.	Vráti číslo odkazovaného stĺpca.
04060104.xhp par_id3150094 help.text	<item type="input">=CELL("COL";D2)</item> returns 4.	<item type="input">=CELL("COL";D2)</item> vracia 4.
04060104.xhp par_id3147583 help.text	Returns the number of the referenced row.	Vráti číslo odkazovaného riadku.
04060104.xhp par_id3151222 help.text	<item type="input">=CELL("ROW";D2)</item> returns 2.	<item type="input">=CELL("ROW";D2)</item> vracia 2.
04060104.xhp par_id3151201 help.text	Returns the number of the referenced sheet.	Vráti číslo odkazovaného listu.
04060104.xhp par_id3149169 help.text	<item type="input">=CELL("Sheet";Sheet3.D2)</item> returns 3.	<item type="input">=CELL("Sheet";Sheet3.D2)</item> vracia 3.
04060104.xhp par_id3156054 help.text	Returns the absolute address of the referenced cell.	Vráti absolútnu adresu odkazovanej bunky.
04060104.xhp par_id3154136 help.text	<item type="input">=CELL("ADDRESS";D2)</item> returns $D$2.	<item type="input">=CELL("ADDRESS";D2)</item> vracia $D$2.
04060104.xhp par_id3159198 help.text	<item type="input">=CELL("ADDRESS";Sheet3.D2)</item> returns $Sheet3.$D$2.	<item type="input">=CELL("ADDRESS";Sheet3.D2)</item> vracia $Sheet3.$D$2.

Loading…

None

String updated in the repository

English

Slovak 96 characters edited Current translation Translated

4 months ago

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Slovak
No related strings found in the glossary.

String information

Context

04060104.xhp
bm_id3155509
help.text

Source string description

BsfYR

Source string location

04060104.xhp

String age

4 months ago

Last updated

4 months ago

Source string age

4 months ago

Translation file

sk/helpcontent2/source/text/scalc/01.po, string 1090