Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Import / Formula Settings Imported
In This Topic
    Formula Settings Imported
    In This Topic

    This table summarizes how the cell settings related to formulas are handled when Spread imports data from an Excel file. The properties are members of the Cell class unless specifically noted otherwise. They are also members of the Column class and Row class if you needed to set the cells of an entire column or entire row.

    Excel Setting Related Spread Property Remarks
    Cell references   Spread imports these from Excel as part of formulas. See the remarks on Formulas in this table.
    Cell reference style   If Excel’s reference style is R1C1, when Spread imports the spreadsheet, the ColumnHeaderAutoText property is set to 1 (Display Numbers). See the note on Formulas in this table.
    Formulas   Formulas are imported from Excel into Spread. When the import encounters a cell containing a formula or function, the corresponding cell in Spread is set to the appropriate cell type. If the import encounters a cell with a formula that it does not support, the cell may be left empty or given an error value. For more details on the functions in Spread, refer to the Formula Reference.
    Maximum number of iterations   Sets the value of the MaximumIterations property. See the note on Formulas in this table.
    Maximum change per iteration SheetView.MaximumChange Sets the value of the MaximumChange property.
    Operators   Spread imports Excel operators. See the note on Formulas in this table.
    Functions   Spread supports many of the functions provided in Excel. A list of the functions Spread supports is in the Formula Reference. If the import encounters a cell with a function that it does not support, the cell may be left empty or given a #NAME? error value. See the note on Formulas in this table.
    User-defined function Custom function feature Spread imports custom functions as it does any function.

    For other cell-related settings, refer to Cell Settings Imported.

    See Also