TeX - LaTeX Stack Exchange
TeX - LaTeX Stack Exchange

Questions tagged [spreadtab]

{spreadtab} is a package designed for constructing tables in a spreadsheet-like manner. This tag should only be used for questions pertaining to the use of the {spreadtab} package.

is a package designed for constructing tables in a spreadsheet-like manner. One of the functionalities of the package is that it automatically assigns row and column indices to the entries in the table, and allows the user to use these indices to perform calculations in other table cells.

An example from the package documentation:

\begin{spreadtab}{{tabular}{rr|r}}
22 & 54 & a1+b1 \\
43 & 65 & a2+b2 \\
49 & 37 & a3+b3 \\
\hline
a1+a2+a3 & b1+b2+b3 & a4+b4
\end{spreadtab}
57 questions
6
votes
0 answers

spreadtab: column as text

In the following example I marked all entries in the first column as text: \documentclass{article} \usepackage[T1]{fontenc} \usepackage[utf8]{inputenc} \usepackage{spreadtab} \begin{document} \begin{spreadtab}{{tabular}{@{}cr@{}}} @2017-04-30 & 120…
rolfn
  • 939
  • 4
  • 13
4
votes
1 answer

Could spreadtab save state to file between compilations?

I recently started using the spreadtab package. This generally works well, but it has the following limitation, and probably other similar ones. If one is tagging a cell (using tag), and then wants to reference the tagged value (using value), the…
Faheem Mitha
  • 7,778
3
votes
1 answer

STcopy adds redundant whitespace

I use spreadtab with STcopy. For some reason, there is redundant whitespace at the left of the table. Here is a minimal working example: \documentclass{standalone} \usepackage{spreadtab} …
Erel Segal-Halevi
  • 6,161
2
votes
1 answer

Formatting a cell in SpreadTab

I am using the spreadtab package to create a table that shows a recurrence relation: \begin{spreadtab}{{tabular}{>{\headingstyle}c|cccccccccc}} @ $r\downarrow ~ s \rightarrow$ & 0 & [-1,0]+1 & [-1,0]+1 & [-1,0]+1 & [-1,0]+1 & [-1,0]+1 &…
Erel Segal-Halevi
  • 6,161
2
votes
0 answers

New environment based on spreadtab

I have a spreadtab with a rather complex header and footer that is used at several places in my document. The actual content consists of only a few simple lines. I would like to define a new environment (or macro), so that I do not have to repeat…
tim
  • 501
1
vote
1 answer

Spreadtab and newcommand

I'm trying to achieve this kind of thing : \newcommand{\test}[2]{#1 & :={#2} € & :={[-2,0] * [-1,0]} € \\} \begin{spreadtab}{{tabularx}{\textwidth}{|X|r|r|}} @ Col 1 & @ Col 2 & @ Col 3…
Guildem
  • 113
1
vote
1 answer

spreadtab not producing desired result

I'm using class beamer and package spreadtab. First frame works well, sum(cell(aaf):cell(aal)) gives output. Second frame: sum(cell(ccf):cell(ccl)) gives…
sandu
  • 7,950
1
vote
1 answer

spreadtab summing columns without manual counting?

I'm using spreadtab to calculate a single column of integers in a table. As in this sample I calculate sums by counting the lines manually. Is there any possibility to count the lines programmaticaly so the b4can be updated automatically when Ii add…
novski
  • 1,039
0
votes
0 answers

Color Text vs. SpreadTab

Is it possible change the text color on spreadtab? All text is black and I would like change it to another color like yellow or red. May anyone help me? Thanks in advance.
Angelo Longo
  • 1
0
votes
1 answer

Summation of only numbers in spreadtab package

I recently discovered the spreadtab package since I needed some spreadsheets with some calculations. I would like to produce a LaTeX file with the grades of my students, i. e. something like this (eight problems 10 points each and the total sum).…
richrow
  • 309