tdf#162262 sc add "Summary below data" option for Subtotal dialog

With this option we can set where the summary rows should appear,
above or below the datas when we create a new Subtotal area. The default
option is "True" (which means the summary rows are below the datas)
when we create a new subtotal area. Unless if we already have one subtotal
area on the same sheet, in that case the sheet level property, "TotalsRowBelow"
contains where should the summary rows be for the new Subtotal's.

TODO: add new ODF xml attribute for Summary below

Change-Id: Icf86c85041d75c24919cb528846d5bb2b517ca78
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/175556
Tested-by: Jenkins
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>

1 files changed, 13 insertions, 0 deletions

diff --git a/offapi/com/sun/star/sheet/Spreadsheet.idl b/offapi/com/sun/star/sheet/Spreadsheet.idl
index d1a1dfcd0f18..605055c7b4ec 100644
--- a/offapi/com/sun/star/sheet/Spreadsheet.idl
+++ b/offapi/com/sun/star/sheet/Spreadsheet.idl
@@ -169,6 +169,19 @@ service Spreadsheet
     /** specifies all conditional formats of that sheet
      */
     [optional, property] com::sun::star::sheet::XConditionalFormats ConditionalFormats;
+
+    /** specifies whether summary rows appear below detail in an outline,
+        when applying an outline.
+
+    <p> When true a summary row is inserted below the detailed data being
+        summarized and a new outline level is established on that row.</p>
+
+    <p> When false a summary row is inserted above the detailed data being
+        summarized and a new outline level is established on that row.</p>
+
+        @since LibreOffice 25.2
+    */
+    [optional, property] boolean TotalsRowBelow;
 };