Teessuwa nna Maqishuwa, Coi'tte nna Rileive
Riletivetenni iillishanni
A caccafo giddo noo bisicco, 1 hawiittimma A1 gede teessantanno. Umo qarqaru aliidi gura bisicco xaaddimmo eessite mimmito aantanno bisiccuwa hakkigeeshsho teessiisa dandaatto, hakkunni gedensaanni woriidi qiniiti bisicco xaaddimmonni ledote malaate eessatenniino teessiisa dandaatto. Lawishshaho, umi shoole bisiccuwanni aliidi qiniiti cawera kalaqantanno goodeessaame A1:B2 gede teessantanno.
Qarqara tenne doogonni teessiisatenni, rileetive maqishsha A1:B2ra loosiissaanootto. Konniicho Riletive ya afi'rimalla hinkiilattowoyite kunni qarqari maqishshi umisinni rageessamnno.
co'itte iillishanni
Absolute referencing is the opposite of relative addressing. A dollar sign is placed before each letter and number in an absolute reference, for example, $A$1:$B$2.
LibreOffice can convert the current reference, in which the cursor is positioned in the input line, from relative to absolute and vice versa by pressing F4. If you start with a relative address such as A1, the first time you press this key combination, both row and column are set to absolute references ($A$1). The second time, only the row (A$1), and the third time, only the column ($A1). If you press the key combination once more, both column and row references are switched back to relative (A1)
LibreOffice Calc shows the references to a formula. If, for example, you click the formula =SUM(A1:C5;D15:D24) in a cell, the two referenced areas in the sheet will be highlighted in color. For example, the formula component "A1:C5" may be in blue and the cell range in question bordered in the same shade of blue. The next formula component "D15:D24" can be marked in red in the same way.
Rileetive nna co'itte maqishshuwa horons'iratto yanna
Rileetive maqishsha mayi badanno? E1 bisiccora A1:B2 hakkigeeshsho giddo bisiccuwate ledo shallgga hasirittoro. E1 giddo eessate afi'rimalu: =SUM(A1:B2) ikkanno. Gedenoonni caccafo A albaanni haaro caccafo eessa hasirittoro, lada hasirootto miilla B1:C2 ikkitanna afi'rimalu E1 giddo ikkikkinni F1 giddo ofollanno. Haaro caccafo surkitto gedensaanni afi'rimalla baala shittete giddo buuxanna taashsha hasiisannohe, hattono wole shitte giddo.
Konne LibreOffice loosannohe. Haaro caccafo A surkitto gedensaanni , =SUM(A1:B2) afi'rimali umisinni=SUM(B1:C2) wido soorramanno. Haaro haawiittimma 1 surkittoro haawiittimmate kiiro umisenni biddeessantanno. Maqishshu darggi milleessamiro co'ittenna rileetive maqishuwa LibreOffice Calc giddo rageessamantanno. Kaayinnilla afi'rimala hinkiiltanni noottoro co'itte maqishsha ikkikkinni rileetive calla rageessamantannohura qoropha hasiisannohe.
Co'itte maqishshuwa horonsi'nannihu shallaggu shittete giddo baxxino bisicci aana loosansamannowoyiteeti. Tenne bisicco afi'rimali orijinaale bisicco woriidi bisiccora hinkiilamanno, bisiccote xaaddimmo co'ittete gede tira hoogittoro maqishshunno wororritte millisanno.
Wole haawiittimmanna caccafuwa surkantannowooyite, afi'rimalu maqishshuwano soorrantanno. =SUM(A1:A9) afi'rimala 10 haawiittimma giddo surkittoro. Qiniiteenni noo caccafora lexxo shallagga hasirittoro, konne afi'rimala caccafu qiniite widooonni hinkiili. B caccafo giddo noohu hinkiilamino afi'rimali =SUM(B1:B9) wido rageessamanno.