Spread studio for. Net is a cross-platform spread table control tool set that supports Windows Forms, ASP. NET, WPF, winrt, and Silverlight platforms. The new product package includes the new spread for Windows Forms, spread for ASP. NET, spread for WPF-Silverlight, and spread for winrt control products.
The most widely used spread for Windows Forms and spread for ASP. NET products support Chinese localization. Taking spread for Windows Forms as an example, the developer's interaction interface and prompt information are both Chinese characters, including menus, dialogs, and other interactive interfaces. during design, the methods and attributes of each object are described, and API smart prompts in the Visual Studio environment, and so on.
Open Visual Studio and find fpspread under the "componentone spread" label in the toolbox.
Figure 1: fpspread in the toolbox
Double-click fpspread or drag it to form. The complete Chinese smarttag menu is automatically displayed.
Figure 2: smarttag menu of Spread
The smarttag of spread provides the most common functions and the editor of the main object interface. You can use the spread quick start Wizard to complete the basic spread settings, learn about the basic functions of spread, and complete basic operations. The spread quick start wizard is easy to use when you use the spread control or create a prototype application for the user.
Figure 3: Spread Quick Start wizard
After completing the basic settings, developers may need to customize sheet objects in more detail. For example, spread contains the number of sheet and the setting of each attribute in each sheet. The following sheetview Set editor can complete these settings:
Figure 4: sheetview Set Editor
After the sheet settings are completed, you may need to refine the cells. Similarly, spread provides a cell editor to help you complete cell settings without writing code. As shown in:
Figure 5: edit a cell
In addition to personalized customization of forms and cells, the information system often provides multiple skin sets for end users to customize and improve user experience. Spread also provides skin functions, allowing you to add custom skins through the skin editor, and also provides embedded skin color schemes. As shown in:
Figure 6: Spread skin Editor
In many cases, in a large information system, you can find reusable formats for data processing, display, and report generation. These styles are cumbersome and complex to set through individual cells or cell areas. You cannot use the skin editor to customize the local cells or cell areas. The namedstyle provided by spread is used to solve this problem. By specifying namedstyle, You can preset multiple styles and differentiate them by name for ease of use. Namedstyle can be set and saved in the following Editor:
Figure 7: namedstyle Set Editor
In addition to the above main Chinese editor, the user's favorite is the spread designer. This is not only a designer, but also a document processing tool. It can interact with users like excel, input and process data, generate charts, edit formulas, and customize styles. You can interact with multiple files and directly open and save multiple file formats, including Excel. The final report result is even printed directly. The most important thing is that users can publish and deploy any of them on end users' machines without any additional copyright fees.
Figure 8: Spread designer
In addition to the above functions, spread for Windows Forms also provides an independent chart control fpchart. You can use the fpchart control in any information system that is suitable for any environment, or even in a system that does not contain the spread control. Drag and Drop the fpchart control to the window. The Chinese smarttag menu is displayed by default, as shown in:
Figure 9: graphic controls fpchart and Chinese support during design
Chart editing is also very convenient. Spread provides a dedicated chart designer that allows you to set and adjust more than 85 types of charts in 2D and 3D formats. As shown in:
Figure 10: Spread chart designer
For more details about spread studio for. Net products, see: http://www.gcpowertools.com.cn/products/Spread_Studio.htm