<html><head><meta name="color-scheme" content="light dark"></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">%% 
%%  A DANTE-Edition example
%% 
%%  Beispiel 06-00-40 auf Seite 205.
%% 
%%  Copyright (C) 2010 H. Voss
%% 
%%  It may be distributed and/or modified under the conditions
%%  of the LaTeX Project Public License, either version 1.3
%%  of this license or (at your option) any later version.
%% 
%%  See http://www.latex-project.org/lppl.txt for details.
%% 

%%Run also: &gt;&gt;  &lt;&lt; 
% Show page(s) 1

\documentclass[]{article}
\pagestyle{empty}
\setlength\textwidth{355.65944pt}
\usepackage[utf8]{inputenc}
\usepackage[ngerman]{babel}

\usepackage{tabularx,numprint,spreadtab}

\begin{document}
\nprounddigits2
\begin{spreadtab}{{tabularx}{0.8\linewidth}{|
  &gt;{\rule[-1.2ex]{0pt}{4ex}}X &gt;{{\bfseries}}N42
  &gt;{\bfseries}c N42 &gt;{\bfseries}c N42|}}\hline
@Pos. &amp; @\multicolumn{1}{c}{Preis/Einh.} &amp; @\multicolumn{1}{c}{Anzahl} &amp;
@\multicolumn{1}{c}{Preis} &amp; @\multicolumn{1}{c}{Rabatt} &amp; @\textbf{Netto}\\\hline
@1 &amp; 5.99 &amp; 20 &amp; [-2,0]*[-1,0] &amp; $-:={20}\%$ &amp; [-2,0]*(1-[-1,0]/100)\\
@2 &amp; 12   &amp; 7  &amp; [-2,0]*[-1,0] &amp; $-:={10}\%$ &amp; [-2,0]*(1-[-1,0]/100)\\
@3 &amp; 4.50 &amp; 40 &amp; [-2,0]*[-1,0] &amp; $-:={35}\%$ &amp; [-2,0]*(1-[-1,0]/100)\\
@4 &amp; 650  &amp; 2  &amp; [-2,0]*[-1,0] &amp; $-:={15}\%$ &amp; [-2,0]*(1-[-1,0]/100)\\\hline
@\multicolumn{6}{c}{\vspace{-1.5ex}}\\\cline{4-6}
@\multicolumn{1}{c}{\rule[-1.2ex]{0pt}{4ex}} &amp;
@\multicolumn{2}{r|}{Summe} &amp; sum(d2:[0,-2])
  &amp; \multicolumn{1}{c}{$:={round(([1,0]/[-1,0]-1)*100,0)}\%$}
  &amp; {\bfseries}:={sum(f2:[0,-2])}\\\cline{4-6}
@\multicolumn{3}{r|}{} &amp; @\multicolumn{1}{r}{\textbf{MWSt}} &amp; @ 19\%
  &amp; {\bfseries}:={[0,-1]*0.19}\\\cline{4-6}
@\multicolumn{3}{r|}{} &amp;
@\multicolumn{2}{r}{\textbf{Endsumme}} &amp; {\bfseries}:={[0,-2]+[0,-1]}\\\cline{4-6}
\end{spreadtab}
\end{document}
</pre></body></html>