.gnumeric: For clipboards, send also result values.

[gnumeric.git] / doc / ja / cell_refer.sgml

<sect1 id="cell-referencing">
        <title>
        ¥»¥ë»²¾È
        </title>

<para>
ñ°ì¤Î¥»¥ë¡¢¤¿¤È¤¨¤Ð¥»¥ë B1 ¤ËÊݸ¤µ¤ì¤¿Ãͤϡ¢´Ø¿ô¤Î°ú¿ô¤È¤·¤Æ B1 ¤ÈÆþÎϤ¹¤ë¤À¤±¤Ç»²¾È¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
</para>
  
<para>
¥»¥ë¤Ï C4 ¤Ê¤É¤Î¥Õ¥©¡¼¥Þ¥Ã¥È¤Ç»²¾È¤µ¤ì¤Þ¤¹¤¬¡¢¤³¤Î¡ÖC¡×¤ÏÎó¥é¥Ù¥ë¡¢¡Ö4¡×¤Ï¹Ô¥é¥Ù¥ë¤Ç¤¹¡£
</para>
  
<example id="simplecellrefer">
        <title>
        ´Ø¿ô¥·¥ó¥¿¥Ã¥¯¥¹¤ÎÎã
        </title>

        <programlisting>
      =EXP(B1)
      
      =COS(A2)
      
        </programlisting>
</example>

<sect2>
        <title>
        ÀäÂÐ¥»¥ë»²¾È
        </title>

<para>
¥»¥ë¤ò»²¾È¤¹¤ë¤Ë¤Ï¡¢¥Ç¥Õ¥©¥ë¥È¤ÎÊýË¡¡ÊÁêÂл²¾È¡Ë¤âÀäÂл²¾È¤â»È¤¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£ÀäÂл²¾È¤È¤Ï¡¢¥³¥Ô¡¼¤·¤Æ¤â¥»¥ë»²¾È¤¬Êѹ¹¤µ¤ì¤Ê¤¤¤³¤È¤ò°ÕÌ£¤·¤Þ¤¹¡£Ä̾ï¤Ï¡¢¥»¥ëÈϰϤò¥ª¡¼¥È¥Õ¥£¥ë¤·¤¿¤ê¡¢¥»¥ë¤ò°ÜÆ°¤·¤¿¤ê¤¹¤ë¤È¡¢¸µ¤Î¥»¥ë¤È¤Î´Ø·¸¤¬°Ý»ý¤µ¤ì¤ë¤è¤¦¤Ë¡¢¥»¥ë»²¾È¤¬Êѹ¹¤µ¤ì¤Þ¤¹¡£¥»¥ë¤òÀäÂл²¾È¤·¤¿¾ì¹ç¤Ï¡¢¤³¤ÎµóÆ°¤Ï̵¸ú¤Ë¤Ê¤ê¤Þ¤¹¡£
</para>

<para>
¥»¥ë¤òÀäÂл²¾È¤¹¤ë¾ì¹ç¤Ï¡¢¥æ¡¼¥¶¤¬°ìÄê¤Ë¤·¤Æ¤ª¤­¤¿¤¤¤È¹Í¤¨¤ë¥»¥ëºÂɸ¤ÎÁ°¤Ë¡Ö$¡×¤ò¤Ä¤±¤ë¥Õ¥©¡¼¥Þ¥Ã¥È¤ò»È¤¤¤Þ¤¹¡£¤¹¤ë¤È¡¢Îó¡¢¹Ô¡¢¥·¡¼¥È¡¢¤¢¤ë¤¤¤Ï¤½¤ì¤é¤ÎÁȤ߹ç¤ï¤»¤Ï°ìÄê¤È¤Ê¤ê¤Þ¤¹¡£
</para>

<example id="cell-refer-absolute-reference">
        <title>
        ÀäÂÐ¥»¥ë»²¾È¤ÎÎã
        </title>

        <programlisting>
        A1          °ìÈÌŪ¤Ê¤Î¥»¥ë»²¾È
        $A2         Îó¸ÇÄê¤Î¥»¥ë»²¾È
        A$2         ¹Ô¸ÇÄê¤Î¥»¥ë»²¾È
        $A$2        Îó¤È¹Ô¤ÎξÊý¤ò¸ÇÄꤷ¤¿¥»¥ë»²¾È
        </programlisting>
</example>

</sect2>

<sect2>
        <title>
        Ê£¿ô¤Î¥»¥ë¤Î»²¾È
        </title>

<para>
Ê£¿ô¤Î¥»¥ë¤ò°ú¿ô¤È¤¹¤ë´Ø¿ô¤Ï¿ô¿¤¯¤¢¤ê¤Þ¤¹¡£¤¿¤È¤¨¤Ð¡¢¥³¥ó¥Þ¤Ç¶èÀÚ¤é¤ì¤¿¥ê¥¹¥È¡¢ÇÛÎ󡢤¢¤ë¤¤¤Ï¤½¤ì¤é¤ÎÁȤ߹ç¤ï¤»¤ò°ú¿ô¤È¤¹¤ë´Ø¿ô¤Ç¤¹¡£
</para>

<sect3>
        <title>
        ÆÈΩ¤·¤¿Ê£¿ô¤Î¥»¥ë¤Î½¸¤Þ¤ê
        </title>

<para>
¥³¥ó¥Þ¤Ç¶èÀÚ¤é¤ì¤¿¥»¥ë»²¾È¤Î¥ê¥¹¥È¤Ï¡¢ÉÔϢ³¤Î¥»¥ë¤ò»Ø¤·¼¨¤¹¤Î¤Ë»È¤¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
</para>

<example id="cellrefermutiplecells">
        <title>
        ´Ø¿ô¥·¥ó¥¿¥Ã¥¯¥¹¤ÎÎã
        </title>

        <programlisting>
          =SUM(A1,B2,C4)
          
          =MIN(A1,B2,C4,C5,D6)
          
        </programlisting>
</example>

        <screenshot>
        <graphic fileref="images/cells-1.jpg"></graphic>
        </screenshot>

</sect3>

<sect3>
        <title>
        Ϣ³¤·¤¿¥»¥ëÎΰè¤Î»²¾È
        </title>
      
<para>
Ê£¿ô¤Î°ú¿ô¤ò¼õ¤±¼è¤ë´Ø¿ô¤Î¾ì¹ç¤Ï¡¢¥»¥ë¤ò°ì¤Ä¤Î½¸¹ç¤È¤·¤Æ»²¾È¤¹¤ëÊý¤¬´Êñ¤Ê¾ì¹ç¤¬Â¿¤¯¤¢¤ê¤Þ¤¹¡£¤½¤Î¤è¤¦¤Ê½¸¹ç¤Ï¡¢½Ä¤¢¤ë¤¤¤Ï²£¤Î¥»¥Ã¥È¤Î¾ì¹ç¤â¤¢¤ì¤ÐÇÛÎó¤Î¾ì¹ç¤â¤¢¤ê¤Þ¤¹¡£
</para>
      
<para>
±é»»»Ò¡Ö:¡×¤Ï¥»¥ëÈϰϤò¼¨¤¹¤È¤­¤Ë»È¤ï¤ì¤Þ¤¹¡£´ðËܤΥ·¥ó¥¿¥Ã¥¯¥¹¤Ï¡¢¡Öº¸¾å¥³¡¼¥Ê¡¼¡§±¦²¼¥³¡¼¥Ê¡¼¡×¤Î·Á¤Ç¤¹¡£
</para>

<example id="cellrefercontin">
        <title>
        ¥»¥ë¥Ö¥í¥Ã¥¯¤Î»²¾È
        </title>

        <programlisting>
          =SUM(A1:E1)
          
          =AVERAGE(B4:E7)
          
          =MIN(A1:A5)            
        </programlisting>
</example>

<screenshot>
        <graphic fileref="images/cells-2.jpg"></graphic>
</screenshot>
</sect3>

<sect3>
        <title>
        ÉÔϢ³¤ÊÈϰϤˤ¢¤ë¥»¥ë¤Î»²¾È
        </title>

<para>
ÉÔϢ³¤ÊÈϰϤˤ¢¤ë¥»¥ë¤ò»²¾È¤¹¤ë¾ì¹ç¤Ï¡¢¾åµ­¤ÎÊýË¡¤òǤ°Õ¤ËÁȤ߹ç¤ï¤»¤ÆɬÍפʥ»¥ë¤ò¼èÆÀ¤·¤Þ¤¹¡£
</para>

<example id="cellreferdiscontin">
        <title>
        ÉÔϢ³¤Ê¥»¥ëÈϰϤλ²¾È
        </title>

        <programlisting>
          =SUM(A1:E1, B19, L14:L17)
          
          =AVERAGE(A1,A3, A5:C5)
          
        </programlisting>
</example>

</sect3>

</sect2>

<sect2>
        <title>
        ¾¤Î¥·¡¼¥È¤Î¥»¥ë¤Î»²¾È
        </title>

<para>
¥«¥ì¥ó¥È¡¦¥·¡¼¥È¤Ë¤Ï¸ºß¤·¤Ê¤¤¥»¥ë¤ò»²¾È¤¹¤ë¤³¤È¤â²Äǽ¤Ç¤¹¡£¤³¤ì¤Ï¡¢NAME ! CELL¤È¤¤¤¦¥·¥ó¥¿¥Ã¥¯¥¹¤ò»È¤Ã¤Æ»²¾È¤·¤Þ¤¹¤¬¡¢NAME ¤Ï¼±Ê̻ҡÊÄ̾ï¤Ï¥·¡¼¥È̾¡Ë¤Ç CELL ¤ÏÁ°¹à¤ÇÀâÌÀ¤·¤¿Ä̾ï¤Î¥»¥ë»²¾È¤Ç¤¹¡£
</para>

<para>
NAME ¤Ë¥¹¥Ú¡¼¥¹¤¬´Þ¤Þ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢¤½¤Î NAME Á´ÂΤò°úÍѤ·¤Ê¤¤¸Â¤ê¡¢NAME Ãæ¤Î¤¤¤í¤¤¤í¤Ê¸ì¤ò°ì¤Ä¤Î̾Á°¤È¤·¤Æ Gnumeric ¤Ëǧ¼±¤µ¤»¤ë¤³¤È¤¬¤Ç¤­¤Þ¤»¤ó¡£¤¿¤È¤¨¤Ð¡¢¥Ç¥Õ¥©¥ë¥È¤ÇºîÀ®¤·¤¿¡ÖSheet 0¡×¤ò»²¾È¤¹¤ë¾ì¹ç¤Ï¡¢"Sheet 0"¤ò»È¤¦É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
</para>

<example id="simple-sheet-ref">
        <title>
        ¾¤Î¥·¡¼¥È¤Ë¤¢¤ëÃͤλ²¾È
        </title>

        <programlisting>
        ='Sheet 0'!A1+'Sheet 3'!A5

        =SUM('Sheet 1'!A1:'Sheet 1'!A5)
        </programlisting>
</example>

</sect2>

</sect1>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:2
sgml-indent-data:t
sgml-parent-document:nil
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
-->