<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source" href="https://bugs.documentfoundation.org/show_bug.cgi?id=47523#c14">Comment # 14</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source" href="https://bugs.documentfoundation.org/show_bug.cgi?id=47523">bug 47523</a> from <a class="email" href="mailto:davidjudysmith@gmail.com" title="David F Smith <davidjudysmith@gmail.com>"> David F Smith</a> <pre>In response to Valerio's <a href="show_bug.cgi?id=47523#c13">Comment 13</a>, please note that the Pivot Table Layout box already has an Option checkbox "Ignore empty rows." If that option is checked, there is no column in the resulting pivot table headed "(empty)", but even if the option is not checked, blank rows are not counted and not included in the total. Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>