CN106776508A - A kind of electronic spreadsheet generation method and device - Google Patents
A kind of electronic spreadsheet generation method and device Download PDFInfo
- Publication number
- CN106776508A CN106776508A CN201611004931.4A CN201611004931A CN106776508A CN 106776508 A CN106776508 A CN 106776508A CN 201611004931 A CN201611004931 A CN 201611004931A CN 106776508 A CN106776508 A CN 106776508A
- Authority
- CN
- China
- Prior art keywords
- cell
- region
- user
- list
- electronic spreadsheet
- 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.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The embodiment of the present invention provides a kind of electronic spreadsheet generation method and device, belongs to data record field.Electronic spreadsheet generation method provided in an embodiment of the present invention and device, corresponding cell property value is transferred by obtaining the cell model identification of user's selection, and the cell in user's selection is created at position, the cell with the cell property value is created, so as to generate electronic spreadsheet.The method is simple to operate, user can designed, designed electronic spreadsheet at any time according to demand, improve Use Limitation;Also, the method is during designing form, the form of expression of list is visible and can arbitrarily adjust, and greatly improves user satisfaction.
Description
Technical field
The present embodiments relate to data record field, more particularly to a kind of electronic spreadsheet generation method and device.
Background technology
All trades and professions are likely to use electrical form record, hereinafter referred to as electronic spreadsheet, and such as finance will use electricity
Sublist list makes financial statement, and school will use electronic spreadsheet statistic information, and hospital will count patient using electronic spreadsheet
Case etc..
For convenience of the typing of form data, electronic spreadsheet is typically provided with supporting data inputting forms program.Fig. 1 is existing
There is a kind of data inputting forms program display interface schematic diagram that technology is provided.Electronic spreadsheet statistic information is used with school
As a example by, staff is input into name, sex, the student number information of student in typing forms shown in Fig. 1, you can generation is such as the institute of table 1
The information such as the electronic spreadsheet for showing, wherein institute, class can be according to typing Automatic generation of information.
Table 1
Inventor realize it is of the invention during find, there is problems with prior art:
Because the electronic form that every profession and trade is used is changeable, a kind of list is often changed, be required for according in form data
Hold the supporting data inputting forms program of redesigning, domestic consumer cannot designed, designed, it is necessary to seek help from professional, seriously
Influence the Use Limitation of user;In addition, new user cannot predict the electronic spreadsheet for obtaining according only to the content that typing forms show
The form of expression.
The content of the invention
The embodiment of the present invention provides a kind of electronic spreadsheet generation method and device, is used to solve domestic consumer in the prior art
Need to seek help from professional design electronic spreadsheet and corresponding data inputting forms program, have a strong impact on the Use Limitation of user
Problem, and the content that new user show according only to typing forms, it is impossible to predict the form of expression of the electronic spreadsheet for obtaining
Problem.
The embodiment of the present invention provides a kind of electronic spreadsheet generation method, including:
Obtain the cell model identification of user's selection;
The property value of corresponding unit lattice model is transferred according to the cell model identification;
The cell for obtaining user's selection creates position;
Created at position in the cell, create the cell of the property value with the unit lattice model, to generate
Electronic spreadsheet.
In an alternative embodiment, the cell for obtaining user's selection creates position, including:
Dragging object is treated in display;
In response to user to the drag operation for treating dragging object, the destination locations of the drag operation are obtained as institute
State cell and create position.
In an alternative embodiment, before the cell model identification for obtaining user's selection, also include:
In response to the establishment operation of the electronic spreadsheet, display electronic forms editing interface, electronic forms editing circle
Face includes that cell model identification, model identification select tools and cell create region.
In an alternative embodiment, the electronic forms editing interface includes that cell described at least two creates region,
Methods described also includes:
The selection in any cell establishment region in region is created to cell described in described at least two in response to user
Operation, shows that the cell of selection creates the corresponding attribute list in region;
Obtain the arrange parameter of the attribute list in the cell establishment region of the selection;
The cell for setting the selection according to the arrange parameter creates the property value in region.
In an alternative embodiment, methods described also includes:
Determine that the cell that the cell is created belonging to position creates region;
The property value for creating region according to the affiliated cell adjusts the property value of the cell.
In an alternative embodiment, create after the cell of the property value with the unit lattice model, also include:
Show the pending attribute list of the cell for creating;
Obtain the corresponding attribute arrange parameter of the pending attribute list;
Attribute in the pending attribute list is set according to the attribute arrange parameter.
In an alternative embodiment, the arrange parameter includes data source and/or corresponding critical field.
In an alternative embodiment, the editing interface also includes:Accelerator identifications list and the quick key range of establishment;
Methods described also includes:
Determine the accelerator identifications that user selects from the accelerator identifications list;
Quick key range is created described, the accelerator identifications are shown, and it is fast with corresponding to associate the accelerator identifications
Prompt operate interface.
In an alternative embodiment, after generation electronic spreadsheet, also include:
The prompt operation interface is called according to the accelerator identifications, following at least one prompt operation is performed:
Cell borders set, font set, alignment settings, the setting of changing unit lattice data, computing unit lattice data, newly
Build electronic spreadsheet, switching list, preserve setting and/or setting of printing.
In an alternative embodiment, the unit lattice model includes drop-down unit lattice model, text unit lattice model, single file
Edit cell lattice model and/or graph image display unit lattice model.
In an alternative embodiment, after generation electronic spreadsheet, also include:
Specified location in the electronic spreadsheet sets continuous routing;
When detect it is continuous play operation when, print the content after the continuous routing in the electronic spreadsheet.
In an alternative embodiment, methods described also includes:
When detect it is continuous play operation when, the cell borders property value of the modification electronic spreadsheet, to cancel cell side
Frame.
The embodiment of the present invention provides a kind of electronic spreadsheet generating means, including:
First acquisition module, the cell model identification for obtaining user's selection;
Module is transferred, the property value for transferring corresponding unit lattice model according to the cell model identification;
Second acquisition module, the cell for obtaining user's selection creates position;
Creation module, for being created at position in the cell, creates the property value with the unit lattice model
Cell, so as to generate electronic spreadsheet.
Electronic spreadsheet generation method provided in an embodiment of the present invention and device, by obtaining the unit lattice model that user selects
Identify to transfer the property value of corresponding unit lattice model, and at the cell establishment position of user's selection, creating has institute
The cell of the property value of unit lattice model is stated, so as to generate electronic spreadsheet.The method is simple to operate, and user can be according to demand
Designed, designed electronic spreadsheet, improves Use Limitation at any time;Also, the method is during designing form, the performance shape of list
Formula is visible and can arbitrarily adjust, and greatly improves user satisfaction.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
The accompanying drawing to be used needed for having technology description is briefly described, it should be apparent that, drawings in the following description are this hairs
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with root
Other accompanying drawings are obtained according to these accompanying drawings.
A kind of data inputting forms program display interface schematic diagram that Fig. 1 is provided for prior art;
Fig. 2 is a kind of electronic spreadsheet generation method flow chart provided in an embodiment of the present invention;
Fig. 3 is a kind of electronic forms editing interface schematic diagram provided in an embodiment of the present invention;
Fig. 4 is another electronic spreadsheet generation method flow chart provided in an embodiment of the present invention;
Fig. 5 is another electronic spreadsheet generation method flow chart provided in an embodiment of the present invention;
Fig. 6 is a kind of electronic spreadsheet schematic diagram provided in an embodiment of the present invention;
Fig. 7 is another electronic spreadsheet schematic diagram provided in an embodiment of the present invention;
Fig. 8 is a kind of electronic spreadsheet generating means provided in an embodiment of the present invention.
Specific embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
A part of embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
A kind of electronic spreadsheet generation method is the embodiment of the invention provides, as shown in figure 1, methods described includes:
Step 101:Obtain the cell model identification of user's selection;
Step 102:The property value of corresponding unit lattice model is transferred according to the cell model identification;
Step 103:The cell for obtaining user's selection creates position;
Step 104:Created at position in the cell, create the unit of the property value with the unit lattice model
Lattice, to generate electronic spreadsheet.
In embodiments of the present invention, can by the electronic equipment with data-handling capacity come creating unit lattice, and then
Generation electronic spreadsheet, the electronic equipment such as computer, mobile phone, intelligent TV set, single-chip microcomputer etc..
In the embodiment of the present invention, described cell attribute can include cell function type, such as drop-down, text,
The functions such as single file editor, graph image displaying;The base attribute of cell, such as frame, height, width, word can also be included
Body, numerical monitor mode, whether the attribute such as visible;Some adeditive attributes of cell can also even be included, such as binding
The attributes such as data source, the critical field of binding, the present invention does not do any restriction.Correspondingly, the cell model identification can be with
Including word and/or the icon mark for describing cell model attributes or underlying attribute, the present invention is not to the unit
The form of lattice model mark does any restriction, as long as user can be made to associate the mark of unit lattice model respective attributes
As the cell model identification in the present invention.
In one scenario, in step 101 electronic equipment display interface Cell display model identification list, electronics sets
For by capturing user to a clicking operation for mark in cell model identification list, the unit of user's selection is got
Lattice model is identified.The method can directly determine the attribute of cell to be created by clicking on corresponding cell model identification,
Operating procedure is simple, and amount of calculation is small.
In another scene, the display interface Cell display model identification list of electronic equipment in step 101, and
Checks options are also shown, electronic equipment determines that user will select two by capturing selection operation of the user to the checks options
Individual or multiple cell model identifications, by capturing choosing of the user to the two or more marks in cell model identification list
Operation is selected, two or more cell model identifications of user's selection are determined.The method can be that cell to be created is assigned
The attribute of more diversification, makes list more hommization, the personalization of generation, further increases user experience.
In the embodiment of the present invention, the property value of the unit lattice model can include numeral, letter, symbol and default
Program etc. all be used to characterize the data of the cell attribute.
It is single by searching after electronic equipment gets the cell model identification of user's selection in the embodiment of the present invention
Mapping relations between first lattice model mark and unit lattice model, determine the corresponding unit of cell model identification of user's selection
Lattice model, according to unit lattice model and the mapping relations of property value, then the property value of determining unit lattice model transfers determination
The property value of unit lattice model.Mapping between the property value of cell model identification, unit lattice model and unit lattice model
Relation can be stored in the memory of electronic equipment, it is also possible to stored in the mobile memory mediums such as mobile hard disk, USB flash disk, very
Can also extremely store in the webserver, the present invention is not limited in any way to this.
In one scenario, electronic equipment is obtained by capturing user in the single-click operation of predeterminable area in step 103
The cell of user's selection creates position;In at step 104 using the cell establishment position of user's selection as cell
The heart, creates the cell with the cell property value.This process simplify the selection operation that cell creates position, operation
Simply, it is time saving.
In another scene, electronic equipment is obtained by capturing user in the double click operation of predeterminable area in step 103
The cell for taking family selection creates the center of position;Step 104 is ibid.The method reduces the mistake even avoided due to user
Addressing mistake caused by operation.
In another scene, electronic equipment shows and treats dragging object in step 103, waits to pull to described in response to user
The drag operation of object, the destination locations for obtaining the drag operation create position as the cell.The method can be by
The property value of unit lattice model is tied to be treated on dragging object, when after dragging object is drawn to destination locations, is directly created
Go out the cell of the property value with cell model.The method operation target it is visible, it is more vivid, intuitively guiding user wound
Cell is built, the Experience Degree of user is improve.
Electronic spreadsheet generation method provided in an embodiment of the present invention, by obtain user select cell model identification come
The property value of corresponding unit lattice model is transferred, and at the cell establishment position of user's selection, creating has the unit
The cell of the property value of lattice model, so as to generate electronic spreadsheet.The method is simple to operate, user can according to demand at any time from
Row design electronic spreadsheet, improves Use Limitation;Also, the method is during designing form, the form of expression of list is visible
And can arbitrarily adjust, greatly improve user satisfaction.
Based on above-described embodiment, in another embodiment of the present invention, the electronic spreadsheet generation method is also wrapped
Include:
Before the cell model identification for obtaining user's selection, also include:
In response to the establishment operation of the electronic spreadsheet, display electronic forms editing interface, electronic forms editing circle
Face includes that cell model identification, model identification select tools and cell create region.Wherein, electronic forms editing interface
A kind of form is as shown in Figure 3.
In embodiments of the present invention, electronic equipment creates mark in display interface display electronic spreadsheet, when capturing user
When creating the clicking operation of mark to electronic spreadsheet, electronic forms editing interface is shown, so that user passes through electronic forms editing
Model identification select tools select unit lattice model mark on interface, and have and cell in cell establishment region establishment
The cell of the corresponding property value of model identification.The method can intuitively guide the user to carry out the selection of cell model identification
It is simple and practical and cell creates the selection of position, user is needed not move through designed, designed electronic spreadsheet by Special Training,
User satisfaction is high.
Optionally, the electronic forms editing interface includes that cell described at least two creates region.Based on this, referring to
Fig. 4, in yet another embodiment of the present invention, methods described also includes:
Step 201:Any cell creates region during region is created to cell described at least two in response to user
Selection operation, shows that the cell of selection creates the corresponding attribute list in region;
Step 202:Obtain the arrange parameter of the attribute list in the cell establishment region of the selection;
Step 203:The cell for setting the selection according to the arrange parameter creates the property value in region.
In the embodiment of the present invention, can be including line number, columns, alignment, visible, row height, col width etc. in the attribute list
All attributes related to cell or electronic spreadsheet.Include attribute-name and corresponding property value in the attribute list.Institute
Stating attribute-name in attribute list can create the different and different of region because of cell, such as creating electronic spreadsheet gauge outfit
Region, the region for creating electronic spreadsheet body matter and the region for creating electronic spreadsheet table tail, be respectively provided with not
Same attribute-name;For the ease of assigning identical attribute-name different property values, different units lattice create the attribute column in region
Attribute-name in table can also be identical.
In embodiments of the present invention, when electronic equipment captures the clicking operation that user creates region to a certain cell,
Or to two or more cells create region frame selection operation when, display user selection cell create region
Corresponding attribute list.
For example, by taking the editing interface that Fig. 3 shows as an example, it is as shown in table 2 for creating the attribute list in region of gauge outfit, use
Attribute list to create the region of list body matter is as shown in table 3, and the attribute list for creating table tail is as shown in table 4,
Wherein table 2-4 is only used for illustrating illustrating the form of expression of attribute list, is not intended to limit the present invention, the row of other forms of expression
Table is also within protection scope of the present invention.
Table 2
Attribute-name | Property value |
Highly | a |
Frame | Have |
…… | …… |
Table 3
Attribute-name | Property value |
Font | Song |
Alignment | Between two parties |
…… | …… |
Table 4
Attribute-name | Property value |
Remarks frame | It is |
The display page number | It is |
…… | …… |
In the embodiment of the present invention, electronic equipment is input into property value column by obtaining user or the data that select are obtained
Arrange parameter, and the property value in region is created according to the arrange parameter setting unit lattice for getting.Wherein, the arrange parameter can
With including numerical value, letter, character, program, word etc. all can be used to the data of characterization attributes.
In one alternate embodiment, electronic equipment according to cell create region property value directly generate some rows,
The cell of row, saves the creation time of electronic spreadsheet.
Region is created by setting two or more cells in editing interface, is easy to be assigned to different regions respectively
Different property values are given, is easy to the cell in unified operation and management the same area.
Further, when editing interface is provided with two or more cells creates region, electronic equipment is obtained
After creating position to cell, determine that the cell that the cell is created belonging to position creates region, according to affiliated
The cell create the property value in region and adjust the property value of the cell.
Alternatively, electronic equipment creates position determination unit lattice position coordinates according to the cell for getting, then will be single
The boundary coordinate that first lattice position coordinates creates region with cell is matched, when cell location coordinate is located at a certain cell
Create when within the boundary coordinate in region, it is that cell creates position said units lattice establishment area to determine that the cell creates region
Domain.
Alternatively, the cell that electronic equipment is determined belonging to cell establishment position is created after region, by cell
Attribute list creates area attribute list and is matched with cell, finds identical or association attributes, transfers cell establishment
Described identical or association attributes property value in area attribute list, according to the property value adjustment unit lattice attribute list transferred
In corresponding property value.Wherein, the association attributes refers to and the form of cell, filling content, each side such as bound content
The data source of relevant attribute, such as cell height, the background color of filling and binding.
For example, attribute list of the table 5 for a cell, table 3 is the attribute list of the cell region, electronic equipment
The attribute identical or related to table 3 of table 5 is found for " font " and " alignment ", transfer in table 3 " font " property value " Song " and
" alignment " property value " placed in the middle ", and " font " property value " pattern " in table 5 is revised as " Song ", by " alignment " attribute in table 5
Value " right side " is revised as " placed in the middle ".
Table 5
Attribute-name | Property value |
Font | Pattern |
Alignment | Right side |
…… | …… |
The method creates the property value adjustment unit lattice property value in region automatically according to cell, it is to avoid user is creating
The troublesome operation of the property value adjustment unit lattice property value one by one for needing to create region according to cell during cell, improves list
The establishment efficiency of first lattice, has saved creation time.
Based on above-described embodiment, in another embodiment of the present invention, referring to Fig. 5, the electronic spreadsheet is created
Method also includes after the cell with the cell property value is created:
Step 301:Show the pending attribute list of the cell for creating;
Step 302:Obtain the corresponding attribute arrange parameter of the pending attribute list;
Step 303:Attribute in the pending attribute list is set according to the attribute arrange parameter.
In embodiments of the present invention, attribute-name and corresponding property value are included in the pending attribute list, wherein
The property value can include existing revisable property value, existing not revisable property value, or even can also include
Blank value.Electronic equipment determines that attribute sets by obtaining the data that user fills in or select in the corresponding property value column of attribute-name
Put parameter.
As shown in figure 3, in a concrete scene of the embodiment of the present invention, cell model identification is words identification, such as Fig. 3
Shown " text unit lattice ".Model identification select tools are " cell select tools bar ", in " cell select tools bar "
Include the checks options and dragging object " Band objects " of cell model identification.Cell creates region includes " Band
Gauge outfit ", " Band contents " and " Band tables tail " three regions.Electronic equipment is chosen according to user to " final election cell object "
Operation, determines that user will select two or more cell model identifications;" text unit lattice " are clicked on when user is captured
Operation when, Cell display model identification list;In response to user to two or more unit lattice models in list
The clicking operation of mark, determines the cell model identification of user's selection;In response to user to the drag motions of " Band objects ",
It is determined that it is that cell creates position to pull destination locations;Generation unit lattice on position are created in cell, the cell has
The property value that the cell model identification selected with user is associated;The pending attribute list of Cell display, the pending category
Property list in include " Name ", " Left ", " Top ", " Visible ", " BindField " and " BindDateSoure " category
Property, and their corresponding property values of difference.
By showing pending attribute list, user is set further to adjust the cell for having created by the list
Attribute, it is to avoid cell cannot again change the problem of unreasonable attribute once founding, operates more hommization, can enter one
Step improves user satisfaction.
In a scene, the arrange parameter includes data source, and the data source can for example include the disease that hospital sets up
Student information data storehouse, accounting data storehouse of Finance Department's foundation that people's archive database, school set up etc., by cell
Binding data source, can obtain target data from the data source of binding automatically, reduce the letter being manually entered after list generation
Breath amount, saves input time;
In another scene, the arrange parameter includes critical field, by setting critical field, can directly from unit
The data related to the critical field are obtained in the data source that lattice have been bound;
In another scene, the arrange parameter includes data source and corresponding critical field, is bound by cell
Data source, and critical field is set, the number related to the critical field can be directly obtained from the data source of cell binding
According to.
Further, to ensure upgrading in time for data, for the cell for having bound data source, electronic equipment in response to
Electronic spreadsheet create complete operation, obtain binding data source latest edition, and by the data source of latest edition with it is corresponding
Cell bound.
The form of expression such as Fig. 6 institutes of the electronic spreadsheet that the method provided by above-mentioned several embodiments of the invention is generated
Show, Fig. 6 is used merely to the form of the electronic spreadsheet of displaying generation, is not intended to limit the invention.
Further, in other embodiments of the invention, the editing interface can also include:Accelerator identifications list
And create quick key range;Methods described also includes:
Determine the accelerator identifications that user selects from the accelerator identifications list;
Quick key range is created described, the accelerator identifications are shown, and it is fast with corresponding to associate the accelerator identifications
Prompt operate interface.
In embodiments of the present invention, prompt operation interface is connected with the corresponding script of prompt operation, and the script can be wrapped
Include cell borders setting script, font setting script, alignment setting script, changing unit lattice data and script, calculating list are set
First lattice data script, newly-built electronic spreadsheet script, switching list script, preservation set script and/or setting of printing script etc., institute
Stating script can be according to the use demand of user by the script such as Python, Lua, JavaScript, Pascal editor
Into.
In the embodiment of the present invention, electronic equipment display accelerator identifications list clicks on the accelerator identifications according to user
The operation of the accelerator identifications in list determines the accelerator identifications of user's selection, shows that user selects in quick key range creating
The accelerator identifications selected, and by the accelerator identifications and corresponding prompt operation interface conjunctionn, user is given birth in electronic spreadsheet
Corresponding prompt operation can be carried out after by the accelerator identifications for creating.
Correspondingly, the electronic spreadsheet of above-described embodiment generation is as shown in fig. 7, Fig. 7 is used merely to the electronic watch of displaying generation
Single form, is not intended to limit the invention.
Further, after generation electronic spreadsheet, methods described also includes:
When the prompt operation event of electronic equipment monitoring users, when getting clicking operation of the user to accelerator identifications
When, the accelerator identifications clicked on according to user call corresponding prompt operation interface, perform prompt operation.The prompt operation bag
Include:Cell borders are set, font is set, align setting, the setting of changing unit lattice data, computing unit lattice data, newly-built electricity
Sublist list, switching list, preservation are set and/or setting of printing.
For example, have selected same row or the two or more cells with a line when electronic equipment gets user
When, the prompt operation event of monitoring users, when user is got to the clicking operation of " summation " accelerator identifications, calculates user
The same row of selection or with the data sum in two or more cells of a line.Wherein, " summation " is only cell
A kind of computational methods example of data, the embodiment of the present invention is applied to all cell method for computing data.
And for example, when electronic equipment gets user have selected two row or two row cells, the prompt operation of monitoring users
Event, when user is got to the clicking operation of " exchange " accelerator identifications, exchanges in two row cells of user's selection
Data in data or two column unit lattice.Wherein, " exchange " is only that a kind of of cell data calculates change example, and the present invention is real
Example is applied suitable for all cell data change methods.
Further, in embodiments of the present invention, after electronic spreadsheet generation, methods described also includes:
Specified location in the electronic spreadsheet sets continuous routing;
When detect it is continuous play operation when, print the content after the continuous routing in the electronic spreadsheet.
In a scene, electronic equipment shows continuous routing, in response to user to continuing the drag operation of routing, by the dragging
The destination locations of operation as the continuous routing set location, in order to detect user it is continuous beat operate when, from described
Electronic spreadsheet is printed at continuous routing.The method is easy to operate, and user can arbitrarily adjust to continue and beat position according to the demand of oneself,
To ensure not existing the unwanted content of user in the continuous electronic spreadsheet beaten.
In another scene, electronic equipment detects input information of the user to electronic spreadsheet, and with the input letter
The lower section of most end a line of breath shows continuous routing, in order to detect user it is continuous beat operate when, beaten from the continuous routing
Print electronic spreadsheet.The method starts to set continuous routing without user, and ensure that in the continuous electronic spreadsheet beaten do not exist user
Unwanted content.
Further, in embodiments of the present invention, when detect it is continuous play operation when, the cell side of the modification electronic spreadsheet
Box properties value, to cancel cell borders.
For the electronic spreadsheet with frame, the frame of electronic spreadsheet is all carried out when printing first time
Printing, in embodiments of the present invention, when electronic equipment detect it is continuous beat operate when, can by changing cell borders attribute
Value, cancels cell borders, it is to avoid the duplicate printing of cell borders, saves print resource.
To realize electronic spreadsheet generation method provided in an embodiment of the present invention, filled present invention also offers electronic spreadsheet generation
Embodiment is put, referring to Fig. 8, described device includes:
First acquisition module 10, the cell model identification for obtaining user's selection;
Module 20 is transferred, the property value for transferring corresponding unit lattice model according to the cell model identification;
Second acquisition module 30, the cell for obtaining user's selection creates position;
Creation module 40, for being created at position in the cell, creates the property value with the unit lattice model
Cell, so as to generate electronic spreadsheet.
Electronic spreadsheet generating means provided in an embodiment of the present invention, by obtain user select cell model identification come
The property value of corresponding unit lattice model is transferred, and at the cell establishment position of user's selection, creating has the unit
The cell of the property value of lattice model, so as to generate electronic spreadsheet.The method is simple to operate, user can according to demand at any time from
Row design electronic spreadsheet, improves Use Limitation;Also, the method is during designing form, the form of expression of list is visible
And can arbitrarily adjust, greatly improve user satisfaction.
In an alternative embodiment, second acquisition module, including:
Display unit, dragging object is treated for showing;
Acquiring unit, to the drag operation for treating dragging object, the drag operation is obtained in response to user
Destination locations create position as the cell.
In an alternative embodiment, described device also includes:
Display module, for the establishment operation in response to the electronic spreadsheet, display electronic forms editing interface, the electricity
Sublist list editing interface includes that cell model identification, model identification select tools and cell create region.
In an alternative embodiment, the electronic forms editing interface includes that cell described at least two creates region,
Described device also includes:
The display module, for creating any unit in region to cell described in described at least two in response to user
Lattice create the selection operation in region, show that the cell of selection creates the corresponding attribute list in region;
3rd acquisition module, the cell for obtaining the selection creates the arrange parameter of the attribute list in region;
First setup module, the cell for setting the selection according to the arrange parameter creates the attribute in region
Value.
In an alternative embodiment, described device also includes:
First determining module, for determining that the cell that the cell is created belonging to position creates region;
Adjusting module, the property value for creating region for the cell belonging to basis adjusts the attribute of the cell
Value.
In an alternative embodiment, described device also includes:
The display module, the pending attribute list for showing the cell for creating;
4th acquisition module, for obtaining the corresponding attribute arrange parameter of the pending attribute list;
Second setup module, for setting the attribute in the pending attribute list according to the attribute arrange parameter.
In an alternative embodiment, the arrange parameter includes data source and/or corresponding critical field.
In an alternative embodiment, the editing interface also includes:Accelerator identifications list and the quick key range of establishment;
Described device also includes:
Second determining module, for determining to show described in the accelerator identifications that user selects from the accelerator identifications list
Show module, for creating quick key range described, show the accelerator identifications;
Relating module, for be associated in it is described create accelerator identifications that quick key range show with it is corresponding fast
Operate interface.
In an alternative embodiment, described device also includes:
Performing module, for after electronic spreadsheet is generated, calling the prompt operation to connect according to the accelerator identifications
Mouthful, perform following at least one prompt operation:
Cell borders set, font set, alignment settings, the setting of changing unit lattice data, computing unit lattice data, newly
Build electronic spreadsheet, switching list, preserve setting and/or setting of printing.
In an alternative embodiment, the unit lattice model includes drop-down unit lattice model, text unit lattice model, single file
Edit cell lattice model and/or graph image display unit lattice model.
In an alternative embodiment, described device also includes:
3rd setup module, continuous routing is set for the specified location in the electronic spreadsheet;
Print module, for when detect it is continuous play operation when, print in the electronic spreadsheet after the continuous routing
Content.
In an alternative embodiment, described device also includes:
Modified module, for when detect it is continuous play operation when, the cell borders property value of the modification electronic spreadsheet, with
Cancel cell borders.
Device embodiment described above is only schematical, wherein the unit illustrated as separating component can
To be or may not be physically separate, the part shown as unit can be or may not be physics list
Unit, you can with positioned at a place, or can also be distributed on multiple NEs.It can according to the actual needs be selected
In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness
Work in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each implementation method can
Realized by the mode of software plus required general hardware platform, naturally it is also possible to by hardware.Based on such understanding, on
Stating the part that technical scheme substantially contributes to prior art in other words can be embodied in the form of software product, should
Computer software product can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers
Order is used to so that a computer equipment (can be personal computer, server, or network equipment etc.) performs each implementation
Method described in some parts of example or embodiment.
Finally it should be noted that:The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although
The present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those within the art that:It still may be used
Modified with to the technical scheme described in foregoing embodiments, or equivalent is carried out to which part technical characteristic;
And these modification or replace, do not make appropriate technical solution essence depart from various embodiments of the present invention technical scheme spirit and
Scope.
Claims (24)
1. a kind of electronic spreadsheet generation method, it is characterised in that including:
Obtain the cell model identification of user's selection;
The property value of corresponding unit lattice model is transferred according to the cell model identification;
The cell for obtaining user's selection creates position;
Created at position in the cell, the cell of the property value with the unit lattice model is created, to generate electronics
List.
2. method according to claim 1, it is characterised in that the cell of the acquisition user selection creates position, bag
Include:
Dragging object is treated in display;
In response to user to the drag operation for treating dragging object, the destination locations of the drag operation are obtained as the list
First lattice create position.
3. method according to claim 1, it is characterised in that the cell model identification of the acquisition user selection it
Before, also include:
In response to the establishment operation of the electronic spreadsheet, display electronic forms editing interface, the electronic forms editing interface bag
Include cell model identification, model identification select tools and cell and create region.
4. method according to claim 3, it is characterised in that the electronic forms editing interface is included described at least two
Cell creates region, and methods described also includes:
The selection operation in any cell establishment region in region is created to cell described in described at least two in response to user,
Show that the cell of selection creates the corresponding attribute list in region;
Obtain the arrange parameter of the attribute list in the cell establishment region of the selection;
The cell for setting the selection according to the arrange parameter creates the property value in region.
5. method according to claim 4, it is characterised in that also include:
Determine that the cell that the cell is created belonging to position creates region;
The property value for creating region according to the affiliated cell adjusts the property value of the cell.
6. the method according to claim any one of 1-5, it is characterised in that create the attribute with the unit lattice model
After the cell of value, also include:
Show the pending attribute list of the cell for creating;
Obtain the corresponding attribute arrange parameter of the pending attribute list;
Attribute in the pending attribute list is set according to the attribute arrange parameter.
7. method according to claim 6, it is characterised in that the arrange parameter includes data source and/or corresponding pass
Key field.
8. method according to claim 3, it is characterised in that the editing interface also includes:Accelerator identifications list and
Create quick key range;
Methods described also includes:
Determine the accelerator identifications that user selects from the accelerator identifications list;
Quick key range is created described, the accelerator identifications is shown, and associate the accelerator identifications with corresponding quick behaviour
Make interface.
9. method according to claim 8, it is characterised in that after generation electronic spreadsheet, also include:
The prompt operation interface is called according to the accelerator identifications, following at least one prompt operation is performed:
Cell borders are set, font is set, align setting, the setting of changing unit lattice data, computing unit lattice data, newly-built electricity
Sublist list, switching list, preservation are set and/or setting of printing.
10. method according to claim 1, it is characterised in that the unit lattice model includes drop-down unit lattice model, text
This unit lattice model, single file edit cell lattice model and/or graph image display unit lattice model.
11. method according to claim any one of 1-5, it is characterised in that after generation electronic spreadsheet, also include:
Specified location in the electronic spreadsheet sets continuous routing;
When detect it is continuous play operation when, print the content after the continuous routing in the electronic spreadsheet.
12. methods according to claim 11, it is characterised in that methods described also includes:
When detect it is continuous play operation when, the cell borders property value of the modification electronic spreadsheet, to cancel cell borders.
A kind of 13. electronic spreadsheet generating means, it is characterised in that including:
First acquisition module, the cell model identification for obtaining user's selection;
Module is transferred, the property value for transferring corresponding unit lattice model according to the cell model identification;
Second acquisition module, the cell for obtaining user's selection creates position;
Creation module, for being created at position in the cell, creates the unit of the property value with the unit lattice model
Lattice, so as to generate electronic spreadsheet.
14. devices according to claim 13, it is characterised in that second acquisition module, including:
Display unit, dragging object is treated for showing;
Acquiring unit, to the drag operation for treating dragging object, the purpose of the drag operation is obtained in response to user
Position creates position as the cell.
15. devices according to claim 13, it is characterised in that also include:
Display module, for the establishment operation in response to the electronic spreadsheet, display electronic forms editing interface, the electronic watch
Single editing interface includes that cell model identification, model identification select tools and cell create region.
16. devices according to claim 15, it is characterised in that the electronic forms editing interface includes at least two institutes
State cell and create region, described device also includes:
The display module, for being created to any cell in cell establishment region described in described at least two in response to user
The selection operation in region is built, shows that the cell of selection creates the corresponding attribute list in region;
3rd acquisition module, the cell for obtaining the selection creates the arrange parameter of the attribute list in region;
First setup module, the cell for setting the selection according to the arrange parameter creates the property value in region.
17. devices according to claim 16, it is characterised in that also include:
First determining module, for determining that the cell that the cell is created belonging to position creates region;
Adjusting module, the property value for creating region for the cell belonging to basis adjusts the property value of the cell.
18. device according to claim any one of 13-17, it is characterised in that also include:
The display module, the pending attribute list for showing the cell for creating;
4th acquisition module, for obtaining the corresponding attribute arrange parameter of the pending attribute list;
Second setup module, for setting the attribute in the pending attribute list according to the attribute arrange parameter.
19. devices according to claim 18, it is characterised in that the arrange parameter includes data source and/or corresponding
Critical field.
20. devices according to claim 15, it is characterised in that the editing interface also includes:Accelerator identifications list
And create quick key range;
Described device also includes:
Second determining module, for determining to show mould described in the accelerator identifications that user selects from the accelerator identifications list
Block, for creating quick key range described, shows the accelerator identifications;
Relating module, for being associated in the accelerator identifications and corresponding prompt operation that the quick key range of establishment shows
Interface.
21. devices according to claim 10, it is characterised in that also include:
Performing module, for after electronic spreadsheet is generated, the prompt operation interface being called according to the accelerator identifications, holds
The following at least one prompt operation of row:
Cell borders are set, font is set, align setting, the setting of changing unit lattice data, computing unit lattice data, newly-built electricity
Sublist list, switching list, preservation are set and/or setting of printing.
22. devices according to claim 13, it is characterised in that the unit lattice model include drop-down unit lattice model,
Text unit lattice model, single file edit cell lattice model and/or graph image display unit lattice model.
23. device according to claim any one of 13-17, it is characterised in that also include:
3rd setup module, continuous routing is set for the specified location in the electronic spreadsheet;
Print module, for when detect it is continuous play operation when, print interior after the continuous routing in the electronic spreadsheet
Hold.
24. devices according to claim 23, it is characterised in that also include:
Modified module, for when detect it is continuous play operation when, the cell borders property value of the electronic spreadsheet is changed, with cancellation
Cell borders.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611004931.4A CN106776508A (en) | 2016-11-15 | 2016-11-15 | A kind of electronic spreadsheet generation method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611004931.4A CN106776508A (en) | 2016-11-15 | 2016-11-15 | A kind of electronic spreadsheet generation method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106776508A true CN106776508A (en) | 2017-05-31 |
Family
ID=58968644
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611004931.4A Withdrawn CN106776508A (en) | 2016-11-15 | 2016-11-15 | A kind of electronic spreadsheet generation method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106776508A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106776509A (en) * | 2016-11-16 | 2017-05-31 | 武汉飞博科技有限公司 | A kind of electronic spreadsheet generation method and device |
CN107766314A (en) * | 2017-10-20 | 2018-03-06 | 网易(杭州)网络有限公司 | The data processing method and device of electrical form |
CN108959225A (en) * | 2018-06-22 | 2018-12-07 | 上海麦健信息技术有限公司 | A kind of clinical research list generation method and device |
CN110245329A (en) * | 2018-03-07 | 2019-09-17 | 珠海金山办公软件有限公司 | Text managemant method, apparatus, electronic equipment and computer readable storage medium |
CN113168497A (en) * | 2018-12-11 | 2021-07-23 | 决策场景私人有限公司 | Improved electronic form and method for updating electronic form |
-
2016
- 2016-11-15 CN CN201611004931.4A patent/CN106776508A/en not_active Withdrawn
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106776509A (en) * | 2016-11-16 | 2017-05-31 | 武汉飞博科技有限公司 | A kind of electronic spreadsheet generation method and device |
CN107766314A (en) * | 2017-10-20 | 2018-03-06 | 网易(杭州)网络有限公司 | The data processing method and device of electrical form |
CN110245329A (en) * | 2018-03-07 | 2019-09-17 | 珠海金山办公软件有限公司 | Text managemant method, apparatus, electronic equipment and computer readable storage medium |
CN108959225A (en) * | 2018-06-22 | 2018-12-07 | 上海麦健信息技术有限公司 | A kind of clinical research list generation method and device |
CN113168497A (en) * | 2018-12-11 | 2021-07-23 | 决策场景私人有限公司 | Improved electronic form and method for updating electronic form |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106776508A (en) | A kind of electronic spreadsheet generation method and device | |
US11520978B2 (en) | Form customization method and device | |
CN106776509A (en) | A kind of electronic spreadsheet generation method and device | |
CN108228183B (en) | Front-end interface code generation method and device, electronic equipment and storage medium | |
CN110362307A (en) | Forms pages configuration method and server | |
CN107229756A (en) | A kind of design method and system directly perceived for showing business connection collection of illustrative plates | |
CN102843484B (en) | Image processing apparatus and image processing method | |
CN108573279A (en) | Image labeling method and terminal device | |
CN108415978A (en) | User tag storage method, user's portrait computational methods and computing device | |
CN105843945A (en) | Report generation method and system | |
CN108255489A (en) | Front-end interface code generating method, device, electronic equipment and storage medium | |
CN102722899B (en) | Positioning printing system for report | |
CN103518195B (en) | Equipment, system and method for form field document based on vector | |
CN107992304A (en) | A kind of method and apparatus for generating display interface | |
CN112232047A (en) | Method, system, equipment and medium for multi-dimensional data acquisition and automatic summarization | |
CN104999813B (en) | Control method, control device and the printing device of printing device | |
CN108280051A (en) | Detection method, device and the equipment of error character in a kind of text data | |
CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
CN113255302A (en) | Method for operating tissue architecture diagram, computer device and computer storage medium | |
CN109254760A (en) | A kind of method of picture scaling | |
CN106250110A (en) | Set up the method and device of model | |
CN101714134A (en) | Modifying processing method and device for electronic medical records | |
CN113077147B (en) | Intelligent student course pushing method and system and terminal equipment | |
CN102222109B (en) | Data processing device and method | |
CN108241518A (en) | It is visual to pull layout and intelligent template generation method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WW01 | Invention patent application withdrawn after publication | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20170531 |