create excel .net user interface - Spread.NET

Description: optional password/s. Built-in Excel-like Runtime Dialogs- Programmatically invoke built-in dialogs that enable users to add data tables, format cells, insert functions, create forecast sheets, remove ... to import and export Excel spreadsheets. Leverage the extensive.NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, ... Deliver Excel-like spreadsheet experiences. Spread.NET helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability ...

Release Notes: user data entry requirements and load/save data validations in Excel documents. Drag-fill Enhancements- Implement Excel-like copy-fill and series-fill in the user interface, with full support ... Ctrl+Shift+Enter) enable advanced matrix and array calculations and the new CircularFormula event fires to inform you when the user enters a formula which creates a circular reference. Workbook Protection Support- ... for undo/redo. Printing Enhancements- Full support for printer settings built into the print preview user interface. HyperLinkCellType Supports Sort and Filter- Work with sort and filter features. New API ...

Release Notes: for Office Themes, which means developers and end users can easily apply *.THMX files from existing Excel files with only a line of code. You can also create custom themes, and the API supports ColorScheme, ... to false, and Locked setting for all cells initialized to True, as in Excel Hidden rows and columns with the zero-size indicator as in Excel Tab strip always as in Excel Enhanced filter user interface ... for sheets and tables as in Excel New keyboard mappings with more built-in actions such as the new AutoSum action [Alt]+[=] Several new features and dialogs that make the end-user experience even more ...

Release Notes: borders around rotated text. Enhanced High DPI Support- Applications created with spread are DPI aware and will automatically scale. New Chart Line Styles (with Excel I/O Support)- Spread now allows you ... to set the style of the series in line charts, much like Excel does. Touch-friendly Date Picker- Now includes a date picker that supports touch interaction. ASP.NET Touch Support for Edge and Chrome- ... Updates in 9 All Platforms Windows 10, Visual Studio 15 and Excel 2016 support. JavaScript-HTML5 Preview and Print Data Views- SpreadJS supports several printing options including best fit, ...

Release Notes: within the confines of a Named Range. IRange.HasSpill API- Spread.NET now includes the IRange.HasSpill API, similar to Excel. This API helps determine whether a cell range includes spilled values or not. ... to Excel but not old versions of Spread.NET. Saving to HTML- Since.NET and.NET Core were updated, data could not be saved to HTML using the SheetView.SaveHtml function anymore. As a replacement, this is now ... destination/reference sheet and creating a reference state within the copied sheets. Scrolling Left and Right with Mouse Wheel- Spread.NET now supports scrolling horizontally in a worksheet using Shift+Ctrl+Mouse Wheel. ...

Release Notes: tools allow users to create, open or close custom shapes quickly and easily, just like in Microsoft Excel. The Camera Shape has been enhanced to support the new Enhanced Shape Engine. It supports using ... LAMBDA Function which lets users create new custom functions using custom names and formulas. Added 7 LAMBDA Helper Functions and Related Enhancements- To help create advanced LAMBDA Functions for specific ... for various data types and use cases. They can be created directly in cells using formulas or through the Spread Designer tool. New LAMBDA Function Enables Creating Custom Functions Using Formulas- Added a new ...

Release Notes: the new Styles panel and drop-down in the ribbon bar. All the standard Microsoft Excel built-in styles are available and custom styles can be easily created and reused. Enter Formulas Using '+' ... GrapeCity.Spread.WinForms.Design, which contains the Spread Designer run-time component and associated dialogs and other user interface elements. This package can be referenced when you want to show the Spread Designer dialogs (for ... and '-'- Entering cell formulas has always previously required starting the formula with: '=‘. Starting in this release, Spread will automatically recognize and parse formulas entered by the end-user ...

Screenshots: Easily create in-depth business and financial Key Performance Indicator (KPI) spreadsheets. 0 ...

Release Notes: to return only the references on the active worksheet. Percentage Labels in Pie Charts Users can now enable percentage labels in pie charts, similar to Excel. After creating a Pie chart and adding Data Labels ... calculation functions which match the new Excel Functions for VALUETOTEXT and ARRAYTOTEXT- currently available in beta to Excel users in the insider's program. These functions operate as in Excel ... MATCH and XMATCH functions in a workbook. This enhancement is modeled after the recent Microsoft Excel enhancements to lookup and match functions. New VALUETOTEXT and ARRAYTOTEXT Functions Added new ...

Release Notes: Worksheet Protection Options Dialog- This release now fully enforces all supported worksheet protection options in the user interface and has a new Protect Sheet Dialog for specifying the worksheet protection ... and apply changes using the Format Cells Dialog. Added 19 New Built-In Formula functions for calculations- This release introduces support for many new Microsoft Excel functions that are already available now ... in the Insiders builds and coming soon in the official release versions of Excel for text and dynamic array manipulation: TEXTBEFORE- Returns text that’s before delimiting characters. TEXTAFTER- Returns text that’s ...

Release Notes: New API allows users to check cell validation status. New API allows users to check cell validation status. NullReferenceException is not thrown while printing to PDF format. The formula entered ... Spread to Microsoft Excel. There is no effect on performance when *.ss6 file in code-behind is loaded with FormulaTextBox presence. DefaultSheetDataModel event is triggered for cell whose data has been ...

Release Notes: specific cells from the selection, as in Microsoft Excel®. 1-based Indexing like VSTO- You can now create the IWorkbook to use 1-based indexing for all GrapeCity.Spreadsheet.IWorkbook APIs, like Microsoft ... references, as in Microsoft Excel®. New Constructor for AsyncFunction- You can now create a custom AsyncFunction which uses specified FunctionAttributes. This enables creating custom asynchronous functions ... Excel® VSTO APIs. This can enable easier porting of Excel VBA code or old Spread COM version code (which also used 1-based row and column indexing) to.NET, which has always used 0-based indexing for all ...

Release Notes: NuGet package GrapeCity.Spread.WinForms for.NET 5 and.NET Core 3.1 WinForms. Users can create WinForms applications using the Spread controls in.NET 5 and.NET Core 3.1 and port existing WinForms projects ... create a table of contents or index for a workbook with links to essential sections organized in cells or shapes, and specify the screen tip text to show the user. Enable the AutoCreateHyperlink feature ... The Show Formulas Command The new Show Formulas command works similar to Microsoft Excel: press Ctrl+` to toggle the Show Formulas mode. Edit Points to Create Custom Shapes The new Edit Points command ...

Release Notes: calculation, not RichText). The Data Table. Support Scrolling through the Ribbon Gallery using Spin Buttons- Enhanced the WinForms Designer UI, which now allows users to scroll though the Spread Designer's ... Ribbon using spin buttons. Fixed the issue where Korean was not typed correctly in TextCellType, when not in editing mode. Fixed the issue where after using the SetColumnMerge method, when saving as Excel ... , the merged cells were displayed without being merged in Excel. Fixed the issue where memory leaks occurred while showing FpSpreadDesigner at runtime. Fixed the issue where an error occurred when importing ...

Release Notes: Added steps to manually create a unique runtime license for Microsoft.NET applications. WinForms The DataField property value is now retained when upgrading to Spread version 15. XML files now load ... Improves product activation and runtime license generation. WinForms Activating the Product- Added steps to activate the product license using online and offline methods. Creating a Runtime License- ...

Release Notes: Now supports filtering by Color on No Fill. Windows Forms- Now supports filtering by Color on No Fill, like Excel. ASP.NET- To reduce the view state size for cases with many hidden cells, new ... the client-side APIs GetHiddenValue and GetHiddenCellValue will not work. The minimum target framework version has changed from.NET 4.0 to.NET 4.5.2. This change affects all assemblies of Spread.NET 11 and all ...

Screenshots: Generate reports with data bound sources, status bars, Excel-like tables with filtering, embedded logos, and much more. 0 ...

Screenshots: Easily create dashboards that visualize data with dozens of charts and elements to quickly provide a snapshot of your business's data. 0 ...

Release Notes: Improves data binding and Spread Designer. The FarPoint.Localization.dll would be missing after installing version 16. An 'InvalidOperationException' would occur when binding data to Spread. Superscripts that were set via the Spread Designer would not be maintained. An

Release Notes: added in v14. RichClipboard is not enabled by default, so users must explicitly enable it to operate a paste to visible cells. Hide Outline For Row and Column Groups- The Hide Outline For Row and Column ... Groups feature allows users to hide the outline for row and/or column outline groups. It also removes the user's ability to expand or collapse the outline row and/or column groups while the outline ...