Making row bold and keeping other formatting in pgfplotstable

Question

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:

Answer 1

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.

Answer 2

Given that your table is quite small in size, the use of TikZ is an overkill. It takes considerable time to load the package and, well, render everything (on my trusty EeePC 1001 HA it is not affordable). Sometimes it much easier to do a small table by hand. If you look at this paper by Donald Knuth himself, you will see that when he has 2 citations, he writes them explicitly as [1] and [2], no \cite trickery. He keeps it simple: no BibTeX, no bibliography environment, only one compilation. Just a couple of commands for nice manual formatting.

So, following in his footsteps, I propose the following remedy:

\documentclass{article}

\usepackage[table]{xcolor}
\usepackage{textcomp}
\usepackage{booktabs}
% Dirty hack to eliminate white bars cause by booktabs' space handling
% Due to http://tex.stackexchange.com/a/11215/19642
\setlength{\aboverulesep}{0pt}
\setlength{\belowrulesep}{0pt}
\setlength{\extrarowheight}{1ex}
\setlength{\tabcolsep}{0.75em}

\newcommand{\mytinytab}[1]{{\footnotesize\bfseries% Locally reverting the hack
\setlength{\extrarowheight}{0ex}\begin{tabular}{@{}r@{}}#1\end{tabular}}}

\begin{document}

\begin{tabular}{lrrr} \toprule
\rowcolor[gray]{0.9}
\rule[-3.5ex]{0pt}{8ex} % Without this strut, the header row looks squished
 & \mytinytab{~ \\ \textcent/kWh \\ ~} %
 & \mytinytab{Year 1 \\ Monthly \\ Average} %
 & \mytinytab{Year 1 \\ Total} \\ \midrule
Without Solar & 21.6\textcent & \$149.80 & \$1797.62 \\
Solar Payment & 15.4\textcent & \$128.15 & \$1537.85 \\
Remaining Utility & 0.0\textcent & \$1.57 & \$18.90 \\
\rowcolor[rgb]{1,0.975,0.75}
\textbf{New Bill} & \textbf{15.4\textcent} & \textbf{\$277.96} & \textbf{\$1556.74} \\
\rowcolor[rgb]{1,0.95,0.5}
\textbf{Savings} & \textbf{6.1\textcent} & \textbf{\$$-$128.15} & \textbf{\$240.88} \\ \bottomrule
\end{tabular}

\end{document}

Those tiny comments under row names may be rewritten in a better way, like being put under the table as footnotes, with explicitly writtern star footnote marks and simple text notes due to \footnote being a fragile command... again, these notes should go after the table because they are relevant. I just don’t think it is correct to give summary statistics under column names in tiny font size. You should consider adding the “Annual growth” column and report those growth rates there (with cell values like “2.9%”, “4.5% (est.)” etc.).

Update. If you have multiple tables and you want to avoid menial labour, you can use external tools (such as the the open-source R statistical software) to round the values with arbitrary precision (you can search in column names with regular expressions) and then output the result to tables with LaTeX column/row separators and any LaTeX code appended (again, string manipulation). You can use one template, like the one suggested above, to rule them all (pun intended). Its parsing capabilities are enormous, too.

P.S. By the way, vertical table lines are considered ugly by many. They should be avoided as much as possible.

Answer 3

This solution is based on the array package, which allows the definition of new column specifiers, so there is no font change spamming.

Option 1: column modifiers. Two prefixes (column modifiers) are defined to indicate the first and subsequent columns, ^ and _, respectively. Two more commands are defined, one explicitly and another implicitly, \rowstyle and \currentstyle. At the beginning of a row, ^ resets the \currentstyle to nothing (namely, \relax). When a \rowstyle is called, the style is changed and set as \currentstyle, which is then reused by each column, _, until the beginning of a new row. This solution is provided here.

\documentclass{standalone}
\usepackage{array}
\newcolumntype{^}{>{\global\let\currentrowstyle\relax}}
\newcolumntype{_}{>{\currentrowstyle}}
\newcommand{\rowstyle}[1]{\gdef\currentrowstyle{#1}%
  #1\ignorespaces
}
\begin{document}
\begin{tabular}{|^l|_l|_l|}   \hline
  Meek & mild & entry      \
  \rowstyle{\bfseries}
  Heading & Big and & Bold \ \hline
  Meek & mild & entry      \
  \rowstyle{\itshape}
  Strange & and & italic   \
  Meek & mild & entry      \ \hline
\end{tabular}
\end{document}

Option 2: column specifiers. A new column specifier, L, is defined, replacing l, so that it includes a column preamble. A suffix (column modifier), x, is also defined to indicate the last column to modified. Two more commands are defined, one explicitly and another implicitly, \rowstyle and \currentstyle. When a \rowstyle is called, the style is changed and set as \currentstyle. At each column, the \currentstyle is used. After the suffixed column is reached, the \currentstyle is reset to nothing (namely, \relax).

\documentclass{standalone}
\usepackage{array}
\newcolumntype{L}{>{\currentrowstyle}l}
\newcolumntype{x}{<{\global\let\currentrowstyle\relax}}
\newcommand{\rowstyle}[1]{\gdef\currentrowstyle{#1}%
  #1\ignorespaces
}
\newcommand{\currentrowstyle}{\relax}
\begin{tabular}{|L|L|Lx|}     \hline
  Meek & mild & entry      \
  \rowstyle{\bfseries}
  Heading & Big and & Bold \ \hline
  Meek & mild & entry      \
  \rowstyle{\itshape}
  Strange & and & italic   \
  Meek & mild & entry      \ \hline
\end{tabular}
\end{document}

Solution. Combining option 2 with the solution by Andreï, one gets a quite simple code for colored and specific font rows.

\documentclass{standalone}
\usepackage[table]{xcolor}
\usepackage{booktabs}
\setlength{\aboverulesep}{0pt}
\setlength{\belowrulesep}{0pt}
\setlength{\extrarowheight}{1ex}
\setlength{\tabcolsep}{0.75em}
\usepackage{array}
\newcolumntype{L}{>{\currentrowstyle}l}
\newcolumntype{R}{>{\currentrowstyle}r}
\newcolumntype{x}{<{\global\let\currentrowstyle\relax}}
\newcommand{\rowstyle}[1]{\gdef\currentrowstyle{#1}%
  #1\ignorespaces
}
\newcommand{\currentrowstyle}{\relax}
\begin{document}
\begin{tabular}{LRRRx}                                         \toprule
\rowcolor[gray]{0.9}
\rowstyle{\bfseries}
                  & \textcent/kWh & Month Avg.  &     Total \ \midrule
Without Solar     & 21.6\textcent &  $149.80   & $1797.62 \
Solar Payment     & 15.4\textcent &   $128.15  & $1537.85 \
Remaining Utility &  0.0\textcent &   $1.57    &   $18.90 \
\rowcolor[rgb]{1,0.975,0.75}
\rowstyle{\bfseries}
New Bill          & 15.4\textcent &    $277.96 & $1556.74 \
\rowcolor[rgb]{1,0.95,0.5}
\rowstyle{\bfseries}
Savings           &  6.1\textcent & $$-$128.15 &  $240.88 \ \bottomrule
\end{tabular}
\end{document}