menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class FormatsCollection - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Class FormatsCollection

    Represents collection of formats in the workbook.

    Inheritance
    System.Object
    CommonObject
    FormatsCollection
    Implements
    IParentApplication
    System.IDisposable
    Inherited Members
    CommonObject.AddReference()
    CommonObject.AppImplementation
    CommonObject.Application
    CommonObject.CheckDisposed()
    CommonObject.Dispose()
    CommonObject.Finalize()
    CommonObject.FindParent(Object, Type)
    CommonObject.FindParent(Object, Type, Boolean)
    CommonObject.FindParent(Type)
    CommonObject.FindParent(Type, Boolean)
    CommonObject.FindParent(Type[])
    CommonObject.FindParents(Type[])
    CommonObject.m_bIsDisposed
    CommonObject.OnDispose()
    CommonObject.Parent
    CommonObject.ReferenceCount
    CommonObject.ReleaseReference()
    CommonObject.SetParent(Object)
    Namespace: Syncfusion.XlsIO.Implementation.Collections
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public class FormatsCollection : CommonObject, IParentApplication, IDisposable

    Constructors

    FormatsCollection(IApplication, Object)

    Initializes new instance and sets its application and parent objects.

    Declaration
    public FormatsCollection(IApplication application, object parent)
    Parameters
    Type Name Description
    IApplication application

    Application object to set.

    System.Object parent

    Parent object to set.

    Fields

    Currency

    Represents the Currency Symbol. TODO: support currency based on the Culture.

    Declaration
    public const string Currency = "$"
    Field Value
    Type
    System.String

    Date

    Represents the index of the date format.

    Declaration
    public const string Date = "date"
    Field Value
    Type
    System.String

    DecimalSeparator

    Represents the Decimal Seprator.

    Declaration
    public const string DecimalSeparator = "."
    Field Value
    Type
    System.String

    DEFAULT_EXPONENTAIL

    Represents the default exponential.

    Declaration
    public const string DEFAULT_EXPONENTAIL = "E+"
    Field Value
    Type
    System.String

    Exponent

    Represents the Exponenet Symbol.

    Declaration
    public const string Exponent = "E"
    Field Value
    Type
    System.String

    Fraction

    Represents the fraction symbol.

    Declaration
    public const string Fraction = "/"
    Field Value
    Type
    System.String

    Minus

    Represents the Minus symbol.

    Declaration
    public const string Minus = "-"
    Field Value
    Type
    System.String

    Percentage

    Represents the percentage in decimal numbers.

    Declaration
    public const string Percentage = "%"
    Field Value
    Type
    System.String

    ThousandSeparator

    Represents the Thousand seprator.

    Declaration
    public const string ThousandSeparator = ","
    Field Value
    Type
    System.String

    Time

    Represents the time separator.

    Declaration
    public const string Time = ":"
    Field Value
    Type
    System.String

    Properties

    Count

    Gets the number of elements contained in the collection. Read-only

    Declaration
    public int Count { get; }
    Property Value
    Type
    System.Int32

    IsFixedSize

    Gets a value indicating whether the collection has a fixed size. Read-only.

    Declaration
    public bool IsFixedSize { get; }
    Property Value
    Type
    System.Boolean

    IsReadOnly

    Gets a value indicating whether the IDictionary is read-only. Read-only.

    Declaration
    public bool IsReadOnly { get; }
    Property Value
    Type
    System.Boolean

    IsSynchronized

    Gets a value indicating whether access to the collection is synchronized (thread-safe).

    Declaration
    public bool IsSynchronized { get; }
    Property Value
    Type
    System.Boolean

    Item[Int32]

    Returns single entry from the collection. Read-only.

    Declaration
    public FormatImpl this[int iIndex] { get; }
    Parameters
    Type Name Description
    System.Int32 iIndex
    Property Value
    Type
    FormatImpl

    Item[String]

    Returns single entry from the collection by format string. Read-only.

    Declaration
    public FormatImpl this[string strFormat] { get; }
    Parameters
    Type Name Description
    System.String strFormat
    Property Value
    Type
    FormatImpl

    Keys

    Gets an ICollection containing the keys of the collection. Read-only.

    Declaration
    public ICollection Keys { get; }
    Property Value
    Type
    System.Collections.ICollection

    Parser

    Returns format parser. Read-only.

    Declaration
    public FormatParserImpl Parser { get; }
    Property Value
    Type
    FormatParserImpl

    SyncRoot

    Gets an object that can be used to synchronize access to the collection.

    Declaration
    public object SyncRoot { get; }
    Property Value
    Type
    System.Object

    Values

    Declaration
    public ICollection Values { get; }
    Property Value
    Type
    System.Collections.ICollection

    Methods

    Add(FormatRecord)

    Adds new format to the collection.

    Declaration
    public void Add(FormatRecord format)
    Parameters
    Type Name Description
    FormatRecord format

    Format to add.

    AddRange(IDictionary, FormatsCollection)

    Adds format range to the collection.

    Declaration
    public Dictionary<int, int> AddRange(IDictionary dicIndexes, FormatsCollection source)
    Parameters
    Type Name Description
    System.Collections.IDictionary dicIndexes

    Dictionary with format indexes to add.

    FormatsCollection source

    Source collection.

    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.Int32, System.Int32>

    Dictionary with updated indexes: key - old index, value - new index.

    Clear()

    Removes all elements from the IDictionary.

    Declaration
    public void Clear()

    Clone(Object)

    Creates copy of the current instance.

    Declaration
    public FormatsCollection Clone(object parent)
    Parameters
    Type Name Description
    System.Object parent

    Parent object for the new collection.

    Returns
    Type Description
    FormatsCollection

    Copy of the current instance.

    Contains(Int32)

    Determines whether the IDictionary contains an element with the specified key.

    Declaration
    public bool Contains(int key)
    Parameters
    Type Name Description
    System.Int32 key

    The key to locate in the IDictionary.

    Returns
    Type Description
    System.Boolean

    True if the IDictionary contains an element with the key; otherwise, False.

    ContainsFormat(String)

    Determines whether the IDictionary contains an element with the specified format.

    Declaration
    public bool ContainsFormat(string formatString)
    Parameters
    Type Name Description
    System.String formatString

    Format to locate in the collection.

    Returns
    Type Description
    System.Boolean

    True if the collection contains an element with the key; otherwise, False.

    CopyTo(Array, Int32)

    Copies the elements of the collection to an Array, starting at a particular Array index.

    Declaration
    public void CopyTo(Array array, int index)
    Parameters
    Type Name Description
    System.Array array

    The one-dimensional Array that is the destination of the elements copied from ICollection. The Array must have zero-based indexing.

    System.Int32 index

    The zero-based index in array at which copying begins.

    CreateFormat(String)

    Method that creates format object based on the format string and registers it in the workbook.

    Declaration
    public int CreateFormat(string formatString)
    Parameters
    Type Name Description
    System.String formatString

    Format string for the new format record.

    Returns
    Type Description
    System.Int32

    Index of created format.

    FindOrCreateFormat(String)

    Searches for format with specified format string and creates one if a match is not found.

    Declaration
    public int FindOrCreateFormat(string formatString)
    Parameters
    Type Name Description
    System.String formatString

    String describing needed format.

    Returns
    Type Description
    System.Int32

    Found or created format.

    GetEnumerator()

    Returns an IDictionaryEnumerator for the IDictionary.

    Declaration
    public IEnumerator<KeyValuePair<int, FormatImpl>> GetEnumerator()
    Returns
    Type Description
    System.Collections.Generic.IEnumerator<System.Collections.Generic.KeyValuePair<System.Int32, FormatImpl>>

    An IDictionaryEnumerator for the IDictionary.

    GetUsedFormats(ExcelVersion)

    Gets all used formats.

    Declaration
    public List<FormatRecord> GetUsedFormats(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type Description
    System.Collections.Generic.List<FormatRecord>

    Array that contains all used format records.

    InsertDefaultFormats()

    Inserts all default formats into list.

    Declaration
    public void InsertDefaultFormats()

    Merge(FormatsCollection)

    Copies all formats from the source collection.

    Declaration
    public Dictionary<int, int> Merge(FormatsCollection source)
    Parameters
    Type Name Description
    FormatsCollection source

    Collection to copy formats from.

    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.Int32, System.Int32>

    Dictionary old format index - to - new format index.

    Parse(IList, Int32)

    Parses list of biff records.

    Declaration
    public int Parse(IList data, int iPos)
    Parameters
    Type Name Description
    System.Collections.IList data

    Records to parse.

    System.Int32 iPos

    Offset to the format records.

    Returns
    Type Description
    System.Int32

    Position after format records.

    Remove(Int32)

    Removes the element with the specified key from the IDictionary.

    Declaration
    public void Remove(int key)
    Parameters
    Type Name Description
    System.Int32 key

    The key of the element to remove.

    Serialize(OffsetArrayList)

    Saves formats into list of biff records.

    Declaration
    public void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    List to save into.

    Implements

    IParentApplication
    System.IDisposable
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved