CN112528611A - Method and device for editing table, computer storage medium and terminal - Google Patents
Method and device for editing table, computer storage medium and terminal Download PDFInfo
- Publication number
- CN112528611A CN112528611A CN201910796474.4A CN201910796474A CN112528611A CN 112528611 A CN112528611 A CN 112528611A CN 201910796474 A CN201910796474 A CN 201910796474A CN 112528611 A CN112528611 A CN 112528611A
- Authority
- CN
- China
- Prior art keywords
- blank
- data
- cells
- determining
- cell
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/543—User-generated data transfer, e.g. clipboards, dynamic data exchange [DDE], object linking and embedding [OLE]
Abstract
A method, a device, a computer storage medium and a terminal for editing a table comprise: determining the position information of a blank cell aiming at the selected cell for data pasting; and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells. According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; the repeated copying of discontinuous tables due to discontinuous blank cells is not needed, the table editing operation of a user is simplified, and editing errors caused by repeated copying are avoided.
Description
Technical Field
The present disclosure relates to, but not limited to, office application technologies, and more particularly, to a method, an apparatus, a computer storage medium, and a terminal for editing a table.
Background
Tables are commonly used carriers for recording data. For example: table 1 records computer configuration information of different users, including Central Processing Unit (CPU) model, CPU master frequency (unit: gigahertz (GHz)), memory size (unit: giga (G)), hard disk size (unit: G), and display size (inch) giga operating system.
| Name (I) | CPU model | CPU dominant frequency (GHz) | Memory size (G) | Hard disk size (G) | Display size (inch) | Operating system |
| Zhang three | I5 | 1.6 | 16 | 250 | 17 | WIN7 |
| Li Si | I7 | 1.6 | 32 | 250 | 17 | WIN7 |
| Wangwu tea |
TABLE 1
Copying and pasting are an important mode for improving the table editing efficiency; for example: if the computer information of the king five is the same as that of the Zhang III, the cell corresponding to the row of the king five can be selected by copying the computer information of the Zhang III, and then the row data of the king five is written in by pasting operation to obtain a table 2;
| name (I) | CPU model | CPU dominant frequency (GHz) | Memory size (G) | Hard disk size (G) | Display size (inch) | Operating system |
| Zhang three | I5 | 1.6 | 16 | 250 | 17 | WIN7 |
| Li Si | I7 | 1.6 | 32 | 250 | 17 | WIN7 |
| Wangwu tea | I5 | 1.6 | 16 | 250 | 17 | WIN7 |
TABLE 2
| Name (I) | CPU model | CPU dominant frequency (GHz) | Memory size (G) | Hard disk size (G) | Display size (inch) | Operating system |
| Zhang three | I7 | |||||
| Li Si | 1.8 | Win10 | ||||
| Wangwu tea | 16 | 24 |
TABLE 3
| CPU model | CPU dominant frequency (GHz) | Memory size (G) | Hard disk size (G) | Display size (inch) | Operating system |
| I5 | 1.6 | 16 | 250 | 17 | WIN7 |
TABLE 4
In the related technology, for the cell selected by the pasting operation in the copying and pasting process, whether the selected cell has the recorded data or not is always covered by the copied data in the clipboard; and in the copying and pasting process, the data of the cell selected by the pasting operation cannot be reserved. Assuming that a new batch of computers needs to be purchased for the users in table 1, when the configuration information of purchased computers is recorded in the previous period, only the special configuration requirements of each user on the computers are recorded with reference to table 3, and the standard configuration information of table 4 is used for recording the configuration items which are not recorded. Assuming that the blank part of table 3 is to be supplemented completely according to table 4, according to the related art, data in consecutive cells or independent cell data needs to be recorded into table 3 by copying and pasting for a plurality of times. Whether continuous cells or independent cells are copied, the continuous cells or the independent cells can be copied and edited for many times by a user; when the continuous cells are not uniformly distributed and the number of data columns to be recorded is large, the workload of copying and pasting is greatly increased, and the probability of error is synchronously increased along with the workload of copying and pasting because the manual operation of office staff is needed.
Disclosure of Invention
The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.
Embodiments of the present invention provide a method and an apparatus for editing a table, a computer storage medium, and a terminal, which can simplify table copying and editing operations and improve table editing efficiency.
The embodiment of the invention provides a method for editing a table, which comprises the following steps:
determining the position information of a blank cell aiming at the selected cell for data pasting;
and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
In an exemplary embodiment, the determining the location information of the blank cell includes:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
In an exemplary embodiment, before determining the location information of the blank cell, the method further comprises:
and when the trigger instruction is received, triggering and executing the processing of determining the position information of the blank cells.
In an exemplary embodiment, before writing the data to be pasted to the blank cell in the clipboard into the blank cell, the method further comprises:
and determining one or more cells with written data in the selected cells for data pasting as blank cells according to the received selection instruction.
In another aspect, an embodiment of the present invention provides an apparatus for editing a table, including: a determination unit and a writing unit; wherein the content of the first and second substances,
the determination unit is used for: determining the position information of a blank cell aiming at the selected cell for data pasting;
the write unit is used for: and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
In an exemplary embodiment, the determining unit is specifically configured to:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
In an exemplary embodiment, the apparatus further includes a triggering unit configured to:
and when the trigger instruction is received, the trigger determining unit executes the processing of determining the position information of the blank cells.
In an exemplary embodiment, the determining unit is further configured to: and determining one or more cells with written data in the selected cells for data pasting as blank cells according to the received selection instruction.
In another aspect, an embodiment of the present invention further provides a computer storage medium, where computer-executable instructions are stored in the computer storage medium, and the computer-executable instructions are used to execute the above method for editing a table.
In another aspect, an embodiment of the present invention further provides a terminal, including: a memory and a processor; wherein the content of the first and second substances,
the processor is configured to execute program instructions in the memory;
the program instructions read and execute the method for editing the table on the processor.
Compared with the related art, the technical scheme of the application comprises the following steps: determining the position information of a blank cell aiming at the selected cell for data pasting; and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells. According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; the repeated copying of discontinuous tables due to discontinuous blank cells is not needed, the table editing operation of a user is simplified, and editing errors caused by repeated copying are avoided.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the example serve to explain the principles of the invention and not to limit the invention.
FIG. 1 is a flow chart of a method of editing a table according to an embodiment of the present invention;
fig. 2 is a block diagram of an apparatus for editing a table according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
Fig. 1 is a flowchart of a method for editing a table according to an embodiment of the present invention, as shown in fig. 1, including:
in an exemplary embodiment, the determining the location information of the blank cell includes:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
It should be noted that the blank cells can be determined by whether the cells contain data characters; the data characters can be determined analytically by means of a relevant text analysis method.
And 102, writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
It should be noted that, according to the position information of the blank cells, the embodiment of the present invention may determine the data to be pasted to the blank cells in the clipboard according to the correlation principle; that is, after the position information of the blank cells is determined, which data in the clipboard is to be pasted to the blank cells at what positions can be determined according to the relevant principle. Combining the existing copying and pasting process in the related technology, after the related technology copies data, recording the data to be pasted in sequence in a shear plate, when the data in the shear plate contains a plurality of rows (or a plurality of columns) of data, recording through a line feed (or a column feed) identifier, when the data is pasted, determining a starting cell for data pasting according to the related technology, writing the data in the shear plate into the corresponding row (or column) cell in sequence, and when the line feed (or the column feed) identifier is identified, selecting the next row (or the next column) cell aligned with the starting cell to continue data writing; after the position of the blank cell is determined, the data to be pasted to the blank cell in the clipboard is written into the blank cell. The blank cells in the embodiment of the invention can be confirmed in the process of writing the data in the clipboard into the cells in sequence.
According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; when the data is copied, the data does not need to be copied for multiple times because the blank cells are discontinuous, the table editing operation of a user is simplified, and editing errors caused by multiple copies are avoided.
In an exemplary embodiment, before determining the location information of the blank cell in step 101, the method in the embodiment of the present invention further includes:
and when the trigger instruction is received, triggering and executing the processing of determining the position information of the blank cells.
In an exemplary embodiment, the triggering instruction of the embodiment of the present invention may be generated by a preset shortcut key, a menu bar, a combination key, and the like.
In an exemplary embodiment, before writing the data to be pasted to the blank cell in the clipboard into the blank cell, the method in the embodiment of the present invention further includes:
and determining one or more cells with written data in the selected cells for data pasting as blank cells according to the received selection instruction.
Compared with the related art, the technical scheme of the application comprises the following steps: determining the position information of a blank cell aiming at the selected cell for data pasting; and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells. According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; the repeated copying of discontinuous tables due to discontinuous blank cells is not needed, the table editing operation of a user is simplified, and editing errors caused by repeated copying are avoided.
Fig. 2 is a block diagram of an apparatus for editing a table according to an embodiment of the present invention, as shown in fig. 2, including: a determination unit and a writing unit; wherein the content of the first and second substances,
the determination unit is used for: determining the position information of a blank cell aiming at the selected cell for data pasting;
in an exemplary embodiment, the determining unit is specifically configured to:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
It should be noted that the blank cells can be determined by whether the cells contain data characters; the data characters can be determined analytically by means of a relevant text analysis method. In addition, according to the position information of the blank cells, the data to be pasted to the blank cells in the clipboard can be determined according to the relevant principle; that is, after the position information of the blank cells is determined, which data in the clipboard is to be pasted to the blank cells at what positions can be determined according to the relevant principle.
The write unit is used for: and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
It should be noted that, according to the position information of the blank cells, the embodiment of the present invention may determine the data to be pasted to the blank cells in the clipboard according to the correlation principle; that is, after the position information of the blank cells is determined, which data in the clipboard is to be pasted to the blank cells at what positions can be determined according to the relevant principle.
According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; when the data is copied, the data does not need to be copied for multiple times because the blank cells are discontinuous, the table editing operation of a user is simplified, and editing errors caused by multiple copies are avoided.
In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a trigger unit, configured to:
and when the trigger instruction is received, the trigger determining unit executes the processing of determining the position information of the blank cells.
In an exemplary embodiment, the triggering instruction of the embodiment of the present invention may be generated by a preset shortcut key, a menu bar, a combination key, and the like.
In an exemplary embodiment, the determining unit is further configured to: and determining one or more cells with written data in the selected cells for data pasting as blank cells according to the received selection instruction.
According to the embodiment of the invention, only the blank cells are subjected to data pasting, so that the existing data cannot be covered; the repeated copying of discontinuous tables due to discontinuous blank cells is not needed, the table editing operation of a user is simplified, and editing errors caused by repeated copying are avoided.
The embodiment of the invention also provides a computer storage medium, wherein the computer storage medium stores computer executable instructions, and the computer executable instructions are used for executing the table editing method.
An embodiment of the present invention further provides a terminal, including: a memory and a processor; wherein the content of the first and second substances,
the processor is configured to execute program instructions in the memory;
the program instructions read and execute the method for editing the table on the processor.
"one of ordinary skill in the art will appreciate that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art. "
Claims (10)
1. A method of editing a table, comprising:
determining the position information of a blank cell aiming at the selected cell for data pasting;
and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
2. The method of claim 1, wherein the determining location information for a blank cell comprises:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
3. The method of claim 1 or 2, wherein prior to determining the location information of the blank cell, the method further comprises:
and when the trigger instruction is received, triggering and executing the processing of determining the position information of the blank cells.
4. The method according to claim 1 or 2, wherein before writing the data to be pasted to the blank cell in the clipboard into the blank cell, the method further comprises:
and determining one or more cells with written data in the selected cells for data pasting as the blank cells according to the received selection instruction.
5. An apparatus for editing a form, comprising: a determination unit and a writing unit; wherein the content of the first and second substances,
the determination unit is used for: determining the position information of a blank cell aiming at the selected cell for data pasting;
the write unit is used for: and writing the data to be pasted to the blank cells in the clipboard into the blank cells according to the determined position information of the blank cells.
6. The apparatus according to claim 5, wherein the determining unit is specifically configured to:
identifying the blank cell;
and determining the row and the column of each identified blank cell.
7. The apparatus according to claim 5 or 6, further comprising a triggering unit for:
and when the trigger instruction is received, the trigger determining unit executes the processing of the position information of the blank cells.
8. The apparatus of claim 5 or 6,
the determination unit is further configured to: and determining one or more cells with written data in the selected cells for data pasting as blank cells according to the received selection instruction.
9. A computer storage medium having stored therein computer-executable instructions for performing the method of editing a table of any one of claims 1-4.
10. A terminal, comprising: a memory and a processor; wherein the content of the first and second substances,
the processor is configured to execute program instructions in the memory;
program instructions for reading and executing on a processor a method for editing a form as claimed in any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910796474.4A CN112528611A (en) | 2019-08-27 | 2019-08-27 | Method and device for editing table, computer storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910796474.4A CN112528611A (en) | 2019-08-27 | 2019-08-27 | Method and device for editing table, computer storage medium and terminal |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112528611A true CN112528611A (en) | 2021-03-19 |
Family
ID=74973955
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910796474.4A Pending CN112528611A (en) | 2019-08-27 | 2019-08-27 | Method and device for editing table, computer storage medium and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112528611A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1571013A (en) * | 2003-02-13 | 2005-01-26 | 微软公司 | Method and device for predicting word error rate from text |
| CN102331984A (en) * | 2011-06-28 | 2012-01-25 | 用友软件股份有限公司 | Lower table header generating device and lower table header generating method |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
| CN107943770A (en) * | 2017-11-13 | 2018-04-20 | 深圳开思时代科技有限公司 | Web page form speed input method and device based on spare and accessory parts transaction platform |
-
2019
- 2019-08-27 CN CN201910796474.4A patent/CN112528611A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1571013A (en) * | 2003-02-13 | 2005-01-26 | 微软公司 | Method and device for predicting word error rate from text |
| CN102331984A (en) * | 2011-06-28 | 2012-01-25 | 用友软件股份有限公司 | Lower table header generating device and lower table header generating method |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
| CN107943770A (en) * | 2017-11-13 | 2018-04-20 | 深圳开思时代科技有限公司 | Web page form speed input method and device based on spare and accessory parts transaction platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11934371B2 (en) | Data processing method and apparatus, and computer-readable storage medium | |
| EP3522042A1 (en) | Method and apparatus for information processing, server and computer readable medium | |
| CN104636266B (en) | Cover tile magnetic recording hard disk, cover tile magnetic recording hard disk write method and the device of data | |
| US7631158B2 (en) | Disk snapshot method using a copy-on-write table in a user space | |
| CN107291399B (en) | Back-end storage method, device and system based on SPDK | |
| CN108459824B (en) | Data modification and rewriting method and device | |
| CN107506145B (en) | Physical storage scheduling method and cloud host creation method | |
| CN104461390A (en) | Method and device for writing data into imbricate magnetic recording SMR hard disk | |
| CN111309687A (en) | Object storage small file processing method, device, equipment and storage medium | |
| US20190012325A1 (en) | Method and Apparatus for Presenting To-Be-Cleaned Data, and Electronic Device | |
| CN107391544B (en) | Processing method, device and equipment of column type storage data and computer storage medium | |
| US9087014B1 (en) | Tape backup and restore in a disk storage environment | |
| CN109710286B (en) | System upgrading method, device, equipment and storage medium | |
| CN111382011B (en) | File data access method and device and computer readable storage medium | |
| CN112466378A (en) | Solid state disk operation error correction method and device and related components | |
| CN109144403B (en) | Method and equipment for switching cloud disk modes | |
| CN107436761B (en) | UEFI (unified extensible firmware interface) system and traditional system coexistence management method based on UEFI mainboard | |
| CN102262589A (en) | Application server for realizing copying of hard disc driver, and method | |
| CN112528611A (en) | Method and device for editing table, computer storage medium and terminal | |
| CN111399774B (en) | Data processing method and device based on snapshot under distributed storage system | |
| CN110287064B (en) | Method and device for restoring disk data and electronic equipment | |
| CN109241011B (en) | Virtual machine file processing method and device | |
| CN110597576B (en) | File remark processing method and system | |
| CN106777288B (en) | A kind of system and method for quick fractionation virtualization disk mirroring | |
| CN110399098A (en) | A kind of data processing method and electronic 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 |