[Tex/LaTex] Making row bold and keeping other formatting in pgfplotstable

boldformattingpgfplotstable

I have a table where the last row needs to be bold. Currently, I can make it bold by following this question. However, when I make it bold, I lose all my number formatting.

Here are the 2 images:

Below is my whole file which produces a page with that table. I comment out the second to last row to produce the picture without bold.

\documentclass[11pt]{report}
\usepackage{arydshln}
\usepackage{amsmath}
\usepackage{array}
\usepackage[landscape]{geometry}
\usepackage{graphicx}
\usepackage{tikz}
\usepackage{tabularx}
\usepackage{xcolor}
\usepackage{colortbl}
\usepackage{fancyhdr}
\usepackage{datetime}
\usepackage{anyfontsize}
\usepackage{wallpaper}
\usepackage{fontspec}
\usepackage{pgfplots,pgfplotstable}
\usepackage{numprint}
\npthousandsep{,}
\npdecimalsign{.}
\usetikzlibrary{plotmarks}

\begin{filecontents}{test.dat}
NAME,DOLKWH,YEAR1MAV,YEAR1TAV
Without Solar,21.587089894172,149.80185755952,1797.6222907142
Solar Payment,15.44620773416,128.15382726042,1537.845927125
Remaining Utility,-0.011600973866237,1.5746741682751,18.896090019302
New Bill,15.44620773416,277.95568481994,1556.7420171443
Savings,6.1408821600121,-128.15382726042,240.88027356994
\end{filecontents}


\pgfplotstableread[col sep=comma]{test.dat} \savingsTable

\newcommand\displ[1]{%  Indicates the number of rows of the data file that we want to display in a given table         
\ifnum\pgfplotstablerow<#1\relax%
\else\pgfplotstableuserowfalse\fi}

%%  TABLES  %%

\pgfplotstableset{ % Makes bold a whole row of a table
    highlightrow/.style={
        postproc cell content/.append code={
           \count0=\pgfplotstablerow
            \advance\count0 by1
            \ifnum\count0=#1
            \pgfkeysalso{@cell content=\textbf{##1}}
            \fi
        },
    },
}

\newcolumntype{R}[1]{>{\raggedleft\arraybackslash}p{#1cm}}  % Right aligned, centered column
\newcolumntype{L}[1]{>{\arraybackslash\raggedright}p{#1cm}} % Left aligned, centered column

%%   COLORS SCHEME  %%

\definecolor{YellowBar}{HTML}{FFE300}

\everymath{\textstyle}

\begin{document}
\begin{minipage}[t]{.48\linewidth}
{\def\arraystretch{1.85}
\newcommand\tabw{2.8}
\pgfplotstabletypeset[
/pgf/number format/fixed zerofill=true,
row predicate/.code={\displ{5}},
create on use/TITLE/.style={%
  create col/set list={%
    \begin{tabular}{@{}l}
    Without Solar\\[-2.5ex]\tiny
    Estimated Annual increase 3.5\%
    \end{tabular},
    \begin{tabular}{@{}l}
    Solar Payment\\[-2.5ex]\tiny
    Annual Escalator 2.9\%
    \end{tabular},
    Remaining Utility,New Bill,Savings
  }
},
columns={TITLE,DOLKWH,YEAR1MAV,YEAR1TAV},
columns/TITLE/.style={string type, column name=,column type=|L{\tabw}},
%
columns/DOLKWH/.style={%
  /pgf/number format/fixed,precision=1,
  column name=\scriptsize\textcent/kWh,column type=|R{\tabw},
  postproc cell content/.append style={/pgfplots/table/@cell content/.add={}{\textcent}}
},
%
columns/YEAR1MAV/.style={
  column name={%
      \scriptsize\parbox[b]{2cm}{%
        \flushright\vskip-1.5ex Year 1\\[-1pt]Monthly\\[-1pt]Average\\[-4pt]
      }
    },
    column type=|R{\tabw},
    postproc cell content/.append style={/pgfplots/table/@cell content/.add={\$}{}
  }
},
%
columns/YEAR1TAV/.style={
   /pgf/number format/set decimal separator={.},thousands separator={,},precision=2,
  column name={%
    \scriptsize\parbox[b]{2cm}{%
      \flushright\vskip-1.5ex Year 1\\[-1pt]Total\\[-4pt]}
  },
  column type=|R{\tabw}|,postproc cell content/.append style={/pgfplots/table/@cell content/.add={\$}{}},
},
after row={\hline},
every head row/.style={before row={\hline\rowcolor{gray!10}}},
every row no 3/.style={before row={\rowcolor{yellow!50}}},
every row no 4/.style={before row={\rowcolor{YellowBar}}},
highlightrow={4},highlightrow={5}
]\savingsTable
}
\end{minipage}

\end{document}

UPDATE: everything is working now thanks to @Zarko, however the font on the last 2 rows changes from the rest of the document:

Best Answer

Your problem is wrong approach in definition of highlightrow. If you replace it with

\pgfplotstableset{ % Makes bold a whole row of a table
    highlightrow/.style={
        postproc cell content/.append code={
           \count0=\pgfplotstablerow
            \advance\count0 by1
            \ifnum\count0=#1
            \pgfkeysalso{@cell content/.add={$\bf}{$}}
            \fi
        },
    },
}

You will get desired result:

Addendum:

Edit: Since this problem is very interesting in general, I adopt your MWE for my archive. This adopted code has changes in column header cells (I like heads with only two lines), in the first column, where the unnecessary nested tables is omitted, the precision of numbers in second column is increased to 3.

I also omit for this table unnecessary packages and instead of report use standalone documentclass. This code

\documentclass[border=3mm]{standalone}
    \usepackage{array}
    \usepackage[table]{xcolor}
% XeLaTeX
    \usepackage{anyfontsize}
    \usepackage{fontspec}
% units and pgf-plots-table
    \usepackage{siunitx}
    \usepackage{pgfplotstable}

\begin{filecontents}{test.dat}
NAME,               DOLKWH,             YEAR1MAV,           YEAR1TAV
Without Solar,      21.587089894172,    149.80185755952,    1797.6222907142
Solar Payment,      15.44620773416,     128.15382726042,    1537.845927125
Remaining Utility,  -0.011600973866237,   1.5746741682751,    18.896090019302
New Bill,           15.44620773416,     277.95568481994,    1556.7420171443
Savings,             6.1408821600121,  -128.15382726042,    240.88027356994
\end{filecontents}
\pgfplotstableread[col sep=comma]{test.dat}\savingsTable

\newcommand\displ[1]{%  Indicates the number of rows of the data file
                     %  that we want to display in a given table
\ifnum\pgfplotstablerow<#1\relax%
\else\pgfplotstableuserowfalse\fi}

%%  TABLES  %%
\pgfplotstableset{ % Makes bold a whole row of a table
    highlightrow/.style={
        postproc cell content/.append code={
           \count0=\pgfplotstablerow
            \advance\count0 by1
            \ifnum\count0=#1
            \pgfkeysalso{@cell content/.add={$\bf}{$}}
            \fi
        },
    },
}
\newcolumntype{R}[1]{>{\raggedleft \arraybackslash}m{#1}}
\newcolumntype{L}[1]{>{\raggedright\arraybackslash}m{#1}} %column

%%   COLORS SCHEME  %%
\definecolor{YellowBar}{HTML}{FFE300}
%%   MATH APPERANCE %%
\everymath{\textstyle}

    \begin{document}
%---------------------------------------------------------------%
% \begin{table}\centering\caption{..}\label{...}
    \def\arraystretch{1.5}
    \newlength\tabw
    \setlength\tabw{28mm}

\pgfplotstabletypeset[
    /pgf/number format/fixed zerofill = true,
                  row predicate/.code = {\displ{5}},
           create on use/TITLE/.style = {create col/set list={%
% first column
    Without Solar\newline\scriptsize
    Estimated Annual increase \SI{3.5}{\%}
    ,
    Solar Payment\newline\scriptsize
    Annual Escalator \SI{2.9}{\%}
    ,
    Remaining Utility, New Bill, Savings}
                                        },% end of first column
    columns={TITLE,DOLKWH,YEAR1MAV,YEAR1TAV},
    columns/TITLE/.style={string type,column name=,column type=|L{\tabw}},
% second column
    columns/DOLKWH/.style={/pgf/number format/fixed,precision=3,
                            column name=~\newline\textcent/kWh,
                            column type=|R{0.5\tabw},
                            postproc cell content/.append style={%
                                /pgfplots/table/@cell content/.add={}{\textcent}}
                            },
% third column
    columns/YEAR1MAV/.style={column name={\hfill Year 1\newline  Monthly Average},
                             column type=|R{\tabw},
                             postproc cell content/.append style={%
                                    /pgfplots/table/@cell content/.add={\$}{}}
                             },
% fourth column
    columns/YEAR1TAV/.style={column name={\hfill Year 1\newline Total},
                             column type=|R{0.6\tabw}|,
                             /pgf/number format/set decimal separator={.},
                             precision=2,
                             postproc cell content/.append style={%
                                    /pgfplots/table/@cell content/.add={\$}{}},
},
% rows styles
after row={\hline},
every head row/.style={before row={\hline\rowcolor{gray!10}}},
every row no 3/.style={before row={\rowcolor{yellow!50}}},
every row no 4/.style={before row={\rowcolor{YellowBar}}},
highlightrow={4},highlightrow={5}
        ]\savingsTable
%\end{table}
%---------------------------------------------------------------%
    \end{document}

In above example I didn't bother with vertical and horizontal lines. Many people consider, that the looks of table without vertical rules and middle horizontal rules are more beautiful.

Related Solutions

[Tex/LaTex] Making hats (and other accents) bold

Here is one solution, albeit cumbersome:

enter image description here

\documentclass{article}
\usepackage{amsmath}% http://ctan.org/pkg/amsmath
\newcommand{\thickhat}[1]{\mathbf{\hat{\text{$#1$}}}}
\newcommand{\thickbar}[1]{\mathbf{\bar{\text{$#1$}}}}
\newcommand{\thicktilde}[1]{\mathbf{\tilde{\text{$#1$}}}}
\begin{document}
$\hat{a}, \bar{a}, \tilde{a}$ \par
$\hat{\mathbf{a}}, \bar{\mathbf{a}}, \tilde{\mathbf{a}}$ \par
$\mathbf{\hat{a}}, \mathbf{\bar{a}}, \mathbf{\tilde{a}}$ \par
$\thickhat{a}, \thickbar{a}, \thicktilde{a}$ \par
\end{document}

amsmath provides the easy font-and-size switching capability via \text. This allows you to use the \thick-constructs inside super-/subscripts.

[Tex/LaTex] Pgfplotstable header in bold

I know this post is old but I just figured this out and was too excited not to share...

Pertaining to your first question about bold headers I can offer the following. Before typesetting the table, specify bold font in the column type using

column type={>{\fontseries{bx}\selectfont}c} %see sec 2.6 for defining column types

This should set all entries in your table to bold font. To leave only the headers bold, you can then post-process every cell's content using

postproc cell content/.append style={ % see sec 3.2
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}}

This works because the second block of code does not apply to header cells, so we can first set everything bold, then reset the other (non-header) cells to normal font. See the sections in comments in the pgfplotstable manual for more information.

Here is a MWE

\documentclass{article}
\usepackage{pgfplotstable}

\begin{document}

\pgfplotstableset{% set global options
format=inline,
string type,
col sep={&}, row sep={\\},
column type={>{\fontseries{bx}\selectfont\centering\arraybackslash}c},
every head row/.style={after row=\hline},
postproc cell content/.append style={
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}}
}

\pgfplotstabletypeset{% The input table
H1&H2&H3 \\
data1&data2&data3 \\
moredata1&moredata2&moredata3 \\
}

\end{document}

MWE

EDIT:

Here is the code embedded in your formatted table. I commented out the every col no <index>/.style and replaced that block simply with column type={<options>}. This allows you to specify column type for every column. Since you wanted a different specification for the first and last columns, you must manually specify those.

\documentclass{article}
\usepackage{pgfplotstable}
\usepackage{booktabs,colortbl}
\begin{document}
\def\tableborder{1.5pt}

% global settings
\pgfplotstableset{
after row={\hline},
every head row/.style={
before row={
\rowcolor{lightgray}
\noalign{\hrule height \tableborder}
},
after row={
\hline
},
},
every last row/.style={
after row=\noalign{\hrule height \tableborder}
},
col sep = &,
row sep=\\,
% column type/.add={}{\vrule width \tableborder},
%every col no 1/.style={ column type/.add={|}{} },
%every col no 2/.style={ column type/.add={|}{} },
%every col no 3/.style={ column type/.add={|}{} },
%every col no 4/.style={ column type/.add={|}{} },
%every col no 5/.style={ column type/.add={|}{} },
column type={|>{\fontseries{bx}\selectfont}c},
every first column/.style={
column type={!{\vrule width \tableborder}>{\fontseries{bx}\selectfont}c} % removed /.add so you can replace the format rather than append to it.
},
every last column/.style={
column type/.add={}{!{\vrule width \tableborder}}
},
string type,
postproc cell content/.append style={
/pgfplots/table/@cell content/.add={\fontseries{\seriesdefault}\selectfont}{}
}
}


\pgfplotstabletypeset{
person & singEnglish & singGaeilge & pluralEnglish & pluralGaeilge\\
1st & at me & agam & at us & againn\\
2st & at you & agat & at you & agaibh\\
3st & at him & aige & at them & acu\\
& at her & aici & &\\
}
\end{document}

mwe_table_edit

Best Answer

Related Solutions

[Tex/LaTex] Making hats (and other accents) bold

[Tex/LaTex] Pgfplotstable header in bold

Related Question