user interface - Spread.NET

Release Notes: 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 ... 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 ... options. ASP.NET controls now support moving rows directly in the user interface using drag-drop from a header cell. New server command events for Spread ASP.NET are supported for the touch menu interface ...

Description: Compatibility Input Maps to easily enable common Excel keyboard shortcuts in your applications for users. The API allows full customization of the Input Maps and Action Maps to suit your needs. Multiple Worksheet ... the end-user to enter formulas using these functions. Custom Data Visualization using Visual Functions- Create custom data visualization functions that extend the Custom Function feature with new interfaces ... Worksheet Protection Options Dialog- Apply and change worksheet protection options in the user interface with Spread’s Protect Sheet Dialog; users can specify the worksheet protection options and set or apply ...

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

Release Notes: 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 ... is changed to a Scientific format. For example, 123451234512 is rounded off to 1.23451E+11. Inline Cell Images- This feature enables the developer or end-user to directly load and display inline cell images ...

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 ... applied. To add the gradient effects, use the Fill property of the IShapeBase interface, which gets an object of the IFillFormat interface for a specified shape that contains the fill formatting properties ...

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

Release Notes: the screen as users navigate your spreadsheet. Windows Forms Smoother, More Accurate Scrolling- Rather than scroll by row or column, which can provide a choppy scrolling experience, the view now scrolls ... license worry and exposes a public API. Fixed Position Floating Objects- The floating obect now has a property to fix its position so you can add a chart, image, or other obect that won’t scroll off ...

Release Notes: and Footers that have images in them can be exported. If there are multiple images, only the first image will be exported. Collated/Uncollated Option – This new option lets the user choose whether to print ... ColumnDragMoveCompleting/RowDragMoveCompleting Events- The new ColumnDragMoveCompleting and RowDragMoveCompleting events fire when a user finishes moving a row or column via dragging. Hide Borders of Spilled Dynamic Array- When using dynamic ... to True, a user can select various pasting types, including: Paste. Formulas. Formulas and Number Formatting. Keep Source Formatting. No Borders. Keep Source Column Widths. Transpose. Paste Values. Values ...

Release Notes: 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 ... 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 ... to manage the conditional formats in your worksheets. This dialog is displayed in run-time using the API ConditionalFormattingUtils.ShowConditionalFormattingManagerForm. Insert Cut/Copied Cells- The new ...

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

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

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 ... enables users to customize the points and segments of the shape. Enhanced Keyboard Shortcuts Introduces a new simple property for enabling Microsoft Excel compatible keyboard shortcuts in the spreadsheet ...

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 ... 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 ... APIs in previous releases for CLS compliance. New F4 Key Action- You can now use the F4 key while editing a formula reference to toggle the reference between absolute and relative column and row ...

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

Release Notes: modern-style skin and an Excel 2013-like skin. WPF/Silverlight/WInRT- New print support enhancements, structured reference support and an updated modern control appearance. In addition users can now import Excel ...