Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

0
votes
1answer
10 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@{}}{@...
3
votes
1answer
27 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{...
1
vote
1answer
30 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. ...
2
votes
1answer
26 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 & ...
0
votes
0answers
25 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 ...
0
votes
0answers
23 views

Summation on a tagged cell in spreadtab?

Assume we have a spreadtab table like the MWE. As you see some rows commented by %tag A, %tag B, or %tag C. I want to make the summation of the last cell of these rows separately. In my case, there ...
1
vote
1answer
49 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 ...
1
vote
1answer
64 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] \\ ...
1
vote
1answer
44 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} \...
1
vote
1answer
65 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{...
3
votes
1answer
167 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-...
1
vote
1answer
101 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 ...
0
votes
0answers
79 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....
2
votes
0answers
59 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{...
7
votes
2answers
576 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, ...
2
votes
1answer
121 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]{...
2
votes
1answer
120 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} \...
1
vote
0answers
455 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 ...
1
vote
0answers
51 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 ...
2
votes
0answers
76 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 ...
1
vote
2answers
351 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 ...
3
votes
1answer
581 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 ...
1
vote
1answer
134 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} \...
2
votes
0answers
240 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 ...
1
vote
2answers
130 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 ...
3
votes
1answer
165 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 ...
3
votes
1answer
447 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. ...
0
votes
1answer
427 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}} \...
1
vote
1answer
176 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 ...
1
vote
1answer
313 views

Problem with spreadtab package: “Paragraph ended before \ST@left@ii was complete”

I'm having issues with this table and can't find the problem. I'm including all the packages I'm using for customizing the table: \usepackage{spreadtab} \usepackage{arydshln} % For the dotted line on ...
3
votes
1answer
235 views

Aligning number with siunitx in spreadtab including calculated numbers

I would like to have this kind of table \begin{spreadtab}{{tabularx}{\linewidth}{XS[table-format=4.2]l}} \toprule @{Was} & @{Betrag [\euro]} & @{Belegart} \\ \midrule @Nice People Charity &...
3
votes
0answers
87 views

Problems in using the spreadtab and the ifthen packages

Using the spreadtab package for some computing, I have to write an expression (mixing of literal and numerical expressions) if some conditions are true. Using the ifthen package, all works well for a ...
4
votes
3answers
1k views

logarithm, sine, cosine etc evaluated in tabular

I know that I can use spreadtab to make automatic calculations in a tabular. However, I only managed to do simple operations like +-*/, but I have no idea how to make more complex ones like log, ln, ...
3
votes
3answers
486 views

Passing values from a tabular to an other with spreadtab

I have two spreadtab tabulars, and I want some of the values calculated in the first one to be reused in the second one. I like the tag(savedValue) method that allows me to save values from the ...
1
vote
2answers
533 views

Asking spreadtab to add all rows above?

I love the idea behind spreadtab. The author should be congratulated. However, it seems to require that I specify specific numbers for the rows that I want to add. What if I have a document, where I ...