|
February 25th, 2008 - SpreadsheetGear for .NET 2007 3.1.1 / 1.7.1 changes include the addition of one simple property and a few bug fixes. |
|
New Feature |
- Added IRange.IndentLevel property.
|
|
Issues Addressed |
- Fixed problem which caused cell comments to sometimes not be displayed when running in Windows Vista with Aero enabled.
- Fixed issues with shape hit testing including problems with large pen sizes as well as problems with vertical and horizontal lines.
- Fix the OFFSET function to use 1 instead of 0 when the 4th or 5th argument is missing (such as "=OFFSET(C2,1,2,,2)" or "=OFFSET(C2,1,2,2,)").
- Added work around to discard bogus hidden formulas associated with external name references (references to defined names in other workbooks) when loading workbooks with SaveLinkValues turned off.
- Fix the way cell border property setters change the borders of adjoining cells to behave more like Excel.
- Fixed problems which caused charts to sometimes not be updated in Excel if they referred to cells containing the INDIRECT function or if they referred indirectly to cells containing volatile functions.
- Changed in-cell edit textbox to raise text one pixel higher when editing cells with bottom vertical alignment so that descenders and underscores display more reliably.
|
|
|
December 12th, 2007 - SpreadsheetGear for .NET 2007 3.1.0 / 1.7.0 changes include the addition of Visual Studio 2008 support and a number of bug fixes. |
|
New Features |
- Added Visual Studio 2008 support.
- Added WorkbookView support for displaying colors from number formats such as "[Color10]General".
- Added WorkbookView support for pasting rich text cells copied from Excel to the clipboard.
- Added work around to read workbooks with invalid worksheet gridline color information (workbooks were created by a 3rd party component).
|
|
Issues Addressed |
- Fixed form controls to no longer fire ShapeAction events when they are being initialized.
- Optimized printing code to make fewer calls into some very slow .NET APIs.
- Fixed TEXT worksheet function to attempt to convert text to numbers before formatting.
- Fixed internal event issues which caused the Undo buffer to be cleared when undoing a Replace.
- Fixed a problem which caused complex formulas which use the OFFSET worksheet function to sometimes return incorrect results.
- Fixed a problem which sometimes caused an unhandled exception to be thrown when a mouse move event is sent to a WorkbookView control after the WorkbookView's current workbook is closed (only happened when the mouse had been hovering over a cell with a cell comment).
- Fixed a problem which caused references to external workbooks from defined names to sometimes not be fixed up correctly when worksheets in the external workbook are moved, deleted or renamed.
|
|
|
October 3rd, 2007 - SpreadsheetGear for .NET 2007 3.0.2 / 1.6.2 changes include a number of bug fixes. |
|
Issues Addressed |
- Added workarounds to read workbooks written by third party reporting product.
- Fixed problems with formula reference fixups in array formulas during insert, delete and cut followed by paste.
- Fixed cases where converting numbers between 0.0 and 1.0 to text used "." instead of the culture specific decimal separator.
- Fixed the on-screen position of a data validation dropdown list when the dropdown list is associated with a merged cell spanning multiple columns.
- Fixed a case in the WorkbookView control where clicking and dragging with the mouse threw an exception when there were no cells visible because all rows or columns had been scrolled out of view.
- Fixed WorkbookView printing to honor the IPageSetup.PaperSize property.
- Fixed a problem which sometimes caused too large of a range to be used when pasting from Excel to the WorkbookView control.
- Fixed formats such as "dd.mm.yyyy" to treat "mm" as minutes instead of months for date formats which use a period as a separator.
- Made IWorkbookSet.MaxRecursions public to allow increasing this value for improved performance when a large stack is known to be available or decreasing to avoid stack overflow exceptions which occurred in rare cases.
- Fixed a problem reading some workbooks with large numbers of charts.
- Fixed WorkbookView painting problems which occurred when cutting, pasting and clearing cells with thick borders.
- Improved rounding of numbers to be more like Excel in edge conditions for certain ranges of numbers.
- Fixed printing problems which occurred when row and column headers are printed at the same time as row and column titles.
- Fixed active sheet index problem when saving copied WorkbookWindowInfo with bogus active sheet index after sheets are deleted.
- Fixed a problem setting custom number formats on workbooks created by some non-US versions of Excel which caused null reference exceptions.
- Fixed painting problems which occurred when using PageUp and PageDown where the selection doesn't change.
|
|
|
July 30th, 2007 - SpreadsheetGear for .NET 2007 3.0.1 / 1.6.1 changes include IWorkbook.DateTimeToNumber and IWorkbook.NumberToDateTime methods as well as a number of bug fixes. |
|
New Features |
- Additional SpreadsheetGear Explorer Solution samples.
- IWorkbook.DateTimeToNumber and NumberToDateTime methods.
|
|
Issues Addressed |
- Enhanced the layout of the data validation dropdown listbox to drop down under the linked cell as well as improving the apperance when placed next to a cell. Also fixed issues when used with various screen DPIs, Display Settings, and Zoom Magnification levels as well as a problem which caused data validation lists to not be removed after clearing data validation from a cell.
- Fixed conditional formats to stop at the first condition which evaluates to true as Excel does.
- Fixed parsing of strings in formulas, conditional formats and data validation lists to adhere to the 255 character file format limit.
- Fixed issues when closing workbooks or changing workbook structure while editing a cell.
- Added a work around so that Formula One ActiveX can read workbooks written by SpreadsheetGear for .NET.
- Fixed a layout issue when grouping rows and columns across frozen panes.
- Fixed a problem which occurred when calculating references to defined names in external workbooks which might cause changes in the external workbook to fail to propagate during calculation.
- Fixed a problem which sometimes caused null reference exceptions after closing a workbook with defined names which are referred by another workbook, where the workbook with the external defined name references is left open.
- Fixed painting of workbooks with frozen panes to no longer paint the line designating the split beyond the last displayed row or column, when there are not enough rows or columns to fill the WorkbookView.
- Added work arounds for reading certain workbooks which are written by third party components.
- Fixed a problem which caused some workbooks containing charts with certain text options to be saved incorrectly.
- Fixed a problem which caused resizing rows or columns on a sheet with frozen panes to incorrectly scroll up or left.
- Fixed a problem which sometimes caused the IF(...) function to return incorrect results in some cases where the second or third argument consists entirely of an absolute range with 1xN or Nx1 rows and columns.
- Fixed calculation problems with some large workbooks which contain large numbers of forward references.
- Fixed copying of cell comments to copy the width and height of the cell comment.
- Fixed Workbook Explorer to update relative references in defined name formulas when the current selection changes.
- Fixed a problem fixing up relative references in data validation formulas and conditional format formulas after cutting and pasting.
- Fixed scrolling problems which occurred in some cases when the last rows or columns of a worksheet are hidden.
- Fixed CommandManager to show errors using the ShowError event.
- Fixed problems with Undo of conditional formats and data validation criteria which use relative cell references.
- Fixed WorkbookView to fire the ShapeSelectionChanged event when shapes are unselected.
- Changed conversion of numbers to text to provide more significant digits including the IRange.Entry property, numeric cell editing including FormulaBar and in-cell editor, as well as numbers in custom number format comparison operators, conditional format comparisons and data validation criteria.
|
|
|
June 12th, 2007 - SpreadsheetGear for .NET 2007 enhancements include conditional formatting, grouping and outlining, find and replace, sort, Visual Basic SpreadsheetGear Explorer Sample Solution, new APIs, a few optimizations, GUI improvements and a number of bug fixes. |
|
New Features |
- Conditional formatting with full API, WorkbookView, and Range Explorer support.
- Grouping and outlining with additional APIs, WorkbookView, and Workbook Designer support.
- Find and replace API, WorkbookView support (CTRL+F / CTRL+H), and modeless find, find all, replace and replace all dialog.
- Sort API and modeless sort dialog.
- New Visual Basic SpreadsheetGear Explorer Sample Solution.
- More samples in the SpreadsheetGear Explorer Solutions and online documentation.
- Data validation support in the Range Explorer.
- IRange.NumberFormatType and IRange.ValueType properties and associated enumerations.
- IRange.Intersect(IRange), IRange.Union(IRange) and IRange.Subtract(IRange) methods.
- IRange.ValidationDefined property.
- IWorkbook.IsModified property.
- WorkbookView.LocationToRange and WorkbookView.RangeToLocation methods.
- WorkbookView.ShowError event and framework.
- WorkbookView support for unhiding rows and columns with the mouse.
- More zoom options in the Workbook Explorer.
- Implemented Delete key support in Workbook Explorer for sheets and defined names.
- Optimize painting of worksheets with large numbers of merged cells.
|
|
Breaking Changes |
- Most public core APIs now throw an exception when all of the following are true:
- The current thread has not acquired a lock on the workbook set using GetLock.
- The workbook set is associated with any GUI element (WorkbookView, etc...).
- Background calculation is true.
- Calculation is not set to Manual.
- The WorkbookView control now displays a Tooltip indicating that locks have not been released when
KeyDown, KeyUp, MouseDown, MouseMove or MouseUp events occur with a pre-existing lock,
indicating that either GetLock or BeginUpdate has been called without a corresponding ReleaseLock or EndUpdate call.
- Fixed enumeration of IRange.Rows to return rows instead of cells and enumeration of IRange.Columns to return columns instead of cells as Excel does.
- Fixed ISheet.CopyBefore and ISheet.CopyAfter to create a new sheet name such as "Sheet (3)" when copying a sheet with a name such as "Sheet (2)".
- Fixed copying an entire worksheet, where a workbook global defined name references that worksheet and the defined name is not referenced by any cells in the source worksheet, to copy the
workbook global defined name to a worksheet specific defined name in the new worksheet. These defined names were always copied when they were referred to by a cell in the source worksheet.
- Fixed IWorksheet.UsedRange to take entire row formatting and entire column formatting into account as Excel does.
|
|
Issues Addressed |
- Fixed problems painting cells with horizontal alignment set to HAlign.Fill and repeating characters in the number format.
- Increased the maximum number of named styles from 1023 to 4095 due to some workbooks written by Excel 2007 having large numbers of named styles.
- Fixed printing to transfer Landscape and Black & White settings from a worksheet's page setup info to the default printer settings and back.
- Fixed editing of cells formatted as percent to properly append "%" after starting a cell entry with "-5", "+5", ".5", etc...
- Fixed a bug which occurred with certain worksheet layouts when inserting cells and shifting right.
- Fixed the WorkbookView control to not show the active cell after a selection if ScrollRow or ScrollColumn are set after the selection is changed.
- Removed 1023 picture limit and fixed an associated problem writing some workbooks with large pictures or large numbers of shapes.
- Fixed data validation lists which come from cells to ignore case as Excel does.
- Fixed inserting or deleting the first row or column where a formula references entire columns or entire rows to no longer change these references to #REF!
- Fixed setting IRange.Value or IRange.Formula, where the range represents multiple cells and the new value or formula changes the number format of the cell, to copy the new number format to
all of the cells in the represented range.
- Fixed protection problems with TextBox and LockText property.
- Fixed a bug which caused Excel to crash when opening a workbook created by copying an entire worksheet which had selected shapes.
- Optimized loading and activating nodes in the various explorers for a cleaner appearance when first displaying.
- Fixed the Workbook Explorer to work better with inactive worksheet and workbook WindowInfos. The WorkbookView control keeps it's own copy of IWorkbookWindowInfo and IWorksheetWindowInfo for
inactive worksheets and inactive workbooks to facilitate the ability to have different window info settings on separate WorkbookView controls. The Workbook Explorer now propagates changes to
the most reasonable of these copies as well as to the core.
- Fixed a problem which caused SpreadsheetGear for .NET to hang if a custom function was added after a workbook was loaded, where a formula in the workbook passes a volatile argument to the custom function.
- Fixed FormulaBar name box to be disabled while in cell edit mode.
- Fixed bug with edit mode starting when mouse button is down. It now works more like Excel.
- Fixed a problem where a worksheet's defined names collection would not get updated after adding the first defined name.
- Fixed scrollbar form control problem when linked to cells on a protected worksheet.
- Fixed painting of row and column headers and sheet tabs to use the default fonts from the associated workbook set.
- Fixed setting IWorkbook.FullName to update external references from other workbooks which reference a workbook of the newly specified name to reference the renamed workbook.
- Added work around for .NET 2.0 MDI framework problem which caused the Workbook Designer to hang when running at screen resolutions of 144+ DPI.
- Fixed Copy to clipboard followed by Paste Values of a defined name reference to paste the value instead of #REF!.
- Fixed pickers and custom dialog controls to use SystemFonts.DefaultFont.
- Fixed problems with formula editing point to reference mode when pointing to a cell in another worksheet.
- Fixed Workbook Designer menus to take better actions in the Workbook Explorer such as activating controls, inserting defined names, etc...
- Fixed problem when double-clicking sheet tabs which are not fully scrolled into view.
- Fixed Workbook Explorer defined name nodes to synchronize properly after an entire worksheet is copied.
- Fixed IRange.MergeCellsDefined property to work like Merged Cells checkbox in Excel.
- Fixed data validation with lists to honor the InCellDropdown setting.
- Fixed FormulaBar to no longer display hidden defined names for the formula address.
- Fixed Cut followed by Paste to correctly fix up references in chart series, data validation custom formulas and form controls.
- Fixed IRange.Copy(IRange) to copy to multiple areas.
- Fixed WorkbookView to display cell comment indicator after copying cells with comments.
- Fixed unhandled exception which occurred when a shape is inserted when existing shapes are selected.
- Fixed problem with IWorksheetWindowInfo.RangeSelection setter sometimes not repainting the WorkbookView.
- Fixed printing headers and footers with &D and &T to use short date and time formats.
- Fixed reading and writing of workbooks which contain very long printer setup records.
- Fixed a number of cases where formatting a number with a general format used a period instead of the decimal separator of the workbook set's CultureInfo.
- Fixed Workbook Explorer to update the display of defined names when a worksheet name is changed.
- Fixed a problem with the IRange.UsedRange property which caused it to return all columns when an entire worksheet was formatted with a non-default cell format (3.0.0.121 / 1.6.0.121).
- Fixed a problem which caused invalid workbooks to be written when references such as Sheet1!$A$1:$B$2 get changed to #REF!$A$1:$B$2 or Sheet1!#REF! during copy, insert or delete of cells or worksheets (3.0.0.121 / 1.6.0.121).
- Fixed a problem which caused the Range Explorer to throw an unhandled exception when the Conditional Formats node is excluded and the current selection is changed (3.0.0.121 / 1.6.0.121).
|
|
|
April 2nd, 2007 - SpreadsheetGear for .NET 2.5.1 / 1.5.1 enhancements include WorkbookView cell comment indicators, a new WorkbookView.ExtraColor property and a number of bug fixes. |
|
New Features |
- Added cell comment indicators to the WorkbookView control.
- Added the WorkbookView.ExtraColor property which specifies the color of the extra space to the right of and below the last displayed cells.
|
|
Issues Addressed |
- Fixed a problem which sometimes caused Excel to fail to open workbooks created by copying entire worksheets which contain JPG picture objects, PNG picture objects, form controls which reference a non-existent worksheet or charts with custom number formats.
- Fixed Data Validation with a list of "TRUE,FALSE" to work like Excel (allow entry of "True" or "true").
- Fixed a problem with inserting or deleting cells which sometimes caused relative 3D cell references to not be fixed up correctly.
- Fixed to write IF() and CHOOSE() worksheet functions to XLS files so that all arguments are not evaluated by Excel, which could lead to bogus circular reference reports (this did not affect the way SpreadsheetGear calculated workbooks).
- Fixed the IRR() function to correctly handle an initial guess of 0.0 which was being treated the same as the default guess (0.1).
- Fixed default and popup cell comment positions for merged cells which span multiple columns.
- Fixed printing from Print Preview to print the correct current page number in print headers and footers.
- Fixed cases where the WorkbookView selection indicator and / or the Formula Bar were not updated correctly.
- Added work around for problems with .NET's MDI Windows Menu.
- Fixed default print range to include visible shapes.
- Fixed printing in black and white to correctly print double cell borders.
- Fixed problems painting certain rows with horizontal alignment set to filled or center across cells.
- Fixed the behavior of WorkbookView cell entries with leading "-" or "+" to behave more like Excel.
- Fixed ISheet.EvaluateValue and ISheet.EvaluateRange to honor IWorkbookSet.Calculation setting (don't calculate referred to cells if calculation is set to manual).
- Fixed to no longer throw null reference exceptions which occurred when evaluating certain formulas using ISheet.EvaluateValue, ISheet.EvaluateRange or IName.RefersToRange, where the formula being evaluated refers to cells which need to be calculated.
- Fixed IWorkbook.GetDataSet(...) to return all DataTables when the referred to range contains multiple areas which are specified with absolute references.
- Fixed IRange.Copy(IRange destination) to allow copying to a destination range which represents multiple areas.
- Fixed Cut followed by Paste to correctly fix up cell references in chart series, data validation custom formulas and form controls.
- Improved the performance of SUMIF, COUNTIF and database functions (DCOUNT, DSUM, etc...) which reference a significant number of sequential empty rows.
- Fixed and improved API documentation for various methods and properties.
- Fixed a problem which caused incorrect formula evaluation in rare cases after copying certain formulas (2.5.1.117).
- Fixed a problem which caused Excel to generate invalid workbooks after using SpreadsheetGear for .NET to copy an entire worksheet which contained shapes, loading the new workbook into Excel, adding another shape in Excel (including a cell comment) and saving the workbook from Excel (2.5.1.117).
- Fixed a problem which sometimes caused SpreadsheetGear for .NET to write workbooks with a first shown sheet tab index greater than the number of visible sheets, causing Excel to display no sheet tabs and crash when the sheet tab scroll button is clicked (2.5.1.119).
- Fixed an unhandled exception which sometimes occurred when selecting an entire row or column which intersects with a merged cell at the left column or top row of the WorkbookView control (2.5.1.119).
|
|
|
January 9th, 2007 - SpreadsheetGear for .NET 2.5.0 / 1.5.0 enhancements include
API and GUI support for cell comments, data validation, pictures, text boxes, check
boxes, dropdowns, list boxes, spinners, scrollbars, buttons, lines, many autoshapes
and more. |
|
New Features |
- Added API and GUI support for cell comments, pictures, text boxes, check boxes,
dropdowns, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
GUI support includes the ability to insert (see the Insert menu), size, move and
set properties (right click on a shape and click Shape Explorer...).
- Added limited support for custom controls with the SpreadsheetGear.Windows.Forms.UIManager
class.
- Added API support and limited GUI support for data validation (data validation is
honored upon cell entry but cannot be changed in the Range Explorer until a future
version).
- Added support for reading and writing form controls with cell references and lists
(as well as the API and GUI support noted above).
- Reimplemented Range Explorer Borders Panel so that it is easier to understand and
use.
- Improved in-cell editor now supports multiline text, wrapped text and uses the format
of the cell being edited.
- Exposed more functionality in CommandManager and associated classes.
- Added support for parsing dates as yyyy/mm/dd regardless of the locale.
- Added Sheet property to ActiveTabChanging and ActiveTabChanged event arguments.
- Added setters for a number of WorkbookView, IWorkbookWindowInfo and IWorksheetWindowInfo
properties related to the currently selected range and sheet.
- Added SpreadsheetGear.IName.Visible property.
- Improved the SpreadsheetGear Explorer Sample Solution.
|
|
Issues Addressed |
- Implemented work around for Visual Studio 2005 Visual Basic compiler crash (see
Microsoft KB 920145).
- Fixed pointing at 3d references in formulas to work with worksheet names which include
spaces.
- Fixed FormulaBar name box to update as needed when defined names are modified.
- Fixed undo to work correctly with commands which include multiple areas.
- Fixed copying and pasting of 3d references to work correctly using a workbook named
"Book1".
- Fixed problem with cutting and pasting which sometimes caused relative references
to incorrectly be converted to #REF!
- Fixed problem with IWorksheet.EvaluateValue(...) which caused errors to be ignored
with some formulas.
- Fixed unparsing of functions to use the correct argument separator when the argument
separator is not a comma.
- Fixed printing problem which caused SpreadsheetGear for .NET to hang in some cases
with hidden rows or hidden columns.
- Fixed problems with some combinations of WorkbookView.DisplayReference and frozen
rows or columns.
- Implemented work arounds for invalid workbooks which are sometimes placed on the
clipboard by Excel.
- Fixed IRange.GetAddress(...) method to add single quotes around workbook and worksheet
names as needed.
- Fixed problem with selecting multiple ranges in a WorkbookView when the argument
separator is not a comma.
- Fixed printing and print preview to correctly honor DisplayZeros setting.
- Fixed problem which caused cell entries such as 999e999 to be entered as #NUM! rather
than as text.
- Fixed WorkbookView so that clicking on cells with the HYPERLINK(...) worksheet function
works like Excel (requires "#" before a range reference).
- Fixed to properly display centered and right justified cells with trailing spaces.
- Fixed problem which caused some defined names to incorrectly return #NAME! in certain
complex workbooks where the defined name is involved in a circular reference.
- Fixed Paste Special/Transpose to select the correct range and fixed Undo to work
correctly after Paste Special/Transpose.
- Fixed problems with copying cells with PasteType.AllExceptBorders (also affected
Paste Special/All Except Borders).
- Fixed reading and writing workbook number formats using locales which do not use
comma for thousands separator and period for decimal separator.
- Fixed problems displaying worksheet tabs which sometimes occurred after changing
the order of sheets in a workbook.
- Fixed problem which caused data in column IV to not be cleared when Deleting cells
and shifting left.
- Fixed null reference exception which occurred when entering formulas such as "=OtherBook.xls!MyNameA
+ MyNameB".
- Fixed problem with F4 toggling between relative and absolute references in certain
formulas.
- Optimized Insert and Delete to operate more efficiently in cases where an entire
worksheet had been formatted.
- Fixed selection code to finish changing the current selection, including firing
of selection events, when the Shift key is pressed.
- Fixed entering of new values into a cell formatted as percent to append "%" when
entry of a new value is started.
- Fixed problems which occurred when printing from Print Preview.
|
|
|
September 25, 2006 - SpreadsheetGear for .NET 2.1.0 / 1.4.0 enhancements include
support for adding pictures to a worksheet, hyperlink support, password protected
worksheets, sheet tab colors, a new command manager, new WorkbookView events, Paste
Special, a new SpreadsheetGear Explorer Sample Solution for Visual Studio 2005 and
more. |
|
New Features |
- New SpreadsheetGear Explorer Sample Solution for Visual Studio 2005.
- Added the ability to add pictures to a worksheet with the new IWorksheet.Shapes.AddPicture
method.
- Added reading, writing, API and GUI support for hyperlinks, password protected worksheets
and sheet tab colors.
- Added CommandManager and Command classes which provide the ability to add custom
undoable commands as well as the ability to override the behavior of common commands.
- Added RangeSelectionChanging, ActiveTabChanging and ActiveTabChanged events to the
WorkbookView control.
- Added the ability to specify which categories are displayed by the Range Explorer
with the CategoryFlags property.
- Added Paste Special command with many options including the ability to consolidate
and transpose cells.
- Added support for the HYPERLINK() worksheet function.
- Added support for providing a default custom function by specifying a function name
of "*".
- Added SpreadsheetGear.CustomFunctions. IArguments.CurrentFunctionName property which
returns the name of the function currently being evaluated.
- Added SpreadsheetGear.CustomFunctions. IArguments.CurrentFormula property which
returns the formula of the cell currently being evaluated.
- Added custom cursors to the WorkbookView control.
- Enhanced IRange.Copy to support copying to destination ranges with multiple areas.
- Added undo support to Insert, Delete and Paste after Cut.
- Added PointsToRow, RowToPoints, PointsToColumn and ColumnToPoints methods to IWorksheetWindowInfo.
- Added PrintQuality and PrintQualityVertical properties to IPageSetup.
- Added support for maintaining the position and/or size of shapes with fixed position
and/or size during Insert, Delete, Row Height changes and Column Width Changes.
|
|
Issues Addressed |
- Fixed WorkbookView control to add leading "=" to formulas entered with leading "+"
or "-".
- Fixed WorkbookView problem which caused sheet names with descenders to be clipped
at certain screen resolutions.
- Fixed problem displaying the correct sheet tab when selecting a sheet which comes
after a hidden sheet.
- Fixed problem writing workbooks with references to external VBA modules but which
do not include their own VBA modules.
- Fixed to no longer set the default print resolution to 300 and the default paper
size to Letter.
- Fixed IRange.Select() to grow the selection as needed for merged cells.
- Improved support for running the Range Explorer and Workbook Explorer at non-standard
screen resolutions.
- Fixed Workbook Explorer to update defined names after Insert, Delete, etc...
- Fixed printing from the WorkbookView or Workbook Designer to get printer settings
from the output device.
- Fixed Workbook Explorer to disable options when editing cells.
- Added confirmation message when setting Precision as Displayed from the Workbook
Explorer.
- Fixed problems with copying and saving some formulas with external cell references.
- Fixed problem with IRange.CopyFromDataTable when inserting a large number of rows.
- Fixed to read files written by Macintosh Excel 2004 which were unreadable in certain
cases.
- Improved TINV, FINV and BETAINV worksheet functions to return results for a wider
range of inputs.
|
|
|
August 21, 2006 - SpreadsheetGear for .NET 2.0.1 / 1.3.1 enhancements include support
for reading and writing VBA Macros, an API for returning arrays from custom functions,
support for the USDOLLAR() function and improved WorkbookView performance. |
|
New Features |
- Added support for reading and writing VBA macros.
- Added SpreadsheetGear.CustomFunction.IValue.SetArray(double[,]) and SetArray(object[,])
methods to enable custom functions to return array results.
- Improved IWorkbook.SaveToStream and IWorkbooks.OpenFromStream to work with streams
which are not seekable.
- Added support for the USDOLLAR() function.
- Added "Calculate" and "Calculating" messages to the Workbook Designer status bar.
- Improved performance of painting a WorkbookView after calculation completes.
- Added support for reading and writing workbooks with DDE links.
|
|
Issues Addressed |
- Fixed problems with Undo and Redo after saving and closing workbooks.
- Fixed several minor issues with the WorkbookView and WorkbookDesigner.
- Fixed WorkbookView problem which sometimes caused cell text to be painted in the
wrong location.
- Fixed IRange.AutoFit to throw exception for invalid ranges.
- Fixed unparsing of number formats such as "###,##0" to no longer return an extra
comma at the start of the number format.
- Fixed unparsing of number formats to omit leading "\" for many characters as Excel
does.
- Fixed ISheet.EvaluateValue and ISheet.EvaluateRange to work correctly with references
to defined names in external workbooks.
- Fixed the IRange API to allow formatting part of a merged cell as the Excel API
does.
- Improved TINV, FINV and BETAINV worksheet functions to return results for a wider
range of inputs.
- Fixed IRR to never return a result <= -1 and added an initialization step which
helps IRR to find a more appropriate solution when multiple solutions > -1 are available.
- Fixed problem which caused certain formulas containing ROW() or COLUMN() to fail
to recalculate after these formulas are copied to other cells.
- Fixed parsing of formulas which reference names which begin with "true" or "false".
- Fixed Cut to no longer lock the cut cells if the worksheet has protection enabled.
- Fixed to no longer allow creation of workbooks with FitToPagesTall or FitToPagesWide
set to zero when FitToPages is true.
|
|
|
June 30, 2006 - SpreadsheetGear for .NET 2006 enhancements include a rich Windows
Forms Spreadsheet Control, Formula Bar, Workbook Designer, Workbook Explorer, Range
Explorer and interruptible background calculation as well as numerous new classes,
methods and properties. |
|
New Features |
- SpreadsheetGear.Windows.Forms.WorkbookView provides viewing, navigation and
editing support which is familiar to Excel users.
- In-cell editing and optional SpreadsheetGear.Windows.Forms.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 automatic recognition and formatting of dates, times, percentages,
currency, scientific notation and fractions.
- SpreadsheetGear.Windows.Forms.WorkbookDesigner provides an MDI Windows application
which may be used from within Visual Studio 2005 at design time or by applications
at run time.
- SpreadsheetGear.Windows.Forms.RangeExplorer provides extensive modeless formatting
of the currently selected range with support for alignment, merged cells, borders,
fonts, colors, patterns, number formats and protection options.
- SpreadsheetGear.Windows.Forms.WorkbookExplorer provides the ability to manipulate
workbooks, worksheets and defined names as well as their properties.
- Support for multiple worksheets in each workbook and multiple workbooks associated
with each WorkbookView.
- WorkbookView.DisplayReference and WorkbookView.DisplayReferenceName
properties allow complete control over what appears for each sheet tab, including
the ability to make multiple workbooks appear as one workbook.
- Cut, copy and paste support including rich data and formatting interchange with
Excel and full formula fixups.
- Frozen rows and columns, split panes, zoom, multi-level undo/redo, autofit rows
and columns, goto, clear, printing, print preview, interruptible background calculation,
real time workbook updates and more.
- Full integration with Visual Studio 2005 including the ability to use the Workbook
Designer, Workbook Explorer and Range Explorer at design time.
- Interruptible background calculation including SpreadsheetGear.IWorkbookSet.
BackgroundCalculation, IWorkbookSet.GetLock(), IWorkbookSet.ReleaseLock(),
IWorkbookSet.HasLock, IWorkbookSet.BeginUpdate() and IWorkbookSet.EndUpdate().
- Added SpreadsheetGear.IWorkbooks.Contains(IWorkbook), IWorksheets.Contains(IWorksheet),
ISheets.Contains(ISheet) and INames.Contains(IName) methods.
- Added SpreadsheetGear.IWorksheetWindowInfo. ActiveCellAreaIndex and IWorksheetWindowInfo.SetSelection(.).
- Added Factory.GetWorkbook(.) overrides which take a CultureInfo.
- Increased maximum number of sheets from 255 to 65531.
- Significantly improved performance of IWorksheets[string worksheetName] and
ISheets[string sheetName], particularly with large numbers of worksheets/sheets.
- Added SpreadsheetGear.IRange.ShrinkToFit property.
- Added support for setting IRange.Value to an Int64 value.
- Added SpreadsheetGear.LineStyle.Continuous to replace the deprecated LineStyle.Continous.
- Significant performance improvements when using SpreadsheetGear.IRange to
get border properties of a large area.
- Added SpreadsheetGear.IPageSetup.PrintArea, PrintTitleRows, PrintTitleColumns
and FitToPages properties.
- Added AllowPartiallyTrustedCallersAttribute to the SpreadsheetGear.dll
assembly.
- Changed SpreadsheetGear.IWorkbook.Calculate() and CalculateFull()
to mark a workbook set as needing calculation and defer to background calculation
when appropriate, typically when IWorkbookSet.BackgroundCalculation is true and
the current thread has acquired a lock with IWorkbookSet.GetLock() (does
not change the way these methods work in existing applications which could not have
called GetLock()).
- Added SpreadsheetGear.IWorkbookSet.DefaultFontName and DefaultFontSize.
Changed the default font used by a workbook set for Japanese, Korean and Chinese
cultures.
- Added SpreadsheetGear.CustomFunctions.IArguments. ClearError method
(2.0.0.49).
- Added support for System.Single and System.Byte
to IRange.Value and IRange.CopyFromDataTable (2.0.0.49).
|
|
Breaking Changes |
- Closing a workbook, deleting a sheet or disposing of a workbook set now sets numerous
properties to null. For example, when a worksheet is no longer valid, it's Workbook
and WorkbookSet properties will return null.
- Fixed creating new workbook with multiple worksheets to select the first worksheet
rather than the last.
|
|
Issues Addressed |
- Fixed the DATE() worksheet function to work correctly with months of -11, -23, -35,
etc.
- Fixed a problem which sometimes occurred when loading two workbooks, where workbook
A refers to workbook B, and the number and/or order of sheets in workbook B has
changed since workbook A was saved.
- Fixed AutoFit of columns to work more like Excel when dealing with merged cells
and cells with wrapped text.
- Fixed copying of locked cells to unlocked cells in a protected worksheet to unlock
the new cells as Excel does.
- Fixed SpreadsheetGear.IRange.RowHeight to return an appropriate height when the
row is set to automatic height and changes are made which affect the row height.
- Improved support for automatically setting the format of a cell when a date, time,
percent, currency, scientific notation, fraction, etc. is entered. SpreadsheetGear
for .NET now changes the format even if it is not the default number format when
the type of the new format is significantly different from the current number format,
such as changing from $123 to 50%.
- Fixed problem which caused "Invalid shape index" exception with some workbooks.
- Fixed SpreadsheetGear.IRange.Value and IRange.Formula to allow entry of a single
"=" as Excel does.
- Fixed problem with Cut, Copy and Paste which sometimes caused formula cell values
to be lost (2.0.0.49).
- Fixed null reference exception which sometimes occurred when making an undoable
change to an entire column or entire row in the WorkbookView control (2.0.0.49).
- Fixed IName.Name property setter to throw an exception if the new
name would create a duplicate defined name (2.0.0.49).
- Fixed pasting from the clipboard to no longer clear the formats of the destination
cells when pasting text from the clipboard (2.0.0.49).
- Added work around to read Biff8 workbooks which are sometimes written to the clipboard
by Excel with invalid font indexes (2.0.0.49).
- Fixed parsing of certain formulas such as "=SUM(aaa:bbb)" (2.0.0.49).
- Fixed some problems with editing of defined names in the Workbook Explorer (2.0.0.49).
- Fixed null reference exception which sometimes occurred when deleting a worksheet
which has undoable actions associated with it (2.0.0.49).
- Fixed cell borders to paint on bottom and right edges when WorkbookView control
is scrolled to bottom or right edge of visible cells (2.0.0.49).
- Improved performance when using Workbook Explorer with workbooks which have many
worksheets and/or many defined names (2.0.0.49).
- Fixed row and column header painting issues when only the row or column header is
visible (2.0.0.49).
- Fixed Formula Bar to update when last workbook is closed in the Workbook Designer
(2.0.0.49).
- Fixed some WindowInfo problems when deleting a worksheet in a non-active WorkbookView
(2.0.0.49).
|
|
|
March 28, 2006 - SpreadsheetGear for .NET 1.2 enhancements include the ability to
read and write charts, pictures, text and drawing objects as well as copy, insert,
move and delete entire worksheets. |
|
New Features |
- Read and write charts, pictures, text and drawing objects.
- Ability to modify the data source for a chart.
- Copy entire worksheets with ISheet.CopyBefore and ISheet.CopyAfter.
- Move entire worksheets with ISheet.MoveBefore and ISheet.MoveAfter.
- Insert worksheets with IWorksheet.AddBefore and IWorksheet.AddAfter.
- Delete worksheets with ISheet.Delete.
- High performance SpreadsheetGear.Advanced.Cells.IValues interface for getting
and setting cell values and formulas.
- Evaluate any Excel compatible formula with ISheet.EvaluateValue and ISheet.EvaluateRange.
- Added the ability to wrap rows from a DataTable to new worksheets when a DataTable
does not fit on a single worksheet with SetDataFlags.WrapToNewWorksheet.
- Added support for System.DBNull, System.DateTime and System.Decimal
to IRange.CopyFromDataTable and IRange.Value.
- Added the IRange.Name property to find the first defined name which refers
to a range.
- Read and write cell data validation information.
- Read and write formatting styles.
- Added CurrentRow, CurrentColumn and CurrentWorksheet properties
to the SpreadsheetGear.CustomFunctions.IArguments interface.
- Added IWorksheet.Range and IRange.Range as a convenience to those
who are familar with the Excel API.
- Added IRange.RowCount, IRange.ColumnCount. IRange.AreaCount
and IRange.GetArea.
- Significantly improved calculation performance for most workbooks which utilize
iteration.
- Significantly improved performance for adding defined names as well as for calculating
most workbooks which utilize defined names.
- Optimized IWorksheet.UsedRange to cache results.
- Added support for reading and writing cell comments. (1.2.0.23)
- Added IWorkbookSet.ReadObjects property which makes it possible to ignore
drawing objects when reading a workbook. (1.2.0.23)
|
|
Issues Addressed |
- Fixed a problem with parsing some formulas which reference an addin function.
- Fixed IRange.CopyFromDataTable to check for partial merged cells, partial
array formulas and locked cells.
- Fixed a number of help file errors.
- Fixed a problem which caused workbooks to grow very large when copying all the cells
of one worksheet to a worksheet in another workbook when the default cell format
is not the same.
- Fixed a problem which caused workbooks to grow very large when the heights of all
rows are set to the same value.
- Fixed ISheet.Name to disallow creating multiple sheets with the same name.
- Fixed IRange.AutoFit to correctly recognize and ignore merged cells.
- Fixed ISheet.Visible to update the active sheet as needed.
- Fixed ISheet.Visible to disallow hiding the last visible worksheet.
- Fixed to parse defined name formulas without a leading "=" as Excel does.
- Fixed to parse "=Sheet!#REF!" as Excel does.
- Fixed IRange.Hidden to work with multiple areas.
- Fixed setting IRange.Value to no longer change the number format of a cell
which already has a non-default number format.
- Fixed to properly handle defined names where the name starts with what looks like
a valid cell reference followed by an underscore or a period, such as A1_" or "A1.".
(1.2.0.5)
- Fixed ISheet.CopyBefore and ISheet.CopyAfter to copy all cell formatting,
not just the number formats. (1.2.0.7)
- Fixed problem with ISheet.Delete not fixing up some 3D references correctly.
(1.2.0.9)
- Fixed problem with IRange[string index] not handling sheet specific defined
names. (1.2.0.11)
- Fixed problems with iteration which affected some workbooks. (1.2.0.15)
- Fixed setting inside vertical and inside horizontal borders to work correctly. (1.2.0.17)
- Fixed a problem which caused large worksheets to be generated when copying an entire
worksheet where the source and destination have different default row heights. (1.2.0.19)
- Removed a call to an overloaded System.Array.Copy method which does not exist in
.NET 1.0; Note that SpreadsheetGear for .NET still does not officially support .NET
1.0. (1.2.0.21)
- Added support to allow reading of invalid Excel workbooks written by some 3rd party
software. (1.2.0.23)
- Fixed problem copying some drawing objects with ISheet.CopyBefore(ISheet) and ISheet.CopyAfter(ISheet).
(1.2.0.23)
- Fixed to delete controls which reference macros when reading. (1.2.0.23)
|
|
|
December 26, 2005 - SpreadsheetGear for .NET 1.1 enhancements include the ability
to easily and efficiently insert a DataTable into an Excel workbook and automatically
fixup all formulas, formats and borders, as well as the ability to insert, delete
and clear rows, columns and cells. |
|
New Features |
- Easily and efficiently copy or insert a DataTable into an Excel workbook
with IRange.CopyFromDataTable(System.Data.DataTable dataTable, SpreadsheetGear.Data.SetDataFlags
flags).
- Insert rows, columns and cells with IRange.Insert and IRange.Insert(InsertShiftDirection).
- Delete rows, columns and cells with IRange.Delete and IRange.Delete(DeleteShiftDirection).
- Clear rows, columns and cells with IRange.Clear, IRange.ClearContents
and IRange.ClearFormats.
- Determine whether an IRange represents entire rows or entire columns with
IRange.IsEntireRows and IRange.IsEntireColumns.
|
|
Issues Addressed |
- Fixed parsing of formulas with strings containing embedded quotes to work correctly.
- Fixed setting of IBorder.ColorIndex and IBorders.ColorIndex to
ColorIndex.Automatic and ColorIndex.None to work correctly.
- Made setting of borders work more like Excel. For example, setting just the color
now sets a default line style and setting just a line style now sets the color index
to ColorIndex.Automatic.
- Fixed IInterior properties to work more like Excel.
- Optimized setting IRange.NumberFormat of an entire row or entire column and
fixed to no longer grow the used range innapropriately.
- Fixed setting of row and column outlines and sizes which threw an exception for
certain rare cases.
|
|
|
November 7, 2005 - SpreadsheetGear for .NET 1.0.9 adds the ability to copy and consolidate
rows, columns and ranges as well as fixing a few issues. |
|
New Features |
- IRange.Copy methods.
- Setting cell values with IRange.Value and IRange.Formula now sets
the number format of the destination cell as Excel does.
- Tested with Visual Studio 2005 RTM.
- Factory.GetWorkbookSet( System.Globalization.CultureInfo ) method to create
a workbook set with a specified culture. (1.0.9.7)
|
|
New Features Supported By IRange.Copy Methods |
- Copy rows, columns and cells.
- Control what is copied with the pasteType argument which supports all, all
except borders, values, values and number formats, formulas, formulas and number
formats, column widths or just formats.
- Consolidate cells by specifying PasteOperation.Add, PasteOperation.Subtract,
PasteOperation.Multiply or PasteOperation.Divide.
- Transpose cells by passing true for the transpose argument.
- Skip blank cells by passing true for the skipBlanks argument.
|
|
Issues Addressed |
- Fixed various IRange property setters and methods to correctly check for partial
merged cells and partial array formulas.
- Fixed setting of palette entries to work correctly.
- Fixed setting IRange.Formula to correctly parse dates.
- Fixed issue with the INDIRECT(address) worksheet function which resulted in cells
containing the INDIRECT function sometimes not being calculated.
- Fixed issue with OFFSET(range, rows, cols...) which resulted in cells sometimes
not being calculated if the starting range was limited to cells in the same column
as the cell containing the function.
- Fixed issues with setting and writing row heights and row hidden status.
- Fixed rounding of certain numbers to work more like Excel. (1.0.9.7)
- Fixed copying of columns to copy column hidden and outline settings. (1.0.9.7)
- Fixed parsing of functions with spaces before a function name and the function's
closing parenthesis; "= PI( )" was getting changed to "=PI( )". (1.0.9.7)
- Fixed SUMIF() and COUNTIF() worksheet functions to convert date criteria to a number
as Excel does. SUMIF(criteriaRange, "<11/10/2005", dataRange) now treats 11/10/2005
as a date serial number rather than text.
- Fixed problem with SUMPRODUCT(...) which caused it to sometimes not calculate it's
arguments as arrays.
|
|
|
October 19, 2005 - SpreadsheetGear for .NET 1.0.7 adds a few new features and addresses
some issues in SpreadsheetGear for .NET 1.0.4. |
|
New Features |
- Significantly improved performance.
- Added support for getting and setting manual page breaks with the SpreadsheetGear.IRange.PageBreak
property as well as the SpreadsheetGear.IHPageBreaks, SpreadsheetGear.IHPageBreak,
SpreadsheetGear.IVPageBreaks and SpreadsheetGear.IVPageBreak interfaces.
- Added IRange.GetOffset(int rowOffset, int columnOffset) which returns an
identical IRange except that it is offset by rowOffset rows and columnOffset
columns.
- Added a new indexer to SpreadsheetGear.IRange which creates an instance of
IRange from the specified starting and ending row and column offsets.
- Added the SpreadsheetGear.IRange.WrapText and SpreadsheetGear.IRange.WrapTextDefined
properties.
- Added the SpreadsheetGear.IRange.Orientation and SpreadsheetGear.IRange.OrientationDefined
properties, as well as the SpreadsheetGear.Orientation class with related
constants.
|
|
Issues Addressed |
- Fixed formatting of entire rows, entire columns and entire worksheets to work correctly.
- Fixed setting SpreadsheetGear.IRange.Value and SpreadsheetGear.IRange.Formula
to work correctly when a cell is formatted as text (such as a NumberFormat of "@").
Setting a cell formatted as text always puts the text in the cell without trying
to convert it to a formula, number, date, time or logical value.
- Fixed parsing of formulas which contain references to worksheets with a name which
does not start with a letter or underscore (such as "=2005!A1"). This already worked
correctly if the worksheet name was surrounded by single quotes (such as "='2005'!A1"),
but Excel, as well as SpreadsheetGear for .NET 1.0.7, allows these to be entered
without the single quotes.
- Fixed IRange.MergeCells and IRange.MergeCellsDefined to return the
correct values when reading a file written by Excel.
- Fixed to allow custom function references to external XLA functions so that a custom
function named "MYADD()" will be used for an XLA custom function reference such
as "=Workbook.xla!MYAdd()".
- Fixed so that newly created worksheets start looking for a name to use at "SheetX"
instead of "Sheet1" where X is the new number of worksheets in the workbook. This
was done to provide behavior which is consistent with Excel.
- Fixed adding a formula with a new external workbook name reference (such as "=Workbook!AName")
to work.
- Fixed formatting of dates and the TEXT(...) worksheet function to work correctly
with the 1904 date system.
- Fixed references with URL's such as "=http://abc.com/Worksheet.xls" to unparse correctly.
- Fixed the SMALL(...) and LARGE(...) worksheet functions to truncate k rather
than rounding it.
|
|
|
|
See What's New and
download the Licensed or
Evaluation version Now. |
|
"For more than twenty years, we have been creating and leading the development of high performance spreadsheet technology which is used by most of the Fortune 500."
Joe Erickson
Founder and CEO
SpreadsheetGear LLC |
|
"We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for .NET. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. This is over 100 times faster than other controls we’ve tested. That difference makes it possible for us to develop and release a viable product with the Microsoft .NET Framework."
Amy Tate
Chief .NET Architect
Applied OLAP, Inc.
Huntsville, Alabama |
|
"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"
Luke Melia, Software
Development Manager
Oxygen Media, New York |
|
"Thank you for all your help during the trial period.
Your excellent product and service is what convinced us to buy this component."
Etienne Demers
OceanLogics, Canada |
|
September 22, 2005 - "The license allows royalty free deployment, making this a cost effective alternative to Excel as well as a technically superior one for generating worksheets and performing heavy-duty calculations from your .NET applications."
Mike Gunderloy
Lead developer for Larkware
Author of numerous books and articles on programming. |
|
"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”
Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana |
|
"Your quick responses to queries are one of the original reasons why we opted for your product, and you continue to impress us with the speed at which questions and issues are dealt with."
Justin Blackwell
Volume Design Ltd.
Berkshire, United Kingdom |
|
"SpreadsheetGear for .NET is a fantastically powerful spreadsheet component which is very easy to use and expand. We delivered our mandatory customer requirements well before time so we had plenty of time to implement the nice-to-have requirements nobody ever manages to deliver."
Simon Black
Software Architect
Nokia |
|
"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”
Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana |
|
September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."
Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP |
|
"You have an excellent product. I've finished my testing and was able to rewrite a program using VB.NET and your control. I wrote the previous version 4 years ago using VB6 which employed the Excel COM object. The old program generated about 2100 excel sheets in 8 hours. With your control it now takes 7 minutes!
I also wrote a web form in ASP.NET VB using your control. This was also previously a VB6 / Excel app. This one went from 36 minutes to less than a minute.
I'm having no trouble getting this purchase approved!"
Mark Hitchcock
Manager of Information Technology
Administrative Concepts, Inc. |
|
"We started to use SpreadsheetGear for .NET almost two years ago when the performance of other controls was becoming problematic. We needed a control that could handle large workbooks with complex formulas to be able to apply Monte Carlo simulation to financial statements. Since that time SpreadsheetGear for .NET has become our tool of choice not only for the performance but also for the flexibility. But most of all, the technical support we receive from SpreadsheetGear LLC is priceless; it has always been fast and accurate with the vision to arrive at the desired solution."
Frédérick Faucher
Analyste Financier
Solutions Modex Inc.
Montréal, Canada |
|
I must say that everyday that goes by I am more amazed with your component. It’s easy to use but still powerful. No more problems using Excel workbooks in the .NET environment.
You have spared me about 3 or 4 months of work with your excellent tool. I also must say that I’m using many other components from other companies and no one has proven to be as fast and effective as you in solving a support request.
Pedro Horta
IT Analyst / Programmer
OmnicomMediaGroup
Portugal |
|
"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"
Wolfgang Kamir
Softwaretailor
Baden, Lower Austria |
|
"Just wanted to give you a little good feedback on your product. I'm a programmer for a small company in Norway and we needed to create an Excel report for one of our customers. So I purchased a license for your wonderful product and it took me about 10 minutes to get the report from a DataTable into a finished Excel document!
My boss thinks I'm a genius, but hey; the credit should go to your product. At least half of it.
Cheers!"
Hans Olav Stjernholm
Chief Developer
ZapDance as, Norway |
|
"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"
José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina |
|
August 23, 2005 - "We welcome SpreadsheetGear to the Microsoft Visual Studio Industry Partner Program. The improved ability to create, modify, calculate, read and write Microsoft Excel (versions 97 and higher) workbooks will allow our mutual customers to create a broad range of solutions in a rich and familiar form."
Nick Abbott
Group Manager
.NET Developer Product Marketing Group
Microsoft Corp.
|
|
"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."
Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer |
|
"SpreadsheetGear for .NET is truly a pleasure to work with. I was up and running within the first day. It is the best spreadsheet generator out on the market. Performance, Ease of Use, and Full Control of the generation process sold me. I no longer have to be concerned with memory leaks, hung processes, COM Interop and slow performance. Our users demand cosmetically appealing reports without additional work. I can build templates at will, with complete control to freeze panes, page setup, cell formats, etc., etc. The old days of pre-building templates are gone. I cannot think of anything this product cannot do."
Todd Dickard
TA Billing Systems Mgr.
TravelCenters of America
|
|
"Although there was an initial issue related to date formatting associated with a cultural problem, I found that SpreadsheetGear provided myself, and ultimately the bank, with above and beyond support, providing us with the necessary fix for the issue within 2 days. This is nothing less than exceptional, and I for one would like to thank SpreadsheetGear for their tenacity, enthusiasm and dedication to their product."
David Lashley
IT Development Manager
Commercial Bank of Qatar |
|
"Your support is first rate. We always get an answer within a few minutes of any request or question. This support, combined with the exceptional speed and ease of use of your superior control enables me to create complex spreadsheet solutions that work in a few minutes instead of days. Keep up the excellent work!"
Greg Newman
WSFS Bank
Newark DE |
|
We really love SpreadsheetGear for .NET. The comprehensive and robust set of worksheet functions ensures that our customers are able to fully leverage their Excel knowledge in our product.
Andreas Lipphardt
XLCubed Ltd
Hessen Germany |
|
"I have one big problem with Spreadsheetgear for .NET, my billable hours are going to go down because your product is so much easier to use than a web grid. Yikes!
I sure wish I had found your product a couple of years ago. And converting my webgrid code over to SpreadsheetGear for .NET is going very quickly because all of the logic is already coded and I just have to write to the spreadsheet.
I really like not having to insert columns and rows when I need them. I really like your product so far."
Bruce Hemmerich
Manager - Business and Technical Solutions
KeyChainData, LLC |
|
"After trying every Microsoft Excel compatible spreadsheet solution for the .NET Framework I could find, SpreadsheetGear for .NET is the only one that actually worked as described."
Michael Garnett
Interpublic Group
New York, NY |
|
