Spread COM and Spread.NET have some differences in their formula operators and functions. Spread COM uses 0 or 1 for Boolean values while Spread.NET uses True or False. Spread.NET also has more formula functions than Spread COM. The following table describes additional differences and how the differences are handled when Spread.NET imports a Spread COM file.
| Operator or Function | Difference | How Imported |
|---|---|---|
| Comparison operators (=, <>, <, <=, >, >=) | Spread.NET is case insensitive. For the following comparison, Spread COM returns false: "ABC"="abc" However, Spread.NET returns true for the same comparison. | The formula remains the same, but is evaluated differently. Be sure to update your project to reflect this change. |
| PMT | The Spread.NET syntax for the PMT function is PMT(rate,nper,pval,fval,end) The Spread COM syntax for the PMT function is PMT(Amount, Interest, Terms, TermsPerYear) | The formula is not updated from Spread COM. You must manually change your arguments to the correct values to match the Spread.NET syntax. |
| Date and time functions | Spread.NET returns DateTime or TimeSpan objects rather than serial or other date time values. | You might need to change the cell types for the cells that return the values for these formulas to accurately display and format the DateTime or TimeSpan object returned by the Spread.NET function. |
| URL | Spread.NET has a HyperLink cell type. | This function is not imported. |