LibreOffice Help – 7.6/text/scalc/05 — Tibetan @ TDF Weblate - LibreOffice: <bookmark_value>empty cells;handling of</bookmark

Translation

Context empty_cells.xhp bm_id3146799 help.text

English nVAzC

Tibetan

Needs editing

Insufficient privileges for saving translations.

Skip

Context	English	Tibetan
02140000.xhp par_id3149710 help.text	<emph>Interpreter: </emph>AddIn not found.
02140000.xhp par_id3152967 help.text	No Macro
02140000.xhp par_id3149711 help.text	<emph>Interpreter: </emph>Macro not found.
02140000.xhp par_id5324564 help.text	532<br/>#DIV/0!
02140000.xhp par_id7941831 help.text	Division by zero
02140000.xhp par_id5844294 help.text	Division operator / if the denominator is 0<br/>Some more functions return this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0
02140000.xhp par_id951549820044260 help.text	Nested arrays are not supported
02140000.xhp par_id781549820065619 help.text	For example, ={1;{2}}
02140000.xhp par_id521549825734781 help.text	Error: Array or matrix size
02140000.xhp par_id601549825744677 help.text	The maximum limit for sorting has exceeded (the maximum is twice the maximum number of rows, so for 1048576 rows 2097152 entries). The same Err:538 is also used whenever a temporary matrix could not be allocated due to its size requirement.
02140000.xhp par_id931549825818729 help.text	Unsupported inline array content
02140000.xhp par_id551549825825905 help.text	For example, ={1+2}
02140000.xhp par_id131549825893410 help.text	External content disabled
02140000.xhp par_id881549825900965 help.text	A function that requires (re)loading of external sources is encountered and the user has not confirmed reloading of external sources yet.
empty_cells.xhp tit help.text	Handling of Empty Cells
empty_cells.xhp bm_id3146799 help.text	<bookmark_value>empty cells;handling of</bookmark_value>	<bookmark_value>%PRODUCTNAME གློག་རྡུལ་རེའུ་མིག་ནང་གི་ནོར་འཁྲུལ་ཚབ་ཨང་</bookmark_value><bookmark_value>%PRODUCTNAME གློག་རྡུལ་རེའུ་མིག་ ནོར་འཁྲུལ་ཚབ་ཨང་</bookmark_value>
empty_cells.xhp hd_id1502121 help.text	<variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link></variable>
empty_cells.xhp par_id8266853 help.text	In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned.
empty_cells.xhp par_id2733542 help.text	A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected.
empty_cells.xhp par_id4238715 help.text	For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:
empty_cells.xhp par_id291535142746121 help.text	Case
empty_cells.xhp par_id441535142746121 help.text	Formula
empty_cells.xhp par_id261535142746121 help.text	Results and comments
empty_cells.xhp par_id941535142746122 help.text	A1: 1<br/>B1: <Empty>
empty_cells.xhp par_id851535142746123 help.text	Displays 0
empty_cells.xhp par_id981535142948275 help.text	<variable id="vtrue">TRUE</variable>
empty_cells.xhp par_id1001535143031604 help.text	TRUE (previously was FALSE)
empty_cells.xhp par_id201535143064244 help.text	=ISNUMBER(B1)
empty_cells.xhp par_id421535143064245 help.text	<variable id="vfalse">FALSE</variable>
empty_cells.xhp par_id681535143124250 help.text	=ISNUMBER(C1)
empty_cells.xhp par_id211535143124250 help.text	FALSE (previously was TRUE)

Loading…

None

String updated in the repository

English

Tibetan 169 characters edited Current translation Translated

8 months ago

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Tibetan
No related strings found in the glossary.

String information

Context

empty_cells.xhp
bm_id3146799
help.text

Source string description

nVAzC

Source string location

empty_cells.xhp

String age

8 months ago

Last updated

8 months ago

Source string age

8 months ago

Translation file

bo/helpcontent2/source/text/scalc/05.po, string 81