Enum OdsCellFieldType

OdsCellFieldType enumeration

Represents the cell field type of ods.

public enum OdsCellFieldType

Values

NameValueDescription
Date0Current date.
SheetName1The name of the sheet.
Title2The name of the file.

Examples

[C#]

namespace Demos
{
    using Aspose.Cells;
    using Aspose.Cells.Ods;
    using System;

    public class OdsCellFieldTypeDemo
    {
        public static void OdsCellFieldTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Create an OdsCellFieldCollection
            OdsCellFieldCollection odsCellFields = worksheet.Cells.OdsCellFields;

            // Add a new OdsCellField for the current date
            int rowIndex = 0;
            int columnIndex = 0;
            string customFormat = "yyyy-mm-dd";
            odsCellFields.Add(rowIndex, columnIndex, OdsCellFieldType.Date, customFormat);

            // Add another OdsCellField for the sheet name
            rowIndex = 1;
            columnIndex = 0;
            odsCellFields.Add(rowIndex, columnIndex, OdsCellFieldType.SheetName, null);

            // Add another OdsCellField for the title
            rowIndex = 2;
            columnIndex = 0;
            odsCellFields.Add(rowIndex, columnIndex, OdsCellFieldType.Title, null);

            // Update the fields value to the cells
            odsCellFields.UpdateFieldsValue();

            // Output the values in the console
            for (int i = 0; i < odsCellFields.Count; i++)
            {
                OdsCellField field = odsCellFields[i];
                worksheet.Cells[field.Row, field.Column].PutValue($"Field Type: {field.FieldType}, Custom Format: {field.CustomFormat}");
            }

            // Save the workbook
            workbook.Save("OdsCellFieldTypeExample.ods");
        }
    }
}

See Also