CN109657218A - The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device - Google Patents
The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device Download PDFInfo
- Publication number
- CN109657218A CN109657218A CN201811393308.1A CN201811393308A CN109657218A CN 109657218 A CN109657218 A CN 109657218A CN 201811393308 A CN201811393308 A CN 201811393308A CN 109657218 A CN109657218 A CN 109657218A
- Authority
- CN
- China
- Prior art keywords
- identity
- electronic spreadsheet
- text
- hand
- video
- 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
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000003780 insertion Methods 0.000 claims abstract description 26
- 230000037431 insertion Effects 0.000 claims abstract description 26
- 238000012163 sequencing technique Methods 0.000 claims abstract description 7
- 238000010586 diagram Methods 0.000 claims description 25
- 238000013507 mapping Methods 0.000 claims description 12
- 230000005611 electricity Effects 0.000 claims description 4
- 230000001960 triggered effect Effects 0.000 claims description 2
- 241000406668 Loxodonta cyclotis Species 0.000 claims 1
- 238000004891 communication Methods 0.000 claims 1
- 238000005070 sampling Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- PCTMTFRHKVHKIS-BMFZQQSSSA-N (1s,3r,4e,6e,8e,10e,12e,14e,16e,18s,19r,20r,21s,25r,27r,30r,31r,33s,35r,37s,38r)-3-[(2r,3s,4s,5s,6r)-4-amino-3,5-dihydroxy-6-methyloxan-2-yl]oxy-19,25,27,30,31,33,35,37-octahydroxy-18,20,21-trimethyl-23-oxo-22,39-dioxabicyclo[33.3.1]nonatriaconta-4,6,8,10 Chemical compound C1C=C2C[C@@H](OS(O)(=O)=O)CC[C@]2(C)[C@@H]2[C@@H]1[C@@H]1CC[C@H]([C@H](C)CCCC(C)C)[C@@]1(C)CC2.O[C@H]1[C@@H](N)[C@H](O)[C@@H](C)O[C@H]1O[C@H]1/C=C/C=C/C=C/C=C/C=C/C=C/C=C/[C@H](C)[C@@H](O)[C@@H](C)[C@H](C)OC(=O)C[C@H](O)C[C@H](O)CC[C@@H](O)[C@H](O)C[C@H](O)C[C@](O)(C[C@H](O)[C@H]2C(O)=O)O[C@H]2C1 PCTMTFRHKVHKIS-BMFZQQSSSA-N 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000001684 chronic effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/189—Automatic justification
Abstract
This application discloses the extensive Edition Contains composition methods of a kind of pair of electronic spreadsheet, operating device, which comprises acquisition is inserted into object and is inserted into corresponding first identity of object with described；Whether judge in presently described electronic spreadsheet comprising being inserted into object；All in presently described electronic spreadsheet corresponding second identity of object has been inserted into if so, obtaining；Described be inserted into described in object insertion is inserted into object according to the first preset rules, wherein first preset rules are related to first identity and second identity；Otherwise, the object that is inserted into is inserted directly into the electronic spreadsheet.By the above-mentioned means, the application can carry out auto-sequencing to the insertion object in electronic spreadsheet.
Description
Technical field
This application involves the goal of electronic form technology fields, more particularly to the extensive Edition Contains typesetting of a kind of pair of electronic spreadsheet
Method, operating device.
Background technique
Electronic spreadsheet is becoming the new focus of Software Industry, can be electronics, it is common and be easy to use it is several
Any kind of document.Currently, electronic spreadsheet is widely used in the fields such as E-Government, for example, Report on Network, examination & approval, interior
Portion's office, government affairs information are acquired, are reported and submitted.
Present inventor has found in chronic study procedure, when needing more people to carry out in some field of electronic spreadsheet
When writing comments and sign one's name, and having regulation to the sequence that this is write comments and sign one's name, generally by being manually ranked up, efficiency is lower.
Summary of the invention
The application is mainly solving the technical problems that provide the extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, behaviour
Make device, auto-sequencing can be carried out to the insertion object in electronic spreadsheet.
In order to solve the above technical problems, the technical solution that the application uses is: providing the wide of a kind of pair of electronic spreadsheet
General Edition Contains composition method, which comprises acquisition is inserted into object and is inserted into object corresponding first with described
Identity；Whether judge in presently described electronic spreadsheet comprising being inserted into object；If so, obtaining presently described electronic spreadsheet
It is interior all to be inserted into corresponding second identity of object；It is inserted into described in object insertion according to the first preset rules by described
It is inserted into object, wherein first preset rules are related to first identity and second identity；It is no
Then, the object that is inserted into is inserted directly into the electronic spreadsheet.
Wherein, described that described be inserted into described in object insertion has been inserted into object according to the first preset rules, comprising: to adjust
With the first mapping table, interior first mapping table includes that all second identity and first identity are corresponding
Priority ranking；The object that is inserted into is inserted into the first predeterminated position according to first mapping table, wherein described first is pre-
If position includes an adjacent insertion object, the priority of first identity for being inserted into object is not higher than
Or the priority not less than second identity for being inserted into object described in adjacent；Alternatively, the first default position
It sets and has been inserted into object comprising two adjacent, the priority of first identity for being inserted into object is not higher than wherein
The priority of one adjacent second identity for being inserted into object, and it is adjacent not less than another it is described
It is inserted into the priority of second identity of object.
Wherein, the method also includes: be inserted into described in judgement object first identity and adjacent position pair
Whether the priority for second identity of object that answers be inserted into is identical；If they are the same, then further according to time sequencing
The presently described object that is inserted into is placed in that the adjacent position is corresponding to be inserted into after object；Alternatively, by presently described to be inserted
Enter object and replaces that the adjacent position is corresponding to be inserted into object.
Wherein, it is described be inserted into object or it is described be inserted into object be text, it is picture, video, any in voice,
In, the text is any in keyboard input, hand-written insertion.
Wherein, the object that is inserted into is video/voice, and it includes: to receive the video/language that the acquisition, which is inserted into object,
Sound, and by the video/phonetic storage into memory；It is rendered in the electronic spreadsheet corresponding with the video/voice
Image tagged.
Wherein, the method also includes triggering described image labels, by described image label link to the memory,
Corresponding video/the voice is marked to obtain described image；Video/speech player is called, in the electronic watch single page
Video/the voice is played on face.
Wherein, the object that is inserted into is text, and the text derives from hand-written insertion, and the acquisition is inserted into object packet
It includes: receiving hand-written inserting instruction, and hand-written frame is popped up according to the hand-written inserting instruction, the hand-written block diagram layer is located at the electricity
Below sublist list；Input of the user in the hand-written frame is received, and synchronizes and is shown in the electronic spreadsheet.
Wherein, the text of handwriting input every row height shown in the electronic spreadsheet is fixed；And/or the method
Further include: obtain the first direction of current handwriting input text in the hand-written frame；Judge text currently entered and described the
Whether the distance between edge of the hand-written frame pointed by one direction is less than or equal to threshold value；If so, next input
Text shifts to the next line or next column parallel with the first direction automatically.
Wherein, the electronic spreadsheet includes at least one field, the method also includes: judge presently described be inserted into pair
As whether including the insertion object Chong Die with the field part in the field that is inserted；If so, then described be inserted into pair
The region that object is overlapped with the field has been inserted into as described in avoiding automatically.
In order to solve the above technical problems, another technical solution that the application uses is: a kind of operating device is provided, it is described
Operating device includes: processor, memory, display and telecommunication circuit, and the processor is respectively coupled to the memory, described
Display and the telecommunication circuit, the processor can be realized the step in any of the above-described method as described in the examples when working
Suddenly.
The beneficial effect of the application is: it is in contrast to the prior art, it is provided herein to the wide of electronic spreadsheet
The method of general Edition Contains typesetting include: according to the first identity corresponding with object is inserted into, to be inserted into object corresponding
Second identity and the first preset rules relevant to the first identity and the second identity, will be inserted into object
It has been inserted into object；Method i.e. provided herein can be pre- according to first according to the first identity for being inserted into object
If rule carries out auto-sequencing, the efficiency operated to electronic spreadsheet is improved；
In addition, text, picture, video, voice etc. can be inserted in electronic spreadsheet, text can be keyboard input, can also
To be handwriting input, thus the displaying content of abundant electronic spreadsheet.
Detailed description of the invention
In order to more clearly explain the technical solutions in the embodiments of the present application, make required in being described below to embodiment
Attached drawing is briefly described, it should be apparent that, the drawings in the following description are only some examples of the present application, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.Wherein:
Fig. 1 is flow diagram of the application to extensive one embodiment of Edition Contains composition method of electronic spreadsheet；
Fig. 2 is the structural schematic diagram of the single embodiment of the application electronic watch；
Fig. 3 is to obtain the flow diagram for being inserted into one embodiment of object in Fig. 1 in step S101；
Fig. 4 is the structural schematic diagram of the single embodiment of the application electronic watch；
Fig. 5 is to obtain the flow diagram for being inserted into one embodiment of object in Fig. 1 in step S101；
Fig. 6 is flow diagram of the application to extensive another embodiment of Edition Contains composition method of electronic spreadsheet；
Fig. 7 is the flow diagram of mono- embodiment of step S104 in Fig. 1；
Fig. 8 is the structural schematic diagram of another embodiment of the application electronic spreadsheet；
Fig. 9 is the structural schematic diagram of another embodiment of the application electronic spreadsheet；
Figure 10 is flow diagram of the application to extensive one embodiment of Edition Contains composition method of electronic spreadsheet；
Figure 11 is the structural schematic diagram of one embodiment of the application operating device；
Figure 12 is the structural schematic diagram for one embodiment of device that the application has store function.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, rather than whole embodiments.Based on this
Embodiment in application, those of ordinary skill in the art are obtained every other under the premise of not making creative labor
Embodiment shall fall in the protection scope of this application.
Referring to Fig. 1, Fig. 1 is process of the application to extensive one embodiment of Edition Contains composition method of electronic spreadsheet
Schematic diagram, this method comprises:
S101: acquisition is inserted into object and the first identity corresponding with object is inserted into.
Specifically, in an application scenarios, the first identity can be the identity ID of operator, for example, surname
Name, code name, department etc..The acquisition modes of identity ID can be believed by the equipment of the identity ID of the operator of binding
Breath etc. obtains；For example, cell-phone number of available current phone etc. can be marked uniquely when operator is operated using mobile phone
The information for knowing the identity ID of operator, can be obtained the identity ID of unique operator according to the cell-phone number etc..
In another application scenarios, the signified object that is inserted into can be text, picture, video, voice in the application
In it is any, wherein text from keyboard input, it is any in hand-written insertion.
For example, please referring to Fig. 2-Fig. 3 when being inserted into object is video or voice, Fig. 2 is that the application electronic watch is single
The structural schematic diagram of embodiment, Fig. 3 are to obtain the process signal for being inserted into one embodiment of object in Fig. 1 in step S101
Figure.It is obtained in above-mentioned steps S101 and is inserted into object and includes:
S201: video/voice data is received, and video/voice data is stored in memory.
Specifically, which, which can be, is recording, or prerecords completion.
S202: image tagged corresponding with video/voice data is rendered in electronic spreadsheet.
Specifically, as shown in Fig. 2, the corresponding image tagged of video data can be the wherein a certain frame of the video data,
It is also possible to other artificial defined image taggeds (for example, commonly playing icon etc.) for representing video data.Voice data
Corresponding image tagged can be it is artificial as defined in represent the image tagged of voice data (for example, ripple glaze shown in Fig. 2
Deng).
When user needs to know the particular content of the video/voice data, method provided herein further include: touching
Image tagged is sent out, memory is linked to by image tagged, to obtain the corresponding video/voice data of image tagged；Calling video/
Speech player, to play video/voice on the electronic spreadsheet page.For example, can additionally pop up one in electronic spreadsheet
Video/speech player plays, which can be with covering part electronic spreadsheet；In another example can also be just in electricity
It is directly played at the image tagged rendered in sublist list, i.e., there is no additional pop-up on the electronic spreadsheet page.
In another example being text when being inserted into object, text derives from hand-written insertion, please refers to Fig. 4-Fig. 5, and Fig. 4 is this Shen
Please the single embodiment of electronic watch structural schematic diagram, Fig. 5 is to obtain in step S101 to be inserted into one embodiment of object in Fig. 1
Flow diagram.It is obtained in above-mentioned steps S101 and is inserted into object and includes:
S301: hand-written inserting instruction is received, and hand-written frame 30 is popped up according to hand-written inserting instruction, hand-written 30 figure layer of frame is located at
32 lower section of electronic spreadsheet.
Specifically, in the present embodiment, hand-written 30 figure layer of frame can part overlay electronic list 32, but do not cover the electronics
List 32 is in requisition for the place for showing the handwriting input text, for example, region of " envisioning opinion " in Fig. 4 is in requisition for displaying
The region of the handwriting input text, hand-written frame 30 do not cover the region.
S302: input of the user in hand-written frame 30 is received, and synchronizes and is shown in electronic spreadsheet 32.
Specifically, in the present embodiment, the method that the text of handwriting input is detected in hand-written frame 30 can be in the prior art
It is any, continuous sampling is carried out for example, can identify the handwriting, and detect that corresponding sampling point position information and practical pen are wide；It will be every
Former point is as Sampling starting point in two neighbouring sample points, and latter point is as sampling terminal, and two o'clock line is as point-to-point transmission stroke
Center line, obtain on center line that the location information of each point and corresponding longitudinal pen are wide, believed according to the position of each point on center line
Cease the gray value of the filling of each pixel in the wide determining stroke of longitudinal pen corresponding with each point on center line；According to patterned grays value
Corresponding pixel is filled and is shown.
In addition, being shown to the aesthetic measure in electronic spreadsheet to increase the handwriting input, method provided herein is also
It include: the format for presetting the text of handwriting input, for example, the text of handwriting input every row shown in electronic spreadsheet is high
Degree is fixed, in another example, text background color shown in electronic spreadsheet of handwriting input etc..
In addition, method provided herein can also realize automatic line feed during handwriting input, for example, such as Fig. 6
Shown, Fig. 6 is flow diagram of the application to extensive another embodiment of Edition Contains composition method of electronic spreadsheet, the party
Method further include:
S401: the first direction of current handwriting input text in hand-written frame 30 is obtained.
Specifically, which can be determined by the line direction for currently inputting text and previously input text.Example
Such as, as shown in frame 30 hand-written in Fig. 4, currently input that text is " meaning ", previously input text is " same ", the two in hand-written frame 30
Line direction it is as shown by the arrows in Figure 4, direction shown in the arrow is first direction；Certainly, in other embodiments, first
Direction may be other, for example, first direction is also possible to the direction etc. vertical with the arrow direction.
S402: judge whether text currently entered and the distance between edge of hand-written frame pointed by first direction are small
In equal to threshold value.
Specifically, as shown in Figure 4, the edge 300 for the hand-written frame 30 that first direction is directed toward at this time.Text currently entered
The distance between " meaning " and the edge 300 are d.Threshold value can be taking human as presetting, for example, threshold value can be fixed as a certain number
Value.Alternatively, threshold value can also be determined according to the practical situation of writing of user, it is for instance possible to obtain owning on the first direction
The mean breadth for the text write, threshold value can be mean breadth.
S403: if so, the text of next input shifts to the next line or next column parallel with first direction automatically.
Specifically, as shown in Figure 4, when first direction is direction shown in the arrow, the text of next input can be with
Automatically switch to the next line parallel with the first direction；Alternatively, when first direction is the direction vertical with arrow direction in Fig. 4
When, the text of next input can automatically switch to the next column parallel with first direction.
S404: otherwise, continuation is write in a first direction.
In another example any in the prior art insert can be used when being inserted into object is the text that picture or keyboard input
Enter mode, the application is not construed as limiting this.In addition, in the present embodiment, when needing to check the picture of insertion, this can be triggered
Picture calls Photo Viewer, to check the picture on the electronic spreadsheet page.
S102: whether judge in Current electronic list comprising being inserted into object.
Specifically, being inserted into object can be text, picture, video, any in voice, wherein text derives from key
It is any in disk input, hand-written insertion.Can by checking in Current electronic list whether there is satisfactory picture, text,
Voice, video etc., whether to judge in Current electronic list comprising being inserted into object.
S103: if so, all in acquisition Current electronic list be inserted into corresponding second identity of object.
It specifically, can be according to the letter such as the signature that electronic spreadsheet is included or other links in an application scenarios
Breath all has been inserted into corresponding second identity of object to obtain.Second identity can be the identity of operator
ID, for example, name, code name, department etc..
S104: object will be inserted into according to the first preset rules and be inserted into object, wherein the first preset rules with
First identity is related to the second identity.
Specifically, referring to Fig. 7, Fig. 7 is the flow diagram of mono- embodiment of step S104 in Fig. 1.Above-mentioned steps
S104 is specifically included:
S501: calling the first mapping table, includes all second identity and the first identity pair in the first mapping table
The priority ranking answered.
Specifically, the first mapping table can be artificial in advance provide and storage；Certainly, the first mapping table can also be from electricity
It is obtained in sublist list, for example, being previously provided with multiple grasped in electronic spreadsheet shown in Fig. 2 referring to Fig. 2
The sequence of the operator of work, processor can be directly using the sequences as the first mapping table.
S502: object will be inserted into according to the first mapping table and be inserted into the first predeterminated position.
Specifically, in an application scenarios, the first predeterminated position can be initial position or end in electronic spreadsheet
Tail position, the first predeterminated position only include an adjacent insertion object, are inserted into the preferential of the first identity of object
Grade be not higher than or not less than adjacent the second identity for being inserted into object priority.
For example, being inserted into corresponding second identity of object is respectively A, B, C, and object has been inserted into according to first
Preset rules are ranked up, and wherein the priority of A, B, C can be A >=B >=C.Currently it is inserted into corresponding first identity of object
The priority for identifying D is less than C, then being inserted into the sequence after object insertion according to the first preset rules is ABCD.
In another application scenarios, the first predeterminated position can be the middle position that object has been inserted into electronic spreadsheet,
First predeterminated position has been inserted into object comprising two adjacent, is inserted into the priority of the first identity of object not higher than it
In adjacent second identity for being inserted into object priority, and be inserted into object adjacent not less than another
The priority of second identity.
For example, being inserted into corresponding second identity of object is respectively as follows: A, B, C, and object has been inserted into according to
One preset rules are ranked up, and wherein the priority of A, B, C can be A >=B >=C.Currently it is inserted into corresponding first body of object
The priority of part mark D is less than B and is greater than C, then being inserted into the sequence after object insertion according to the first preset rules is ABDC.
In another application scenarios, it is possible that the user of the same priority inputs multiple feelings for being inserted into object
Condition, at this point, method provided herein further include:
S503: judgement is inserted into the first identity the second identity for being inserted into object corresponding with adjacent position of object
Whether the priority of mark is identical.
Specifically, being inserted into object includes that an adjacent position or two adjacent positions, this step need to judge all phases
It sets at ortho position.
S504: if they are the same, then further according to time sequencing being currently inserted into object, to be placed in adjacent position corresponding
It is inserted into after object；Alternatively, currently object, which will be inserted into, replaces that adjacent position is corresponding to be inserted into object.
Specifically, in an application scenarios, referring to Fig. 8, Fig. 8 is the knot of another embodiment of the application electronic spreadsheet
Structure schematic diagram.If be currently inserted into object with it is adjacent to be inserted into the first identity of object identical, sequentially in time
It is ranked up, and non-placed side by side.As shown in dotted line frame in Fig. 8, in the dotted line frame comprising two identity be " C "
Signature, this two signatures carry out non-placed side by side sequentially in time.
In another application scenarios, the object of insertion of original adjacent position can also directly be replaced.
S105: otherwise, object will be inserted into and be inserted directly into electronic spreadsheet.
Specifically, in an application scenarios, it has been inserted into object if not including in electronic spreadsheet, can will be inserted into pair
As insertion electronic spreadsheet in any position, any position can be a certain column in the electronic spreadsheet initial position,
Middle position, end position etc..
Under normal conditions, more than one field is usually contained in electronic spreadsheet, method provided by above-described embodiment is applicable in
Any field in electronic spreadsheet.
In addition, in the present embodiment, the object that is inserted into provided herein also supports full frame handwriting input etc., i.e., to be inserted
It, can be across at least column in electronic spreadsheet after entering object insertion electronic spreadsheet.As shown in Fig. 9-Figure 10, Fig. 9 is this Shen
Please an electronic watch separately and exclusively embodiment structural schematic diagram, Figure 10 is extensive Edition Contains typesetting side of the application to electronic spreadsheet
The flow diagram of one embodiment of method.Method provided herein further include:
S601: whether judgement is currently inserted into the field that object is inserted comprising the insertion Chong Die with field part
Object.
Specifically, hand-written " same " word as shown in Figure 9 spans " office's opinion " and " finance or capital construction is responsible for
People's will is shown in " two fields.
S602: it avoids being inserted into the region that object is overlapped with field automatically if so, being then inserted into object.
Specifically, as shown in figure 9, if at this time object need to be inserted into " finance or capital construction responsible person opinion " column increase,
Then this is inserted into object and avoids the region that the column is covered Bei " same " word automatically.
Figure 11 is please referred to, Figure 11 is the structural schematic diagram of one embodiment of the application operating device, the operating device 1 packet
Include: processor 10, memory 12, display 14 and telecommunication circuit 16, processor 10 are respectively coupled to memory 12,14 and of display
Telecommunication circuit 16, processor 10 can be realized the step in method provided by any of the above-described embodiment when working.In this implementation
In example, which can be computer, mobile phone, plate etc..
Figure 12 is please referred to, Figure 12 is the structural schematic diagram for one embodiment of device that the application has store function, this is deposited
Program data 20 is stored on storage device 2, program data 20 can be executed by processor to realize that any of the above-described embodiment is mentioned
Step in the method for confession.The storage device 2 can be USB flash disk, mobile hard disk, CD etc..
To sum up, being in contrast to the prior art, the extensive Edition Contains provided herein to electronic spreadsheet
The method of typesetting includes: according to the first identity corresponding with object is inserted into, has been inserted into the corresponding second identity mark of object
Knowledge and the first preset rules relevant to the first identity and the second identity, will be inserted into object and have been inserted into
In object；Method i.e. provided herein can be carried out according to the first identity for being inserted into object according to the first preset rules
Auto-sequencing improves the efficiency operated to electronic spreadsheet；In addition, text, picture, view can be inserted in electronic spreadsheet
Frequently, voice etc., text can be keyboard input, be also possible to handwriting input, thus the displaying content of abundant electronic spreadsheet.
The foregoing is merely presently filed embodiments, are not intended to limit the scope of the patents of the application, all to utilize this
Equivalent structure or equivalent flow shift made by application specification and accompanying drawing content, it is relevant to be applied directly or indirectly in other
Technical field similarly includes in the scope of patent protection of the application.
Claims (10)
1. the extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, which is characterized in that the described method includes:
Acquisition is inserted into object and is inserted into corresponding first identity of object with described；
Whether judge in presently described electronic spreadsheet comprising being inserted into object；
All in presently described electronic spreadsheet corresponding second identity of object has been inserted into if so, obtaining；
Described be inserted into described in object insertion is inserted into object according to the first preset rules, wherein the described first default rule
It is then related to first identity and second identity；
Otherwise, the object that is inserted into is inserted directly into the electronic spreadsheet.
2. the method according to claim 1, wherein described be inserted into object for described according to the first preset rules
Insertion is described to be inserted into object, comprising:
The first mapping table is called, includes all second identity and first identity in first mapping table
Corresponding priority ranking；
The object that is inserted into is inserted into the first predeterminated position according to first mapping table, wherein first predeterminated position
Comprising an adjacent insertion object, the priority of first identity for being inserted into object is not higher than or not
Lower than the priority for second identity for being inserted into object described in adjacent；Alternatively, first predeterminated position includes
Two adjacent to be inserted into object, the priority of first identity for being inserted into object is not higher than one of phase
The priority of adjacent second identity for being inserted into object, and adjacent not less than another described be inserted into pair
The priority of second identity of elephant.
3. according to the method described in claim 2, it is characterized in that, the method also includes:
First identity that object is inserted into described in judgement corresponding with adjacent position has been inserted into described the second of object
Whether the priority of identity is identical；
If they are the same, then the presently described object that is inserted into further is placed in that the adjacent position is corresponding to have inserted according to time sequencing
After entering object；Alternatively, the presently described object that is inserted into is replaced that the adjacent position is corresponding to be inserted into object.
4. the method according to claim 1, wherein the object or the object that has been inserted into of being inserted into is text
It is word, picture, video, any in voice, wherein the text is any in keyboard input, hand-written insertion.
5. according to the method described in claim 4, it is characterized in that, it is described be inserted into object be video/voice, it is described obtain to
Being inserted into object includes:
Video/the voice is received, and by the video/phonetic storage into memory；
Image tagged corresponding with the video/voice is rendered in the electronic spreadsheet.
6. according to the method described in claim 5, it is characterized in that, the method also includes:
Described image label is triggered, it is corresponding to obtain described image label by described image label link to the memory
Video/the voice；
Video/speech player is called, to play the video/voice on the electronic spreadsheet page.
7. according to the method described in claim 4, the text derives from it is characterized in that, the object that is inserted into is text
Hand-written insertion, the acquisition are inserted into object and include:
Hand-written inserting instruction is received, and hand-written frame is popped up according to the hand-written inserting instruction, the hand-written block diagram layer is located at described
Below electronic spreadsheet；
Input of the user in the hand-written frame is received, and synchronizes and is shown in the electronic spreadsheet.
8. the method according to the description of claim 7 is characterized in that
The text of handwriting input every row height shown in the electronic spreadsheet is fixed；And/or the method also includes:
Obtain the first direction of current handwriting input text in the hand-written frame；
Judge whether text currently entered and the distance between edge of the hand-written frame pointed by the first direction are small
In equal to threshold value；
If so, the text of next input shifts to the next line or next column parallel with the first direction automatically.
9. according to the method described in claim 4, it is characterized in that, the electronic spreadsheet includes at least one field, the side
Method further include:
Judge presently described whether be inserted into the field that object is inserted comprising the insertion Chong Die with the field part
Object；
If so, then the object that is inserted into is avoided described being inserted into the region that object is overlapped with the field automatically.
10. a kind of operating device, which is characterized in that the operating device includes: processor, memory, display and communication electricity
Road, the processor are respectively coupled to the memory, the display and the telecommunication circuit, and the processor can when working
Realize the step in the described in any item methods of claim 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811393308.1A CN109657218A (en) | 2018-11-21 | 2018-11-21 | The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811393308.1A CN109657218A (en) | 2018-11-21 | 2018-11-21 | The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109657218A true CN109657218A (en) | 2019-04-19 |
Family
ID=66112360
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811393308.1A Pending CN109657218A (en) | 2018-11-21 | 2018-11-21 | The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109657218A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105469249A (en) * | 2015-11-19 | 2016-04-06 | 歌尔声学股份有限公司 | Form endorsement method based on role selection and form endorsement system |
| CN105913224A (en) * | 2016-04-08 | 2016-08-31 | 江苏中威科技软件系统有限公司 | Opinion signing method and system |
| CN108540758A (en) * | 2017-03-01 | 2018-09-14 | 中国电信股份有限公司 | The processing method and system of image data |
-
2018
- 2018-11-21 CN CN201811393308.1A patent/CN109657218A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105469249A (en) * | 2015-11-19 | 2016-04-06 | 歌尔声学股份有限公司 | Form endorsement method based on role selection and form endorsement system |
| CN105913224A (en) * | 2016-04-08 | 2016-08-31 | 江苏中威科技软件系统有限公司 | Opinion signing method and system |
| CN108540758A (en) * | 2017-03-01 | 2018-09-14 | 中国电信股份有限公司 | The processing method and system of image data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP5563190B2 (en) | Modular computer-aided language learning method and system | |
| EP2369567A2 (en) | Information processing apparatus and information processing program | |
| US9659547B2 (en) | Method and device for displaying images and text in accordance with a selected pattern | |
| CN1530815A (en) | Device and method for simplified keyboard input | |
| DE112007000122T5 (en) | Keyboards for portable electronic devices | |
| EP2642468A1 (en) | Learning support device, learning support method and storage medium in which learning support program is stored | |
| CN110287465B (en) | Text processing method, device, equipment and storage medium | |
| US7292986B1 (en) | Method and apparatus for displaying speech recognition progress | |
| CN109446506B (en) | Automatic reconstruction method and device for electronic form table | |
| CN111159975B (en) | Display method and device | |
| JP2015036788A (en) | Pronunciation learning device for foreign language | |
| CN109783184B (en) | User's customizing form generation method | |
| KR20090120442A (en) | Chinese input system and method | |
| CN109657218A (en) | The extensive Edition Contains composition method of a kind of pair of electronic spreadsheet, operating device | |
| CN106648367A (en) | Clicking and reading method and clicking and reading device | |
| CN113986018B (en) | Vision impairment auxiliary reading and learning method and system based on intelligent glasses and storage medium | |
| US20210073458A1 (en) | Comic data display system, method, and program | |
| CN115048949A (en) | Multilingual text replacement method, system, equipment and medium based on term base | |
| CN111787127A (en) | Classroom information transmission method and classroom information transmission system | |
| JP4951472B2 (en) | Electronic document creation system | |
| CN110046336A (en) | Position encoded sheet disposal method and system | |
| CN103677487B (en) | Information processing method and the information processor using the method | |
| JP2019200233A (en) | Lesson support system, information processing device, lesson support method, and program | |
| CN111046863B (en) | Data processing method, device, equipment and computer readable storage medium | |
| KR100810331B1 (en) | Method for searching telephone numbers in a mobile communication terminal equipment |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190419 |