Cell report Learning (I.)

Before the job is to do with everyone to do some web development, requirements design, coding, testing and implementation of maintenance, there is no special place, the other is in the project team made N interfaces, nothing else. A chance to contact to do a call cell report things, at first just feel that this thing is good, that time just a business trip back to do nothing to do, to help do a bit of development. Then the leader found out that I did this better than the others, it is not my ability to do the web, let him feel that I self-study ability or relatively strong and other aspects are more balanced, the design of the face is also relatively wide, so put up the original project team to do this cell report specifically.

The main job these days is to save the report, open the report and insert a picture, save the cell report almost made a huge error, because it is a Web project, so to save the file on the server, I check the cell help document to find FileSaveAs method, without further ado that to use, the sound process to make, Own development server and client is a machine nothing, later colleagues said I just found out, I called the method is saved in the client, this feasible, to find FileUpload method, the realization of the process is also twists, on this side of the program or not familiar, a lot of things are not understand, I took it. No one to tell me the system, nor to design documents and data dictionary, really bitter ah!　　　Use of everything to ask others, perhaps now China's IT development management is so, too lack of documentation. Here it is necessary to introduce the cell report, if there are to do this cell report, we can study together.

Cell products are divided into cell components and cell Plug-ins two sister products. Cell components, plug-in (ActiveX control) is Beijing Ufida Huabiao Company in the long-term development and practice based on the launch of a powerful, technically mature report two development tools, is the leading domestic technology has a broad customer base of the business report components, there are more than 600 programming interfaces, to achieve report customization, report display, Print Preview, print, charts, formulas, custom functions, resource localization and other powerful features, to fully read and write Excel files. It is the best solution for software developers to develop excellent reporting software.

The Cell component is suitable for developing Windows report applications

1, a strong tabulation ability, especially suitable for the production of Chinese-style complex reports, to solve all your tabulation problems;

2, rich cell types, support values, currency, date, text and other types. Cell cells contain almost all of the Windows standard controls;

3, rich print settings, the United States and beautiful print preview and printing effect, easy to output a variety of reports;

4, do not need the system to install Excel, you can and Excel file conversion, conversion efficiency is higher, the effect is more perfect;

5, the powerful custom function function, the user may add own function according to own business logic;

6, greatly enhanced the chart function, the chart kind and the effect is par excel;

7, the resources localization function, according to the need may make the cell the different language version;

8, applicable to VB, VC, VF,. NET, Delphi, C + + Builder, PowerBuilder and other development tools.

The Cell plugin is suitable for developing the network report procedure of B/s structure

1, with all the features of cell components, in the browser to provide report display and printing (not IE print);

2, the network report interface beautiful, greatly improve the browser report output effect;

3, with international digital signature, so that users to use a more secure, more assured;

4, the report file can be saved as a Huabiao file or Excel file, which can be further processing;

5, support ASP, asp.net, JSP, VBScript, JavaScript and other language development.

Characteristics	Feature Details
Overall impression	1, table size 8, drag and drop 2, with Excel drag and drop Compatibility 9, input control 3, the unit edit 10, multiple selection/whole line selection 4. Integration Chart 11, Unit formula 5, Chinese environment 12, cell content character limit 6, existing dialog box number 13, automatic drag and drop fill 7, Javascript,vbscript fully compatible interface
Unit style	1, numerical format 5, form line 2, font/color/style 6, automatic folding line display 3, date, time 7, 3D style 4, Currency, percentage 8, the contents of the super long ellipsis tip
Cell type	1, Drop-down Box 7, Step type Roll button 2, Nuclear selection box 8, chart 3, button 9, bar code 4, graphics 10, radio buttons 5, Roll button 11, drop-down form (* * *) 6, can be hidden pull button 12, hyperlink Note: drop down form This is a unique control in the cell, derived from the DataWindow in PowerBuilder, but the function is more excellent. When the Drop-down table is open, another table appears, and the contents of the table come from the data from the master table (which can be taken from any region or from a different table page). Making it easier for users to select data
Chart	1, according to the table data automatically generated 2. Automatically refresh the chart when the unit data changes 3, according to the chart size automatically set the chart font 4, relative reference cell data (similar to the relative element formula) 5. Chart Wizard dialog box 6, unique X-axis property settings 7, according to the data intelligence set data axis 8, mouse drag and drop and resize chart size 9. Multiple chart types 10, the chart floats on the form
Formulas and functions	1. Relative formula 2, to find any expression of the value 3. Evaluate the formula as soon as you edit it 4, generate a circular reference to generate a circular reference formula list 5. The cursor stays in the wrong position when there is a grammatical error 6. Number of system functions 7. Custom Function 8. Add Custom Function Help 9, cell data type 13. Area data type 14. Support Logical Expression 15, the formula unit color display (automatically turns black when printing)
Print and preview	1, print 7, header and footer font color size 2, Print preview 8, margin 3, Header and footer 9, preview multiple page display 4, Paper direction 10, double roll and Keyboard Control preview page move 5, Print Setup dialog box 11, you can use the above methods in the browser 6. Partial printing Printing is an indispensable part of business software, and it is a place where programmers are very frustrated. The cell component attaches particular importance to printing, from the above table, the cell provides the printing function can be compared with Office software.
Output file format	1, Excel 4, HTML 2, PDF 5, CSV 3, TXT
Report type	1, sub-report 5, multilayer table head 2, multiple nested reports 6, conditional grouping 3, cross-report 7, Summary 4. master-Slave table
Other	1. Resource localization 2, can be used in a multi-language environment 3, Chinese-style complex report making