Graphics, Figures & Tables ⇒ A simple Problem with an Excel-like table

[Cham]

I'm building a large table, which needs to be of Excel type. It is working great, except that I have a small problem. Here's a MWE showing the table (a bit simplified) :

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
\documentclass[10pt,oneside]{scrartcl}
\usepackage[T1]{fontenc}
\usepackage[utf8]{inputenc}
\usepackage[french]{babel}
\usepackage{microtype}
\usepackage[left=0.75in,right=0.75in,top=0.5in,bottom=0.5in,includehead,includefoot]{geometry}
\usepackage{amsmath}
\usepackage{tensor}
\usepackage{hhline}
\usepackage[separate-uncertainty=true]{siunitx}
\sisetup{output-decimal-marker = {,}}
\begin{document}
\section{Title}
\begin{center}
%\begin{minipage}{0.925\linewidth}
    \renewcommand{\arraystretch}{1.5}
    \begin{tabular}{|c|r|c|S|S|S|S|}
    \hline
    \multicolumn{7}{|c|}{Table title}                                                                                                                                               \\ \hline
    $t$ & $x$ & $\tensor{t}{_{\text{c}}}$ & $\tensor{v}{_x}$ & $\Delta\tensor{v}{_x}$ & $\tensor{v}{_{\text{moy},\, x}}$ & $\Delta\tensor{v}{_{\text{moy},\, x}}$ \\ \hline
    $\si{\s}$ & $\si{\cm}$ & $\si{\s}$ & \multicolumn{2}{c|}{$\si{\m/\s}$} & \multicolumn{2}{c|}{$\si{\m/\s}$}                                         \\ \hline
    – & 0,1 & – & \multicolumn{2}{c|}{–} & \multicolumn{2}{c|}{–} \\ \hhline{|=|=|=|==|==|}
    0,0000 & 0,0 & 0,0191 & 1,31 & 0,05 & – & – \\ \hline
    0,0382 & 5,0 & 0,0535 & 1,64 & 0,07 & 1,31 & 0,03 \\ \hline
    0,0687 & 10,0 & 0,0818 & 1,92 & 0,08 & 1,46 & 0,01 \\ \hline
    0,0948 & 15,0 & 0,1064 & 2,16 & 0,09 & 1,58 & 0,01 \\ \hline
    0,1180 & 20,0 & 0,1285 & 2,4 & 0,1 & 1,695 & 0,008 \\ \hline
    0,1390 & 25,0 & 0,1487 & 2,6 & 0,1 & 1,799 & 0,007 \\ \hline
    0,1583 & 30,0 & – & – & – & 1,895 & 0,006 \\ \hline
    \end{tabular} \\[10pt]
    \renewcommand{\arraystretch}{1.5}
    \begin{tabular}{|l|}
    \hline
    \multicolumn{1}{|c|}{Légende} \\ \hline
    $t$ is time. \\
    $x$ is position. \\
    $\tensor{t}{_{\text{c}}}$ is a bla blabla bla bla blablabla blabla bla blabla bla. \\
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

Here's a preview of it :

table.jpg (67.47 KiB) Viewed 4418 times

Please, don't ask why I need to show the data that way. It's a complicated matter and it's off-topic anyway.

Now, how can I have ALL the number columns of the same width ?

[Cham]

I may have found a solution, from this page :
http://tex.stackexchange.com/questions/ ... n-extend-t

I just have to paste the command \newcolumntype{C}{>{\centering\arraybackslash}p{3.5em}}, before the table, and use "C" instead of "c".

Now, I'm wondering if we could align the numbers by their comma, using a similar trick.

[Stefan Kottwitz]

Nice that you found it. We had this column type thingy already many times, such as in

• Centering Cell content in fixed Width Columns
• Center text in a table
• All Columns centered but the last one

and more, google said.

But I think you don't need centering, you need alignment. dcolumn helps, or rccol, but siunitx is the most modern package providing it.

Example:

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
% Stefan Kottwitz, LaTeX Cookbook, Packt Publishing, 2015
% Chapter 5, Designing Tables
% Aligning numeric data
\documentclass{article}
\usepackage{booktabs}
\usepackage{siunitx}
\usepackage{chemformula}
%\sisetup{table-figures-decimal  = 5,
%         table-figures-integer  = 2,
%         table-number-alignment = right}
%\sisetup{table-format = 2.5,
%         table-number-alignment = right}
\begin{document}
  \begin{tabular}{lSS}
    \toprule
              & {atomic mass} & {total mass} \\
    \midrule
    \ch{C}    &    12.011     & 12.011       \\
    \ch{H}    &     1.00794   &  6.04764     \\
    \ch{C2H6} &               & 30.06964     \\
    \bottomrule
  \end{tabular}
\end{document}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

Stefan

[Cham]

Thanks Stefan,


but how do you set all the number columns of the same width, while aligning the numbers on their comma ?

[Johannes_B]

You want to have the good, the bad and the ugly all in one place. ust like in real life, this leads to tension and fights. You need a real manual crutch to get what you want.

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
% Stefan Kottwitz, LaTeX Cookbook, Packt Publishing, 2015
% modified Johannes_B 2016
% Chapter 5, Designing Tables
% Aligning numeric data
\documentclass{article}
\usepackage{booktabs}
\usepackage{siunitx}
\usepackage{chemformula}
    %\sisetup{table-figures-decimal  = 5,
    %         table-figures-integer  = 2,
    %         table-number-alignment = right}
    %\sisetup{table-format = 2.5,
    %         table-number-alignment = right}
\begin{document}
\begin{tabular}{|l|S|S|}
    \toprule
    \multicolumn{1}{p{.3\textwidth}}{}& \multicolumn{1}{p{.3\textwidth}}{atomic mass} & \multicolumn{1}{p{.3\textwidth}}{\centering total mass} \\
    \midrule
    \ch{C}    &    12.011     & 12.011       \\
    \ch{H}    &     1.00794   &  6.04764     \\
    \ch{C2H6} &               & 30.06964     \\
    \bottomrule
\end{tabular}
\end{document}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

Suggestion: Make a few of the tables as shown in previous posts and convert them to something that would be published in a journal, i.e. no vertical rules and getting rid of all that mess. Show it to the guys in charge and just say something nice. This might be a simpler approach and long-time more educational to your students than first whacking LaTeXs legs to build in an extra knee and build a crutch around all it. It is really hacky.

[Cham]

Suggestion: Make a few of the tables as shown in previous posts and convert them to something that would be published in a journal, i.e. no vertical rules and getting rid of all that mess. Show it to the guys in charge and just say something nice. This might be a simpler approach and long-time more educational to your students than first whacking LaTeXs legs to build in an extra knee and build a crutch around all it. It is really hacky.

I'm afraid this is not possible. It's not just a matter of a guy in charge. It is an institutional thing, related to the use of Excel, not LaTeX. I just need to show the students how to use Excel and make their tables of data in their physics lab, and I'm writing their labs protocols documents with LaTeX, instead of Excel. So I don't have a choice here.

This previous table example is extremely ugly, and is not of an Excel type. The lines do not close, and the spacing is way exagerated.

[Johannes_B]

I just took Stefan's example and showed how to fix the width of the cells, using vertical lines for better visualization. You already had all the rest, don't you?

[Cham]

Sorry for the misunderstanding.

The only thing missing in my code is to align all the numbers to their comma, while having the same column width for all the numbers. I don't know how to change the code line
\newcolumntype{C}{>{\centering\arraybackslash}p{3.5em}},
except of course of adjusting the 3.5em. But how to get the numbers aligned to their comma ?

[Johannes_B]

That is shown in Stefans post, in mine and in your own. You already do that. I am confused.

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
\documentclass[10pt,oneside]{scrartcl}
\usepackage[T1]{fontenc}
\usepackage[utf8]{inputenc}
\usepackage[french]{babel}
\usepackage{microtype}
\usepackage[left=0.75in,right=0.75in,top=0.5in,bottom=0.5in,includehead,includefoot]{geometry}
\usepackage{amsmath}
\usepackage{showframe}
\usepackage{hhline}
\usepackage[separate-uncertainty=true]{siunitx}
\sisetup{output-decimal-marker = {,}}
\begin{document}
\section{Title}
\begin{center}
    %\begin{minipage}{0.925\linewidth}
    \renewcommand{\arraystretch}{1.5}
    \begin{tabular}{|c|r|c|S|S|S|S|}
        \hline
        \multicolumn{7}{|c|}{Table title}\\ \hline
        \multicolumn{1}{|>{\centering}p{.1\linewidth}|}{$t$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$x$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$t_{\text{c}}$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$v{_x}$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$\Delta v{_x}$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$v_{\text{moy},\, x}$} & 
        \multicolumn{1}{>{\centering}p{.1\linewidth}|}{$\Delta v_{\text{moy},\, x}$} \\ \hline
        $\si{\s}$ & $\si{\cm}$ & $\si{\s}$ & \multicolumn{2}{c|}{$\si{\m/\s}$} & \multicolumn{2}{c|}{$\si{\m/\s}$}\\ \hline
        – & 0,1 & – & \multicolumn{2}{c|}{–} & \multicolumn{2}{c|}{–} \\ \hhline{|=|=|=|==|==|}
        0,0000 & 0,0 & 0,0191 & 1,31 & 0,05 & – & – \\ \hline
        0,0382 & 5,0 & 0,0535 & 1,64 & 0,07 & 1,31 & 0,03 \\ \hline
        0,0687 & 10,0 & 0,0818 & 1,92 & 0,08 & 1,46 & 0,01 \\ \hline
        0,0948 & 15,0 & 0,1064 & 2,16 & 0,09 & 1,58 & 0,01 \\ \hline
        0,1180 & 20,0 & 0,1285 & 2,4 & 0,1 & 1,695 & 0,008 \\ \hline
        0,1390 & 25,0 & 0,1487 & 2,6 & 0,1 & 1,799 & 0,007 \\ \hline
        0,1583 & 30,0 & – & – & – & 1,895 & 0,006 \\ \hline
        \hline
        \multicolumn{7}{|l|}{Légende} \\ \hline
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

[Cham]

Oh ! I missed something somewhere then. Thanks. I'll check my code.

EDIT : the columns are too wide in the previous code.

Also, the problem with this table is that the comma are all centered, which makes the spacements looking horrible.

Excel can align the numbers by their comma, while having some nice spacements around the numbers in their cell (comma isn't centered in the cell), with all columns of equal width.