Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.