aspose.cells

aspose.cells

Class SxRng

Represents Group Range in a PivotField.
NOTE: This class is now obsolete. Instead, please use PivotFieldGroupSettings class. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.

Property Getters/Setters Summary
functiongetBy()
Represents the interval object for the group range.
functiongetEnd()
Represents the end object for the group range.
functiongetGroupByTypes()
Represents the group type for the group range. rangeofvalue Seconds Minutes Hours Days Months Quarters Years
functionisAutoEnd()
Specifies a boolean value that indicates whether the application will use the source data to set the end range value.
functionisAutoStart()
Specifies a boolean value that indicates whether the application will use the source data to set the beginning range value.
functiongetStart()
Represents the start object for the group range.
 

    • Property Getters/Setters Detail

      • isAutoStart : Object 

        function isAutoStart()
        Specifies a boolean value that indicates whether the application will use the source data to set the beginning range value.

      • isAutoEnd : Object 

        function isAutoEnd()
        Specifies a boolean value that indicates whether the application will use the source data to set the end range value.

      • getStart : Object 

        function getStart()
        Represents the start object for the group range.

      • getEnd : Object 

        function getEnd()
        Represents the end object for the group range.

      • getBy : Object 

        function getBy()
        Represents the interval object for the group range.

      • getGroupByTypes : boolean[] 

        function getGroupByTypes()
        Represents the group type for the group range. rangeofvalue Seconds Minutes Hours Days Months Quarters Years