com.aspose.cells
Classes 
AboveAverage
AbstractCalculationEngine
AbstractCalculationMonitor
ArcShape
Area
AutoFilter
AutoFitterOptions
AutomaticFill
Axis
Bevel
Border
BorderCollection
BuiltInDocumentPropertyCollection
Button
CalculationCell
CalculationData
CalculationOptions
Cell
CellArea
Cells
CellsColor
CellsDrawing
CellsException
CellsFactory
CellsHelper
CellWatch
CellWatchCollection
Chart
ChartArea
ChartCollection
ChartDataTable
ChartFrame
ChartPoint
ChartPointCollection
ChartShape
ChartTextFrame
CheckBox
CheckBoxCollection
CollectionBase
Color
ColorFilter
ColorHelper
ColorScale
Column
ColumnCollection
ComboBox
Comment
CommentCollection
CommentShape
ConditionalFormattingCollection
ConditionalFormattingIcon
ConditionalFormattingIconCollection
ConditionalFormattingResult
ConditionalFormattingValue
ConditionalFormattingValueCollection
ConnectionParameter
ConnectionParameterCollection
ContentTypeProperty
ContentTypePropertyCollection
CopyOptions
CustomDocumentPropertyCollection
CustomFilter
CustomFilterCollection
CustomGeometry
CustomImplementationFactory
CustomProperty
CustomPropertyCollection
CustomXmlPart
CustomXmlPartCollection
CustomXmlShape
DataBar
DataBarBorder
DataLabels
DataSorter
DataSorterKey
DataSorterKeyCollection
DateTime
DateTimeGroupItem
DBConnection
DeleteOptions
DialogBox
DifSaveOptions
DigitalSignature
DigitalSignatureCollection
DisplayUnitLabel
DocumentProperty
DocumentPropertyCollection
DrawObject
DrawObjectEventHandler
DropBars
DxfCollection
DynamicFilter
Encoding
ErrorBar
ErrorCheckOption
ErrorCheckOptionCollection
ExportObjectEvent
ExportTableOptions
ExternalConnection
ExternalConnectionCollection
ExternalLink
ExternalLinkCollection
FileFontSource
FileFormatInfo
FileFormatUtil
Fill
FillFormat
FilterColumn
FilterColumnCollection
FindOptions
Floor
FolderFontSource
Font
FontConfigs
FontSetting
FontSourceBase
Format3D
FormatCondition
FormatConditionCollection
Geometry
GlobalizationSettings
GlowEffect
GradientFill
GradientStop
GradientStopCollection
GroupBox
GroupFill
GroupShape
HeaderFooterCommand
HorizontalPageBreak
HorizontalPageBreakCollection
HTMLLoadOptions
HtmlSaveOptions
Hyperlink
HyperlinkCollection
IconFilter
IconSet
ImageFormat
ImageOrPrintOptions
ImageSaveOptions
ImportTableOptions
IndividualFontConfigs
InterruptMonitor
Label
Legend
LegendEntry
LegendEntryCollection
License
Line
LineFormat
LineShape
ListBox
ListColumn
ListColumnCollection
ListObject
ListObjectCollection
LoadDataOption
LoadFilter
LoadOptions
Marker
MemoryFontSource
Metered
MsoFillFormat
MsoFillFormatHelper
MsoFormatPicture
MsoLineFormat
MsoLineFormatHelper
MsoTextFrame
MultipleFilterCollection
Name
NameCollection
NegativeBarFormat
NoneFill
ODSLoadOptions
OdsSaveOptions
OleObject
OleObjectCollection
OoxmlSaveOptions
Oval
PageSetup
PaneCollection
PasteOptions
PatternFill
PdfBookmarkEntry
PdfSaveOptions
PdfSecurityOptions
PicFormatOption
Picture
PictureCollection
PivotField
PivotFieldCollection
PivotFilter
PivotFilterCollection
PivotFormatCondition
PivotFormatConditionCollection
PivotItem
PivotItemCollection
PivotPageFields
PivotTable
PivotTableCollection
PlotArea
ProtectedRange
ProtectedRangeCollection
Protection
QueryTable
QueryTableCollection
RadioButton
Range
RangeCollection
RectangleShape
ReferredArea
ReferredAreaCollection
ReflectionEffect
ReplaceOptions
Row
RowCollection
SaveOptions
Scenario
ScenarioCollection
ScenarioInputCell
ScenarioInputCellCollection
ScrollBar
Series
SeriesCollection
SeriesLayoutProperties
ShadowEffect
Shape
ShapeCollection
ShapeFormat
ShapeGuide
ShapeGuideCollection
ShapePath
ShapePathCollection
ShapePathPoint
ShapePathPointCollection
ShapePropertyCollection
ShapeSegmentPath
ShapeSegmentPathCollection
SheetRender
SignatureLine
SmartArtShape
SmartTag
SmartTagCollection
SmartTagOptions
SmartTagProperty
SmartTagPropertyCollection
SmartTagSetting
SolidFill
Sparkline
SparklineCollection
SparklineGroup
SparklineGroupCollection
Spinner
SpreadsheetML2003SaveOptions
StreamProviderOptions
Style
StyleCollection
StyleFlag
SubtotalSetting
SvgSaveOptions
SxRng
TableStyle
TableStyleCollection
TableStyleElement
TableStyleElementCollection
TextBox
TextBoxCollection
TextEffectFormat
TextureFill
ThemeColor
ThreeDFormat
TickLabels
TilePicOption
Title
Top10
Top10Filter
Trendline
TrendlineCollection
TxtLoadOptions
TxtSaveOptions
Validation
ValidationCollection
VbaModule
VbaModuleCollection
VbaProject
VbaProjectReference
VbaProjectReferenceCollection
VerticalPageBreak
VerticalPageBreakCollection
Walls
WarningInfo
WebQueryConnection
Workbook
WorkbookDesigner
WorkbookRender
WorkbookSettings
Worksheet
WorksheetCollection
WriteProtection
XlsbSaveOptions
XlsSaveOptions
XmlColumnProperty
XmlDataBinding
XmlMap
XmlMapCollection
XpsSaveOptions
Interfaces 
ICellsDataTable
ICustomFunction
ICustomParser
IExportObjectListener
IFilePathProvider
ISmartMarkerCallBack
IStreamProvider
IWarningCallback
LightCellsDataHandler
LightCellsDataProvider
Constants 
AutoShapeType
AxisType
BackgroundMode
BackgroundType
Bar3DShapeType
BevelPresetType
BevelType
BorderType
BubbleSizeRepresents
BuiltinStyleType
CalcModeType
CalculationPrecisionStrategy
CategoryType
CellBorderType
CellValueFormatStrategy
CellValueType
ChartLineFormattingType
ChartMarkerType
ChartSplitType
ChartType
CheckValueType
ColorDepth
ColorType
ConnectionDataSourceType
ConnectionParameterType
ConsolidationFunction
CountryCode
CredentialsMethodType
CrossType
DataBarAxisPosition
DataBarBorderType
DataBarFillType
DataBarNegativeColorType
DataLabelShapeType
DataLablesSeparatorType
DateTimeGroupingType
DirectoryType
DisplayDrawingObjects
DisplayUnitType
DrawObjectEnum
DynamicFilterType
EncryptionType
ErrorBarDisplayType
ErrorBarType
ErrorCheckType
ExceptionType
ExternalLinkType
FileFormatType
FillPattern
FillPictureType
FillType
FilterOperatorType
FilterType
FontSchemeType
FontSourceType
FontUnderlineType
FormatConditionType
FormatConditionValueType
FormatSetType
FormattingType
GradientColorType
GradientDirectionType
GradientFillType
GradientPresetType
GradientStyleType
GridlineType
HeaderFooterCommandType
HtmlCrossType
HtmlExportDataOptions
HtmlFormatHandlingType
HtmlHiddenColDisplayType
HtmlHiddenRowDisplayType
HtmlLinkTargetType
IconSetType
ImageType
LabelPositionType
LegendPositionType
LightRigDirectionType
LightRigType
LineCapType
LineJoinType
LineType
LoadDataFilterOptions
LoadFormat
LookAtType
LookInType
MapChartLabelLayout
MapChartProjectionType
MapChartRegionType
MemorySetting
MirrorType
MsoArrowheadLength
MsoArrowheadStyle
MsoArrowheadWidth
MsoDrawingType
MsoLineDashStyle
MsoLineStyle
MsoPresetTextEffect
MsoPresetTextEffectShape
NumberCategoryType
OLEDBCommandType
OleFileType
OoxmlCompliance
OperatorType
Outline
PageLayoutAlignmentType
PageOrientationType
PaperSizeType
ParameterType
PasteType
PdfCompliance
PdfCompressionCore
PdfCustomPropertiesExport
PdfOptimizationType
PivotConditionFormatRuleType
PivotConditionFormatScopeType
PivotFieldDataDisplayFormat
PivotFieldSubtotalType
PivotFieldType
PivotFilterType
PivotGroupByType
PivotItemPosition
PivotMissingItemLimitType
PivotOptions
PivotTableAutoFormatType
PivotTableStyleType
PlacementType
PlotEmptyCellsType
PresetCameraType
PresetMaterialType
PresetShadowType
PresetWordArtStyle
PrintCommentsType
PrintErrorsType
PrintingPageType
PrintOrderType
PrintSizeType
PropertyType
ProtectionType
QuartileCalculationType
ReConnectionMethodType
RectangleAlignmentType
ReflectionEffectType
RegexType
RenameStrategy
ResourceLoadingType
SaveFormat
SelectionType
ShapeLockType
ShapePathType
SheetType
ShiftType
SmartTagShowType
SortOnType
SortOrder
SparklineAxisMinMaxType
SparklinePresetStyleType
SparklineType
SqlDataType
StyleModifyFlag
TableDataSourceType
TableStyleElementType
TableStyleType
TextAlignmentType
TextCapsType
TextCrossType
TextDirectionType
TextOrientationType
TextOverflowType
TextStrikeType
TextureType
ThemeColorType
TickLabelPositionType
TickMarkType
TiffCompression
TimePeriodType
TimeUnit
TotalsCalculation
TrendlineType
TxtLoadStyleStrategy
TxtValueQuoteType
UpdateLinksType
ValidationAlertType
ValidationType
VbaModuleType
VbaProjectReferenceType
ViewType
VisibilityType
WarningType
WeightType

com.aspose.cells
Class GlobalizationSettings

java.lang.Object
    extended by com.aspose.cells.GlobalizationSettings

public class GlobalizationSettings 
extends java.lang.Object

Repsents the globalization settings.

Constructor Summary
GlobalizationSettings()
          
 
Property Getters/Setters Summary
chargetColumnSeparatorOfFormulaArray()
           Gets the separator for the items in array's row data in formula.
chargetListSeparator()
           Gets the separator for list, parameters of function, ...etc.
chargetRowSeparatorOfFormulaArray()
           Gets the separator for rows in array data in formula.
 
Method Summary
java.lang.StringgetAllName()
           Gets the name of "(All)" label in the PivotTable.
java.lang.StringgetBooleanValueString(boolean bv)
           Gets the display string value for cell's boolean value
java.lang.StringgetColumnLablesName()
           Gets the name of "Column Labels" label in the PivotTable.
java.lang.StringgetEmptyDataName()
           Gets the name of "(blank)" label in the PivotTable.
java.lang.StringgetErrorValueString(java.lang.String err)
           Gets the display string value for cell's error value
java.lang.StringgetGrandTotalName(int functionType)
           Gets the grand total name of the function.
java.lang.StringgetLocalBuiltInName(java.lang.String standardName)
           Gets the locale dependent text for built-in Name according to given standard text.
java.lang.StringgetLocalFunctionName(java.lang.String standardName)
           Gets the locale dependent function name according to given standard function name.
java.lang.StringgetMultipleItemsName()
           Gets the name of "(Multiple Items)" label in the PivotTable.
java.lang.StringgetOtherName()
           Gets the name of "Other" labels for Pie charts.
java.lang.StringgetPivotGrandTotalName()
           Gets the name of "Grand Total" label in the PivotTable.
java.lang.StringgetPivotTotalName()
           Gets the name of "Total" label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.
java.lang.StringgetRowLablesName()
           Gets the name of "Row Labels" label in the PivotTable.
java.lang.StringgetStandardBuiltInName(java.lang.String localName)
           Gets the standard text of built-in Name according to given locale dependent text.
java.lang.StringgetStandardFunctionName(java.lang.String localName)
           Gets the standard function name according to given locale dependent function name.
java.lang.StringgetStandardHeaderFooterFontStyleName(java.lang.String localfontStyleName)
           Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
java.lang.StringgetSubTotalName(int subTotalType)
           Gets the name of PivotFieldSubtotalType type in the PivotTable.
java.lang.StringgetTableRowTypeOfAll()
           Gets the type name of table rows that consists of all rows in referenced table. Default is "All": "#All" denotes all rows in referenced table.
java.lang.StringgetTableRowTypeOfCurrent()
           Gets the type name of table rows that consists of the current row in referenced table. Default is "This Row": "#This Row" denotes the current row in referenced table.
java.lang.StringgetTableRowTypeOfData()
           Gets the type name of table rows that consists of data region of referenced table. Default is "Data": "#Data" denotes the data region of the table.
java.lang.StringgetTableRowTypeOfHeaders()
           Gets the type name of table rows that consists of the table header. Default is "Headers": "#Headers" denotes the table header.
java.lang.StringgetTableRowTypeOfTotals()
           Gets the type name of table rows that consists of the total row of referenced table. Default is "Totals": "#Totals" denotes the total row of referenced table.
java.lang.StringgetTotalName(int functionType)
           Gets the total name of the function.
 

Constructor Detail

GlobalizationSettings

public GlobalizationSettings()

Property Getters/Setters Detail

getListSeparator

public char getListSeparator()
Gets the separator for list, parameters of function, ...etc.

getRowSeparatorOfFormulaArray

public char getRowSeparatorOfFormulaArray()
Gets the separator for rows in array data in formula.

getColumnSeparatorOfFormulaArray

public char getColumnSeparatorOfFormulaArray()
Gets the separator for the items in array's row data in formula.

Method Detail

getPivotTotalName

public java.lang.String getPivotTotalName()
Gets the name of "Total" label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.
Returns:
The name of "Total" label

getPivotGrandTotalName

public java.lang.String getPivotGrandTotalName()
Gets the name of "Grand Total" label in the PivotTable.
Returns:
The name of "Grand Total" label

getMultipleItemsName

public java.lang.String getMultipleItemsName()
Gets the name of "(Multiple Items)" label in the PivotTable.
Returns:
The name of "(Multiple Items)" label

getAllName

public java.lang.String getAllName()
Gets the name of "(All)" label in the PivotTable.
Returns:
The name of "(All)" label

getColumnLablesName

public java.lang.String getColumnLablesName()
Gets the name of "Column Labels" label in the PivotTable.
Returns:
The name of column labels

getRowLablesName

public java.lang.String getRowLablesName()
Gets the name of "Row Labels" label in the PivotTable.
Returns:
The name of row labels

getEmptyDataName

public java.lang.String getEmptyDataName()
Gets the name of "(blank)" label in the PivotTable.
Returns:
The name of empty data

getSubTotalName

public java.lang.String getSubTotalName(int subTotalType)
Gets the name of PivotFieldSubtotalType type in the PivotTable.
Parameters:
subTotalType - A PivotFieldSubtotalType value. The PivotFieldSubtotalType type
Returns:
The name of PivotFieldSubtotalType type

getTotalName

public java.lang.String getTotalName(int functionType)
Gets the total name of the function.
Parameters:
functionType - A ConsolidationFunction value. The function type.
Returns:
The total name of the function.

getGrandTotalName

public java.lang.String getGrandTotalName(int functionType)
Gets the grand total name of the function.
Parameters:
functionType - A ConsolidationFunction value. The function type.
Returns:
The grand total name of the function.

getOtherName

public java.lang.String getOtherName()
Gets the name of "Other" labels for Pie charts.
Returns:

getTableRowTypeOfHeaders

public java.lang.String getTableRowTypeOfHeaders()
Gets the type name of table rows that consists of the table header. Default is "Headers": "#Headers" denotes the table header.
Returns:
the type name of table rows

getTableRowTypeOfData

public java.lang.String getTableRowTypeOfData()
Gets the type name of table rows that consists of data region of referenced table. Default is "Data": "#Data" denotes the data region of the table.
Returns:
the type name of table rows

getTableRowTypeOfAll

public java.lang.String getTableRowTypeOfAll()
Gets the type name of table rows that consists of all rows in referenced table. Default is "All": "#All" denotes all rows in referenced table.
Returns:
the type name of table rows

getTableRowTypeOfTotals

public java.lang.String getTableRowTypeOfTotals()
Gets the type name of table rows that consists of the total row of referenced table. Default is "Totals": "#Totals" denotes the total row of referenced table.
Returns:
the type name of table rows

getTableRowTypeOfCurrent

public java.lang.String getTableRowTypeOfCurrent()
Gets the type name of table rows that consists of the current row in referenced table. Default is "This Row": "#This Row" denotes the current row in referenced table.
Returns:
the type name of table rows

getErrorValueString

public java.lang.String getErrorValueString(java.lang.String err)
Gets the display string value for cell's error value
Parameters:
err - error values such as #VALUE!,#NAME?
Returns:
Default returns the error value itself

getBooleanValueString

public java.lang.String getBooleanValueString(boolean bv)
Gets the display string value for cell's boolean value
Parameters:
bv - boolean value
Returns:
Default returns "TRUE" for true value and "FALSE" for false value.

getLocalFunctionName

public java.lang.String getLocalFunctionName(java.lang.String standardName)
Gets the locale dependent function name according to given standard function name.
Parameters:
standardName - Standard(en-US locale) function name.
Returns:
Locale dependent function name. The locale was specified by the Workbook for which this settings is used.

getStandardFunctionName

public java.lang.String getStandardFunctionName(java.lang.String localName)
Gets the standard function name according to given locale dependent function name.
Parameters:
localName - Locale dependent function name. The locale was specified by the Workbook for which this settings is used.
Returns:
Standard(en-US locale) function name.

getLocalBuiltInName

public java.lang.String getLocalBuiltInName(java.lang.String standardName)
Gets the locale dependent text for built-in Name according to given standard text.
Parameters:
standardName - Standard(en-US locale) text of built-in Name.
Returns:
Locale dependent text. The locale was specified by the Workbook for which this settings is used.

getStandardBuiltInName

public java.lang.String getStandardBuiltInName(java.lang.String localName)
Gets the standard text of built-in Name according to given locale dependent text.
Parameters:
localName - Locale dependent text of built-in Name. The locale was specified by the Workbook for which this settings is used.
Returns:
Standard(en-US locale) text.

getStandardHeaderFooterFontStyleName

public java.lang.String getStandardHeaderFooterFontStyleName(java.lang.String localfontStyleName)
Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
Parameters:
localfontStyleName - Locale font style name for Header/Footer.
Returns:
Standard English font style name(Regular, Bold, Italic)

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.