spread code creation editing - Spread.NET

Release Notes: using the Spread Designer tool and other design-time editors, you must use the full-framework controls in a project which targets.NET 4.5.2 or later. You can create parallel projects to build your code ... to named ranges. Links to tables. Links to email. Links to web sites and files. Links from cells, shapes, and images. Custom tooltip text for links. Automatic creation of links when editing cells. Easily ... and create hyperlinks while editing cells. Create internal workbook links using a special syntax like "spread://Sheet1!A1" to specify the location. This syntax also supports named ranges like ...

Release Notes: 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 ... workbooks can now be edited directly or Added in Code. You can add threaded comments by using the IRange.AddCommentThreaded method. Comment Gradient Fill- Cell comments can now have Gradient Fill Effects ... Text in Cells when importing XLSX, so multiple font colors and styles can show in a cell. This release introduces new support for Rich Text Editing directly in cells, so you can select text in the cell ...

Screenshots: With the powerful Spread Desktop Designer App, you’ll get code-free.NET spreadsheet apps in no time. 0 ...

Release Notes: .NET 8 Support Spread.NET now supports.NET 8. Spread Ribbon Control The Spread Ribbon Control is a new addition to Spread.NET, allowing you to insert the Designer ribbon into your application for use ... with Spread.NET. This includes contextual ribbon tabs, buttons, menus and error handling. You can also override built-in commands using the CommandExecuting and CommandExecuted events and manually execute commands ... using the ExecuteCommand function. Workbook Enhancements Header and Footer WrapText- With this release, Spread.NET provides the ability to wrap text for Column headers and footers with the WrapText2 ...

Description: shapes using the new Edit Points feature, or create custom shapes in code using the new API to specify the shape points and segments. Enhanced Hyperlink Support- Add hyperlinks in cells by simply typing ... and full customization for your formulas—you’ll take your complex spreadsheets to the next level No-Code Design with Spread Designers- With the powerful Spread Desktop Designer App, you’ll get code ... 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: 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 ... Adds Dynamic Array support and Spread Designer enhancements. Dynamic Array Support- You can now enter cell formulas that return array values which “spill” into empty adjacent cells. This powerful ... feature is a new alternative to array formulas and includes support for seven new formula functions and the new operators for spilled range (#) and range intersection (@). New Spread Designer Enhancements- ...

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

Release Notes: Adds.NET 6 support and 17 new Sparkline visual functions. Microsoft.NET 6 Support and Nuget Package- Using NuGet Package Manager in Microsoft Visual Studio, you can now easily add the Spread ... KPI, HBar, Histogram, Image, Month Calendar, Pareto, Pie, Scatter, Spread, Stacked, Vari, VBar, and Year Calendar. These new sparkline functions provide a wide variety of built-in data visualizations ... 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: 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 ... in a cell is retained as it is in Spread Designer. Row tag can now be restored while using XML. Subscripts appear incorrectly in the application. Images are exported with different names when exporting form ... changed. Changes made to an XML file in Spread Designer are saved correctly. The value of cells with formulas pointing to another sheet are updated correctly. The font of cell containing rich text ...

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 ... formatting of formula values. Automatic adjustment of row header width to size with the text as the sheet is scrolled down. BackgroundImage in IWorksheet. Editing formulas now supports inserting structured ...

Release Notes: or code in run-time, includes all custom Spread objects that previously would have been lost on export to Excel format (like cell types and column footers). Using the new Exchangeable XLSX file format, all ... saving the workbook in the form resources. This enhances design time performance, especially when using the Spread Designer tool to apply a large or complex template. Exchangeable file format enhances ... performance- Spread.NET 12 features a new exchangeable XLSX file format enhancement. The new ExcelSaveFlag and ExcelOpenFlag enumeration, available when saving or loading XLSX files using the Spread Designer ...

Release Notes: 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 ... digital signature. Important Breaking Changes in Spread.NET 11 Components and Controls The minimum target framework version is changed from.NET 4.0 to.NET 4.5.2. Microsoft has dropped support for.NET 4.0, ... 4.5, and 4.5.1 and implemented support for "quirking" in the latest supported frameworks. This change affects all assemblies of Spread.NET 11. Important Breaking Changes in Spread.NET 11 ...

Release Notes: GcNumber, GcTextBox and GcTimeSpan. Enhanced Printing- Add security to your generated PDF files by password protecting them. Spread for WinForms Missing borders fixed when overflow text is too long. ... hangs the application. Opening an Excel file from a stream with conditional formatting with formulas no longer throws an exception. Memory usage no longer increases when searching in Spread. TextTipPolicy ... no longer shows TextTips on Sheet tabs. QR Code no longer disappears after clicking on any cell. Print preview no longer produces an empty page when the frozen column size is greater than the page size. ...

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 'ExcecutionEngineException' would be triggered in certain circumstances. ToIndex would always return 1. ...

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

Release Notes: Spread Designer now allows you to set built-in theme styles. Baseline Microsoft.NET Framework reference has been changed from.NET 4.5.2 to.NET 4.6.2- All GrapeCity Spread.NET components are now ... In addition, support for the.NET 5 platform target has also been dropped. Added new NuGet Package for GrapeCity.Spread.WinForms.Design- This release introduces a new NuGet package, ... 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 ...

Release Notes: Adds new frozen trailing stick-to-edge option. Frozen Trailing Stick-To-Edge Option- This enhancement affects the layout of frozen trailing columns and rows. These columns are always displayed on the right side, or on the left if RightToLeft is true. This new feature allows you to set a new ...

Release Notes: for the series, you can use Format Data Labels... to specify the percentage type for the pie slice labels. Support Hide/Unhide in Tab Strip Context Menu of Spread Designer Enabled hiding and unhiding worksheets ... in the Spread Designer tool. Previously, users could hide worksheets using only the PropertyGrid to set the Visible property of the worksheet. That setting would be overridden in the Spread Designer to always ... show the hidden worksheets. You now have the option to specify whether to show hidden sheets in the Spread Designer Preferences. Pixel Scrolling by a Set Number of Pixels Enabled setting the vertical ...

Specification:         Spread COM Our Bestseller SpreadJS Spread.NET   $ 1,476.52 $ 1,476.52 $ 1,476.52   Pricing       New License $ 1,476.52 Save $ 22.48 SRP: $ 1,499.00 $ 1,476.52 Save $ 22.48 SRP: $ 1,499.00 $ ...

Licensing Fact Sheet:   ...