What are the functions of Spreadsheet control
This article mainly explains "what are the functions of the Spreadsheet control". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn what functions the Spreadsheet control has.
Spreadsheet
Support for XML Spreadsheet 2003 format
The Spreadsheet Document API and WinForms / WPF Spreadsheet controls now support the XML Spreadsheet 2003 file format, which you can use to load and save documents as needed.
Calculation precision
V20.1 significantly improves the calculation accuracy of the comparison operator and the following built-in functions:
ROUND,ROUNDUP,ROUNDDOWN,FLOOR (rounding can now copy Microsoft Excel)
Date and time function (WEEKNUM,YEARFRAC,DATEDIF,NETWORKDAYS.INTL)
Mathematical functions (SUM and AVERAGE)
Financial function (EFFECT)
Conventional floating-point operations may have a great impact on computational accuracy. In addition to standard floating-point operations, we also use mathematical algorithms to match Microsoft Excel as much as possible.
Theme
Visual Studio 2019 theme
This release includes three new topics inspired by Microsoft Visual Studio 2019:
Visual Studio 2019 Blue
Visual Studio 2019 Dark
Visual Studio 2019 Light
New default theme
In this release, we changed the default theme to Office2019Colorful. The theme supports palettes, lightweight templates, and standard WPF control customization options (Background, BorderBrush, and BorderThickness).
For backward compatibility, use the CompatibilitySettings.LegacyDefaultTheme property.
Support appearance attribut
The most recent theme (Office 2016 SE,Office 20119 Magi vs 2017 Magi vs 2019) now provides enhanced templates for the following controls:
Ribbon items, pages, categories and groups
Toolbars and toolbar items
Context menu and context menu items
SimpleButton,DropDownButton and SplitButton
These templates simplify appearance customization with the following appearance properties:
Background / Foreground
BorderBrush
BorderThickness
CornerRadius
Margin / Padding.
Standard control support
In this release, you can apply DevExpress WPF Office 2019 / 2016SE and Visual Studio 2017Tap 2019 themes to PasswordBox, Menu, and ContextMenu controls.
Other
Simplified SVG declaration
You can now specify the SVG icon, as shown below:
Thank you for your reading, these are the contents of "what are the functions of the Spreadsheet control?" after the study of this article, I believe you have a deeper understanding of what functions the Spreadsheet control has, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
