CN111832267A - Cell pasting method and device - Google Patents
Cell pasting method and device Download PDFInfo
- Publication number
- CN111832267A CN111832267A CN201910245552.1A CN201910245552A CN111832267A CN 111832267 A CN111832267 A CN 111832267A CN 201910245552 A CN201910245552 A CN 201910245552A CN 111832267 A CN111832267 A CN 111832267A
- Authority
- CN
- China
- Prior art keywords
- pasting
- cell
- target information
- empty
- information
- 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
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application provides a cell pasting method and device, and relates to the technical field of electronic forms. The method comprises the following steps: determining copied target information and a pasting area, wherein the pasting area comprises at least one empty cell, and pasting the target information to the empty cell in the pasting area. By the adoption of the method and the device, user experience can be improved.
Description
Technical Field
The present application relates to the field of electronic forms, and in particular, to a cell pasting method and device.
Background
When processing information using a spreadsheet, a user typically needs to copy information of a certain cell (which may be referred to as destination information) and paste the destination information onto a cell (which may be referred to as an empty cell) that needs to be pasted and contains no information.
In the prior art, the specific pasting process generally comprises: the user inputs a copying instruction of a target cell to the terminal and inputs a selection instruction of a pasting area, wherein the pasting area comprises an empty cell needing to be pasted. The terminal can determine the copied target information (i.e., information in the target cell) and the paste area according to the copy instruction and the selection instruction. Then, the user can input a paste instruction to the terminal, and after the terminal receives the paste instruction, the target information can be pasted to the cells in the paste area.
However, when a cell (which may be referred to as a non-empty cell) containing information exists in the paste area, the information of the non-empty cell is covered by the target information, so that the original information of the non-empty cell is lost, and the user experience is poor.
Disclosure of Invention
The embodiment of the application aims to provide a cell pasting method and device, which can improve user experience. The specific technical scheme is as follows:
in a first aspect, a cell pasting method is provided, and the method includes:
determining copied target information and a pasting area, wherein the pasting area comprises at least one empty cell;
and pasting the target information to the empty cells in the pasting area.
Optionally, the unit cell positions included in the pasting region are continuous.
Optionally, before pasting the target information onto the empty cell in the pasting region, the method further includes:
judging whether the copied target information is cell information or not;
and if the copied target information is cell information, executing the step of pasting the target information to the empty cells in the pasting area.
Optionally, the pasting the target information to the empty cell in the pasting region includes:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
In a second aspect, there is provided a cell pasting device, the device comprising:
the system comprises a determining module, a pasting module and a judging module, wherein the determining module is used for determining copied target information and a pasting area, and the pasting area comprises at least one empty cell;
and the pasting module is used for pasting the target information to the empty cells in the pasting area.
Optionally, the unit cell positions included in the pasting region are continuous.
Optionally, the apparatus further includes a determining module, where the determining module is specifically configured to:
judging whether the copied target information is cell information or not;
and if the copied target information is cell information, triggering the pasting module to execute the step of pasting the target information onto the empty cells in the pasting area.
Optionally, the pasting module is specifically configured to:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
In a third aspect, there is provided an electronic device comprising a processor and a machine-readable storage medium storing machine-executable instructions executable by the processor, the processor being caused by the machine-executable instructions to: the method steps of the first aspect are implemented.
In a fourth aspect, a computer-readable storage medium is provided, having stored thereon a computer program which, when being executed by a processor, carries out the method steps of the first aspect.
In a fifth aspect, there is provided a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of the first aspect described above.
The cell pasting method and device provided by the embodiment of the application can determine copied target information and a pasting area, wherein the pasting area comprises at least one empty cell. And pasting the target information to the empty cells in the pasting area. In the scheme provided by the application, the target information is only pasted to the empty cells in the pasting area, and the target information is not pasted to the non-empty cells in the pasting area, so that the original information of the non-empty cells in the pasting area is reserved, and the user experience is improved.
Of course, not all advantages described above need to be achieved at the same time in the practice of any one product or method of the present application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a cell pasting method according to an embodiment of the present application;
fig. 2 is a schematic view of a pasting region according to an embodiment of the present disclosure;
fig. 3 is a schematic view of a pasting region after pasting according to an embodiment of the present application;
fig. 4 is a flowchart of a cell pasting method according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a cell pasting device according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The embodiment of the application provides a cell pasting method which is applied to a user terminal. The method comprises the following steps: and determining copied target information and a pasting area, wherein the pasting area comprises at least one empty cell. And pasting the target information to the empty cells in the pasting area. In the scheme provided by the application, the target information is only pasted to the empty cells in the pasting area, and the target information is not pasted to the non-empty cells in the pasting area, so that the original information of the non-empty cells in the pasting area is reserved, and the user experience is improved.
A cell pasting method provided in the embodiments of the present application will be described in detail below with reference to specific embodiments, as shown in fig. 1, the specific steps are as follows:
The pasting area comprises at least one empty cell, and the positions of the cells in the pasting area are continuous.
In the embodiment of the application, the user terminal can display the spreadsheet to be processed, the user can input the selection instruction of the target cell to the user terminal, and correspondingly, the user terminal can determine the target cell in the spreadsheet according to the selection instruction. Then, the user may input a copy instruction to the user terminal, and accordingly, after receiving the copy instruction, the user terminal may use the information of the target cell as the copied target information. The information of the target cell may include the content in the target cell and the format of the target cell. For example, a user may select a target cell in the spreadsheet with a mouse, and after selecting the target cell, the user may input a copy instruction to the user terminal by clicking a copy button, and accordingly, after receiving the copy instruction, the user terminal may use information of the target cell as copied target information.
The user can input a selection instruction of the pasting area to the user terminal, and correspondingly, the user terminal can determine the pasting area according to the selection instruction. For example, a user may drag and select an area containing an empty cell to be pasted by a mouse, where the cell positions in the area selected by the user are continuous. The user terminal may drag the selected area by the user through the mouse as the paste area. When the number of the empty cells needing to be pasted is multiple and the empty cells needing to be pasted are distributed in different rows and different columns, a user drags the selected area through a mouse to include the non-empty cells needing not to be pasted, namely the pasting area includes the non-empty cells needing not to be pasted. The pasting region may be as shown in fig. 2, the positions of the cells in the pasting region are continuous, and the pasting region includes non-empty cells and empty cells containing the letter "a".
In the embodiment of the application, a user can input a paste instruction to the user terminal, and correspondingly, after the user terminal receives the paste instruction, the user terminal can determine the empty cells in the paste area and paste the target information to the determined empty cells. For example, a user may click a paste button displayed by the user terminal, and when the user terminal detects that the user clicks the paste button, the user terminal may determine, for each cell in the paste area, whether the cell is an empty cell, and if the cell is an empty cell, store an identifier of the cell, for example, store location information of the cell. The user terminal may then determine the empty cells in the paste area based on the stored identity of the cells. Further, the user terminal can paste the object information onto the empty cell. For example, if the target information is the letter "B" included in the cell and the pasted area is as shown in fig. 2, the pasted area after pasting is as shown in fig. 3, the empty cell is filled with the letter "B", and the letter "a" in the non-empty cell in the pasted area is retained.
Therefore, only the target information is pasted to the empty cells in the pasting area, and the target information is not pasted to the non-empty cells in the pasting area, so that the original information of the non-empty cells in the pasting area is reserved, and the user experience is improved.
Optionally, the specific process of pasting the target information to the empty cell in the pasting area may be: judging whether each cell in the pasting area is an empty cell or not; and if the cell is an empty cell, pasting the target information to the cell.
In the embodiment of the application, a user can input a paste instruction to the user terminal, and correspondingly, after receiving the paste instruction, the user terminal can sequentially perform the following processing on each cell in the paste area: and judging whether the cell is an empty cell or not, and pasting the target information to the cell if the cell is the empty cell.
Optionally, before pasting the target information onto the empty cell in the pasting region, the user terminal determines whether the copied target information is cell information, so as to prevent non-cell information from being pasted onto the empty cell in the pasting region. The specific process is as follows: judging whether the copied target information is cell information or not; if the copied target information is information of a cell, a step of pasting the target information onto an empty cell in the pasting region is performed.
In the embodiment of the application, the user can input the paste instruction to the user terminal, and correspondingly, after the user terminal receives the paste instruction, the user terminal can judge whether the copied target information is the information of the cell. If the copied target information is the cell information, the user terminal executes a step of pasting the target information onto the empty cell in the pasting area; and if the copied target information is not the information of the cell, displaying first indication information by the user terminal, wherein the first indication information is used for indicating that the copied target information is not the information of the cell. For example, if the copied target information is a picture, the user terminal may determine that the target information is not cell information, and the user terminal may display the first indication information. In this way, it is possible to prevent non-cell information from being pasted into an empty cell of the pasted area.
In the scheme provided by the application, the target information is only pasted to the empty cells in the pasting area, and the target information is not pasted to the non-empty cells in the pasting area, so that the original information of the non-empty cells in the pasting area is reserved, and the user experience is improved.
The embodiment of the present application further provides an example of a cell pasting method, as shown in fig. 4, the specific steps are as follows:
If yes, go to step 404; if not, go to step 403.
At step 404, an empty cell in the paste area is determined.
Wherein, in steps 401 and 405, reference may be made to steps 101 and 102, which are not described herein again in this embodiment of the present application.
Based on the same technical concept, as shown in fig. 5, an embodiment of the present application further provides a cell pasting device, including:
a determining module 501, configured to determine copied target information and a pasting region, where the pasting region includes at least one empty cell;
a pasting module 502, configured to paste the target information onto the empty cells in the pasting area.
Optionally, the unit cell positions included in the pasting region are continuous.
Optionally, the apparatus further includes a determining module, where the determining module is specifically configured to:
judging whether the copied target information is cell information or not;
if the copied target information is cell information, triggering the pasting module 502 to execute the step of pasting the target information onto the empty cells in the pasting area.
Optionally, the pasting module 502 is specifically configured to:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
The embodiment of the present application further provides an electronic device, as shown in fig. 6, which includes a processor 601, a communication interface 602, a memory 603, and a communication bus 604, where the processor 601, the communication interface 602, and the memory 603 complete mutual communication through the communication bus 604,
a memory 603 for storing a computer program;
the processor 601 is configured to implement the following steps when executing the program stored in the memory 603:
determining copied target information and a pasting area, wherein the pasting area comprises at least one empty cell;
and pasting the target information to the empty cells in the pasting area.
Optionally, the unit cell positions included in the pasting region are continuous.
Optionally, before pasting the target information onto the empty cell in the pasting region, the method further includes:
judging whether the copied target information is cell information or not;
and if the copied target information is cell information, executing the step of pasting the target information to the empty cells in the pasting area.
Optionally, the pasting the target information to the empty cell in the pasting region includes:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component.
In yet another embodiment provided by the present application, a computer-readable storage medium is further provided, in which a computer program is stored, and the computer program, when executed by a processor, implements the steps of any of the above cell pasting methods.
In yet another embodiment provided by the present application, there is also provided a computer program product containing instructions which, when run on a computer, cause the computer to perform any of the cell pasting methods of the above embodiments.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus, the electronic device, the computer-readable storage medium, and the computer program product embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiments.
The above description is only for the preferred embodiment of the present application, and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims (10)
1. A method of cell pasting, the method comprising:
determining copied target information and a pasting area, wherein the pasting area comprises at least one empty cell;
and pasting the target information to the empty cells in the pasting area.
2. The method of claim 1, wherein the pasting region comprises a continuum of cell locations.
3. The method according to claim 1, wherein before the pasting the object information onto the empty cell in the pasting region, the method further comprises:
judging whether the copied target information is cell information or not;
and if the copied target information is cell information, executing the step of pasting the target information to the empty cells in the pasting area.
4. The method according to claim 1, wherein the pasting the object information onto the empty cell in the pasting region comprises:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
5. A cell pasting apparatus, said apparatus comprising:
the system comprises a determining module, a pasting module and a judging module, wherein the determining module is used for determining copied target information and a pasting area, and the pasting area comprises at least one empty cell;
and the pasting module is used for pasting the target information to the empty cells in the pasting area.
6. The apparatus of claim 5, wherein the pasting region comprises a continuum of cell locations.
7. The apparatus according to claim 5, further comprising a determining module, the determining module being specifically configured to:
judging whether the copied target information is cell information or not;
and if the copied target information is cell information, triggering the pasting module to execute the step of pasting the target information onto the empty cells in the pasting area.
8. The device according to claim 5, wherein the pasting module is specifically configured to:
judging whether each cell in the pasting area is an empty cell or not;
and if the cell is an empty cell, pasting the target information to the cell.
9. An electronic device comprising a processor and a machine-readable storage medium storing machine-executable instructions executable by the processor, the processor being caused by the machine-executable instructions to: carrying out the method steps of any one of claims 1 to 4.
10. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the method steps of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910245552.1A CN111832267A (en) | 2019-03-28 | 2019-03-28 | Cell pasting method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910245552.1A CN111832267A (en) | 2019-03-28 | 2019-03-28 | Cell pasting method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111832267A true CN111832267A (en) | 2020-10-27 |
Family
ID=72915247
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910245552.1A Pending CN111832267A (en) | 2019-03-28 | 2019-03-28 | Cell pasting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111832267A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126433A (en) * | 2015-05-07 | 2016-11-16 | 爱思开海力士有限公司 | Storage system and operational approach thereof |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
| CN107291564A (en) * | 2017-06-08 | 2017-10-24 | 北京金山安全软件有限公司 | Information copying and pasting method and device and electronic equipment |
| 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-03-28 CN CN201910245552.1A patent/CN111832267A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126433A (en) * | 2015-05-07 | 2016-11-16 | 爱思开海力士有限公司 | Storage system and operational approach thereof |
| CN106445900A (en) * | 2016-09-20 | 2017-02-22 | 东软集团股份有限公司 | Table style processing method and device |
| CN107291564A (en) * | 2017-06-08 | 2017-10-24 | 北京金山安全软件有限公司 | Information copying and pasting method and device and electronic equipment |
| 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 |
|---|---|---|
| CN111026392B (en) | Method and device for generating guide page and electronic equipment | |
| CN108959495B (en) | page display method, device, equipment and computer storage medium of H5 webpage | |
| CN110533464A (en) | A kind of advertisement detecting method, apparatus, system and calculate equipment | |
| CN111368226A (en) | Screening method and device, electronic equipment and computer readable storage medium | |
| CN111080374A (en) | Test method of advertisement delivery strategy, bidding server and advertisement delivery system | |
| CN111124564A (en) | Method and device for displaying user interface | |
| CN111159160B (en) | Version rollback method and device, electronic equipment and storage medium | |
| CN110989893A (en) | Click operation response method and device and electronic equipment | |
| CN111522626A (en) | Virtual machine list generation method and device and electronic equipment | |
| CN111832267A (en) | Cell pasting method and device | |
| CN111553130A (en) | Chapter title style conversion method and device, electronic equipment and storage medium | |
| CN113268183B (en) | List page countdown display method and device | |
| CN111666020B (en) | Method and device for switching document pages, electronic equipment and storage medium | |
| CN111897661B (en) | Cell content copying method and device in electronic table and electronic equipment | |
| CN109542300B (en) | Method and device for updating web directory, electronic equipment and storage medium | |
| CN110659096B (en) | Method, device, system and storage medium for displaying network topological graph | |
| CN111199144B (en) | Document content altering method and device, electronic equipment and readable storage medium | |
| CN113535832A (en) | Method and device for acquiring cloud service data, electronic equipment and medium | |
| CN112256654A (en) | Document sharing method and device | |
| CN111666733B (en) | Method and device for processing cells in document | |
| CN111880776A (en) | Hierarchical relationship obtaining method and device and electronic equipment | |
| CN111444392A (en) | Method, device and equipment for accessing cave library | |
| CN112231111A (en) | Data pasting method and device, electronic equipment and storage medium | |
| CN110928470B (en) | Signature box display method and device, electronic equipment and storage medium | |
| CN112788091B (en) | Document content providing system, document content collecting method, device and 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 |