CN102521327A - Method and system for demonstrating electronic form - Google Patents
Method and system for demonstrating electronic form Download PDFInfo
- Publication number
- CN102521327A CN102521327A CN2011104006802A CN201110400680A CN102521327A CN 102521327 A CN102521327 A CN 102521327A CN 2011104006802 A CN2011104006802 A CN 2011104006802A CN 201110400680 A CN201110400680 A CN 201110400680A CN 102521327 A CN102521327 A CN 102521327A
- Authority
- CN
- China
- Prior art keywords
- page
- electronic spreadsheet
- intermediate data
- formatting
- list element
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention relates to a method and a system for demonstrating an electronic form. The method comprises step S1 of setting all form elements and page forms of the electronic form and interlinking the form elements and page forms to generate intermediate data and storing the intermediate data; step S2 of parsing the intermediate data to obtain the form elements and page forms and demonstrating and outputting the form elements and page forms; and step S3 of judging whether the content demonstrated should be adjusted, if so, repeating the steps S1-S3. In the invention, the demonstrated page form of the electronic form is preset to ensure that a complex electronic form is demonstrated and outputted uniformly and automatically according to predetermined demonstrated page forms.
Description
Technical field
The invention belongs to the process field of electronic spreadsheet, particularly a kind of methods of exhibiting of electronic spreadsheet and system.
Background technology
In the production and office administration process of various enterprises and institutions, used a large amount of paper lists and document, these forms and document become list usually.List has formed the operation and the fundamentals of management of unit and enterprise, strictly according to the facts and write up the data in operation and the management process, be very important management object in the IT application in enterprises.This process specifically can show as filling in and handling of the various lists that are associated with production run.For example the management of the occurrences in human life in the production run, finance and material control all is to be based upon on the basis of list.In the service management of enterprises and institutions such as bank, insurance, communications and transportation, post and telecommunications, all rely on the list of a large amount of standards, otherwise just can't carry out the processing of business event.
List essence is exactly through analyzing and refine professional attribute, working out normalized form, be printed on the paper, and in practical application, fill in, handle and transmit.The content of list has been reacted the concrete business of enterprise from many aspects.
Traditional list adopts paper media usually, and cost is high in processing and circulation paper form process, speed is slow, error rate is high in enterprise; Simultaneously traditional preprint the paper list and also need consume a large amount of paper, also bring high printing, storage, distribution and processing cost.Along with computing machine is progressively popularized, enterprises and institutions come into effect and application popularization IT application in enterprises system, have formed electronic spreadsheet.Realize the data input, browse and store through the electronic spreadsheet in the infosystem by business personnel or client.Therefore; Electronic spreadsheet has The visual design, the instant characteristics (Print On Demand) of revising, showing as required; Can avoid document to preprint all direct and indirect waste and waste that mode forms; As it is too much etc. to preprint excessive cycle, printed matter warehousing management cost height, document loss risk, bad stock, progressively substitutes paper form.
Electronic spreadsheet generally shows as in information system and supplies user's input and check the page of data; An electronic spreadsheet has just comprised several list elements, mainly contains text label, single file or multiline text input frame; List box; Drop-down list, radio box and check box also have some other more complicated list element type in addition.The user can import form data through mouse and keyboard operation in these list elements; The electronic spreadsheet project of perhaps choosing some to list; So accomplish the data input and the making of electronic spreadsheet, other users also can browse, check this electronic spreadsheet page simultaneously.
Usually data or the information in the electronic spreadsheet is divided into static elements, dynamic element.Static elements refers to changeless literal, picture, wire frame etc. in the electronic spreadsheet, and they have constituted the overall appearance of a list; Dynamic element refers to the variable literal of content, figure, bar code, form etc., and they are relevant with variable data, and format informations such as the position when being used for the flag data filling, scope, font are also become " variable ".Dynamic element has four kinds: literal variable (Zon) comprises various literal, bar code, system variable literal (like the page number, date) etc.; Form variable (Table) comprises multi-column data, and data length is variable, possible multipage; Chart variable (Chart) is used for the diagrammatic representation to statistics, can be histogram or pie chart; Picture variable (Image) comprises pictorial information.Usually static elements is used for the drawing template establishment file, and dynamic element then is used to show the dynamic data of input.But for a electronic spreadsheet, no matter how dynamic data changes, its static appearance and data fill form always user definition got well.
The dynamic data of electronic spreadsheet is realized the storage to the raw data of each dynamic element such as the text on the electronic spreadsheet, image, bar code, form, chart with database file, XML, HTML, PDF, TXT etc. and special-purpose file layout usually.So the dynamic data of electronic spreadsheet can be kept in the format file easily, make things convenient for other infosystems to handle form data.
Electronic spreadsheet of the prior art all exists deficiency more or less technically with on the performance, and is low such as the treatment effeciency of complicated list, lack aspect such as displayed page control.Though electronic spreadsheet important carrier such as imports, stores, checks as data message, many times also need output, comprise demonstration, displaying etc.Because electronic spreadsheet data itself are page info not; Each electronic spreadsheet data item has only relative position; Lack page model information, what electronic spreadsheet was showed usually is the form of absolute position, and there is uncertain factor in output results such as the demonstration of causes electrons list, displaying; Will find that when output electronic spreadsheet lacks the page model attribute usually, shows and control problems such as bad, shows with different page model such as the electronic spreadsheet that can't realize the same page usually; Usually in the electronic spreadsheet of multipage face, can't specify the different page model of each electronic spreadsheet page; The size of each element in the time of can't realizing the electronic spreadsheet page zoom-in and zoom-out usually on the page, position equal proportion convergent-divergent etc.; Usually the displaying of the electronic spreadsheet page depends on presentation device resolution, and the presentation device page displayed original size of different resolution is different.
Therefore, need a kind of methods of exhibiting and system of electronic spreadsheet, can realize the electronic spreadsheet output effect is showed, according to preset page model comprise the specification of the page, relatively origin position, resolution control, laterally vertical control etc. showed.
Summary of the invention
The object of the present invention is to provide a kind of methods of exhibiting and system of electronic spreadsheet; These method and system can be in advance be provided with the displayed page form of electronic spreadsheet, guarantee that the sophisticated electronic list unifies the displaying output of robotization according to preset displayed page form.
For addressing the above problem, the present invention provides the methods of exhibiting of electronic spreadsheet, comprising:
Step S1 is provided with all list element and page formattings of electronic spreadsheet, said list element and page formatting is linked generate intermediate data and storage;
Step S2 resolves acquisition said list element and page formatting and shows output said intermediate data;
Step S3 judges whether said displaying content needs adjustment,
If, repeating said steps S1 to S3 then;
If not, then withdraw from.
Optional, in said method, among the said step S1, the setting of said page formatting comprises to be created page model and the displayed page attribute in the said page model is set.
Optional, in said method, among the said step S2, middle data are resolved the said page formatting of acquisition, comprise the displayed page attribute of discerning earlier in the said intermediate data.
Optional, in said method, said displayed page attribute comprise the specification of the page, laterally vertically, resolution, in the origin position or multinomial relatively.
According to another side of the present invention, a kind of display systems of electronic spreadsheet is provided, comprising:
The intermediate data module is used to be provided with all list element and page formattings of electronic spreadsheet, said list element and page formatting is linked generate intermediate data and storage;
Show resolver, said intermediate data is resolved acquisition said list element and page formatting and showed output;
Micro control module is used to judge whether said displaying content needs adjustment.
Optional, in said system, said intermediate data module is provided with page formatting and comprises the establishment page model, and displayed page attribute in the said page model is set.
Optional, in said system, said displaying resolver is resolved said intermediate data and is obtained said page formatting, comprises the displayed page attribute in the said intermediate data of identification.
Compared with prior art; The present invention links generation intermediate data and storage through all list element and page formattings of electronic spreadsheet are set with said list element and page formatting, resolves the form of said intermediate data with the displayed page of control electronic spreadsheet; Thereby can be in advance the displayed page form of electronic spreadsheet be provided with; Guarantee that the preset displayed page form of basis of sophisticated electronic list unifies the displaying output of robotization, hidden the interface of page formatting adjustment, satisfied the demand of showing the displayed page form of the electronic spreadsheet that output is complicated and changeable at final displayed page; Need not that each page is provided with one by one in the displaying process; Need not be provided with repeatedly, guarantee the in full accord of output format, realize that electronic spreadsheet can show output accurately and quickly.
Description of drawings
Fig. 1 is the high-level schematic functional block diagram of the computer system of one embodiment of the invention;
Fig. 2 is the high-level schematic functional block diagram of the application software system of one embodiment of the invention;
Fig. 3 is the process flow diagram of displaying of the electronic spreadsheet of one embodiment of the invention;
Fig. 4 is the high-level schematic functional block diagram of display systems of the electronic spreadsheet of one embodiment of the invention.
Embodiment
Methods of exhibiting and system's further explain of the electronic spreadsheet that the present invention is proposed below in conjunction with accompanying drawing and specific embodiment.According to following explanation and claims, advantage of the present invention and characteristic will be clearer.What need explanation is, accompanying drawing all adopts the form of simplifying very much, only is used for conveniently, the purpose of the aid illustration embodiment of the invention lucidly.
As shown in Figure 1; The present invention can specifically realize on computer system; Said computer system comprises centre device CPU 101, primary memory 102, external memory interface 103, memory device 107, IO interface 104, keypad/display 108; As required, can also comprise printing interface 105, PRN device 109, other I/O interface 106, miscellaneous equipment 110 in the said computer system, the various assemblies of said computer system communicate through system bus.
As shown in Figure 2; Computer software is provided the operation that is used for guiding said computer system; Said computer software is stored in primary memory 102, the memory device 107, and said computer software comprises kernel or operating system 203 and UI interface 202, can be loaded such as one or more application programs of application software 204; Be transferred to the primary memory 102 from memory device 107, so that carry out by said computer system.Said computer system receives user 201 data and instruction through UI interface 202; These data and instructions as input by said computer system according to handling from the instruction of computer software or application software 204, perhaps output in the PRN device 109 through printing interface 105.UI interface 202 is used to show result, and the user can provide extra input or stop session this moment.
As shown in Figure 3, the present invention provides a kind of methods of exhibiting of electronic spreadsheet, comprising:
Step S1 is provided with all list element and page formattings of electronic spreadsheet, said list element and page formatting is linked generate intermediate data and storage; Concrete, suppose the displaying output that single page is provided by the page formatting of being studied, then for the instance that is output as characteristic with some pages displaying; Can be regarded as page formatting the set of different page formattings, wherein each page formatting regulation single page is showed output, supposes that OD is corresponding to the list element; MD is corresponding to page formatting; Said page formatting has defined concrete page properties, and ID is corresponding to intermediate data, and intermediate data has comprised the set of OD data and MD data; F is corresponding to the stores processor of data; The relational expression that defines between the above-mentioned data is represented by mathematical function ID=F (MD+OD), for the displaying output that produces a plurality of pages, only need get final product for each page repeats this step;
Step S2; Said intermediate data is resolved acquisition said list element and page formatting and showed output, concrete, can resolve the intermediate data of storage; Analyze page formatting such as page specification type, relative origin position, direction; And said list element, then the data that parse are showed output, for showing and confirming that electronic spreadsheet is through the net result after the page formatting setting;
Step S3 judges whether said displaying content needs adjustment,
If, repeating said steps S1 to S3, concrete so that page formatting is made amendment, adjusted, when needs are adjusted, but the page formatting of illegal or non-standard identification in the modifying target electronic spreadsheet is perhaps appended the page that lacks to the target electronic list;
If not, then withdraw from (like step S4 among Fig. 3).
Further; Among the said step S2, middle data are resolved, analyze page formatting such as page specification type, relative origin position, direction, resolution etc.; And the list element, the page formatting tissue that obtains according to parsing is then showed the electronic spreadsheet of output by the correspondence of page number control.
Further, among the said step S1, the setting of said page formatting comprises to be created page model and the page properties in the said page model is set.
Further, among the said step S2, middle data are resolved the said page formatting of acquisition, comprise the displayed page attribute of discerning earlier in the said intermediate data.
Further; Said displayed page attribute comprise the specification of the page, laterally vertically, in the origin position or multinomial relatively; Concrete, can specifically form a record set when forming said intermediate data, each record in the said record set includes following field:
Page specification type (TYPE);
Relative origin position (XY)
Resolution (DPI)
Direction (LH)
Content (Data)
Said record is that first from the list element begins to make up, and wherein TYPE (page specification type) is defaulted as A4, and origin position (XY) is defaulted as (0,0) relatively.
In the electronic spreadsheet design; The final user can confirm displayed page model composition easily; Intermediate result has comprised page info, and these information are the criteria of right and wrong forms in the electronic spreadsheet data, is not discerned by other software, driving usually; The present invention can be used for sharing the instrument that produces page model with the third party, realizes that the standard of electronic spreadsheet displaying output is resolved.
If the different electronic spreadsheet page that current design is good needs Different control; For example first and second page adopts laterally, A4 output, and third and fourth page adopts vertically, A3 output, and the different pages need adopt different direction output (laterally, vertically) in this form data; Adopt the different page (A3, A4); This method is for these outputs electronic spreadsheet demand complicated and changeable, can be in advance the displayed page form of electronic spreadsheet be provided with, and guarantees that the sophisticated electronic list unifies the output of robotization according to preset displayed page form; Can guarantee the in full accord of output format; And need not to carry out setting one by one, only need guarantee to show the accurate, quick of output through page formatting is set in electronic spreadsheet at displayed page.
As shown in Figure 6, according to another side of the present invention, a kind of display systems of electronic spreadsheet is provided, comprise intermediate data module 1, show resolver 2 and micro control module 3.
Intermediate data module 1 is used to be provided with all list element and page formattings of electronic spreadsheet, and said list element and page formatting are linked generation intermediate data and storage;
2 pairs of said intermediate data of displaying resolver are resolved and are obtained said list element and page formatting and show output;
Micro control module 3 is used to judge whether said displaying content needs adjustment;
Further, said intermediate data module 1 is provided with page formatting and comprises the establishment page model, and displayed page attribute in the said page model is set.
Further, 2 pairs of said intermediate data of said displaying resolver are resolved and are obtained said page formatting, comprise the displayed page attribute in the said intermediate data of identification.
In sum; The present invention is through being provided with all list element and page formattings of electronic spreadsheet; Said list element and page formatting linked generate intermediate data and storage, resolve the form of said intermediate data, thereby can be in advance the displayed page form of electronic spreadsheet be provided with the displayed page of control electronic spreadsheet; Guarantee that the sophisticated electronic list unifies the output of robotization according to preset displayed page form; Satisfied the demand of the displayed page form of exporting electronic spreadsheet complicated and changeable, need not during the course that each page is provided with one by one, realized that electrical form can show output accurately and quickly.
Each embodiment adopts the mode of going forward one by one to describe in this instructions, and what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For the disclosed system of embodiment, because corresponding with the embodiment disclosed method, so description is fairly simple, relevant part is partly explained referring to method and is got final product.
The professional can also further recognize; The unit and the algorithm steps of each example of describing in conjunction with embodiment disclosed herein; Can realize with electronic hardware, client software or the combination of the two; For the interchangeability of hardware and software clearly is described, the composition and the step of each example described prevailingly according to function in above-mentioned explanation.These functions still are that software mode is carried out with hardware actually, depend on the application-specific and the design constraint of technical scheme.The professional and technical personnel can use distinct methods to realize described function to each certain applications, but this realization should not thought and exceeds scope of the present invention.
Obviously, those skilled in the art can carry out various changes and modification to invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these revise and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these change and modification.
Claims (7)
1. the methods of exhibiting of an electronic spreadsheet is characterized in that, comprising:
Step S1 is provided with all list element and page formattings of electronic spreadsheet, said list element and page formatting is linked generate intermediate data and storage;
Step S2 resolves acquisition said list element and page formatting and shows output said intermediate data;
Step S3 judges whether said displaying content needs adjustment,
If, repeating said steps S1 to S3 then.
2. the methods of exhibiting of electronic spreadsheet as claimed in claim 1 is characterized in that, among the said step S1, the setting of said page formatting comprises to be created page model and the displayed page attribute in the said page model is set.
3. the methods of exhibiting of electronic spreadsheet as claimed in claim 2 is characterized in that, among the said step S2, middle data is resolved the said page formatting of acquisition, comprises the displayed page attribute of discerning earlier in the said intermediate data.
4. the methods of exhibiting of electronic spreadsheet as claimed in claim 2 is characterized in that, said displayed page attribute comprise the specification of the page, laterally vertically, resolution, in the origin position or multinomial relatively.
5. the display systems of an electronic spreadsheet is characterized in that, comprising:
The intermediate data module is used to be provided with all list element and page formattings of electronic spreadsheet, said list element and page formatting is linked generate intermediate data and storage;
Show resolver, said intermediate data is resolved acquisition said list element and page formatting and showed output;
Micro control module is used to judge whether said displaying content needs adjustment.
6. the display systems of electronic spreadsheet as claimed in claim 5 is characterized in that, said intermediate data module is provided with page formatting and comprises the establishment page model, and displayed page attribute in the said page model is set.
7. the display systems of electronic spreadsheet as claimed in claim 6 is characterized in that, said displaying resolver is resolved said intermediate data and obtained said page formatting, comprises the displayed page attribute in the said intermediate data of identification.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104006802A CN102521327A (en) | 2011-12-07 | 2011-12-07 | Method and system for demonstrating electronic form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104006802A CN102521327A (en) | 2011-12-07 | 2011-12-07 | Method and system for demonstrating electronic form |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102521327A true CN102521327A (en) | 2012-06-27 |
Family
ID=46292244
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011104006802A Pending CN102521327A (en) | 2011-12-07 | 2011-12-07 | Method and system for demonstrating electronic form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521327A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107450829A (en) * | 2017-06-27 | 2017-12-08 | 武汉逸飞激光设备有限公司 | Touch-screen single page plane display method, touch-screen and programmable logic controller (PLC) |
| CN109582928A (en) * | 2018-12-06 | 2019-04-05 | 万兴科技股份有限公司 | PDF report data extracting method and device |
| CN111274509A (en) * | 2020-01-14 | 2020-06-12 | 拉扎斯网络科技（上海）有限公司 | Object list page display method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510637A (en) * | 2002-12-25 | 2004-07-07 | 深圳市中兴通讯股份有限公司 | General method for printing and drawing graphics document, dynamic link-base |
| CN101038583A (en) * | 2007-04-26 | 2007-09-19 | 孟为 | Gold report generating and generating method thereof |
| CN101499057A (en) * | 2008-01-29 | 2009-08-05 | 鸿富锦精密工业（深圳）有限公司 | Electronic document generating system and method |
-
2011
- 2011-12-07 CN CN2011104006802A patent/CN102521327A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510637A (en) * | 2002-12-25 | 2004-07-07 | 深圳市中兴通讯股份有限公司 | General method for printing and drawing graphics document, dynamic link-base |
| CN101038583A (en) * | 2007-04-26 | 2007-09-19 | 孟为 | Gold report generating and generating method thereof |
| CN101499057A (en) * | 2008-01-29 | 2009-08-05 | 鸿富锦精密工业（深圳）有限公司 | Electronic document generating system and method |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107450829A (en) * | 2017-06-27 | 2017-12-08 | 武汉逸飞激光设备有限公司 | Touch-screen single page plane display method, touch-screen and programmable logic controller (PLC) |
| CN107450829B (en) * | 2017-06-27 | 2021-06-15 | 武汉逸飞激光设备有限公司 | Single-page display method of touch screen, touch screen and programmable logic controller |
| CN109582928A (en) * | 2018-12-06 | 2019-04-05 | 万兴科技股份有限公司 | PDF report data extracting method and device |
| CN109582928B (en) * | 2018-12-06 | 2023-07-21 | 万兴科技股份有限公司 | PDF report data extraction method and device |
| CN111274509A (en) * | 2020-01-14 | 2020-06-12 | 拉扎斯网络科技（上海）有限公司 | Object list page display method and device |
| CN111274509B (en) * | 2020-01-14 | 2021-08-17 | 拉扎斯网络科技（上海）有限公司 | Object list page display method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10169320B2 (en) | Assistive technology for the visually impaired | |
| US9015578B2 (en) | Dynamic optimization of available display space | |
| US8427672B2 (en) | Image processing device | |
| US8812951B1 (en) | Publisher formatting controls | |
| CN101308489B (en) | Electronic table statement type size variable list | |
| CN101699426A (en) | Document format conversion system and method | |
| US8239754B1 (en) | System and method for annotating data through a document metaphor | |
| WO2015078159A1 (en) | Webpage display method and device | |
| US20100287187A1 (en) | Method for query based on layout information | |
| US7865818B2 (en) | Form output control apparatus, form output control method, and computer readable program | |
| CN102521327A (en) | Method and system for demonstrating electronic form | |
| CN103034990B (en) | The method and apparatus of publication verification | |
| US8788926B1 (en) | Method of content filtering to reduce ink consumption on printed web pages | |
| CN103699520A (en) | Font processing method for maintaining e-document layout | |
| CN115114556A (en) | Method and device for creating page | |
| US20070180353A1 (en) | Systems and methods for generating documents using multimedia data gathering tools | |
| CN115309476A (en) | Browser-based ofd file display and editing method | |
| EP2255300A1 (en) | Method and apparatus for the page-by-page provision of an electronic document as a computer graphic | |
| CN111045614B (en) | Method for printing running water report, method for generating overprint file, client and server | |
| US20120246559A1 (en) | Method and system for estimating variable data document conversion time | |
| US10606928B2 (en) | Assistive technology for the impaired | |
| CN113703699B (en) | Real-time output method and device for electronic file | |
| KR102185851B1 (en) | Method for Producting E-Book and Computer Program Therefore | |
| CN114491097A (en) | Method, device and equipment for converting webpage into presentation PPT | |
| CN115080887A (en) | Cross-platform display method, device, equipment and medium for webpage data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120627 |