diff options
Diffstat (limited to 'Master/texmf-dist/doc/latex')
| -rw-r--r-- | Master/texmf-dist/doc/latex/spreadtab/README | 4 | ||||
| -rw-r--r-- | Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.pdf | bin | 768434 -> 770610 bytes | |||
| -rw-r--r-- | Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.tex | 19 | ||||
| -rw-r--r-- | Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.pdf | bin | 802544 -> 805275 bytes | |||
| -rw-r--r-- | Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.tex | 20 |
5 files changed, 39 insertions, 4 deletions
diff --git a/Master/texmf-dist/doc/latex/spreadtab/README b/Master/texmf-dist/doc/latex/spreadtab/README index 88f7329b6f7..d974dae7693 100644 --- a/Master/texmf-dist/doc/latex/spreadtab/README +++ b/Master/texmf-dist/doc/latex/spreadtab/README @@ -1,8 +1,8 @@ _____________________ spreadtab package - v0.3a - 2010/05/15 + v0.3b + 2010/06/06 _____________________ This package provides spreadsheet features for LaTeX table environments. diff --git a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.pdf b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.pdf Binary files differindex 02881028218..2cac0295c12 100644 --- a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.pdf +++ b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.pdf diff --git a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.tex b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.tex index 9cbde6945eb..aaa0398f468 100644 --- a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.tex +++ b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_en.tex @@ -69,7 +69,7 @@ numbersep=1em,classoffset=1,% morekeywords={% les macros et commandes de spreadtab spreadtab,SThiderow,SThidecol,STsavecell,STautoround,STmessage,STsetdecimalsep,STtransposecar,STdebug,STdisplaytab,STsetdisplaymarks,% - STnumericfieldmarker,STtextcell,STcopy,fact,ifeq,ifgt,iflt,numtofrshortdate,% + STnumericfieldmarker,STtextcell,STcopy,id,fact,ifeq,ifgt,iflt,numtofrshortdate,% numtoengshortdate,numtofrlongdate,numtoenglongdate,numtofrmonth,% numtoengmonth,numtofrday,numtoengday,sum,rand,randint,sumprod,% frshortdatetonum,engshortdatetonum,englongdatetonum,frlongdatetonum,gcd,lcm},% @@ -906,6 +906,23 @@ Example : \end{spreadtab} \end{center} +\subsubsection{Identity} +The simplest macro functions is "\verbinline=id(<number>)=". It returns the number in its argument. Mathematically, it is not very usefull, but with \ST, it makes possible to write mathematical expressions in arguments of macro function where they are not allowed. In the argument of \verbinline=sum= for example. + +In the code below, the \verbinline-id- macro function is used to compute the range of cell to add with \verbinline-sum-. In this example, the numeric field of the cell "a2" contains 8. Therefore, "\verbinline=sum([0,-1]:[id(a2-1),-1])/a2=" is equivalent to \verbinline=sum([0,-1]:[7,-1])/8=: +\begin{lstlisting} +\begin{spreadtab}{{tabular}{r*{10}c}} + @Integers & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10\\ +Mean of the :={8} first integers & sum([0,-1]:[id(a2-1),-1])/a2 \\ +\end{spreadtab} +\end{lstlisting} +\begin{center} +\begin{spreadtab}{{tabular}{r*{10}c}} + @Integers & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10\\ +Mean of the :={8} first integers & sum([0,-1]:[id(a2-1),-1])/a2 \\ +\end{spreadtab} +\end{center} + \subsection{Tests} Three macro-functions provide tests:\par\nobreak \begin{center} diff --git a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.pdf b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.pdf Binary files differindex 2ba2f35c977..4da9abbdcd0 100644 --- a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.pdf +++ b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.pdf diff --git a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.tex b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.tex index 67ff436c8a6..ec155119bd1 100644 --- a/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.tex +++ b/Master/texmf-dist/doc/latex/spreadtab/spreadtab_doc_fr.tex @@ -70,7 +70,7 @@ numbersep=1em,classoffset=1,% morekeywords={% les macros et commandes de spreadtab spreadtab,SThiderow,SThidecol,STsavecell,STautoround,STmessage,STsetdecimalsep,STtransposecar,STdebug,STdisplaytab,STsetdisplaymarks,% - STnumericfieldmarker,STtextcell,STcopy,fact,ifeq,ifgt,iflt,numtofrshortdate,% + STnumericfieldmarker,STtextcell,STcopy,fact,id,ifeq,ifgt,iflt,numtofrshortdate,% numtoengshortdate,numtofrlongdate,numtoenglongdate,numtofrmonth,% numtoengmonth,numtofrday,numtoengday,sum,rand,randint,sumprod,% frshortdatetonum,engshortdatetonum,englongdatetonum,frlongdatetonum,gcd,lcm},% @@ -906,6 +906,24 @@ Exemple : \end{spreadtab} \end{center} +\subsubsection{Identité} +La plus simple des macros fonctions est \og\verbinline=id(<nombre>)=\fg. Celle-ci renvoie le nombre qui se trouve entre parenthèses. Mathématiquement, elle ne sert pas à grand chose, mais avec \ST, elle permet de passer des expressions mathématiques à des macros qui n'en admettent pas. On peut ainsi s'en servir dans les plages de cellules de \verbinline=sum= par exemple. + +Dans le code ci dessous, la macro \verbinline=id= est utilisée pour déterminer la plage de cellules à additionner avec \verbinline-sum-. Dans cet exemple, la valeur du champ numérique de la cellule a2 vaut 8. Par conséquent, "\verbinline=sum([0,-1]:[id(a2-1),-1])/a2=" est équivalent à \verbinline=sum([0,-1]:[7,-1])/8= : + +\begin{lstlisting} +\begin{spreadtab}{{tabular}{r*{10}c}} + @Entiers & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10\\ +Moyenne des :={8} premiers entiers & sum([0,-1]:[id(a2-1),-1])/a2 \\ +\end{spreadtab} +\end{lstlisting} +\begin{center} +\begin{spreadtab}{{tabular}{r*{10}c}} + @Entiers & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10\\ +Moyenne des :={8} premiers entiers & sum([0,-1]:[id(a2-1),-1])/a2 \\ +\end{spreadtab} +\end{center} + \subsection{Macro-fonctions de test} Elles sont au nombre de 3 et ont la syntaxe suivante :\par\nobreak \begin{center} |