CN111104780B - Method and terminal for screening columns in electronic form - Google Patents
Method and terminal for screening columns in electronic form Download PDFInfo
- Publication number
- CN111104780B CN111104780B CN201811174806.7A CN201811174806A CN111104780B CN 111104780 B CN111104780 B CN 111104780B CN 201811174806 A CN201811174806 A CN 201811174806A CN 111104780 B CN111104780 B CN 111104780B
- Authority
- CN
- China
- Prior art keywords
- title
- spreadsheet
- displayed
- columns
- titles
- 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
- 238000012216 screening Methods 0.000 title claims abstract description 45
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 5
- 238000001914 filtration Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000007723 transport mechanism Effects 0.000 description 1
Landscapes
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a terminal for screening columns in a spreadsheet, wherein the method comprises the following steps: extracting a title from a spreadsheet title line; selecting a title to be displayed from the extracted titles; displaying columns corresponding to selected titles and hiding columns corresponding to unselected titles. The invention can automatically and conveniently screen the columns to be displayed in the electronic form.
Description
Technical Field
The present invention relates to electronic form editing technology, and in particular, to a method and a terminal for screening columns in an electronic form.
Background
Today, system-derived spreadsheets contain more and more information, and therefore the number of columns in a spreadsheet may be tens, hundreds, or even hundreds of columns that are no longer rare. The spreadsheet may record as comprehensive as possible various information through so many columns, but it is often only necessary for a user of the data to view a portion of the column contents therein.
Currently, if a data user wants to view a few columns of information in a large electronic table, only columns which do not need to be viewed can be manually selected block by block and then hidden. This process is very cumbersome and is especially prone to operating errors when there are many columns and the columns to be viewed are more diffuse.
Disclosure of Invention
In order to solve the technical problems, the invention provides a method and a terminal for screening columns in a spreadsheet, which can automatically and conveniently screen the columns to be displayed in the spreadsheet.
In order to achieve the object of the present invention, an embodiment of the present invention provides a method for screening columns in a spreadsheet, including:
extracting a title from a spreadsheet title line;
Selecting a title to be displayed from the extracted titles;
Displaying columns corresponding to selected titles and hiding columns corresponding to unselected titles.
As an embodiment, the extracting the title from the spreadsheet title line includes:
extracting a title from a cell of a spreadsheet title line, comprising:
when the spreadsheet header line is more than one line, the header is extracted from the cells in which the line is specified.
As an embodiment, the extracting the title from the cells of the row includes:
When n continuous cells exist in the same row and belong to the same merging cell, extracting a title from the merging cell, wherein n is an integer greater than or equal to 2.
As one embodiment, extracting a title from a cell of a specified row includes:
When a sub-cell exists in a given row in which one cell is a co-column merged cell, a title is extracted from the merged cell.
As an embodiment, the method further comprises:
And after selecting the title to be displayed from the extracted titles, saving the selected title to be displayed as a history list screening record.
As an embodiment, the method further comprises:
And receiving a locking instruction for the designated column through the set column locking entry, and simultaneously displaying the locked column when displaying the column corresponding to the selected title.
As an embodiment, the method further comprises:
after extracting a title from a title row of the electronic form, searching the title containing the keyword from the extracted title through the keyword;
Selecting a title to be displayed from the extracted titles, comprising:
And selecting a title to be displayed from the searched titles containing the keywords.
As an embodiment, the method further comprises:
After selecting a title to be displayed from the searched titles containing the keywords, when receiving an instruction for reserving a column corresponding to the displayed title, displaying the title indicated by the instruction while searching for the title containing the new keywords from the extracted titles through the new keywords next time.
The embodiment of the invention also provides a terminal for screening columns in the electronic form, which comprises the following steps:
a memory for storing computer executable instructions;
a processor for executing the computer-executable instructions to perform the steps of the method of screening columns in a spreadsheet as described above.
Embodiments of the present invention also provide a computer-readable storage medium storing computer-executable instructions that, when executed by a processor, perform the steps of a method of screening columns in a spreadsheet as described above.
In contrast to the prior art, the present invention includes extracting a title from a spreadsheet title line; selecting a title to be displayed from the extracted titles; displaying columns corresponding to selected titles and hiding columns corresponding to unselected titles. The embodiment of the invention can automatically and conveniently screen the columns to be displayed in the electronic form.
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 application and are incorporated in and constitute a part of this specification, illustrate and do not limit the application.
FIG. 1 is a flowchart of a method for screening columns in a spreadsheet according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a spreadsheet according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a title list extracted from the electronic form shown in FIG. 2 according to an embodiment of the present invention;
FIG. 4 is a diagram of a spreadsheet according to an embodiment of the present invention after a row screening of the spreadsheet shown in FIG. 2;
FIG. 5 is a schematic diagram of a spreadsheet containing a plurality of header rows according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a stored history list filtering record according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of a search title according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of a lock column provided by an embodiment of the present invention;
Fig. 9 is a system block diagram of a column in a screening electronic form according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present application more apparent, embodiments of the present application will be described in detail hereinafter with reference to the accompanying drawings. It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be arbitrarily combined with each other.
The steps illustrated in the flowchart of the figures may be performed in a computer system, such as a set of computer-executable instructions. Also, while a logical order is depicted in the flowchart, in some cases, the steps depicted or described may be performed in a different order than presented herein.
The embodiment of the invention provides a method for screening columns in a spreadsheet, as shown in fig. 1, the method comprises the following steps:
S101, extracting a title from a title line of the electronic form;
As one implementation, the extracting the title from the spreadsheet title line includes: extracting a title from cells of a title row of the electronic form, extracting the title from the merging cells when n cells in the title row are subordinate to the same merging cells, wherein n is an integer greater than or equal to 2, as shown in the detailed data table of each item access condition in figure 2, the title line of the electronic form is extracted from the cells of the line, and the title is 'the number of first-level page clicks and the number of detailed page clicks of the first-level page clicks of the number of the display people of the date item name channel daily display times and the number of the detailed page clicks of the number of the display people of the number of the date item name channel daily display times'. Wherein, the two cells D3 and E3 belong to the same merging cell, and the title is extracted from the merging cell; the extracted titles may be displayed to the user in the form of a list, as shown in fig. 3;
S102, selecting a title to be displayed from the extracted titles; as shown in fig. 3, the title "the number of first-level page clicks of date item name channel day display number of first-level page clicks of detail page clicks" in the selection list is the title to be displayed; an external instruction may be received to select a title to be displayed from the extracted titles;
S103 displays columns corresponding to the selected title and hides columns corresponding to the unselected title, as shown in fig. 4.
As an embodiment, the title line of the electronic form may be more than one line, at this time, a line may be designated therefrom, and the title may be extracted from the cells of the designated line, as in the form shown in fig. 5, where the gray-filled line is the title line of the electronic form, the title line may be designated to extract the title from the cells of the 2 nd line, as described above, when there are n consecutive cells in the same line belonging to the same merging cell in the title line, the title is extracted from the merging cell, C2, D2 and E2 in the 2 nd line belong to the same merging cell in fig. 5, and the title "payroll" is extracted from the merging cell; f2 and G2 belong to the same merging cell from which the title "prize" is extracted. When there is a sub-cell in which one cell is a merging cell in the same column in the specified row, the title is extracted from the merging cell, and if A2 and B2 in fig. 5 are sub-cells of merging cells in the same column respectively, the title "serial number" and "name" are extracted from the merging cells respectively. The extracted titles are displayed to the user in the form of a list.
As an embodiment, the method further includes: after selecting a title to be displayed from the extracted titles, saving the selected title to be displayed as a history list screening record, so that the later repeated use is facilitated, and taking the table shown in fig. 2 as an example, the saved history list screening record can be as shown in fig. 6, and the saved history screening record can be all history screening records; the user can further manually screen all the stored history screening records, so that the finally stored history screening records can also be part of the history screening records screened by the user.
As an embodiment, the method further includes:
After extracting the title from the title row of the electronic table, searching the title containing the keyword from the extracted title through the keyword, and selecting the title to be displayed from the searched titles containing the keyword. When the number of titles is large, the method can quickly locate the required title, as shown in fig. 7. When searching the title containing the keyword from the extracted titles through the keyword, the embodiment of the invention only displays the column meeting the screening condition of the user by default, and other columns are uniformly hidden; if it is desired that the currently displayed column is not hidden and displayed with the subsequent columns satisfying the user screening criteria, this can be accomplished by providing a special function entry, as shown in FIG. 7, which provides an option of "keep columns originally displayed". After selecting a title to be displayed from the searched titles containing the keywords, when receiving an instruction for reserving a column corresponding to the displayed title (namely, the option of reserving the column displayed originally is checked), displaying the title indicated by the instruction while searching the title containing the new keywords from the extracted titles through the new keywords next time.
A specific example is given below for illustration:
such as the form header includes: a first quarter goal, a first quarter sales, a first quarter completion rate, a first quarter growth rate, a second quarter goal, a second quarter sales, a second quarter completion rate, a second quarter growth rate; screening with keyword 'sales' for the first time to obtain the required columns: a first quarter sales, a second quarter sales; next, hope to display the column containing 'growth rate' again on the basis of original screening result, at this time, we can pick up 'keep the column originally displayed', continue to screen with the keyword 'growth rate' to get the required column: the first quarter sales, the first quarter growth rate, the second quarter sales and the second quarter growth rate are in a non-hooking state, and if the function of reserving the original displayed column is required to be continuously started subsequently, the option of reserving the original displayed column can be hooked again; if the required columns are obtained by screening with the keyword sales for the first time, the columns which are reserved and displayed originally are not checked, and the columns obtained by screening with the keyword growth rate are as follows: the first quarter rate of increase, the second quarter rate of increase, are inconsistent with the desired result.
As an embodiment, the method further includes:
And receiving a locking instruction for the designated column through the set column locking entry, and simultaneously displaying the locked column when displaying the column corresponding to the selected title. As shown in fig. 8, the columns corresponding to the two titles of "date" and "item name" may be locked in the title list, and cannot be unchecked, and when the selected column is displayed, the columns corresponding to "date" and "item name" are always displayed regardless of whether there are other unchecked columns or how the other unchecked columns change.
The embodiment of the invention can automatically and conveniently screen the columns to be displayed in the electronic form.
The embodiment of the invention also provides a system for screening columns in a spreadsheet, as shown in FIG. 9, the system comprises:
An extraction module 901 for extracting a title from a spreadsheet title line;
A selection module 902, configured to select a title to be displayed from the extracted titles;
the display module 903 is configured to display a column corresponding to a selected title and hide a column corresponding to an unselected title.
As an embodiment, the extracting module 901, configured to extract a title from a spreadsheet title line, includes: extracting a title from cells of a title row of the electronic form, extracting the title from the merging cells when n cells in the title row are subordinate to the same merging cells, wherein n is an integer greater than or equal to 2, as shown in the detailed data table of each item access condition in figure 2, the title line of the electronic form is extracted from the cells of the line, and the title is 'the number of first-level page clicks and the number of detailed page clicks of the first-level page clicks of the number of the display people of the date item name channel daily display times and the number of the detailed page clicks of the number of the display people of the number of the date item name channel daily display times'. Wherein, the two cells D3 and E3 belong to the same merging cell, and the title is extracted from the merging cell; the extracted titles may be displayed to the user in the form of a list, as shown in fig. 3. When the title line of the electronic form is more than one line, extracting the title from the cells of the appointed line, as shown in a table in fig. 5, wherein the gray filled line is 3 lines in total, the title can be appointed to be extracted from the cells of the 2 nd line, when the same line exists in the title line and n continuous cells belong to the same merging cell, extracting the title from the merging cell, and C2, D2 and E2 of the 2 nd line belong to the same merging cell in fig. 5, extracting the title 'wage' from the merging cell; f2 and G2 belong to the same merging cell from which the title "prize" is extracted. When there is a sub-cell in which one cell is a merging cell in the same column in the specified row, the title is extracted from the merging cell, and if A2 and B2 in fig. 5 are sub-cells of merging cells in the same column respectively, the title "serial number" and "name" are extracted from the merging cells respectively.
As an implementation manner, the selection module 902 may be configured to select, according to a received external instruction, a title to be displayed from the extracted titles, as shown in fig. 3, and the title "the number of first-level page clicks of date item name channel day display people" in the selection list is the title to be displayed.
Fig. 4 is a schematic diagram of the column after display by the display module 903.
As an embodiment, the apparatus further comprises:
And the title saving module is used for saving the title to be displayed selected by the selecting module 902 as a history column screening record, so that the later repeated use is facilitated. The history record saved by the title saving module can be displayed to the user, taking the table shown in fig. 2 as an example, the saved history column filtering record can be as shown in fig. 6, and the saved history filtering record can be all the history filtering records; the user can further manually screen all the stored history screening records, so that the finally stored history screening records can also be part of the history screening records screened by the user.
As an embodiment, the apparatus further comprises:
A search module for searching for a title containing a keyword from among the titles extracted by the extraction module 901 through the keyword; a selection module 902, configured to select a title to be displayed from the searched titles including the keyword; the display module 903 is further configured to display a title including the keyword to be displayed after the selection. When the number of titles is large, the method can quickly locate the required title, as shown in fig. 7. As one implementation, the search module also supports the function of setting whether to retain columns that have been displayed otherwise. After selecting a title to be displayed from the searched titles containing the keywords, when the search module receives an instruction for reserving a column corresponding to the displayed title, the title indicated by the instruction is displayed while searching for the title containing the new keywords from the extracted titles through the new keywords next time.
As an embodiment, the apparatus further comprises:
The column locking module is used for receiving a locking instruction for a designated column through a set column locking entry; and the display module is also used for displaying the locked column at the same time when displaying the column corresponding to the selected title. As shown in fig. 8, the columns corresponding to the two titles of "date" and "item name" may be locked in the title list, and cannot be unchecked, and when the selected column is displayed, the columns corresponding to "date" and "item name" are always displayed regardless of whether there are other unchecked columns or how the other unchecked columns change.
The embodiment of the invention can automatically and conveniently screen the columns to be displayed in the electronic form.
The embodiment of the invention also provides a terminal for screening columns in the electronic form, which comprises the following steps:
a memory for storing computer executable instructions;
a processor for executing the computer-executable instructions to perform the steps of the method of screening columns in a spreadsheet as described in the previous embodiments.
Embodiments of the present invention also provide a computer-readable storage medium storing computer-executable instructions that, when executed by a processor, implement the steps of the method of screening columns in a spreadsheet as described in the previous embodiments.
Those of ordinary skill in the art will appreciate that all or some of the steps, systems, functional modules/units in the apparatus, and methods disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between the 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 cooperatively by several physical components. 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 both 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 known to those skilled 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 be accessed by a computer. Furthermore, as is well known to those of ordinary skill in the art, 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.
Claims (8)
1. A method of screening columns in a spreadsheet comprising:
Extracting titles from the spreadsheet title lines, wherein the extracted titles are individually displayed in a list form;
selecting a title to be displayed in the electronic form from a list containing the extracted title;
Displaying columns corresponding to the selected titles in the electronic table, and hiding columns corresponding to unselected titles;
wherein the extracting the title from the spreadsheet title line comprises:
When the spreadsheet header line is more than one line, extracting a header from the cells in which the line is specified;
When n continuous cells exist in the same row and belong to the same merging cell, extracting a title from the merging cell, wherein n is an integer greater than or equal to 2.
2. The method of screening columns in a spreadsheet of claim 1, wherein extracting a header from a cell of a specified row comprises:
When a sub-cell exists in a given row in which one cell is a co-column merged cell, a title is extracted from the merged cell.
3. The method of screening columns in a spreadsheet of claim 1, wherein the method further comprises:
And after selecting the title to be displayed in the electronic table from the list containing the extracted title, saving the title selected to be displayed in the electronic table as a history list screening record.
4. The method of screening columns in a spreadsheet of claim 1, wherein the method further comprises:
and receiving a locking instruction for a designated column through a set column locking entry, and simultaneously displaying the locked column when the column corresponding to the selected title is displayed in the electronic table.
5. The method of screening columns in a spreadsheet of claim 1, wherein the method further comprises:
after extracting a title from a title row of the electronic form, searching the title containing the keyword from the extracted title through the keyword;
Selecting a title to be displayed in the electronic form from a list containing extracted titles, comprising:
and selecting a title to be displayed in the electronic table from the searched titles containing the keywords.
6. The method of screening columns in a spreadsheet of claim 5, wherein the method further comprises:
After selecting a title to be displayed in the electronic table from the searched titles containing the keywords, when receiving an instruction for reserving a column corresponding to the displayed title, displaying the title indicated by the instruction while searching for the title containing the new keywords from the extracted titles through the new keywords next time.
7. A terminal for screening columns in a spreadsheet comprising:
a memory for storing computer executable instructions;
A processor for executing the computer-executable instructions to perform the steps of the method of screening columns in a spreadsheet as claimed in any one of claims 1 to 6.
8. A computer-readable storage medium storing computer-executable instructions which, when executed by a processor, implement the steps of the method of screening columns in a spreadsheet of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811174806.7A CN111104780B (en) | 2018-10-09 | 2018-10-09 | Method and terminal for screening columns in electronic form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811174806.7A CN111104780B (en) | 2018-10-09 | 2018-10-09 | Method and terminal for screening columns in electronic form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111104780A CN111104780A (en) | 2020-05-05 |
| CN111104780B true CN111104780B (en) | 2024-06-11 |
Family
ID=70417963
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811174806.7A Active CN111104780B (en) | 2018-10-09 | 2018-10-09 | Method and terminal for screening columns in electronic form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111104780B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112989776A (en) * | 2021-03-03 | 2021-06-18 | 远光软件股份有限公司 | Method and device for adjusting table columns, storage medium and terminal equipment |
| CN114492348A (en) * | 2022-01-25 | 2022-05-13 | 北京字跳网络技术有限公司 | Information processing method, device, terminal and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
| CN101763348A (en) * | 2008-12-26 | 2010-06-30 | 英业达股份有限公司 | Dynamic table type data acquisition system and method |
| CN102929855A (en) * | 2012-09-27 | 2013-02-13 | 珠海金山办公软件有限公司 | Method for exporting screening result from spreadsheet and terminal |
-
2018
- 2018-10-09 CN CN201811174806.7A patent/CN111104780B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101211334A (en) * | 2006-12-28 | 2008-07-02 | 珠海金山软件股份有限公司 | Device and method for positioning unit grid position in electronic form designated area |
| CN101763348A (en) * | 2008-12-26 | 2010-06-30 | 英业达股份有限公司 | Dynamic table type data acquisition system and method |
| CN102929855A (en) * | 2012-09-27 | 2013-02-13 | 珠海金山办公软件有限公司 | Method for exporting screening result from spreadsheet and terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111104780A (en) | 2020-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10062415B2 (en) | Synchronizing audio and video components of an automatically generated audio/video presentation | |
| US20060224568A1 (en) | Automatically displaying fields that were non-displayed when the fields are filter fields | |
| US8484108B2 (en) | Tracking entities during identity resolution | |
| US20160012016A1 (en) | Data Visualization Methods, Data Visualization Devices, Data Visualization Apparatuses, and Articles of Manufacture | |
| CN107808306B (en) | Business object segmentation method based on tag library, electronic device and storage medium | |
| US20120016879A1 (en) | Systems and methods of user interface for image display | |
| CN111104780B (en) | Method and terminal for screening columns in electronic form | |
| US11462002B2 (en) | Wallpaper management method, apparatus, mobile terminal, and storage medium | |
| US8954838B2 (en) | Presenting data in a tabular format | |
| US20130091412A1 (en) | Representation of data records in graphic tables | |
| CN111950241B (en) | Method, system, terminal and storage medium for displaying form data | |
| CN113688150B (en) | Keyword searching method and device, electronic equipment and storage medium | |
| CN110866380A (en) | Method and terminal for filling in information field content | |
| WO2021028891A1 (en) | Scalable interactive data collection system | |
| US7882117B1 (en) | First normal form (1NF) data normalizer | |
| CN113064605B (en) | Configuration-based multi-data card automatic identification and unloading method | |
| US20140222480A1 (en) | Test scheduling | |
| CN112507673B (en) | Method and device for editing form, computer storage medium and terminal | |
| US20110138335A1 (en) | Thin analytics for enterprise mobile users | |
| JPH0877328A (en) | Map data retrieval method | |
| CN112817499B (en) | Schedule display method and device, storage medium and electronic equipment | |
| CN117009344A (en) | Data table processing method, device, storage medium and equipment | |
| CN106294802A (en) | The grasping means of voice data and system | |
| CN111291237A (en) | Data information management method and device | |
| CN111563217A (en) | Method and device for managing information in webpage |
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 |