SpreadsheetGear 2012 adds some of the most frequently requested features including WPF and Silverlight controls, multithreaded recalc, 64 new functions, Windows 10 support, Windows Server 2012 R2 support, Visual Studio 2015 support, improved memory efficiency and performance particularly in 64 bit applications, custom row and column header text and styling for XAML controls, save to XPS and more.
The SpreadsheetGear 2012 family of products is made up of powerful and flexible Microsoft Excel compatible spreadsheet components and includes SpreadsheetGear 2012 for .NET and SpreadsheetGear 2012 for Silverlight.
- Excel Reporting: Easily create richly formatted Excel reports without Excel from any ASP.NET, Windows Forms, WPF or Silverlight application using spreadsheet technology built from the ground up for performance, scalability and reliability.
- Create Dashboards from Excel Charts and Ranges: You and your users can design dashboards, reports, charts and models in Excel or the SpreadsheetGear Workbook Designer rather than hard to learn developer tools and you can easily deploy them with one line of code.
- Excel Compatible Windows Forms, WPF and Silverlight Controls: Add powerful Excel compatible viewing, editing, formatting, calculating, filtering, sorting, charting, printing and more to your Windows Forms, WPF and Silverlight applications with the easy to use WorkbookView controls.
- Excel Charting: Enable users to visualise data with comprehensive Excel compatible charting which makes creating, modifying, rendering and interacting with complex charts easier than ever before.
- Excel Calculations: Evaluate complex Excel based models and business rules with the fastest and most complete Excel compatible calculation engine available including 398 Excel compatible functions, multithreaded recalc, array formula support and more.
SpreadsheetGear - Features
New features include robust Excel 2007 Open XML (xlsx) support, dynamic chart and range image generation, comprehensive Excel compatible charting support, more rows and columns, named cell styles, RGB colors, theme colors with tinting and shading and more.
- Royalty free client and server deployment.
- Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007 Open XML (xlsx) workbooks without Excel.
- Scalable and reliable Excel Reporting.
- Powerful Windows Forms spreadsheet controls.
- Easily create images from Excel charts and ranges.
- Comprehensive charting APIs.
- Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel).
- Support for cell comments, pictures, text boxes, check boxes, drop-downs, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
- Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists.
- Conditional formats with support for simple comparison operators and custom formulas.
- Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups.
- Easily convert entire workbooks or specific ranges to a DataSet or DataTable.
- Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.
- Insert, delete and clear rows, columns and cells.
- Stable sort with an unlimited number of keys and the ability to sort text as numbers.
- Grouping and outlining of rows and columns.
- Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
- Copy, insert and move entire worksheets.
- C# and Visual Basic samples for ASP.NET and Windows Forms.
- Reads and writes VBA Macros.
Windows Forms Spreadsheet Control Features
- WorkbookView spreadsheet control provides viewing, navigation and editing support which is familiar to Excel users.
- In-cell editing and optional FormulaBar control provide the ability to enter and edit cell values and formulas, including support for pointing at cell references in formulas across worksheets and workbooks.
- Smart data entry with optional data validation as well as automatic recognition and formatting of dates, times, percentages, currency, scientific notation and fractions will be familiar to Excel users.
- Conditional formatting enables font colors, font styles, background colors and borders which are based on simple comparison operators or complex formulas.
- Grouping and outlining which allows users to easily expand and collapse the displayed level of detail.
- WorkbookDesigner provides an MDI Windows application which may be used from within Visual Studio 2005 and Visual Studio 2008 at design time and by applications at run time.
- WorkbookExplorer provides the ability to manipulate workbooks, worksheets and defined names as well as their properties.
- RangeExplorer provides extensive modeless formatting of the currently selected range with support for number formats, alignment, fonts, borders, colors, patterns,
- protection options, hyperlinks, conditional formats and data validation.
- ChartExplorer provides basic modeless modification and formatting of the currently selected chart with support for chart types and data sources, legend options, primary and secondary axes options and various series options.
- Modeless find and replace dialog with support for find, find all, replace and replace all.
- Support for an unlimited number of workbooks associated with each WorkbookView.
- DisplayReference and DisplayReferenceName properties allow complete control over what appears for each sheet tab, including the ability to make multiple workbooks appear as one workbook and the ability to specify dynamically changing ranges using worksheet functions such as OFFSET().
- Cut, copy, paste and paste special support including rich data and formatting interchange with Excel and full formula fixups.
- Frozen rows and columns, split panes, sheet tab colors, zoom, multi-level undo/redo, autofit rows and columns, goto, clear, printing, print preview, interruptible background calculation, real time workbook updates and more.
- CommandManager provides the ability to add custom undoable commands as well as the ability to override the behavior of common commands.
- Full integration with Visual Studio 2005 and Visual Studio 2008 including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer and ShapeExplorer at design time and at runtime.
- SpreadsheetGear Explorer Sample Solutions with C# and Visual Basic source code demonstrate commonly used SpreadsheetGear 2008 features and APIs.
- Fastest and most complete Excel compatible calculation engine available in a spreadsheet component.
- All Excel 2003 built-in financial, date, time, text, lookup, math, trigonometry, statistical and database functions.
- All types, operators, defined names, data tables and arrays.
- Interruptible background calculation.
- Support for 64K worksheets and unlimited workbooks in formulas.
- Worksheet specific defined names and global defined names.
- Custom functions, minimal recalc, iteration, precision as displayed and more.
- Copy formulas between cells, worksheets, workbooks and workbook sets with full support for reference fixups.
- Insert and delete worksheets, rows, columns and cells with full support for reference fixups.
- Cut, copy and paste with full support for smart reference fixups across multiple worksheets and workbooks.
- Special care was taken with numerical stability.
- Number formats, including full support for getting and setting Excel compatible custom number formats as well as getting the formatted text of a cell as Excel would display it.
- Fonts, borders, Office Theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns.
- Horizontal alignment, vertical alignment, word wrap and shrink to fit.
- Merged cells, hyperlinks and conditional formats.
- Enable or disable worksheet protection, worksheet passwords and cell locking.
- Grouping and outlining of rows and columns.
- Automatic row heights and column widths.
- Copy formats without affecting formulas or values.
- Named cell style support.
- The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component with API support for virtually every charting property.
- SpreadsheetGear.Drawing.Image class provides the ability to generate an image (such as GIF or PNG) with one line of code.
- Chart rendering supports the most common charting features:
- Chart types include area, bar, column, line, pie, stock and XY scatter.
- Chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, high-low lines, open-close bars, exploded pies, and data point labels.
- Axes options include primary and secondary axes sets, auto and manual scaling, major gridlines and tick marks, reversed axes, and tick label positions.
- General chart options include chart titles, legends, theme colors, auto colors, number formats and fonts.
Microsoft .NET Framework Features
- Easy to use API which will be familiar to Excel VBA and COM developers while taking advantage of .NET's expressiveness.
- Supports Microsoft .NET Framework 2.0 and 64-Bit .NET 2.0. Works with Microsoft .NET Framework 3.0 and .NET 3.5.
- Microsoft Visual Studio 2005 and Visual Studio 2008 integration, including IntelliSense and Dynamic Help.
- The security of 100 percent safe managed code which does not require FullTrust.
- Hassle free deployment with a single strong named assembly and no license keys, registry entries or configuration issues.
- No dependency on Microsoft Excel, which is not supported in a server environment.
|Database and List Management Functions|
|DAVERAGE||Indicates the average of the values that meet the specified criteria.|
|DCOUNT||Counts the number of cells containing numbers that meet the specified criteria.|
|DCOUNTA||Counts nonblank cells containing numbers or text that meet the specified criteria.|
|DGET||Returns a single value that meets the specified criteria.|
|DMAX||Extracts the highest value that meets the specified criteria.|
|DMIN||Extracts the lowest value that meets the specified criteria.|
|DPRODUCT||Returns the product of the values that meet the specified criteria.|
|DSTDEV||Estimates the standard deviation of a population, based on a sample of selected entries from the database.|
|DSTDEVP||Returns the calculation of the standard deviation of a population, based on the sum of the whole population.|
|DSUM||Returns the total of the values that meet the specified criteria.|
|DVAR||Estimates the variance of a sample population based on the values that meet the specified criteria.|
|DVARP||Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria.|
|Date and Time Functions|
|NOW||Returns the current date and time in the form of a serial number.|
|TODAY||Returns the current date as a serial number.|
|DATEVALUE||Converts date text to a DATEVALUE serial number.|
|DAY||Returns the corresponding day of the month serial number or date text from 1 to 31.|
|HOUR||Returns the hour as a serial number integer between 0 and 23.|
|MINUTE||Returns the serial number that corresponds to the minute.|
|MONTH||Returns the corresponding serial number of the month of a date between 1 and 12.|
|SECOND||Returns the seconds portion of a serial time value.|
|TIMEVALUE||Returns the decimal number for a given time.|
|YEAR||Returns the corresponding year as a serial number in the form of an integer.|
|WEEKDAY||Returns the corresponding day of the week as a serial number.|
|DAYS360||Returns the number of days between two set dates based on a 360-day year.|
|DATE||Returns the serial number that represents a date.|
|TIME||Returns the decimal value of a given time.|
|IRR||Returns the internal rate of return for a series of cash flows represented by numbers in the form of values.|
|NPV||Calculates the net present value of an investment from the discount rate and several future payments and income.|
|MIRR||Returns a modified internal rate of return for several periodic cash flows.|
|SLN||Returns the straight-line depreciation on an asset.|
|FV||Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments.|
|NPER||Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate.|
|PMT||Calculates the loan payment for a loan based on constant payments and constant interest rates.|
|PV||Returns the present value based on an investment.|
|RATE||Returns per period the interest of an annuity.|
|ISPMT||Calculates the interest paid during a defined period of an investment.|
|SYD||Based on a specified period, SYD returns the sum-of-years' digits depreciation of an asset.|
|DB||Returns the asset depreciation for a period using the fixed declining balance method.|
|DDB||Returns the asset depreciation for a period using the double-declining balance method or another specified method.|
|IPMT||Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate.|
|PPMT||Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate.|
|VDB||For a period you specify, returns the depreciation of an asset.|
|NA||An alternative representation of the error value #N/A.|
|ERROR.TYPE||Returns the corresponding number value associated with an error type in Microsoft Excel.|
|ISBLANK||Returns TRUE if the cell is empty, FALSE if it contains data.|
|ISERR||Returns TRUE if value contains any error value except #N/A, FALSE if it does not.|
|ISERROR||Returns TRUE if value contains any error value (including #N/A), FALSE if it does not.|
|ISLOGICAL||Returns TRUE if value is a logical value, FALSE if it is not.|
|ISNA||Returns TRUE if value is #N/A, FALSE if it is not.|
|ISNONTEXT||Returns TRUE if value is not text, FALSE if it is.|
|ISNUMBER||Returns TRUE if value is a number, FALSE if it is not.|
|ISREF||Returns TRUE if value is a reference, FALSE if it is not.|
|ISTEXT||Returns TRUE if value is text, FALSE if it is not.|
|N||Returns a value converted to a number.|
|TYPE||Determines the type of value in a cell.|
|FALSE||Returns the value FALSE. May be typed directly into the cell as "FALSE".|
|TRUE||Returns the value TRUE. May be typed directly into the cell as "TRUE".|
|NOT||Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE.|
|AND||Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE.|
|OR||Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE.|
|IF||Returns a value if one condition is TRUE and returns another value if the condition is FALSE.|
|Lookup and Reference Functions|
|COLUMN||Returns the column number(s) based on a given reference.|
|ROW||Returns the row number based on a reference.|
|AREAS||Returns the number of areas based on a reference.|
|COLUMNS||Returns the number of columns based on an array or reference.|
|ROWS||Returns the number of rows in a reference or array.|
|TRANSPOSE||Returns a horizontal range of cells as vertical or vice versa.|
|HYPERLINK||Creates a shortcut to jump to a document stored on a network server.|
|INDIRECT||Returns the contents of a cell using its reference.|
|INDEX||Returns the value of an element selected by the row number and column letter indexes.|
|LOOKUP||Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array.|
|MATCH||Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item.|
|ADDRESS||Given specified row and column numbers, creates a cell address as text.|
|CHOOSE||Returns an item from a list of values..|
|HLOOKUP||Searches for a specified value in an array or a table's top row.|
|VLOOKUP||Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify.|
|OFFSET||Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells.|
|Math and Trigonometry Functions|
|PI||Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.|
|RAND||Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated.|
|ABS||Returns the absolute value of a number.|
|ACOS||Returns the arccosine of a number in radians in the range 0 to pi.|
|ACOSH||Returns the inverse hyperbolic cosine of a number.|
|ASIN||Returns the arcsine of a number in radians in the range -pi/2 to pi/2.|
|ASINH||Returns the inverse hyperbolic sine of a number.|
|ATAN||Returns the arctangent of a number in radians in the range -pi/2 to pi/2|
|ATANH||Returns the inverse hyperbolic tangent of a number.|
|COS||Returns the cosine of the given angle.|
|COSH||Returns the hyperbolic cosine of a number.|
|DEGREES||Converts radians into degrees.|
|EVEN||Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers.|
|EXP||Returns e (2.71828182845804) raised to the power of a specified number.|
|FACT||Returns the factorial of a number.|
|INT||Rounds a number down to the nearest integer.|
|LN||Returns the natural (base e) logarithm of a number.|
|LOG10||Returns the base-10 logarithm of a number.|
|MDETERM||Returns the matrix determinant of an array.|
|MINVERSE||Returns the inverse matrix for the matrix stored in an array.|
|ODD||Returns a number rounded up away from zero to the nearest odd integer.|
|RADIANS||Converts degrees to radians.|
|SIGN||Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative.|
|SIN||Returns the sine of a given angle.|
|SINH||Returns the hyperbolic sine of a number.|
|SQRT||Returns a positive square root.|
|TAN||Returns the tangent of the given angle.|
|TANH||Returns the hyperbolic tangent of a number.|
|LOG||Returns the logarithm of a number of the base you specify.|
|ROMAN||Converts an Arabic numeral to Roman, as text.|
|TRUNC||Truncates a number to an integer by removing the fractional part of a number.|
|PRODUCT||Multiplies all the numbers given as arguments and returns the product.|
|SUM||Adds all the numbers in a range of cells.|
|SUMSQ||Returns the sum of the squares of the arguments.|
|ATAN2||Returns the four-quadrant arctangent of the specified x- and y- coordinates in radians between -pi and pi excluding -pi. A positive result represents a counterclockwise angle from the x-axis, a negative result represents a clockwise angle.|
|CEILING||Returns a number rounded up, away from zero, to the nearest multiple of significance.|
|COMBIN||Returns the number of combinations for a given number of items.|
|FLOOR||Returns a number rounded down, toward zero, to the nearest multiple of significance.|
|MMULT||Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.|
|MOD||Returns the remainder of a division operation (modulus).|
|POWER||Returns the result of a specified number raised to a specified power.|
|ROUND||Round a number to a specified number of digits.|
|ROUNDDOWN||Rounds a number down, towards zero.|
|ROUNDUP||Rounds a number up, away from zero.|
|SUMX2MY2||Returns the sum of the difference of squares of corresponding values in two arrays.|
|SUMX2PY2||Returns the sum of the sum of squares of corresponding values in two arrays.|
|SUMXMY2||Returns the sum of squares of differences of corresponding values in two arrays.|
|SUMIF||Adds the cells specified by a certain criteria.|
|SUMPRODUCT||Multiplies corresponding components in the given arrays, and returns the sum of those products.|
|COUNTBLANK||Counts the empty cells in a specified range.|
|FISHER||Returns the Fisher transformation at x.|
|FISHERINV||Returns the inverse of the Fisher transformation at y.|
|GAMMALN||Returns the natural logarithm of the gamma function.|
|NORMSDIST||Returns the standard normal cumulative distribution function.|
|NORMSINV||Returns the inverse of the standard normal cumulative distribution function.|
|GROWTH||Calculates predicted exponential growth by using existing data.|
|LINEST||Calculates a straight line that best fits your data using the least squares method.|
|LOGEST||Calculates an exponential curve that fits your data and returns an array of values that describes the curve.|
|TREND||Returns the y-values along a linear trendline that best fits the values in a data set.|
|AVEDEV||Retuns the average of the absolute deviations of data points from their mean.|
|AVERAGE||Returns the average of its arguments.|
|AVERAGEA||Returns the average of the values in its list of arguments including text and logical values.|
|COUNT||Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments.|
|COUNTA||Counts the number of cells that are not empty.|
|DEVSQ||Returns the sum of the squares of deviations of a data set from their sample mean.|
|GEOMEAN||Returns the geometric mean of an array or range of positive data.|
|HARMEAN||Returns the harmonic mean of a data set.|
|KURT||Returns the Kurtosis of a data set.|
|MAX||Returns the largest value in a set of values.|
|MAXA||Returns the largest value in a set of values including text and logical values.|
|MEDIAN||Returns the median of the given numbers.|
|MIN||Returns the smallest value in a set of values.|
|MINA||Returns the smallest value in a set of values including text and logical values.|
|MODE||Returns the most frequently occuring, or repetitive, number in an array or range of data.|
|SKEW||Returns the skew of a distribution.|
|STDEV||Estimates standard deviation based on a sample.|
|STDEVA||Estimates standard deviation based on a sample. Includes text and logical values.|
|STDEVP||Estimates standard deviation based on a sample assuming that the arguments represent the total population.|
|STDEVPA||Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values.|
|VAR||Returns an estimate for the variance of a population based on a sample data set.|
|VARA||Returns an estimate for the variance of a population based on a sample data set and may include text or logical values.|
|VARP||Calculates variance based on the entire population.|
|VARPA||Calculates variance based on the entire population and may include text or logical values.|
|CHIDIST||Returns the one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve.|
|CHIINV||Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution.|
|CHITEST||Returns the test for independence of the characteristics in a table.|
|CORREL||Returns the correlation coefficient between two data sets.|
|COUNTIF||Counts the number of cells in a range that meet a given criteria.|
|COVAR||Returns the covariance, the average of products of deviations, for each data point pair.|
|FREQUENCY||Calculates how often values occur within a range of values and then returns a vertical array of numbers.|
|FTEST||Returns the result of an F-test.|
|INTERCEPT||Calculates the point at which a line will intersect the y-axis by using existing x and y values.|
|LARGE||Returns the k-th largest value in a data set.|
|PEARSON||Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.|
|PERCENTILE||Returns the k-th percentile of values in a range.|
|PERMUT||Returns the number of permutations for a given number of objects that can be selected from a range of numbers.|
|QUARTILE||Returns the quartile of a data set.|
|RSQ||Returns the r^2 value of a linear regression line.|
|SLOPE||Returns the slope of a regression line through data points in KNOWN Y'S and KNOWN X'S.|
|SMALL||Returns the k-th smallest value in a data set.|
|STEYX||Returns the standard error of the predicted y value for each x in the regression.|
|TINV||Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.|
|TRIMMEAN||Returns the mean of the interior of a data set.|
|PERCENTRANK||Returns the rank of a value in a data set set as a percentage of the data set.|
|RANK||Returns the rank of a number in a list of numbers.|
|ZTEST||Returns the two-tailed P-value of a z-test.|
|CONFIDENCE||Returns the confidence interval for a population mean.|
|CRITBINOM||Returns the minimum number yields a binomial distribution less than or equal to the specified criteria|
|EXPONDIST||Returns the exponential distribution.|
|FDIST||Returns the F probability distribution.|
|FINV||Returns the inverse of the F probability distribution.|
|FORECAST||Calculates or predicts a future value by using existing values.|
|GAMMAINV||Returns the inverse of the gamma cumulative distribution.|
|LOGINV||Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation.|
|LOGNORMDIST||Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation.|
|NEGBINOMDIST||Returns the negative binomial distribution.|
|NORMINV||Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.|
|POISSON||Returns the Poisson distribution.|
|STANDARDIZE||Returns a normalized value from a distribution characterized by MEAN and STANDARD DEV.|
|TDIST||Returns the percentage points (probability) for the student t-distribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed.|
|PROB||Returns the probability that values in a range are between two specified limits.|
|BETADIST||Returns the cumulative beta probability density function.|
|BETAINV||Returns the inverse of the cumulative beta probability density function.|
|BINOMDIST||Returns the individual term binomial distribution probability.|
|GAMMADIST||Returns the gamma distribution.|
|HYPGEOMDIST||Returns the hypergeometric distribution.|
|NORMDIST||Returns the normal cumulative distribution for the specified mean and standard deviation.|
|TTEST||The probability associated with t-test.|
|WEIBULL||Returns the Weibull distribution.|
|CHAR||Returns the character specified by a number.|
|CLEAN||Removes all nonprintable characters from text.|
|CODE||Returns a numeric code from the first character in a text string. The opposite of the CHAR function.|
|LEN||Returns the number of characters in a text string.|
|LENB||Returns the number of characters in a text string expressed in bytes.|
|LOWER||Converts all letters in a text string to lowercase.|
|PROPER||Capitalizes the first letter of each word in a text string or sentence.|
|T||Returns the text referred to by a value.|
|TRIM||Removes all spaces from text except single spaces between words.|
|UPPER||Converts text to uppercase.|
|VALUE||Converts a text string that represents a number to a number.|
|DOLLAR||Converts a number to text using Currency format, with the decimals rounded to the specified place.|
|USDOLLAR||Converts a number to text using US Dollar format, with the decimals rounded to the specified place.|
|LEFT||Returns the first character(s) in a text string.|
|LEFTB||Returns the first character(s) in a text string based on a specified number of bytes|
|RIGHT||Returns the last character(s) in a text string.|
|RIGHTB||Returns the last character(s) in a text string based on a specified number of bytes.|
|FIXED||Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.|
|CONCATENATE||Joins several text strings into one text string.|
|EXACT||Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise.|
|REPT||Repeats specified text a given number of times.|
|TEXT||Converts a value to text in a specific number format.|
|FIND||Locates one text string within another text string, and returns the number of the starting position of of FIND TEXT from the leftmost character of WITHIN TEXT.|
|FINDB||Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN TEXT.|
|SEARCH||Returns the number of the character at which a specific character or text string is first found, reading from left to right.|
|SEARCHB||Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right.|
|MID||Returns a specific number of characters from a text string starting at the position you specify.|
|MIDB||Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify.|
|SUBSTITUTE||Substitutes NEW TEXT for OLD TEXT in a string.|
|REPLACE||Replaces part of a text string with a different text string based on the number of characters you specify.|
|REPLACEB||Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes.|
What's new in SpreadsheetGear 2009
- Support for the 93 functions which are in the Excel 2003 Analysis Toolpak as well as the undocumented DATEDIF function bringing the total number of supported functions to 331.
- CSV and tab separated text support (read and write).
- Drag Fill / Auto Fill API & UI including support for numbers, dates, times, month names, day names and certain text patterns.
- Data Series API & UI including support for automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.
- Single variable and single target goal seeking API & UI.
- Chart axis title rendering.
- Bubble chart rendering.
- Rotated text support in charts and cells.
- Enhanced fill option support including gradient API & UI.
- Many Range Explorer, Chart Explorer and Shape Explorer enhancements.
- Added WorkbookView.BeginEdit(), WorkbookView.CancelEdit() and WorkbookView.EndEdit() methods as well as a WorkbookView.IsEditing property.
- Added support for hidden chart series when linked to hidden rows or columns when the PlotVisibleOnly option enabled.
- Added support for font names and font sizes in print headers and print footers.
- Added IArguments.GetArrayFormulaInfo(ref int row1, ref int col1, ref int row2, ref int col2) method to return information about the array formula currently being evaluated, if any.
- Added SetDataFlags.WrapToNewWorksheet64K to provide support for wrapping at the Excel 97-2003 64K row limit.
- Added more samples to the SpreadsheetGear Explorer Sample Solutions for C# and VB.