I am very happy to announce the release of Spread Studio 7 v4! The most awesome, powerful, fantastic, and empowering set of development components on the planet just got even better! We've added several new enhancements and many fixes to reported issues from customers across all of the Spread Studio 7 components. Download: Spread Studio 7 v4

What is Spread Studio 7?

Spread Studio 7 is ComponentOne's most powerful suite of spreadsheet tools for application development, covering all major .NET platforms: Windows Forms, ASP.NET, WPF, Silverlight, and Windows 8 App Store application development.

What's new in this release for Spread 7 for Windows Forms?

We have added the following enhancements in Spread 7 for Windows Forms:

  • Custom names are now supported in FormulaConditionalFormattingRule.
  • New overloads of OpenExcel allow import of Excel documents without clearing the keyboard input mappings set with SetInputMap.

    • NOTE: The readme.chm installed incorrectly describes this enhancement, and this API is missing from the installed documentation; please refer to the above description and the online help contexts linked above for details about this new API.
  • Multiple range expressions (e.g. "Sheet1!A1:B5:Sheet1!F7:H12:Sheet1!I3:K9") are now supported for calculation and Microsoft Excel import and export.
  • Memory management for importing and exporting large Excel documents is improved so larger documents can load and save successfully.

We have fixed many issues reported by customers in this release:

  • The text in the text tip is no longer truncated if the text is too long. [51967]
  • Extra sheets are no longer exported to an Excel-formatted file. [51968]
  • Calculated values are now imported correctly. [51969]
  • Cell borders are now rendered correctly when grid lines are hidden. [51971]
  • The BeginPrinting property in the PrintMessageBox event now works correctly. [51972]
  • Custom data models now correctly set the column size. [51974]
  • Items in the filter drop-down now sort correctly. [51991]
  • The chart area fill is now set correctly after importing an Excel-formatted file. [51996]
  • The x-axis is now correctly exported to an Excel-formatted file. [51997]
  • The Select Data Chart form now responds correctly when focus is lost. [51998]
  • Certain Excel-formatted files now import correctly. [52294]
  • Printing now works correctly when the ShowGrid property is set to true. [52295]
  • Custom combo cells no longer cause the application to stop responding. [52297]
  • Certain XML files now load correctly. [52700]
  • Cell fonts now work correctly. [56293]
  • Items in the combo box cell are now correctly selected. [56910]
  • Formulas are now updated correctly on copied sheets. [56926]
  • The control no longer stops responding when clicking on a header row or column. [56936]
  • The ClipBoardPasteUndoAction now works correctly when copying and pasting a cell range. [56937]
  • The custom data model now works correctly. [56941]
  • Printing now works correctly with Korean Microsoft Visual Studio. [56952]
  • Upgrading projects from an older version of Spread now works correctly. [56961]
  • XML files now load correctly. [56962]
  • The Tab key now works correctly when loading an older designer file. [63120]
  • Certain XML files now print correctly. [63179]
  • Sharp zip types are now correctly set to internal. [63807]
  • Exporting large numbers of rows and columns to an Excel-formatted file now works correctly. [64699]
  • Long strings of text are no longer truncated in the preview window. [64979]
  • The SmartPrintPagesTall and SmartPrintPagesWide properties now work correctly with page setup. [65686]
  • Large Excel-formatted files are now imported correctly. [66231]
  • The SaveExcel method now works correctly. [68812]
  • Check boxes are now rendered correctly in print preview when using certain DPI settings. [72311]
  • Spread serialization now works correctly when using a custom cell type inherited from the BaseCellType class. [72348]

What's new in this release for Spread 7 for ASP.NET?

We have added the following enhancements in Spread 7 for ASP.NET:

We have fixed many issues reported by customers in this release:

  • The user can now type in cells in Microsoft Internet Explorer 8. [56040]
  • Certain applications no longer stop responding after upgrading. [57074]
  • The cell value is no longer lost when the ShowPopupButton property of the DateCalendarCellType class is set to true. [57076]
  • The number format is now correctly exported. [57088]
  • Percentile and Quartile functions are now correctly exported to an Excel-formatted file. [57092]
  • The GetFont_Bold method in the client script Cells object now returns the correct value. [57093]
  • Navigating cells with arrow keys no longer changes the combo box cell value. [57096]
  • The SaveExcel method now works correctly. [57097]
  • Cell formatting and fonts are now correctly exported to an Excel-formatted file. [57102]
  • The command bar is now displayed with Spread MVC. [57108]
  • The scroll bar now displays correctly with Microsoft Internet Explorer 11. [57110]
  • The date time cell now displays the correct date when the FormatString property does not contain the year. [57122]
  • The ClientAutoSizeMaxHeight and ClientAutoSizeMaxWidth properties have been added. [57256]
  • UI virtualization now renders cells correctly with Microsoft Internet Explorer 8. [61642]
  • The Value property has been added to the FilterItemValue class. [66613]
  • The client script DataChanged event now works correctly in Mozilla Firefox. [69799]

What's new in this release for Spread 7 for WPF and Spread 7 for Silverlight?

New SetDataSource methods for WPF and Silverlight allows the developer to choose whether to reset the control when binding to the data source. We have fixed many issues reported by customers in this release:

  • Formulas with cross sheet references are now updated correctly. [69987]
  • The scrolling now works correctly. [69990]
  • Adding formulas and selecting cells from another sheet now works correctly. [69994]
  • Certain custom skins now work correctly. [69995]
  • The Spread chart axis items now work correctly. [69997]
  • Scrolling after editing spanned cells now works correctly. [69998]
  • The background image now works correctly. [69999]
  • Data validation now works correctly. [70000]
  • The SetDataSource methods for WPF and Silverlight have been added. [70001]
  • The drag fill series now works correctly. [70002]
  • Exporting to an Excel-formatted file now works correctly. [70011]
  • Spread no longer freezes when editing a formula cell. [70186]
  • Deleting rows now works correctly. [70764]
  • The Search methods for WPF and Silverlight now works correctly. [70766]
  • Borders from Excel-formatted files are now imported correctly. [70797]
  • Spread no longer calculates automatically after exporting to an Excel-formatted file. [71774]
  • Loading a specific sheet from an Excel-formatted file now works correctly. [72060]

What's new in this release for Spread 7 for WinRT?

New SetDataSource method allows the developer to choose whether to reset the control when binding to the data source. We have fixed many issues reported by customers in this release:

  • Formulas with cross sheet references are now updated correctly. [69987]
  • The scrolling now works correctly. [69990]
  • Adding formulas and selecting cells from another sheet now works correctly. [69994]
  • Certain custom skins now work correctly. [69995]
  • The Spread chart axis items now work correctly. [69997]
  • Scrolling after editing spanned cells now works correctly. [69998]
  • The background image now works correctly. [69999]
  • Data validation now works correctly. [70000]
  • The SetDataSource method has been added. [70001]
  • The drag fill series now works correctly. [70002]
  • Exporting to an Excel-formatted file now works correctly. [70011]
  • Spread no longer freezes when editing a formula cell. [70186]
  • Deleting rows now works correctly. [70764]
  • The Search method now works correctly. [70766]
  • Borders from Excel-formatted files are now imported correctly. [70797]
  • Spread no longer calculates automatically after exporting to an Excel-formatted file. [71774]
  • Loading a specific sheet from an Excel-formatted file now works correctly. [72060]
  • The touch keyboard now works correctly. [72607]