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.
63
questions
1
vote
1
answer
51
views
spreadtab & odsfile : TeX capacity exceeded, sorry [parameter stack size=20000]
I'm trying to use the package spreadtab to make a template for the \includespread command provided by the odsfile package (https://www.ctan.org/tex-archive/macros/luatex/latex/odsfile), but I get this ...
- 21
2
votes
0
answers
26
views
How can I use a tagged value earlier in the document using spreadtab?
I wonder whether I can create a table using spreadtab, calculate the sum of some floating number to display in the last row, and save that sum to be used in another spreadtab table earlier on in the ...
- 219
1
vote
1
answer
78
views
Why can I not specify the key "guard" only in the \SetTblrInner command using tabularray?
My goal
I wanted to make a document with some bookkeeping tables.
I figured having automatic summing etc. would be nice, so I resorted to the use of the spreadtab package. For colored rows etc. I ...
- 219
1
vote
1
answer
39
views
How to add more space after prepended symbol in a table using siunitx in a tabularray?
My goal
I wanted to make a document with some bookkeeping tables. I figured having automatic summing etc. would be nice, so I resorted to the use of the spreadtab package. For colored rows etc. I ...
- 219
0
votes
1
answer
39
views
How to remove prepended symbol in entire column from header row using tabularray?
My goal
I wanted to make a document with some bookkeeping tables. I figured having automatic summing etc. would be nice, so I resorted to the use of the spreadtab package. For colored rows etc. I ...
- 219
0
votes
0
answers
18
views
Vertical centering of cells in a spreadtab environment
I'm trying to correctly align vertically all the cells in the following table created with the spreadtab environment that I need because I need to do both calculations and cross referencing with ...
- 167
1
vote
1
answer
34
views
Analyze number of spreadtab rows for conditionally changing text elements in the document
again I need your help. I'm writing my invoices for my small music busines with LATEX scrlttr2 and with a spreadtab-tables. It is working very well, but I want to have an automatic selection of some ...
- 249
0
votes
0
answers
56
views
Spreadtable bug \ST@after@ref@found
Tried to compile an old, once working document, but a bug popped out.
Took an example from the documentation, but the bug showed up. I use TexLive2023, I update it regularly
\documentclass[]{article}
...
- 5,630
0
votes
1
answer
31
views
Adressing numeric field with newcommand within spreadtab [duplicate]
I am using a spreadtab environment in a document to display a table with calculations. Since the commands are repeated for each row, I want to define a command via \newcommand that represents one row ...
- 249
0
votes
0
answers
50
views
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.
1
vote
1
answer
117
views
Colorcells and Rowcolor in spreadtab
I wonder how to add some colorcell, rowcolor and so on in this type of table
\documentclass[a4paper,14pt]{extreport}
\usepackage{spreadtab}
\begin{document}
\begin{spreadtab}{{tabular}{|c|c|c|...
- 3,058
0
votes
1
answer
130
views
Placing symbols into spreadtab
I am quite new for the spreadtab package. I have prepared a MWE for my issues as:
\documentclass[handout]{beamer}
\usepackage{spreadtab}
%\input{diagrams}
\newcommand\dollarsign{\$}
\begin{document}
\...
- 160
2
votes
1
answer
135
views
merge many txt to one
There are plenty of .txt files and I try to figure a way in Latex to merge all *.txt to one *.txt. I thought about \newread and \newwrite but I don't know if there is a better way or how to start.
the ...
- 143
0
votes
1
answer
51
views
I can't transfer different information form tables to other tables
I use this code and I want to collect the Information form the different tables in one table. so I put tag in the different tables and in the last table I use \STtag but I get this error:Package ...
- 143
3
votes
3
answers
378
views
TeX capacity exceeded with several \input in a spreadtab
I use several \input in a spreadtab using the method from this answer in my document until I got this error:
TeX capacity exceeded, sorry [text input levels=15].
I read in the Internet that I can ...
- 143
0
votes
1
answer
95
views
Import tex data in a spreadtab table with this structure
I want to import a products.tex in a spreadtab. The content of the products.tex is
@ Plant & 1 & 60 & 2 & 77 \\
@ Book & 2 & 90 & 4 & 64 \\
@ Other & 3 & ...
- 143
1
vote
0
answers
56
views
how to import many input in spreadtab table [duplicate]
\documentclass{article}
\begin{filecontents*}{products.tex}
@ Plant & 60 & 2 \\
@ Book & 90 & 4 \\
@ Other & 100 & 10 \\
\end{filecontents*}
\usepackage{...
- 143
0
votes
1
answer
45
views
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 (...
- 319
1
vote
1
answer
152
views
When bolding a spreadtab calculation, how to make spreadtab and siunitx coexist happily?
I can't find a way to fix this annoying corner case.
In this example, spreadtab gives the value for cell(foo)+cell(bar) correctly, but siunitx does not do its thing if \bfseries is being used in that ...
- 7,848
0
votes
2
answers
86
views
Converting nested tables to use with spreadtab gives errors
The following example code consists of two tables. The first compiles, the second does not. Both these tables use sinunitx. The second one uses spreadtab.
The second table is the same as the first ...
- 7,848
4
votes
1
answer
73
views
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 ...
- 7,848
0
votes
1
answer
234
views
Applying rowcolor to tabularx in spreadtab causes "TeX capacity exceeded" error
Trying to apply \rowcolor{gray} to a specific row of a tabularx table whose values are calculated from spreadtab causes the famous error
TeX capacity exceeded, sorry [parameter stack size=10000].
...
- 7,329
1
vote
1
answer
62
views
Fill spreadtab with key value command
In this question, there are three answers to build a tabular from a key value command.
How to build a spreadtab with the same key value in order to be able to sum up columnwise (with a tag to reuse ...
- 5,301
2
votes
1
answer
54
views
gcd in spreadtab error
why wont my code work? I get up to 22 errow massages
\documentclass{article}
\usepackage[utf8]{inputenc}
\usepackage{dcolumn}
\usepackage{spreadtab}
\usepackage{siunitx}
\usepackage{mathtools}
\...
- 359
2
votes
1
answer
135
views
Spreadtab and datatool
I would like to use the spreadtab package in combination with datatool to make calculations within a table. The data is coming from an external file; here is an example (scores.csv):
FirstName,...
- 31
1
vote
1
answer
170
views
Can't split spreadtab longtable using \newcommand
Check this example (using packages longtable and spreadtab) that has zeroed out rows at the beginning and at the end. These two rows are made invisible by \phantom and are moved up by [-6.9mm] at the ...
- 3,583
4
votes
2
answers
754
views
Values in a table, or spreadtab table, given to 2 decimal places
I am developing a simple cash book on latex using spreadtab. How would I ensure that the Cost column always gives the value to 2 decimal places (it represents money). I would like the British format ...
- 189
1
vote
1
answer
191
views
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 & @ ...
- 113
1
vote
1
answer
71
views
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 error.
MWE:
\documentclass{beamer}
\...
- 8,012
1
vote
1
answer
347
views
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 ...
- 1,059
2
votes
1
answer
140
views
Using @{} in multicolumn in spreadtab
I want to be able to run this:
\documentclass{report}
\usepackage{spreadtab}
\begin{document}
\begin{spreadtab}{{tabular}{@{}ll@{}}}
@Test & 1234\\
\multicolumn{2}{@{}l@{}}{@...
- 439
3
votes
1
answer
71
views
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}
\begin{...
- 6,231
1
vote
1
answer
146
views
LATEX : save the value of a cell in Tabular
This question may seem very simple but I didn't find a solution!
I have a table with some values. Among these values, I want to save some of them to re-use them in a table that summarizes few tables.
...
- 113
2
votes
1
answer
275
views
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 & ...
- 6,231
0
votes
0
answers
67
views
Copy value from one spreadtab to another
I have two tables. The first only does calculations with spreadtab and has some final result that I tag (with spreadtab's ommand tab). Later, I want to reuse the value in another spreadtab, but I do ...
- 1,822
1
vote
1
answer
199
views
Conditional summation in spreadtab
I have a table with a column contains some numbers, positive and negative ones.
I want to make a summation of positive and negative numbers separately, but I don't want to mention the cell addresses ...
- 2,424
1
vote
1
answer
233
views
calculate tables [closed]
I have two tables which look like this
\begin{table}[h!]
\centering
\begin{spreadtab}{{tabular}{|c|>{\centering}p{8.5cm}|c|}}
\hline
@Datum & @Tätigkeit & @Zeitaufwand [h] \\
...
- 11
1
vote
1
answer
71
views
How to prevent `tabularx` run a macro in trial runs?
By the following code I can set some tags in table's rows, and keep track of the desired rows in a macro.
\documentclass{article}
\usepackage{spreadtab}
\usepackage{array}
\usepackage{etoolbox}
\...
- 2,424
1
vote
1
answer
126
views
\label{tab:a} does not show in listoftables but in listoffigures
I have a table made with spreadtab that does not show in the list of Tables but, instead, in the List of Figures. I don't know how to solve that.
this is a MWE that behaves wrong:
\documentclass{...
- 1,059
3
votes
1
answer
367
views
Colored elements in spreadtab table have a problem with package siunitx
I want to have a table for a Newton-Iteration. The first and the last value should be colored. So I tried the following code, and it works. But the colored numbers are not correctly set and table-...
user139826
2
votes
1
answer
600
views
Too much whitespace in a table with spreadtab and unitx S
i made a table where latex creates a big white-space between 2nd and 3rd column. Is there a way to force latex to reduce the width or to let it choose a better width by itself? The numbers themselves ...
- 23
0
votes
0
answers
219
views
How to use spreadtab inside form for this type of tabular?
I would like to automate the column total using spreadtab in the table but couldn't do. Please help.
\documentclass[12pt,a4paper,landscape]{article}
\usepackage[left=0.75in,right=0.75in,top=0....
- 489
6
votes
0
answers
184
views
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{...
- 949
7
votes
2
answers
1k
views
How to count the occurence of M and F in a particular column , No. of male and female deaths?
how to command LaTeX to count occurence of M and F in a particular column of a table from first row to last row of a particular column? And also the number of Male Deaths and Number of Female Deaths,
...
- 3,310
2
votes
1
answer
263
views
spreadtab \newline in @longtext does not work
I can't find it in the manual or elsewhere.
How can I make a linebreak like \\ or \newline in spreadtab tables text (@longtext sentences) cells?
Edit providing a MWE:
\documentclass[a4paper]{...
- 1,059
3
votes
1
answer
253
views
Spreadtab in new environment
I want to use spreadtab in newenvironment and wrote this code.
The problem is - I cannot find the mistake:
\documentclass[a4paper; 11pt; titlepage]{article}
\usepackage{tabularx}
\usepackage{array}
\...
0
votes
0
answers
1k
views
Managing columns with estout/esttab suite and Latex
I am using the excellent suite of tools -estout, esttab, etc.- by Ben Jann. I have a little issue by using the "esttab" ado to produce some summary statistics. Specifically, I want to show the number ...
- 33
2
votes
0
answers
122
views
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 ...
- 501
1
vote
2
answers
627
views
Using result of spreadtab macro outside of table
I have a spreadtab table and want to sum one of it's columns. I would like to use the result several times in my document. How do I go about doing that?
This code should explain what I am trying to ...
- 155
3
votes
1
answer
1k
views
! TeX capacity exceeded, sorry [save size=50000]
I am working in a large spreadsheet using spreadtab package.
The spreadsheet is basically a billing list with individual prices; quantities and total price for all items.
Even with a high number of ...
- 61