doc/ru/cell_refer.sgml

   1 <sect1 id="cell-referencing">
   2   <title>õËÁÚÁÎÉÅ ÑÞÅÅË</title>
   3
   4
   5   <para>þÔÏÂÙ ÓÏÓÌÁÔØÓÑ ÎÁ ÚÎÁÞÅÎÉÅ ÈÒÁÎÑÝÅÅÓÑ × ÏÄÎÏÊ ÑÞÅÊËÅ, ÎÁÐÒÉÍÅÒ B1, ÐÒÏÓÔÏ
   6         ××ÅÄÉÔÅ "B1" ËÁË ÁÒÇÕÍÅÎÔ ÆÕÎËÃÉÉ.</para>
   7
   8   <para>îÁ ÑÞÅÊËÕ ÍÏÖÎÏ ÓÏÓÌÁÔØÓÑ × ÆÏÒÍÁÔÅ C4, ÇÄÅ C ÍÅÔËÁ ÓÔÏÌÂÃÁ
   9     É 4 ÍÅÔËÁ ÓÔÒÏËÉ.</para>
  10
  11   <example id="simplecellrefer">
  12     <title>îÅËÏÔÏÒÙÅ ÐÒÉÍÅÒÙ ÓÉÎÔÁËÓÉÓÁ ÆÕÎËÃÉÊ</title>
  13     <programlisting>
  14       =EXP(B1)
  15
  16       =COS(A2)
  17
  18     </programlisting>
  19   </example>
  20
  21   <sect2>
  22     <title>áÂÓÏÌÀÔÎÙÅ ÓÓÙÌËÉ ÎÁ ÑÞÅÊËÉ</title>
  23
  24     <para>îÁ ÑÞÅÊËÉ ÍÏÖÎÏ ÓÓÙÌÁÔØÓÑ ÓÐÏÓÏÂÏÍ ÐÏ ÕÍÏÌÞÁÎÉÀ (ÏÔÎÏÓÉÔÅÌØÎÙÅ ÓÓÙÌËÉ),
  25      ÉÌÉ ÉÓÐÏÌØÚÕÑ ÁÂÓÏÌÀÔÎÙÅ ÓÓÙÌËÉ. áÂÓÏÌÀÔÎÁÑ ÓÓÙÌËÁ ÏÚÎÁÞÁÅÔ, ÞÔÏ ÐÒÉ ËÏÐÉÒÏ×ÁÎÉÉ
  26      ÑÞÅÊËÉ ÅÅ ÓÓÙÌËÁ ÎÅ ÍÅÎÑÅÔÓÑ. ïÂÙÞÎÏ ÐÒÉ Á×ÔÏÚÁÐÏÌÎÅÎÉÉ ÒÑÄÁ ÑÞÅÅË
  27      ÉÌÉ ÐÅÒÅÍÅÝÅÎÉÉ ÑÞÅÊËÉ ÉÈ ÓÓÙÌËÉ ÍÅÎÑÀÔÓÑ ÔÁËÉÍ ÏÂÒÁÚÏÍ, ÞÔÏÂÙ ÏÎÉ ÓÏÈÒÁÎÉÌÉÓØ
  28      ÏÔÎÏÓÉÔÅÌØÎÏ ÉÓÈÏÄÎÏÊ ÑÞÅÊËÉ. ðÒÉ ÁÂÓÏÌÀÔÎÙÈ ÓÓÙÌËÁÈ ÐÏ×ÅÄÅÎÉÅ ÉÚÍÅÎÑÅÔÓÑ. </para>
  29
  30     <para>æÏÒÍÁÔ ÁÂÓÏÌÀÔÎÙÈ ÓÓÙÌÏË ÎÁ ÑÞÅÊËÉ ÉÓÐÏÌØÚÕÅÔ '$' × ÎÁÞÁÌÅ ËÏÏÒÄÉÎÁÔ
  31       ÑÞÅÊËÉ, ËÏÔÏÒÕÀ ÐÏÌØÚÏ×ÁÔÅÌØ ÈÏÞÅÔ ÓÄÅÌÁÔØ ÐÏÓÔÏÑÎÎÏÊ. óÔÏÌÂÅÃ, ÓÔÒÏËÁ, ÔÁÂÌÉÃÁ ÉÌÉ
  32       ÌÀÂÁÑ ÉÈ ËÏÍÂÉÎÁÃÉÑ ÍÏÖÅÔ ÂÙÔØ ÓÏÈÒÁÎÅÎÁ ÐÏÓÔÏÑÎÎÏÊ.</para>
  33
  34     <example id="cell-refer-absolute-reference">
  35       <title>ðÒÉÍÅÒ ÁÂÓÏÌÀÔÎÙÈ ÓÓÙÌÏË</title>
  36       <programlisting>
  37         A1          ïÂÙÞÎÁÑ ÓÓÙÌËÁ ÎÁ ÑÞÅÊËÕ
  38         $A2         óÏÈÒÁÎÉÔØ ÐÏÓÔÏÑÎÎÏÅ ÚÎÁÞÅÎÉÅ ÓÔÏÌÂÃÁ
  39         A$2         óÏÈÒÁÎÉÔØ ÐÏÓÔÏÑÎÎÏÅ ÚÎÁÞÅÎÉÅ ÓÔÒÏËÉ
  40         $A$2        óÏÈÒÁÎÉÔØ ÐÏÓÔÏÑÎÎÏÅ ÚÎÁÞÅÎÉÅ ÓÔÏÌÂÃÁ É ÓÔÒÏËÉ.
  41       </programlisting>
  42     </example>
  43
  44   </sect2>
  45
  46
  47   <sect2>
  48     <title>óÓÙÌËÁ ÎÁ ÇÒÕÐÐÕ ÑÞÅÅË</title>
  49
  50     <para>íÎÏÇÉÅ ÆÕÎËÃÉÉ ÍÏÇÕÔ ÐÒÉÎÉÍÁÔØ × ËÁÞÅÓÔ×Å ÁÒÇÕÍÅÎÔÁ ÎÅÓËÏÌØËÏ ÑÞÅÅË.
  51     üÔÏ ÍÏÖÅÔ ÂÙÔØ ÐÅÒÅÞÉÓÌÅÎÉÅ ÞÅÒÅÚ ÚÁÐÑÔÕÀ, ÍÁÓÓÉ× ÉÌÉ ÌÀÂÁÑ ËÏÍÂÉÎÁÃÉÑ.</para>
  52
  53     <sect3>
  54       <title>íÎÏÖÅÓÔ×Ï ÏÔÄÅÌØÎÙÈ ÑÞÅÅË</title>
  55
  56       <para>ðÅÒÅÞÉÓÌÅÎÉÅ ÓÓÙÌÏË ÎÁ ÑÞÅÊËÉ ÞÅÒÅÚ ÚÁÐÑÔÕÀ ÍÏÖÅÔ ÂÙÔØ ÉÓÐÏÌØÚÏ×ÁÎÏ
  57         ÄÌÑ ÕËÁÚÁÎÉÑ ÎÅ Ó×ÑÚÁÎÎÙÈ ÑÞÅÅË.</para>
  58
  59
  60       <example id="cellrefermutiplecells">
  61         <title>îÅËÏÔÏÒÙÅ ÐÒÉÍÅÒÙ ÓÉÎÔÁËÓÉÓÁ ÆÕÎËÃÉÊ</title>
  62         <programlisting>
  63           =SUM(A1,B2,C4)
  64
  65           =MIN(A1,B2, C4,C5,D6)
  66
  67         </programlisting>
  68       </example>
  69
  70
  71       <screenshot>
  72         <graphic fileref="images/cells-1.jpg"></graphic>
  73       </screenshot>
  74
  75         </sect3>
  76
  77     <sect3>
  78       <title>õËÁÚÁÎÉÅ Ó×ÑÚÁÎÎÏÊ ÏÂÌÁÓÔÉ ÑÞÅÅË</title>
  79
  80       <para>äÌÑ ÆÕÎËÃÉÊ, ËÏÔÏÒÙÅ ÐÒÉÎÉÍÁÀÔ ÂÏÌØÛÅ ÏÄÎÏÇÏ ÁÒÇÕÍÅÎÔÁ, ÞÁÓÔÏ
  81         ÌÅÇÞÅ ÕËÁÚÁÔØ ÑÞÅÊËÉ ËÁË ÇÒÕÐÐÕ. çÒÕÐÐÁ ÍÏÖÅÔ ×ËÌÀÞÁÔØ ÑÞÅÊËÉ
  82         ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏ ÒÁÓÐÏÌÏÖÅÎÎÙÅ ÐÏ ÇÏÒÉÚÏÎÔÁÌÉ, ÐÏ ×ÅÒÔÉËÁÌÉ ÉÌÉ × ÍÁÓÓÉ×Åts horizontally.</para>
  83
  84       <para>äÌÑ ÕËÁÚÁÎÉÑ ÄÉÁÐÁÚÏÎÁ ÑÞÅÅË ÉÓÐÏÌØÚÕÅÔÓÑ ÏÐÅÒÁÔÏÒ ':'. ïÓÎÏ×ÎÏÊ ÓÉÎÔÁËÓÉÓ
  85          "×ÅÒÈÎÉÊ ÌÅ×ÙÊ ÕÇÏÌ":"ÎÉÖÎÉÊ ÐÒÁ×ÙÊ ÕÇÏÌ". </para>
  86
  87       <example id="cellrefercontin">
  88         <title>õËÁÚÁÎÉÅ ÂÌÏËÁ ÑÞÅÅË</title>
  89         <programlisting>
  90           =SUM(A1:E1)
  91
  92           =AVERAGE(B4:E7)
  93
  94           =MIN(A1:A5)
  95         </programlisting>
  96       </example>
  97
  98
  99       <screenshot>
 100         <graphic fileref="images/cells-2.jpg"></graphic>
 101       </screenshot>
 102     </sect3>
 103
 104     <sect3>
 105       <title>õËÁÚÁÎÉÅ ÎÅÓ×ÑÚÁÎÎÏÊ ÏÂÌÁÓÔÉ ÑÞÅÅË</title>
 106
 107       <para>äÌÑ ÕËÁÚÁÎÉÑ ÑÞÅÅË ÒÁÓÐÏÌÏÖÅÎÎÙÈ × ÎÅÓ×ÑÚÁÎÎÏÊ ÏÂÌÁÓÔÉ,
 108             ÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ ÌÀÂÙÅ ËÏÍÂÉÎÁÃÉÉ ×ÙÛÅ ÐÅÒÅÞÉÓÌÅÎÎÙÈ ÍÅÔÏÄÏ×. </para>
 109
 110
 111           <example id="cellreferdiscontin">
 112         <title>õËÁÚÁÎÉÅ ÂÌÏËÁ ÑÞÅÅË</title>
 113         <programlisting>
 114           =SUM(A1:E1, B19, L14:L17)
 115
 116           =AVERAGE(A1,A3, A5:C5)
 117
 118         </programlisting>
 119       </example>
 120     </sect3>
 121   </sect2>
 122
 123   <sect2>
 124     <title>õËÁÚÁÎÉÅ ÑÞÅÅË × ÄÒÕÇÉÈ ÔÁÂÌÉÃÁÈ</title>
 125
 126     <para>íÏÖÎÏ ÓÓÙÌÁÔØÓÑ ÎÁ ÑÞÅÊËÉ, ËÏÔÏÒÙÅ ÎÅ Ñ×ÌÑÀÔÓÑ ÞÁÓÔØÀ
 127     ÔÅËÕÝÅÊ ÔÁÂÌÉÃÙ. üÔÏ ÄÅÌÁÅÔÓÑ Ó ÉÓÐÏÌØÚÏ×ÁÎÉÅÍ ÓÉÎÔÁËÓÉÓÁ
 128     éíñ!ñþåêëá, ÇÄÅ éíñ ÜÔÏ ÉÄÅÎÔÉÆÉËÁÔÏÒ (ÏÂÙÞÎÏ ÎÁÚ×ÁÎÉÅ ÔÁÂÌÉÃÙ)
 129     É ñþåêëá - ÜÔÏ ÏÂÙÞÎÁÑ ÓÓÙÌËÁ ÎÁ ÑÞÅÊËÕ ËÁË ÏÐÉÓÁÎÏ × ÐÒÅÄÙÄÕÝÉÈ
 130     ÐÁÒÁÇÒÁÆÁÈ.</para>
 131
 132     <para>úÁÍÅÔØÔÅ, ÞÔÏ ÅÓÌÉ éíñ ÓÏÄÅÒÖÉÔ ÐÒÏÂÅÌÙ, ÔÏ ×ÁÍ ÎÁÄÏ ×ÚÑÔØ ÅÇÏ
 133     × ËÁ×ÙÞËÉ, ÞÔÏÂÙ ÐÏÚ×ÏÌÉÔØ Gnumeric ÓÇÒÕÐÐÉÒÏ×ÁÔØ ÏÔÄÅÌØÎÙÅ ÓÌÏ×Á × éíåîé
 134     ËÁË ÐÒÏÓÔÏÅ ÉÍÑ.  îÁÐÒÉÍÅÒ, ×Ù ÄÏÌÖÎÙ ÉÓÐÏÌØÚÏ×ÁÔØ "ôÁÂÌÉÃÁ 0" ËÏÇÄÁ
 135     ÓÓÙÌÁÅÔÅÓØ ÎÁ ÓÏÚÄÁ×ÁÅÍÕÀ ÐÏ ÕÍÏÌÞÁÎÉÀ "ôÁÂÌÉÃÕ 0".</para>
 136
 137     <example id="simple-sheet-ref">
 138       <title>õËÁÚÁÎÉÅ ÚÎÁÞÅÎÉÊ × ÄÒÕÇÉÈ ÔÁÂÌÉÃÁÈ</title>
 139       <programlisting>
 140         ='ôÁÂÌÉÃÁ 0'!A1+'ôÁÂÌÉÃÁ 3'!A5
 141
 142         =SUM('ôÁÂÌÉÃÁ 1'!A1:'ôÁÂÌÉÃÁ 1'!A5)
 143       </programlisting>
 144     </example>
 145
 146   </sect2>
 147 </sect1>
 148
 149
 150 <!-- Keep this comment at the end of the file
 151 Local variables:
 152 mode: sgml
 153 sgml-omittag:t
 154 sgml-shorttag:t
 155 sgml-minimize-attributes:nil
 156 sgml-always-quote-attributes:t
 157 sgml-indent-step:2
 158 sgml-indent-data:t
 159 sgml-parent-document:nil
 160 sgml-exposed-tags:nil
 161 sgml-local-catalogs:nil
 162 sgml-local-ecat-files:nil
 163 End:
 164 -->