/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ module com { module sun { module star { module sheet { /** represents a single field in a data pilot table.
If the data pilot table is based on a spreadsheet cell range, a field is represented by a column of the range and is named using the topmost cell of the column.
*/ published service DataPilotField { /** provides access to the name of the data pilot field. */ interface com::sun::star::container::XNamed; //!published service PropertySet /** provides access to the properties. */ interface com::sun::star::beans::XPropertySet; [optional] interface XDataPilotField; [optional] interface XDataPilotFieldGrouping; /** specifies the orientation of the field.If the orientation of a field has been changed using this property, the field will be moved to the last position in the collection of all fields with the specified orientation.
*/ [property] DataPilotFieldOrientation Orientation; /** specifies the function used to calculate results for this field.For column and row fields, this is the function for subtotals (GeneralFunction::NONE means no subtotals). For data fields, this is the function shown in the data pilot table.
*/ [property] GeneralFunction Function; /** specifies the functions used to calculate subtotals for this field.This property is supported by column and row fields only.
An empty sequence means no subtotals. The same effect can be achieved by setting the property #Function to the value GeneralFunction::NONE. If the length of the sequence is greater than 1, then the sequence MUST NOT contain one of the values GeneralFunction::NONE or GeneralFunction::AUTO.
The order of the functions in this sequence is reflected in the DataPilot table. Multiple entries of the same function are ignored when setting the property.
*/ [property, optional] sequenceBy changing the value of this property it is possible to modify the grouping settings of this field.
*/ [property, optional] DataPilotFieldGroupInfo GroupInfo; /** specifies whether to show this field also if it is empty or not. */ [property, optional] boolean ShowEmpty; /** specifies the function used to calculate results for this field.For column and row fields, this is the function for subtotals (GeneralFunction2::NONE means no subtotals). For data fields, this is the function shown in the data pilot table.
@since LibreOffice 5.3 */ [property, optional] short Function2; /** specifies the functions used to calculate subtotals for this field.This property is supported by column and row fields only.
An empty sequence means no subtotals. The same effect can be achieved by setting the property #Function2 to the value GeneralFunction::NONE. If the length of the sequence is greater than 1, then the sequence MUST NOT contain one of the values GeneralFunction2::NONE or GeneralFunction2::AUTO.
The order of the functions in this sequence is reflected in the DataPilot table. Multiple entries of the same function are ignored when setting the property.
@since LibreOffice 5.3 */ [property, optional] sequence