create excel .net - Spread.NET

Description: 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 ... 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, ... your Spread.NET spreadsheet to XLSX or other file formats... all with zero dependencies on Excel. Enhanced Shape Engine with Group Shape- Create flowcharts, process diagrams, cell callouts, and more ...

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: Adds more than 130 new calculation functions. Performance Improvements- Up to 80% faster and using a fraction of the memory. Spread.NET 11 can import, export, and calculate your Excel documents ... with Document Properties- New API to get and set document properties (Title, Subject, Author, Manager, Company, etc.). ASP.NET Enhancements New command bar buttons for PDF and Excel document export, with password ... 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- ...

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: 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, ... by the control and will be vastly more efficient to use with much smaller file sizes. Making Spread.NET more Excel-like New default instances of Spread.NET Windows Forms 12 support: Drag-drop cell ranges Drag-fill ... return the.NET DateTime data type as in previous releases, instead of the double data type as in Excel. The PropertyDefaults flag disables all of the new default values for properties to enable the new ...

Release Notes: 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 ... 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 ... WinForms projects. Use those projects for editing and design-time, and create separate projects which link the source and resource files to build.NET 5 and.NET Core 3.1 versions. The new ...

Release Notes: 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. ... 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. ...

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 ... 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 ... 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 ...

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 '+' ... if there is not already a cell format applied to that cell. Enhanced Excel-Compatible Keyboard Shortcuts: Ctrl+PgUp and Ctrl+PgDn- This feature must be enabled using FpSpread.Features.ExcelCompatibleKeyboardShortcuts = ... true, which will update the key mappings to support the most common Excel keyboard shortcuts automatically. This support now includes mappings for Ctrl+PageUp and Ctrl+PageDown to navigate the previous ...

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 ... 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 ... 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 ...

Release Notes: 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 ... Excel files. Fixed the issue where a free 30-day evaluation trial license was not automatically generated on the first use. Fixed the issue where the context menu items was displayed in Japanese instead ...

Release Notes: 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 ... Adds new Text-To-Columns dialog, plus 19 new formulas including 'WRAPROWS', 'EXPAND' and 'FORECAST.ETS'. Rich Text Editing- Spread.NET v15 introduced support for Rich ...

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- ...

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: 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: 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: Adds new Enhanced Shape Engine. New Enhanced Shape Engine. Shape property bindings for making rich interactive shapes. Copy-paste enhancements between Microsoft Excel and Spread.NET. Slicers ...

Release Notes: with style settings as well as values and formulas. The TEXT calculation function now uses Excel syntax for formatting values instead of.NET syntax for improved Excel-like behavior. To get the old behavior ... with series patterns and copy cells when Ctrl is pressed, as in Microsoft Excel. The default value of FpSpread.DragFillDataOnly is changed to false. This change will make the control default to fill cells ... Each Spread.NET assembly is now signed with the GrapeCity digital signature. Digital Signatures on DLLs- Starting with this release, each assembly of Spread.NET 11 will be signed with the GrapeCity ...