CN112784552B - Table editing method and apparatus - Google Patents
Table editing method and apparatus Download PDFInfo
- Publication number
- CN112784552B CN112784552B CN202010503886.7A CN202010503886A CN112784552B CN 112784552 B CN112784552 B CN 112784552B CN 202010503886 A CN202010503886 A CN 202010503886A CN 112784552 B CN112784552 B CN 112784552B
- Authority
- CN
- China
- Prior art keywords
- target
- preset
- data types
- data
- user
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000004891 communication Methods 0.000 description 14
- 238000010586 diagram Methods 0.000 description 12
- 238000004590 computer program Methods 0.000 description 9
- 230000009471 action Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 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/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application provides a table editing method and a table editing device, wherein the method comprises the following steps: determining a preset number of target cells to be edited selected by a user; when a quick writing instruction aiming at a target cell is received, displaying a list recorded with a plurality of preset data types; generating target random data with a preset number of data types which are preset data types selected by a user; and writing target random data into a preset number of target cells. In this way, the electronic device can quickly write the target random data which accords with the data type expected by the user in the target cell selected by the user, so that the exemplary table which does not require the data accuracy is quickly obtained, and the table editing efficiency is improved.
Description
Technical Field
The application relates to the technical field of office software, in particular to a table editing method and device.
Background
In the electronic form software, a user can select a certain cell in the form first and then input data to the cell, so that the form editing is realized. However, when a user needs to populate nonsensical random data in a row of cells or a column of cells in a table to obtain an exemplary table, the user needs to perform at each cell in the row or column: the operation of selecting a cell and inputting data. In this way, the user is made less efficient in editing the form.
Disclosure of Invention
The embodiment of the application aims to provide a table editing method and device so as to improve table editing efficiency. The specific technical scheme is as follows:
in a first aspect, a method for editing a table is provided, the method including:
determining a preset number of target cells to be edited selected by a user;
when a quick writing instruction aiming at a target cell is received, displaying a list recorded with a plurality of preset data types;
generating target random data with a preset number of data types which are preset data types selected by a user;
and writing target random data into a preset number of target cells.
Optionally, when a fast write command for the target cell is received, displaying a list recorded with a plurality of preset data types, including:
when a quick writing instruction aiming at a target cell is received, acquiring historical use frequency of each preset data type in a plurality of preset data types;
displaying a list recorded with a plurality of preset data types; wherein, a plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
Optionally, when a fast write command for the target cell is received, displaying a list recorded with a plurality of preset data types, including:
when a fast write instruction aiming at a target cell is received, determining the last selected preset data type in a plurality of preset data types as a target data type;
displaying a list recorded with a plurality of preset data types; wherein the target data type is located first in the list.
Optionally, the target cell to be edited includes: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
Optionally, generating the target random data with the preset number of data types being the preset data types selected by the user includes:
determining a preset data type selected by a user in the list as a target data type;
obtaining an identifier corresponding to the target data type;
generating a preset number of random data;
before adding the identifier to each random data, a predetermined number of target random data of the target data type is obtained.
In a second aspect, there is provided a form editing apparatus comprising:
the determining module is used for determining a preset number of target cells to be edited selected by a user;
the display module is used for displaying a list recorded with a plurality of preset data types when receiving a quick writing instruction aiming at a target cell;
the generation module is used for generating target random data with a preset number of data types which are preset data types selected by a user;
and the writing module is used for writing the target random data into a preset number of target cells.
Optionally, the display module includes:
the acquisition unit is used for acquiring the historical use frequency of each preset data type in the plurality of preset data types when receiving a quick write-in instruction aiming at the target cell;
a first display unit for displaying a list recorded with a plurality of preset data types; wherein, a plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
Optionally, the display module includes:
a first determining unit, configured to determine, when a fast write command for a target cell is received, a preset data type selected last time from a plurality of preset data types as a target data type;
a second display unit for displaying a list recorded with a plurality of preset data types; wherein the target data type is located first in the list.
Optionally, the target cell to be edited includes: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
Optionally, the generating module includes:
a second determining unit, configured to determine a preset data type selected by a user in the list as a target data type;
an obtaining unit, configured to obtain an identifier corresponding to the target data type;
a generation unit for generating a preset number of random data;
and the adding unit is used for obtaining target random data of a preset number of target data types before adding the identifier to each random data.
In a third aspect, an electronic device is provided, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any of the first aspects when executing a program stored on a memory.
In a fourth aspect, a computer-readable storage medium is provided, in which a computer program is stored which, when being executed by a processor, carries out the method steps of any of the first aspects.
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 any of the first aspects described above.
In the embodiment of the application, the electronic equipment can determine the preset number of target cells to be edited selected by the user; when a quick writing instruction aiming at a target cell is received, displaying a list recorded with a plurality of preset data types; generating target random data with a preset number of data types which are preset data types selected by a user; and writing target random data into a preset number of target cells. In this way, the electronic device can quickly write the target random data which accords with the data type expected by the user in the target cell selected by the user, so that the exemplary table which does not require the data accuracy is quickly obtained, and the table editing efficiency is improved.
Of course, it is not necessary for any one product or method of practicing the application to achieve all of the advantages set forth above at the same time.
Drawings
In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a method for editing a table according to an embodiment of the present application;
FIG. 2 is an interface schematic diagram of a target table according to an embodiment of the present application;
FIG. 3 is an interface diagram of another object table according to an embodiment of the present application;
FIG. 4 is a schematic diagram of an interface of another object table according to an embodiment of the present application;
FIG. 5 is a schematic diagram of a selected discrete target cell according to an embodiment of the present application;
FIG. 6 is a schematic diagram of target random data written in discontinuous target cells according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of a table editing apparatus according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The embodiment of the application provides a table editing method, which can be applied to an electronic software table, and the table editing method provided by the embodiment of the application is described in detail below with reference to a specific implementation manner, as shown in fig. 1, and the specific steps are as follows:
step 101: and determining a preset number of target cells to be edited selected by the user.
In the embodiment of the application, the user can send out an instruction to select the target cell to be edited in the target table. The target cell may be a continuous cell in a row to be edited or a continuous cell in a column to be edited. For example, fig. 2 is an interface schematic diagram of a target table according to an embodiment of the present application. As shown in fig. 2, the user selects the target cell in the black thick line box in fig. 2, that is, the target cell from the 8 th to 27 th rows of the D column.
Step 102: when a fast write command for a target cell is received, a list recorded with a plurality of preset data types is displayed.
In the embodiment of the application, a user can send out a quick writing instruction aiming at the target cell. Specifically, after selecting the target cell, the user can click a random data button preset in the display page to send out a quick writing instruction; or after the target cell is selected, clicking a preset keyboard key or a preset combination key to send out a quick writing instruction. After receiving a quick writing instruction of a user for a target cell, the electronic device displays a list recorded with a plurality of preset data types at a preset position in a display page. For example, the electronic device may display the list directly under or to the right of a preset random data button, or may display the list in the middle of a page where the page is displayed. Wherein the preset data types may include: date, time, currency, value, etc.
For example, fig. 3 is an interface schematic diagram of another object table according to an embodiment of the present application. As shown in fig. 3, after the user clicks a random data button preset in the display page, the electronic device may display a list recorded with a plurality of preset data types at a position right below the random data button. The preset data types of the list record shown in fig. 3 are as follows: a random date (i.e., date data type), a random amount (i.e., amount data type), a random sequence number (i.e., sequence number data type), and a random time (i.e., time data type) may also be recorded. Under each preset data type, a plurality of sample data of the preset data type are also displayed. As shown in the table, sample data displayed below the random date are: 2020-3-18, 1932-3-6, 2013-7-3; sample data displayed below the random amount are: 1213, 12, 284; sample data displayed below the random number are: 1,5,2,7,2.
Step 103: and generating target random data with a preset number of data types which are preset data types selected by a user.
The generating the target random data with the preset number of data types being the preset data types selected by the user comprises the following steps:
determining a preset data type selected by a user in a list as a target data type
Obtaining an identifier corresponding to the target data type;
generating a preset number of random data;
before adding the identifier to each random data, a predetermined number of target random data of the target data type is obtained.
Specifically, after the electronic device displays the list recorded with the plurality of preset data types, the user may select the preset data type to be displayed from the list recorded with the plurality of preset data types. Then the electronic device can determine the preset data type selected by the user in the list as the target data type, and obtain the identifier corresponding to the target data type. Then generating a preset number of random data, and obtaining target random data of a preset number of target data types before adding the identifier to each random data. Thus, the electronic equipment can accurately generate target random data meeting the needs of the user, and the efficiency of editing the table is improved.
For example, fig. 4 is an interface schematic diagram of another object table according to an embodiment of the present application. As shown in fig. 4, after the user selects 20 target cells, the electronic device may display a list in which preset data types are recorded. The user may then select the preset data type to be displayed as the target data type in the list in which the preset data type is recorded, e.g., the user may select a random amount as the target data type in the displayed list. The electronic device may then obtain the identifier corresponding to the target type, and in particular, the electronic device may obtain the identifier "@" corresponding to the random amount. The electronic device may then generate 20 pieces of random data: 1231. 4345, 2426, 5463, 1234, 12, 564, 234, 552, 3453, 88, 346, 654, 658, 2534, 654, 6754, 2345, 75, 758, and generating target random data before adding the identifier "", to each random data: 1231, 4345, 2426, 5463, 1234, 12, 564, 234, 552, 3453, 88, 346, 654, 658, 2534, 654, 6754, 2345, 75, 758.
Step 104: and writing target random data into a preset number of target cells.
In the embodiment of the application, after the electronic device generates the target random data with the preset number and the data type being the preset data type selected by the user, the target random data can be sequentially written into the target cells of the preset data.
As shown in fig. 4, after generating 20 random data with the data type of the amount data type, the electronic device may sequentially write the target random data into 20 target cells in the order from top to bottom in the column to be edited. Specifically, the electronic device may sequentially write the target random data into the selected target cell as follows: 1231, 4345, 2426, 5463, 1234, 12, 564, 234, 552, 3453, 88, 346, 654, 658, 2534, 654, 6754, 2345, 75, 758.
In the embodiment of the application, the electronic equipment can determine the preset number of target cells to be edited selected by the user; when a quick writing instruction aiming at a target cell is received, displaying a list recorded with a plurality of preset data types; generating target random data with a preset number of data types which are preset data types selected by a user; and writing target random data into a preset number of target cells. In this way, the electronic device can quickly write the target random data which accords with the data type expected by the user into the target cell selected by the user, so that an exemplary table which does not require accuracy is obtained, and the table editing efficiency is improved.
Optionally, when a fast write command for the target cell is received, displaying a list recorded with a plurality of preset data types, including:
when a quick writing instruction aiming at a target cell is received, acquiring historical use frequency of each preset data type in a plurality of preset data types;
displaying a list recorded with a plurality of preset data types; wherein, a plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
In the embodiment of the application, the electronic equipment can acquire the historical use frequency of each preset data type in a plurality of preset data types. When displaying a list recorded with a plurality of preset data types, the electronic device can display the plurality of preset data types in the order from high to low according to the historical use frequency. For example, the plurality of preset data types includes: random date, random time, random amount and random number; the electronic device may then obtain historical usage frequencies for the plurality of preset data types: the historical use frequency of the random date is 23%, the historical use frequency of the random time is 10%, the historical use frequency of the random amount is 40%, and the historical use frequency of the random number is 27%; the preset data types displayed by the list are sequentially: random amount, random number, random date, random time.
Therefore, the preset data types with higher use frequency are displayed at the front position of the list, so that a user can quickly find the required preset data types, the efficiency of selecting the preset data types to be displayed by the user is improved, and the table editing efficiency is improved.
Optionally, when a fast write command for the target cell is received, displaying a list recorded with a plurality of preset data types, including:
when a fast write instruction aiming at a target cell is received, determining the last selected preset data type in a plurality of preset data types as a target data type;
displaying a list recorded with a plurality of preset data types; wherein the target data type is located first in the list.
In the embodiment of the application, when receiving the fast write-in instruction for the target cell, the electronic equipment can determine the preset data type selected by the user when the user uses the random data last time. The electronic device may then determine the preset data type as the target data type and display the target data type in the first bit of the list. Since the preset data type used last time by the user is likely to be the preset data type which the user wants to use this time, the preset data type selected last time can be displayed in the first position in the list, so that the user can quickly find the required preset data type, the efficiency of selecting the preset data type required to be displayed by the user is improved, and the table editing efficiency is improved.
Optionally, the target cell to be edited includes: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
In the embodiment of the application, the electronic device can select the discontinuous preset number of cells in the column to be edited, or the discontinuous preset number of cells in the row to be edited as the target cells to be edited. The electronic device may then also display a list of the plurality of preset data types recorded in the display page upon receiving a fast write command for the target cell. Then, target random data with the preset number of data types being the preset data types selected by the user can be generated, and the target random data are sequentially written into the preset number of target cells. In this way, the electronic device can quickly write the target random data which accords with the data type expected by the user into the discontinuous target cells selected by the user, so that an exemplary table which does not require accuracy is obtained, and the table editing efficiency is improved.
For example, fig. 5 is a schematic diagram of a selected discontinuous target cell according to an embodiment of the present application. As shown in fig. 5, the user selects the column a, the row 2, the column a, the row 4, the column a, the row 6, the column a, the row 8, the column a, the row 10, the column a, the row 12 as 6 target cells to be edited. Then, after receiving the fast write command for the target cell, the electronic device may display a list recorded with a plurality of preset data types. After the user selects the preset data type with the random date in the list, the electronic device can generate 6 random data with the data type being the date, and write the random data into the target cell to be edited.
Fig. 6 is a schematic diagram of target random data written in discontinuous target cells according to an embodiment of the present application. As shown in fig. 6, in the column a, the row 2, the column a, the row 4, the column a, the row 6, the column a, the row 8, the column a, the row 10, and the column a, the row 12, the target random data written in sequence are: 2020-3-15, 1999-5-18, 2013-9-5, 2008-9-23, 1932-3-18, 1972-8-15.
Based on the same technical concept, the embodiment of the application further provides a table editing device, as shown in fig. 7, where the device includes:
a determining module 701, configured to determine a preset number of target cells to be edited selected by a user;
the display module 702 is configured to display a list recorded with a plurality of preset data types when receiving a fast write command for a target cell;
a generating module 703, configured to generate target random data with a preset number of data types being preset data types selected by a user;
the writing module 704 is configured to write target random data in a preset number of target cells.
In the embodiment of the application, the electronic equipment can determine the preset number of target cells to be edited selected by the user; when a quick writing instruction aiming at a target cell is received, displaying a list recorded with a plurality of preset data types; generating target random data with a preset number of data types which are preset data types selected by a user; and writing target random data into a preset number of target cells. In this way, the electronic device can quickly write the target random data which accords with the data type expected by the user in the target cell selected by the user, so that the exemplary table which does not require the data accuracy is quickly obtained, and the table editing efficiency is improved.
Optionally, the display module 702 includes:
the acquisition unit is used for acquiring the historical use frequency of each preset data type in the plurality of preset data types when receiving a quick write-in instruction aiming at the target cell;
a first display unit for displaying a list recorded with a plurality of preset data types; wherein, a plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
Optionally, the display module 702 includes:
a first determining unit, configured to determine, when a fast write command for a target cell is received, a preset data type selected last time from a plurality of preset data types as a target data type;
a second display unit for displaying a list recorded with a plurality of preset data types; wherein the target data type is located first in the list.
Optionally, the target cell to be edited includes: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
Optionally, the generating module 703 includes:
a second determining unit, configured to determine a preset data type selected by a user in the list as a target data type;
an obtaining unit, configured to obtain an identifier corresponding to the target data type;
a generation unit for generating a preset number of random data;
and the adding unit is used for obtaining target random data of a preset number of target data types before adding the identifier to each random data.
The embodiment of the present application further provides an electronic device, as shown in fig. 8, including a processor 801, a communication interface 802, a memory 803, and a communication bus 804, where the processor 801, the communication interface 802, and the memory 803 complete communication with each other through the communication bus 804,
a memory 803 for storing a computer program;
the processor 801 is configured to implement any of the method steps in the above-described table editing method embodiments when executing the program stored in the memory 803.
The communication bus mentioned above for the electronic devices may be a peripheral component interconnect standard (Peripheral Component Interconnect, PCI) bus or an extended industry standard architecture (Extended Industry Standard Architecture, EISA) bus, etc. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, the figures are shown with only one bold line, but not with only one bus or one type of bus.
The communication interface is used for communication between the electronic device and other devices.
The Memory may include random access Memory (Random Access Memory, RAM) or may include 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 aforementioned processor.
The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but also digital signal processors (Digital Signal Processing, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
In a further embodiment of the present application, a computer readable storage medium is also provided, in which a computer program is stored, which computer program, when being executed by a processor, implements any of the method steps of the table editing method embodiments described above.
In a further embodiment of the present application, a computer program product comprising instructions which, when run on a computer, cause the computer to perform any of the method steps of the table editing method embodiments described above is also provided.
In the above embodiments, it may be implemented in whole or in part 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, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, for example, by wired (e.g., coaxial cable, optical fiber, digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more 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)), etc.
It is noted that relational terms such as first and second, and the like are 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. Moreover, 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 one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
In this specification, each embodiment is described in a related manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for the apparatus, the electronic device, the computer-readable storage medium, and the computer-readable storage medium embodiments, the description is relatively simple, and relevant places are referred to in the section of the description of the method embodiments, since they are basically similar to the method embodiments.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement, etc. 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 table editing, the method comprising:
determining a preset number of target cells to be edited selected by a user;
when a fast write instruction aiming at the target cell is received, displaying a list recorded with a plurality of preset data types;
generating target random data with the preset number of data types being preset data types selected by a user;
and writing the target random data into the preset number of target cells.
2. The method of claim 1, wherein the displaying a list recorded with a plurality of preset data types when a fast write command for the target cell is received comprises:
when a quick writing instruction aiming at the target cell is received, acquiring historical use frequency of each preset data type in a plurality of preset data types;
displaying a list recorded with the plurality of preset data types; wherein the plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
3. The method of claim 1, wherein the displaying a list recorded with a plurality of preset data types when a fast write command for the target cell is received comprises:
when a fast write instruction aiming at the target cell is received, determining the last selected preset data type in a plurality of preset data types as a target data type;
displaying a list recorded with the plurality of preset data types; wherein the target data type is located first in the list.
4. The method of claim 1, wherein the target cell to be edited comprises: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
5. The method according to any one of claims 1-4, wherein the generating the target random data of the preset number of data types being user-selected preset data types comprises:
determining a preset data type selected by a user in the list as a target data type;
obtaining an identifier corresponding to the target data type;
generating the preset number of random data;
and before the identifier is added to each piece of random data, obtaining the target random data of the preset number of target data types.
6. A form editing apparatus, the apparatus comprising:
the determining module is used for determining a preset number of target cells to be edited selected by a user;
the display module is used for displaying a list recorded with a plurality of preset data types when receiving a quick writing instruction aiming at the target cell;
the generation module is used for generating target random data with the preset number of data types being preset data types selected by a user;
and the writing module is used for writing the target random data into the preset number of target cells.
7. The apparatus of claim 6, wherein the display module comprises:
the acquisition unit is used for acquiring the historical use frequency of each preset data type in a plurality of preset data types when receiving a quick write-in instruction aiming at the target cell;
a first display unit for displaying a list recorded with the plurality of preset data types; wherein the plurality of preset data types in the list are displayed in the order from high to low according to the historical use frequency.
8. The apparatus of claim 6, wherein the display module comprises:
a first determining unit, configured to determine, when a fast write command for the target cell is received, a preset data type selected last time from a plurality of preset data types as a target data type;
a second display unit for displaying a list recorded with the plurality of preset data types; wherein the target data type is located first in the list.
9. The apparatus of claim 6, wherein the target cell to be edited comprises: a preset number of cells in a row to be edited that are discontinuous, or a preset number of cells in a column to be edited that are discontinuous.
10. The apparatus according to any one of claims 6-9, wherein the generating module comprises:
a second determining unit, configured to determine a preset data type selected by a user in the list as a target data type;
an obtaining unit, configured to obtain an identifier corresponding to the target data type;
a generation unit, configured to generate the preset number of random data;
and the adding unit is used for obtaining the target random data of the preset number of target data types before adding the identifier to each random data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010503886.7A CN112784552B (en) | 2020-06-05 | 2020-06-05 | Table editing method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010503886.7A CN112784552B (en) | 2020-06-05 | 2020-06-05 | Table editing method and apparatus |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112784552A CN112784552A (en) | 2021-05-11 |
| CN112784552B true CN112784552B (en) | 2023-10-27 |
Family
ID=75749173
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010503886.7A Active CN112784552B (en) | 2020-06-05 | 2020-06-05 | Table editing method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112784552B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591002B (en) * | 2021-07-23 | 2023-01-17 | 天津同阳科技发展有限公司 | Data processing method, data processing device, electronic device, and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| CN107506457A (en) * | 2017-08-29 | 2017-12-22 | 姜博 | A kind of method and apparatus of data processing |
| CN107992458A (en) * | 2016-10-26 | 2018-05-04 | 腾讯科技（北京）有限公司 | The generation method and device of form rule |
| CN110221858A (en) * | 2019-06-17 | 2019-09-10 | 深圳前海微众银行股份有限公司 | Analogue data generation method, device, equipment and computer readable storage medium |
| CN110287473A (en) * | 2019-06-28 | 2019-09-27 | 北京字节跳动网络技术有限公司 | Electrical form edit methods and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11354494B2 (en) * | 2017-07-10 | 2022-06-07 | Adaptam Inc. | Methods and systems for connecting a spreadsheet to external data sources with formulaic specification of data retrieval |
| CN107515862A (en) * | 2017-09-01 | 2017-12-26 | 北京百度网讯科技有限公司 | Voice translation method, device and server |
-
2020
- 2020-06-05 CN CN202010503886.7A patent/CN112784552B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| CN107992458A (en) * | 2016-10-26 | 2018-05-04 | 腾讯科技（北京）有限公司 | The generation method and device of form rule |
| CN107506457A (en) * | 2017-08-29 | 2017-12-22 | 姜博 | A kind of method and apparatus of data processing |
| CN110221858A (en) * | 2019-06-17 | 2019-09-10 | 深圳前海微众银行股份有限公司 | Analogue data generation method, device, equipment and computer readable storage medium |
| CN110287473A (en) * | 2019-06-28 | 2019-09-27 | 北京字节跳动网络技术有限公司 | Electrical form edit methods and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112784552A (en) | 2021-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111414727B (en) | Editing method and device for PDF document header footer and electronic equipment | |
| CN103984626A (en) | Method and device for generating test-case script | |
| CN110956016A (en) | Document content format adjusting method and device and electronic equipment | |
| CN113590102A (en) | Zero-code rapid software development method, system, medium and equipment | |
| CN110321410A (en) | Method, apparatus, storage medium and the electronic equipment that log is extracted | |
| CN112784552B (en) | Table editing method and apparatus | |
| CN111368226A (en) | Screening method and device, electronic equipment and computer readable storage medium | |
| CN109189688B (en) | Test case script generation method and device and electronic equipment | |
| CN110795464A (en) | Method, device, terminal and storage medium for checking field of object marker data | |
| CN112329409B (en) | Cell color conversion method and device and electronic equipment | |
| CN113344514A (en) | Item information display method and device, electronic equipment and readable medium | |
| CN112528703B (en) | Method and device for identifying table structure and electronic equipment | |
| CN110201397B (en) | Game resource allocation method and device and electronic equipment | |
| CN111008058A (en) | Page display method and device | |
| CN115129590A (en) | Test case generation method and device, electronic equipment and storage medium | |
| CN111881311B (en) | Intelligent recommendation method, device and equipment for chart type and storage medium | |
| CN111078026B (en) | Input prompting method, device, electronic equipment and readable storage medium | |
| CN111897661B (en) | Cell content copying method and device in electronic table and electronic equipment | |
| CN111399832B (en) | Page editing method and device | |
| CN112232046B (en) | Method and device for displaying repeated items of table | |
| CN112784560A (en) | Data display method and device | |
| JP6204923B2 (en) | Assessment device, assessment system, assessment method, and program | |
| CN112181240B (en) | Information display method and device | |
| CN112784550B (en) | Information input method and device | |
| CN112417832A (en) | Format conversion method and device for spreadsheet document 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |