#include "address.hxx"
#include <i18nlangtag/lang.h>
#include <svx/svdtypes.hxx>
#include <tools/ref.hxx>
#include <sal/types.h>
#include <com/sun/star/i18n/CollatorOptions.hpp>
#include "scdllapi.h"
#include <rtl/ustring.hxx>
#include <tools/long.hxx>
#include <o3tl/unit_conversion.hxx>
#include <atomic>
#include <memory>
#include <optional>
#include <string_view>

Include dependency graph for global.hxx:

This graph shows which files directly or indirectly include this file:

Classes
class	com::sun::star::uno::Reference< class >

struct	o3tl::typed_flags< PaintPartFlags >

struct	o3tl::typed_flags< CRFlags >

struct	o3tl::typed_flags< ScBreakType >

struct	o3tl::typed_flags< InsertDeleteFlags >

struct	o3tl::typed_flags< HasAttrFlags >

struct	o3tl::typed_flags< ScScenarioFlags >

struct	o3tl::typed_flags< SubtotalFlags >

struct	o3tl::typed_flags< ScCloneFlags >

struct	ScImportParam

class	ScGlobal

struct	ScConsolidateParam

Namespaces
	com::sun::star::uno

	sc
	CAUTION! The following defines must be in the same namespace as the respective type.

	o3tl

	com::sun::star

	com::sun::star::lang

	com::sun::star::i18n

	utl

Macros
#define	SC_COLLATOR_IGNORES css::i18n::CollatorOptions::CollatorOptions_IGNORE_CASE

#define	MINDOUBLE 1.7e-307

#define	MAXDOUBLE 1.7e307

#define	MINZOOM 20

#define	MAXZOOM 400

#define	STD_ROWHEIGHT_DIFF 23

#define	OLE_STD_CELLS_X 4

#define	OLE_STD_CELLS_Y 5

#define	SC_INDENT_STEP 200

Enumerations
enum	PaintPartFlags { PaintPartFlags::NONE = 0x00, PaintPartFlags::Grid = 0x01, PaintPartFlags::Top = 0x02, PaintPartFlags::Left = 0x04, PaintPartFlags::Extras = 0x08, PaintPartFlags::Marks = 0x10, PaintPartFlags::Objects = 0x20, PaintPartFlags::Size = 0x40, PaintPartFlags::All = Grid \| Top \| Left \| Extras \| Objects \| Size }

enum	CRFlags : sal_uInt8 { CRFlags::NONE = 0x00, CRFlags::Hidden = 0x01, CRFlags::ManualBreak = 0x02, CRFlags::Filtered = 0x04, CRFlags::ManualSize = 0x08, CRFlags::All = Hidden \| ManualBreak \| Filtered \| ManualSize }

enum	ScBreakType { ScBreakType::NONE = 0x00, ScBreakType::Page = 0x01, ScBreakType::Manual = 0x02 }

enum	InsertDeleteFlags : sal_uInt16 { InsertDeleteFlags::NONE = 0x0000, InsertDeleteFlags::VALUE = 0x0001, InsertDeleteFlags::DATETIME = 0x0002, InsertDeleteFlags::STRING = 0x0004, InsertDeleteFlags::NOTE = 0x0008, InsertDeleteFlags::FORMULA = 0x0010, InsertDeleteFlags::HARDATTR = 0x0020, InsertDeleteFlags::STYLES = 0x0040, InsertDeleteFlags::OBJECTS = 0x0080, InsertDeleteFlags::EDITATTR = 0x0100, InsertDeleteFlags::OUTLINE = 0x0800, InsertDeleteFlags::SPARKLINES = 0x4000, InsertDeleteFlags::NOCAPTIONS = 0x0200, InsertDeleteFlags::ADDNOTES = 0x0400, InsertDeleteFlags::SPECIAL_BOOLEAN = 0x1000, InsertDeleteFlags::FORGETCAPTIONS = 0x2000, InsertDeleteFlags::ATTRIB = HARDATTR \| STYLES, InsertDeleteFlags::CONTENTS = VALUE \| DATETIME \| STRING \| NOTE \| FORMULA \| OUTLINE \| SPARKLINES, InsertDeleteFlags::ALL = CONTENTS \| ATTRIB \| OBJECTS \| SPARKLINES, InsertDeleteFlags::AUTOFILL = ALL & ~(NOTE \| OBJECTS) }

enum	ScPasteFunc { ScPasteFunc::NONE, ScPasteFunc::ADD, ScPasteFunc::SUB, ScPasteFunc::MUL, ScPasteFunc::DIV }

enum	HasAttrFlags { HasAttrFlags::NONE = 0x0000, HasAttrFlags::Lines = 0x0001, HasAttrFlags::Merged = 0x0002, HasAttrFlags::Overlapped = 0x0004, HasAttrFlags::Protected = 0x0008, HasAttrFlags::Shadow = 0x0010, HasAttrFlags::NeedHeight = 0x0020, HasAttrFlags::ShadowRight = 0x0040, HasAttrFlags::ShadowDown = 0x0080, HasAttrFlags::AutoFilter = 0x0100, HasAttrFlags::Conditional = 0x0200, HasAttrFlags::Rotate = 0x0400, HasAttrFlags::NotOverlapped = 0x0800, HasAttrFlags::RightOrCenter = 0x1000 }

enum	ScLinkMode { ScLinkMode::NONE, ScLinkMode::NORMAL, ScLinkMode::VALUE }

enum	ScEnterMode { ScEnterMode::NORMAL, ScEnterMode::BLOCK, ScEnterMode::MATRIX }

enum	ScScenarioFlags { ScScenarioFlags::NONE = 0, ScScenarioFlags::CopyAll = 1, ScScenarioFlags::ShowFrame = 2, ScScenarioFlags::PrintFrame = 4, ScScenarioFlags::TwoWay = 8, ScScenarioFlags::Attrib = 16, ScScenarioFlags::Value = 32, ScScenarioFlags::Protected = 64 }

enum	SubtotalFlags { SubtotalFlags::NONE = 0x00, SubtotalFlags::IgnoreNestedStAg = 0x08, SubtotalFlags::IgnoreErrVal = 0x04, SubtotalFlags::IgnoreHidden = 0x02, SubtotalFlags::IgnoreFiltered = 0x01 }

enum	ScCloneFlags { ScCloneFlags::Default = 0x0000, ScCloneFlags::StartListening = 0x0001, ScCloneFlags::NoMakeAbsExternal = 0x0002, ScCloneFlags::NamesToLocal = 0x0004 }

enum	CellType { CELLTYPE_NONE, CELLTYPE_VALUE, CELLTYPE_STRING, CELLTYPE_FORMULA, CELLTYPE_EDIT }

enum	DelCellCmd { DelCellCmd::CellsUp, DelCellCmd::CellsLeft, DelCellCmd::Rows, DelCellCmd::Cols, DelCellCmd::NONE }

enum	InsCellCmd { INS_CELLSDOWN, INS_CELLSRIGHT, INS_INSROWS_BEFORE, INS_INSCOLS_BEFORE, INS_NONE, INS_INSROWS_AFTER, INS_INSCOLS_AFTER }

enum	UpdateRefMode { URM_INSDEL, URM_COPY, URM_MOVE, URM_REORDER }

enum	FillDir { FILL_TO_BOTTOM, FILL_TO_RIGHT, FILL_TO_TOP, FILL_TO_LEFT }

enum	FillCmd { FILL_SIMPLE, FILL_LINEAR, FILL_GROWTH, FILL_DATE, FILL_AUTO }

enum	ScMoveDirection { SC_MOVE_RIGHT, SC_MOVE_LEFT, SC_MOVE_UP, SC_MOVE_DOWN }

enum	FillDateCmd { FILL_DAY, FILL_WEEKDAY, FILL_MONTH, FILL_END_OF_MONTH, FILL_YEAR }

enum	ScDirection { DIR_BOTTOM, DIR_RIGHT, DIR_TOP, DIR_LEFT }

enum	ScSizeMode { SC_SIZE_DIRECT, SC_SIZE_OPTIMAL, SC_SIZE_SHOW, SC_SIZE_VISOPT, SC_SIZE_ORIGINAL }

enum	ScInputMode { SC_INPUT_NONE, SC_INPUT_TYPE, SC_INPUT_TABLE, SC_INPUT_TOP }

enum	ScVObjMode { VOBJ_MODE_SHOW, VOBJ_MODE_HIDE }

enum	ScAnchorType { SCA_CELL, SCA_CELL_RESIZE, SCA_PAGE, SCA_DONTKNOW }

enum	ScGetDBMode { SC_DB_MAKE, SC_DB_AUTOFILTER, SC_DB_IMPORT, SC_DB_OLD }

enum	ScGetDBSelection { ScGetDBSelection::Keep, ScGetDBSelection::ShrinkToUsedData, ScGetDBSelection::RowDown, ScGetDBSelection::ForceMark }
	For ScDBFunc::GetDBData() More...

enum	ScLkUpdMode { LM_ALWAYS, LM_NEVER, LM_ON_DEMAND, LM_UNKNOWN }

enum	ScDBObject { ScDbTable, ScDbQuery }

enum	sc::ColRowEditAction { sc::ColRowEditAction::Unknown, sc::ColRowEditAction::InsertColumnsBefore, sc::ColRowEditAction::InsertColumnsAfter, sc::ColRowEditAction::InsertRowsBefore, sc::ColRowEditAction::InsertRowsAfter, sc::ColRowEditAction::DeleteColumns, sc::ColRowEditAction::DeleteRows }

enum	ScQueryOp { SC_EQUAL, SC_LESS, SC_GREATER, SC_LESS_EQUAL, SC_GREATER_EQUAL, SC_NOT_EQUAL, SC_TOPVAL, SC_BOTVAL, SC_TOPPERC, SC_BOTPERC, SC_CONTAINS, SC_DOES_NOT_CONTAIN, SC_BEGINS_WITH, SC_DOES_NOT_BEGIN_WITH, SC_ENDS_WITH, SC_DOES_NOT_END_WITH }

enum	ScQueryConnect { SC_AND, SC_OR }

enum	ScSubTotalFunc { SUBTOTAL_FUNC_NONE = 0, SUBTOTAL_FUNC_AVE = 1, SUBTOTAL_FUNC_CNT = 2, SUBTOTAL_FUNC_CNT2 = 3, SUBTOTAL_FUNC_MAX = 4, SUBTOTAL_FUNC_MIN = 5, SUBTOTAL_FUNC_PROD = 6, SUBTOTAL_FUNC_STD = 7, SUBTOTAL_FUNC_STDP = 8, SUBTOTAL_FUNC_SUM = 9, SUBTOTAL_FUNC_VAR = 10, SUBTOTAL_FUNC_VARP = 11, SUBTOTAL_FUNC_MED = 12, SUBTOTAL_FUNC_SELECTION_COUNT = 13 }

enum	ScAggregateFunc { AGGREGATE_FUNC_AVE = 1, AGGREGATE_FUNC_CNT = 2, AGGREGATE_FUNC_CNT2 = 3, AGGREGATE_FUNC_MAX = 4, AGGREGATE_FUNC_MIN = 5, AGGREGATE_FUNC_PROD = 6, AGGREGATE_FUNC_STD = 7, AGGREGATE_FUNC_STDP = 8, AGGREGATE_FUNC_SUM = 9, AGGREGATE_FUNC_VAR = 10, AGGREGATE_FUNC_VARP = 11, AGGREGATE_FUNC_MEDIAN = 12, AGGREGATE_FUNC_MODSNGL = 13, AGGREGATE_FUNC_LARGE = 14, AGGREGATE_FUNC_SMALL = 15, AGGREGATE_FUNC_PERCINC = 16, AGGREGATE_FUNC_QRTINC = 17, AGGREGATE_FUNC_PERCEXC = 18, AGGREGATE_FUNC_QRTEXC = 19 }

Functions
constexpr::tools::Long	sc::TwipsToEvenHMM (::tools::Long nTwips)

constexpr SdrLayerID	SC_LAYER_FRONT (0)

constexpr SdrLayerID	SC_LAYER_BACK (1)

constexpr SdrLayerID	SC_LAYER_INTERN (2)

constexpr SdrLayerID	SC_LAYER_CONTROLS (3)

constexpr SdrLayerID	SC_LAYER_HIDDEN (4)

Variables
constexpr OUStringLiteral	STRING_SCAPP = u"scalc"

constexpr OUStringLiteral	STRING_STANDARD = u"Standard"

constexpr OUStringLiteral	SC_TEXT_CSV_FILTER_NAME = u"Text - txt - csv (StarCalc)"

const sal_Unicode	CHAR_NBSP = 0x00A0

const sal_Unicode	CHAR_SHY = 0x00AD

const sal_Unicode	CHAR_ZWSP = 0x200B

const sal_Unicode	CHAR_LRM = 0x200E

const sal_Unicode	CHAR_RLM = 0x200F

const sal_Unicode	CHAR_NBHY = 0x2011

const sal_Unicode	CHAR_WJ = 0x2060

const sal_Unicode	CHAR_NNBSP = 0x202F

const SCSIZE	MAXSUBTOTAL = 3

constexpr auto	TWIPS_PER_CHAR = o3tl::toTwips(1 / 13.6, o3tl::Length::in)

constexpr sal_Int32	STD_COL_WIDTH = o3tl::convert(64, o3tl::Length::pt, o3tl::Length::twip)

constexpr sal_Int32	STD_EXTRA_WIDTH = o3tl::convert(2, o3tl::Length::mm, o3tl::Length::twip)

constexpr sal_Int32	MAX_EXTRA_WIDTH = o3tl::convert(42, o3tl::Length::cm, o3tl::Length::twip)

constexpr sal_Int32	MAX_EXTRA_HEIGHT = o3tl::convert(42, o3tl::Length::cm, o3tl::Length::twip)

constexpr sal_Int32	MAX_COL_WIDTH = o3tl::convert(1, o3tl::Length::m, o3tl::Length::twip)

constexpr sal_Int32	MAX_ROW_HEIGHT = o3tl::convert(1, o3tl::Length::m, o3tl::Length::twip)

SfxViewShell *	pScActiveViewShell

sal_uInt16	nScClickMouseModifier

sal_uInt16	nScFillModeMouseModifier

Macro Definition Documentation

#define MAXDOUBLE 1.7e307

Definition at line 76 of file global.hxx.

Referenced by ScVbaRange::AutoFill(), ScFillSeriesDlg::CheckValues(), ScInterpreter::DBIterator(), ScCellShell::ExecuteEdit(), ScDocFunc::FillAuto(), ScTable::FillAuto(), ScDocFunc::FillSeries(), ScCellRangeObj::fillSeries(), ScDocFunc::FillSimple(), ScFillSeriesDlg::Init(), and ScUndoAutoFill::Redo().

#define MAXZOOM 400

Definition at line 79 of file global.hxx.

Referenced by ScTabView::CalcZoom(), ScTabViewShell::Execute(), ScPreviewShell::GetState(), ScTabViewShell::GetState(), ScPreviewShell::ScrollCommand(), ScTabView::ScrollCommand(), ScSpreadsheetSettings::setPropertyValue(), and ScTabViewObj::SetZoomType().

#define MINDOUBLE 1.7e-307

Definition at line 75 of file global.hxx.

#define MINZOOM 20

Definition at line 78 of file global.hxx.

Referenced by ScTabView::CalcZoom(), ScTabViewShell::Execute(), ScPreviewShell::GetState(), ScTabViewShell::GetState(), ScPreviewShell::ScrollCommand(), ScTabView::ScrollCommand(), ScSpreadsheetSettings::setPropertyValue(), and ScTabViewObj::SetZoomType().

#define OLE_STD_CELLS_X 4

Definition at line 103 of file global.hxx.

Referenced by ScPrintFunc::DrawToDev(), ScDocShell::InitNew(), and ScViewData::ScViewData().

#define OLE_STD_CELLS_Y 5

Definition at line 104 of file global.hxx.

Referenced by ScPrintFunc::DrawToDev(), ScDocShell::InitNew(), and ScViewData::ScViewData().

#define SC_COLLATOR_IGNORES css::i18n::CollatorOptions::CollatorOptions_IGNORE_CASE

Definition at line 51 of file global.hxx.

Referenced by ScGlobal::GetCollator(), and ScTable::InitSortCollator().

#define SC_INDENT_STEP 200

Definition at line 222 of file global.hxx.

Referenced by ScAttrArray::ChangeIndent().

#define STD_ROWHEIGHT_DIFF 23

Definition at line 95 of file global.hxx.

Referenced by ScGlobal::InitTextHeight(), and lcl_GetAttribHeight().

Enumeration Type Documentation

enum CellType

Enumerator
CELLTYPE_NONE
CELLTYPE_VALUE
CELLTYPE_STRING
CELLTYPE_FORMULA
CELLTYPE_EDIT

Definition at line 269 of file global.hxx.

enum CRFlags : sal_uInt8

strong

Enumerator
NONE
Hidden
ManualBreak
Filtered
ManualSize
All

Definition at line 124 of file global.hxx.

enum DelCellCmd

strong

Enumerator
CellsUp
CellsLeft
Rows
Cols
NONE

Definition at line 278 of file global.hxx.

enum FillCmd

Enumerator
FILL_SIMPLE
FILL_LINEAR
FILL_GROWTH
FILL_DATE
FILL_AUTO

Definition at line 314 of file global.hxx.

enum FillDateCmd

Enumerator
FILL_DAY
FILL_WEEKDAY
FILL_MONTH
FILL_END_OF_MONTH
FILL_YEAR

Definition at line 331 of file global.hxx.

enum FillDir

Enumerator
FILL_TO_BOTTOM
FILL_TO_RIGHT
FILL_TO_TOP
FILL_TO_LEFT

Definition at line 306 of file global.hxx.

enum HasAttrFlags

strong

Enumerator
NONE
Lines
Merged
Overlapped
Protected
Shadow
NeedHeight
ShadowRight
ShadowDown
AutoFilter
Conditional
Rotate
NotOverlapped
RightOrCenter

Definition at line 183 of file global.hxx.

enum InsCellCmd

Enumerator
INS_CELLSDOWN
INS_CELLSRIGHT
INS_INSROWS_BEFORE
INS_INSCOLS_BEFORE
INS_NONE
INS_INSROWS_AFTER
INS_INSCOLS_AFTER

Definition at line 287 of file global.hxx.

enum InsertDeleteFlags : sal_uInt16

strong

Enumerator
NONE
VALUE
DATETIME	Numeric values (and numeric results if InsertDeleteFlags::FORMULA is not set).
STRING	Dates, times, datetime values.
NOTE	Strings (and string results if InsertDeleteFlags::FORMULA is not set).
FORMULA	Cell notes.
HARDATTR	Formula cells.
STYLES	Hard cell attributes.
OBJECTS	Cell styles.
EDITATTR	Drawing objects.
OUTLINE	Rich-text attributes.
SPARKLINES	Sheet / outlining (grouping) information.
NOCAPTIONS	Sparklines in a cell.
ADDNOTES	Internal use only (undo etc.): do not copy/delete caption objects of cell notes.
SPECIAL_BOOLEAN	Internal use only (copy from clip): do not delete existing cell contents when pasting notes.
FORGETCAPTIONS
ATTRIB	Internal use only (d&d undo): do not delete caption objects of cell notes.
CONTENTS
ALL
AUTOFILL	Copy flags for auto/series fill functions: do not touch notes and drawing objects.

Definition at line 147 of file global.hxx.

enum PaintPartFlags

strong

Enumerator
NONE
Grid
Top
Left
Extras
Marks
Objects
Size
All

Definition at line 108 of file global.hxx.

enum ScAggregateFunc

Enumerator
AGGREGATE_FUNC_AVE
AGGREGATE_FUNC_CNT
AGGREGATE_FUNC_CNT2
AGGREGATE_FUNC_MAX
AGGREGATE_FUNC_MIN
AGGREGATE_FUNC_PROD
AGGREGATE_FUNC_STD
AGGREGATE_FUNC_STDP
AGGREGATE_FUNC_SUM
AGGREGATE_FUNC_VAR
AGGREGATE_FUNC_VARP
AGGREGATE_FUNC_MEDIAN
AGGREGATE_FUNC_MODSNGL
AGGREGATE_FUNC_LARGE
AGGREGATE_FUNC_SMALL
AGGREGATE_FUNC_PERCINC
AGGREGATE_FUNC_QRTINC
AGGREGATE_FUNC_PERCEXC
AGGREGATE_FUNC_QRTEXC

Definition at line 861 of file global.hxx.

enum ScAnchorType

Enumerator
SCA_CELL
SCA_CELL_RESIZE
SCA_PAGE
SCA_DONTKNOW

Definition at line 371 of file global.hxx.

enum ScBreakType

strong

Enumerator
NONE
Page
Manual

Definition at line 138 of file global.hxx.

enum ScCloneFlags

strong

Enumerator
Default	Default cell clone flags: do not start listening, do not adjust 3D refs to old position, clone note captions of cell notes.
StartListening	If set, cloned formula cells will start to listen to the document.
NoMakeAbsExternal	If set, absolute refs will not transformed to external references.
NamesToLocal	If set, global named expressions will be converted to sheet-local named expressions.

Definition at line 249 of file global.hxx.

enum ScDBObject

Enumerator
ScDbTable
ScDbQuery

Definition at line 416 of file global.hxx.

enum ScDirection

Enumerator
DIR_BOTTOM
DIR_RIGHT
DIR_TOP
DIR_LEFT

Definition at line 340 of file global.hxx.

enum ScEnterMode

strong

Enumerator
NORMAL
BLOCK
MATRIX

Definition at line 217 of file global.hxx.

enum ScGetDBMode

Enumerator
SC_DB_MAKE	create "untitled" (if necessary)
SC_DB_AUTOFILTER	force use of sheet-local instead of document global anonymous range
SC_DB_IMPORT	create "Importx" (if necessary)
SC_DB_OLD	don't create

Definition at line 379 of file global.hxx.

enum ScGetDBSelection

strong

For ScDBFunc::GetDBData()

Enumerator
Keep	Keep selection as is, expand to used data area if no selection.
ShrinkToUsedData	Shrink selection to actually used data area within the selection.
RowDown	If only one row or portion thereof is selected, shrink row to used data columns and select further rows down until end of data. If an area is selected, shrink rows to actually used columns. Else, no selection, expand to used data area.
ForceMark	Behave as if the range corresponding to a ScDBData area was selected, for API use.

Definition at line 388 of file global.hxx.

enum ScInputMode

Enumerator
SC_INPUT_NONE
SC_INPUT_TYPE
SC_INPUT_TABLE
SC_INPUT_TOP

Definition at line 357 of file global.hxx.

enum ScLinkMode

strong

Enumerator
NONE
NORMAL
VALUE

Definition at line 213 of file global.hxx.

enum ScLkUpdMode

Enumerator
LM_ALWAYS
LM_NEVER
LM_ON_DEMAND
LM_UNKNOWN

Definition at line 407 of file global.hxx.

enum ScMoveDirection

Enumerator
SC_MOVE_RIGHT
SC_MOVE_LEFT
SC_MOVE_UP
SC_MOVE_DOWN

Definition at line 323 of file global.hxx.

enum ScPasteFunc

strong

Enumerator
NONE
ADD
SUB
MUL
DIV

Definition at line 179 of file global.hxx.

enum ScQueryConnect

Enumerator
SC_AND
SC_OR

Definition at line 837 of file global.hxx.

enum ScQueryOp

Enumerator
SC_EQUAL
SC_LESS
SC_GREATER
SC_LESS_EQUAL
SC_GREATER_EQUAL
SC_NOT_EQUAL
SC_TOPVAL
SC_BOTVAL
SC_TOPPERC
SC_BOTPERC
SC_CONTAINS
SC_DOES_NOT_CONTAIN
SC_BEGINS_WITH
SC_DOES_NOT_BEGIN_WITH
SC_ENDS_WITH
SC_DOES_NOT_END_WITH

Definition at line 817 of file global.hxx.

enum ScScenarioFlags

strong

Enumerator
NONE
CopyAll
ShowFrame
PrintFrame
TwoWay
Attrib
Value
Protected

Definition at line 224 of file global.hxx.

enum ScSizeMode

Enumerator
SC_SIZE_DIRECT
SC_SIZE_OPTIMAL
SC_SIZE_SHOW
SC_SIZE_VISOPT
SC_SIZE_ORIGINAL

Definition at line 348 of file global.hxx.

enum ScSubTotalFunc

Enumerator
SUBTOTAL_FUNC_NONE
SUBTOTAL_FUNC_AVE
SUBTOTAL_FUNC_CNT
SUBTOTAL_FUNC_CNT2
SUBTOTAL_FUNC_MAX
SUBTOTAL_FUNC_MIN
SUBTOTAL_FUNC_PROD
SUBTOTAL_FUNC_STD
SUBTOTAL_FUNC_STDP
SUBTOTAL_FUNC_SUM
SUBTOTAL_FUNC_VAR
SUBTOTAL_FUNC_VARP
SUBTOTAL_FUNC_MED
SUBTOTAL_FUNC_SELECTION_COUNT