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
17 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.
user avatar
1 vote
1 answer
35 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|...
user avatar
0 votes
1 answer
45 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} \...
user avatar
  • 160
1 vote
2 answers
76 views

Is there a faster way to create large tables or insert spreadsheet information?

I apologize for the long delay in updating this post. I misunderstood quite a bit at first, and wasn't very clear as to my original issue. I am trying to make a table using the \begin{tabular} code. ...
user avatar
2 votes
1 answer
101 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 ...
user avatar
  • 119
0 votes
1 answer
43 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 ...
user avatar
  • 119
3 votes
2 answers
199 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 ...
user avatar
  • 119
0 votes
1 answer
69 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 & ...
user avatar
  • 119
1 vote
0 answers
55 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{...
user avatar
  • 119
0 votes
1 answer
29 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 (...
user avatar
  • 289
1 vote
1 answer
62 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 ...
user avatar
  • 7,444
0 votes
2 answers
54 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 ...
user avatar
  • 7,444
4 votes
1 answer
66 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 ...
user avatar
  • 7,444
0 votes
1 answer
131 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]. ...
user avatar
  • 7,079
1 vote
1 answer
41 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 ...
user avatar
  • 3,631
2 votes
1 answer
38 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} \...
user avatar
  • 359
2 votes
1 answer
72 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,...
user avatar
  • 31
1 vote
1 answer
119 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 ...
user avatar
  • 3,493
4 votes
2 answers
277 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 ...
user avatar
1 vote
1 answer
124 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 & @ ...
user avatar
  • 113
1 vote
1 answer
54 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} \...
user avatar
  • 7,546
1 vote
1 answer
153 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 ...
user avatar
  • 1,019
2 votes
1 answer
76 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@{}}{@...
user avatar
  • 389
3 votes
1 answer
59 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{...
user avatar
1 vote
1 answer
111 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. ...
user avatar
2 votes
1 answer
191 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 & ...
user avatar
0 votes
0 answers
50 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 ...
user avatar
  • 1,662
1 vote
1 answer
176 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 ...
user avatar
  • 2,322
1 vote
1 answer
193 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] \\ ...
user avatar
  • 11
1 vote
1 answer
67 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} \...
user avatar
  • 2,322
1 vote
1 answer
90 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{...
user avatar
  • 1,019
3 votes
1 answer
334 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
1 vote
1 answer
457 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 ...
user avatar
0 votes
0 answers
193 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....
user avatar
  • 459
4 votes
0 answers
135 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{...
user avatar
  • 847
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, ...
user avatar
  • 3,225
2 votes
1 answer
242 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]{...
user avatar
  • 1,019
2 votes
1 answer
209 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} \...
user avatar
1 vote
0 answers
835 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 ...
user avatar
  • 43
1 vote
0 answers
87 views

Can spreadtab distinguish between displayed value and actual value?

Number formatting behaves in a way that is not ideal in spreadtab. Basically, I can set rounding using \STautoround{2}, but if the numbers in the table are used in later computations, the rounding ...
user avatar
2 votes
0 answers
110 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 ...
user avatar
  • 501
1 vote
2 answers
529 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 ...
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 ...
user avatar
1 vote
1 answer
218 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} \...
user avatar
  • 876
2 votes
1 answer
631 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 ...
user avatar
  • 3,571
1 vote
2 answers
223 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 ...
user avatar
  • 481
4 votes
1 answer
303 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 ...
user avatar
3 votes
1 answer
618 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. ...
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}} \...
user avatar
  • 481
1 vote
1 answer
326 views

Expand command in a spreadtab formula

Long story short: I'm trying to come up with a system to generate a LaTeX table dynamically from a YAML file through Pandoc and do some calculations using the spreadtab package. So far so good, the ...
user avatar
  • 291