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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
49 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} ...
sergiokapone's user avatar
  • 5,578
0 votes
0 answers
31 views

Referencing roundtab cell value that is produced by a siunitx macro (here a rounding macro)

In the following script, I'm trying to reference the value tagged by round. But I don't know how to do that. If I place the tag inside as shown, the corresponding cell produces the number without ...
Faheem Mitha's user avatar
  • 7,788
0 votes
1 answer
28 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 ...
Mr_Nofreeze's user avatar
0 votes
0 answers
46 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.
Angelo Longo's user avatar
1 vote
1 answer
98 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|...
WinnieNotThePooh's user avatar
0 votes
1 answer
109 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} \...
ozturkib's user avatar
  • 160
2 votes
1 answer
122 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 ...
IH Pro's user avatar
  • 141
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 ...
IH Pro's user avatar
  • 141
3 votes
3 answers
341 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 ...
IH Pro's user avatar
  • 141
0 votes
1 answer
90 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 & ...
IH Pro's user avatar
  • 141
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{...
IH Pro's user avatar
  • 141
0 votes
1 answer
43 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 (...
richrow's user avatar
  • 309
1 vote
1 answer
141 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 ...
Faheem Mitha's user avatar
  • 7,788
0 votes
2 answers
81 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 ...
Faheem Mitha's user avatar
  • 7,788
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 ...
Faheem Mitha's user avatar
  • 7,788
0 votes
1 answer
224 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]. ...
Pouya's user avatar
  • 7,269
1 vote
1 answer
61 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 ...
NBur's user avatar
  • 4,326
2 votes
1 answer
53 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} \...
Derr Herr's user avatar
  • 359
2 votes
1 answer
128 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,...
Trurl's user avatar
  • 31
1 vote
1 answer
160 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 ...
71GA's user avatar
  • 3,573
4 votes
2 answers
659 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 ...
tedioustortoise's user avatar
1 vote
1 answer
181 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 & @ ...
Guildem's user avatar
  • 113
1 vote
1 answer
68 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} \...
sandu's user avatar
  • 7,950
1 vote
1 answer
305 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 ...
novski's user avatar
  • 1,039
2 votes
1 answer
132 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@{}}{@...
Tvde1's user avatar
  • 439
3 votes
1 answer
69 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{...
Erel Segal-Halevi's user avatar
1 vote
1 answer
145 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. ...
Flora Grappelli's user avatar
2 votes
1 answer
270 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 & ...
Erel Segal-Halevi's user avatar
0 votes
0 answers
61 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 ...
Make42's user avatar
  • 1,782
1 vote
1 answer
198 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 ...
javadr's user avatar
  • 2,404
1 vote
1 answer
229 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] \\ ...
Xandl's user avatar
  • 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} \...
javadr's user avatar
  • 2,404
1 vote
1 answer
119 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{...
novski's user avatar
  • 1,039
3 votes
1 answer
365 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-...
user avatar
2 votes
1 answer
572 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 ...
stereo's user avatar
  • 23
0 votes
0 answers
218 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....
rakatex's user avatar
  • 489
6 votes
0 answers
182 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{...
rolfn's user avatar
  • 939
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, ...
Biki Teron's user avatar
  • 3,275
2 votes
1 answer
262 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]{...
novski's user avatar
  • 1,039
3 votes
1 answer
246 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} \...
Przemysław Kot's user avatar
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 ...
olbap79's user avatar
  • 33
2 votes
0 answers
120 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 ...
tim's user avatar
  • 501
1 vote
2 answers
614 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 ...
John's user avatar
  • 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 ...
EduarDudz's user avatar
1 vote
1 answer
259 views

Time calculation with spreadtab

I come from this question: How can I automatically calculate sums in a LaTeX table? I want to do the same but with "timing" calculations. So my example would look like this: \documentclass{article} \...
user69453's user avatar
  • 936
2 votes
1 answer
796 views

How to get a "thousands" separator in `spreadtab` (wrapping `longtable`)?

I'm trying to use Pandoc for the semi-automatic generation of billing statements from YAML text inputs: For doing sum calculations I use the spreadtab package. For getting automatic page breaks if ...
Kurt Pfeifle's user avatar
  • 3,791
1 vote
2 answers
252 views

Use numbers stored in a command by spreadtab

My aim is to create a command to store numbers and calculated in the table. \begin{table}[h] \npthousandsep{,} \STautoround*{0} \begin{spreadtab}{{tabular}{| l | r | r | r |}} \hline ...
Joe's user avatar
  • 481
4 votes
1 answer
348 views

Write "conditionnally" rows of a tabular with spreadtab

I'm writing a tabular using the spreadtab package for some calculus. I want to write it's rows only under a certain condition, i.e. to test in each of its rows if the condition is true, and then write ...
Faouzi Bellalouna's user avatar
3 votes
1 answer
654 views

ifthen and spreadtab

I use the spreadtab and the xifthen packages for computing percentiles, but I found an unusual behavior. I give an example of false result: a true command remains false when it's used in a spreadtab. ...
Faouzi Bellalouna's user avatar
0 votes
1 answer
1k views

Number formatting in the table with spreadtab

I am using spreadtab for the calculation in a table. \documentclass[a4paper]{article} \usepackage{spreadtab} \usepackage{numprint} \usepackage{xstring} \renewcommand\STprintnum[1]{\numprint{#1}} \...
Joe's user avatar
  • 481