CN112486375A - Method and device for screening and displaying in table software - Google Patents
Method and device for screening and displaying in table software Download PDFInfo
- Publication number
- CN112486375A CN112486375A CN202011517972.XA CN202011517972A CN112486375A CN 112486375 A CN112486375 A CN 112486375A CN 202011517972 A CN202011517972 A CN 202011517972A CN 112486375 A CN112486375 A CN 112486375A
- Authority
- CN
- China
- Prior art keywords
- character
- frame
- cell
- screening
- screened
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The invention discloses a method for screening and displaying in table software, which comprises the following steps: monitoring the use condition of table software in real time; when the table software is monitored to start a screening function, acquiring character contents in each cell to be screened and a first maximum character quantity simultaneously displayed in each row supported by a screening frame of the table software; and generating a suspension frame on the screening frame, and displaying the acquired character content in each cell to be screened in the suspension frame, wherein the second maximum character quantity simultaneously displayed in each row supported by the suspension frame is larger than the first maximum character quantity. The method can enlarge the quantity of characters displayed by each line when the table software screens the cells, so as to reduce the use of the transverse scroll bars, and facilitate the user to check the character contents in each cell to be screened when the user screens the cells. The invention also discloses a device for screening and displaying in the table software.
Description
Technical Field
The invention relates to the field of office software, in particular to a method and a device for screening and displaying in table software.
Background
The spreadsheet is an office software for making electronic forms, and common forms are Microsoft Excel from Microsoft corporation and WPS form from Jinshan corporation.
Existing form software is provided with a screening function to screen character contents in cells, as shown in fig. 1, when screening is performed, the form software pops up a screening frame, and the character contents in the cells to be screened are displayed in the screening frame for a user to check.
However, the size of the filter box is fixed and small, the character contents in some cells are more than the maximum character amount that can be displayed in each row of the filter box, so that the character contents in the cells cannot be completely displayed in the filter box, at this time, a user can only completely check the character contents in the cells by dragging the horizontal scroll bar, and when the character contents in the cells exceed dozens of characters or more, dragging the horizontal scroll bar becomes very inconvenient.
Disclosure of Invention
In order to solve the defects of the prior art, the invention provides a method and a device for screening and displaying in table software, which can enlarge the quantity of characters displayed in each row when the table software screens cells, so as to reduce the use of a horizontal scroll bar, and facilitate a user to check the character content in each cell to be screened when the user screens the cells.
The technical problem to be solved by the invention is realized by the following technical scheme:
a method for screening and displaying in table software comprises the following steps:
monitoring the use condition of table software in real time;
when the table software is monitored to start a screening function, acquiring character contents in each cell to be screened and a first maximum character quantity simultaneously displayed in each row supported by a screening frame of the table software;
and generating a suspension frame on the screening frame, and displaying the acquired character content in each cell to be screened in the suspension frame, wherein the second maximum character quantity simultaneously displayed in each row supported by the suspension frame is larger than the first maximum character quantity.
Further, before generating a suspension frame on the filtering frame and displaying the acquired character content in each cell to be filtered in the suspension frame, the method further includes:
and counting and comparing the character quantity of each cell to be screened according to the character content in each cell to be screened to obtain the required maximum character quantity, and executing the next step if the required maximum character quantity is larger than the first maximum character quantity.
Further, if the required maximum character amount is smaller than the first maximum character amount, no further steps are performed.
Further, the method for statistically comparing the character quantity of each cell to be screened to obtain the required maximum character quantity comprises the following steps: the method comprises the steps of firstly counting the character quantity occupied by the character content in each cell to be screened, then comparing the character quantity of each cell to be screened obtained through counting, and taking the maximum character quantity as the required maximum character quantity.
Further, the character content in each cell to be filtered is self-aligned in the floating frame.
Further, the second maximum character amount is not less than the required maximum character amount.
Furthermore, the screening frame comprises a display area, and the display area is used for displaying the character content in each cell to be screened; the size of the suspension frame is larger than that of the display area, so that the suspension frame can cover the display area in a stacked mode.
Furthermore, the screening frame also comprises a selection frame, and the selection frame corresponds to the character content in each cell to be screened in the display area; and the character content in each cell to be screened in the suspension frame is aligned with the corresponding selection frame in the screening frame.
Further, a new selection frame is generated in the floating frame, and the new selection frame is aligned with the corresponding character content in the floating frame.
The device for screening and displaying in the table software comprises a processor and a memory connected with the processor, wherein a computer program executed by the processor is stored in the memory, and the method for screening and displaying in the table software is carried out when the processor executes the computer program.
The invention has the following beneficial effects: the method displays the character content in each cell to be screened in a mode of generating a suspension frame when the form software starts a screening function, and the second maximum character quantity simultaneously displayed in each line supported by the generated suspension frame is larger than the first maximum character quantity of the screening frame, so that the character quantity displayed in each line when the form software screens the cells can be enlarged, the use of a transverse scroll bar is reduced, and a user can conveniently check the character content in each cell to be screened when the user screens the cells.
Drawings
FIG. 1 is a diagram illustrating a screening process performed by a conventional spreadsheet;
FIG. 2 is a block diagram of the steps of a method for performing screening display in the form software according to the present invention;
fig. 3 is a schematic diagram illustrating screening of table software provided by the present invention.
Detailed Description
The present invention will be described in detail below with reference to the accompanying drawings and examples.
Example one
As shown in fig. 2, a method for performing screening presentation in table software includes the following steps:
step 101: and monitoring the use condition of the table software in real time.
In this step 101, the usage situation refers to the operation instructions being executed by the form software running in the computer or other intelligent devices, such as: opening software, inputting character content, combining cells, closing software and other operation instructions.
The form software in the present application is not limited to general form software such as Microsoft Excel of Microsoft corporation and WPS form of jinshan corporation, but may also be form software specifically used in some industries, such as financial software and management software integrated with form function.
Step 102: when it is monitored that the form software starts a screening function, the character content in each cell to be screened and the first maximum character quantity simultaneously displayed in each row supported by the screening frame of the form software are obtained.
The existing table software generally provides two screening functions of screening by rows and screening by columns, wherein the screening by rows refers to screening character contents in a certain row of cells, then displaying one or more columns of cells corresponding to one or more screened cells, and hiding the other columns of cells corresponding to the cells which are not screened; the column-based screening refers to screening the character content in a certain column of cells, then displaying one or more rows of cells corresponding to one or more screened cells, and hiding the rest rows of cells corresponding to the cells which are not screened.
As shown in fig. 1, in the prior art, when a screening function is started, a screening frame pops up on a software interface of the form software, the screening frame has a display area, the display area displays character contents in each cell to be screened, and the character contents in each cell to be screened are self-aligned in the display area and are correspondingly provided with a selection frame for a user to select; when the character content in a certain cell to be screened exceeds the first maximum character amount of each line of the simultaneously displayed cells supported by the display area for a long time, the user needs to drag the transverse scroll bar positioned below the display area to completely check the character content in the cell to be screened.
The content of the characters referred to in this application includes, but is not limited to, numbers, Chinese, English, symbols, and other language characters.
Step 103: and counting and comparing the character quantity of each cell to be screened according to the character content in each cell to be screened to obtain the required maximum character quantity, if the required maximum character quantity is less than the first maximum character quantity, no step is executed, and if the required maximum character quantity is greater than the first maximum character quantity, the next step is executed.
In step 103, counting the character amount occupied by the character content in each cell to be screened, comparing the counted character amount of each cell to be screened, and taking the maximum character amount as the required maximum character amount; if the required maximum character amount is smaller than the first maximum character amount, the character content in each cell to be screened is short, the character content in each cell to be screened can be completely displayed without dragging a transverse scroll bar in the display area of the existing screening frame, and therefore any step is not executed; if the required maximum character amount is larger than the first maximum character amount, it indicates that the character content in at least one cell to be screened is relatively long, and the character content can be completely checked only by dragging the horizontal scroll bar in the display area of the existing screening box, so that the next step 104 is executed.
Step 104: as shown in fig. 3, a suspension frame is generated on the filtering frame, and the acquired character content in each cell to be filtered is displayed in the suspension frame, where a second maximum character amount simultaneously displayed in each line supported by the suspension frame is greater than the first maximum character amount.
In this step 104, the character content in each cell to be filtered is self-aligned in a line in the floating frame, and preferably, the second maximum character amount is not less than the required maximum character amount, so that each line in the floating frame can completely display the character content in the corresponding cell to be filtered without dragging the horizontal scroll bar.
The size of the suspension frame is larger than that of the display area, so that the suspension frame can be overlapped to shield the display area, character contents in each cell to be screened in the suspension frame are aligned with corresponding selection frames in the screening frame, and a user can check the corresponding character contents in the suspension frame through the selection frames of the screening frame.
Of course, a new selection frame may also be generated in the suspension frame, and the new selection frame is aligned with the corresponding character content in the suspension frame for the user to select, and at this time, the suspension frame may be stacked and shielded together with the original selection frame of the screen frame.
The scheme can be used for completing a series of steps of monitoring an operation instruction, acquiring character content, calculating the required maximum character quantity and the first maximum character quantity and the like for the table software in a plug-in implantation mode, a source code modification mode or a desktop image recognition mode and the like.
The method displays the character content in each cell to be screened in a mode of generating a suspension frame when the form software starts a screening function, and the second maximum character quantity simultaneously displayed in each line supported by the generated suspension frame is larger than the first maximum character quantity of the screening frame, so that the character quantity displayed in each line when the form software screens the cells can be enlarged, the use of a transverse scroll bar is reduced, and a user can conveniently check the character content in each cell to be screened when the user screens the cells.
Example two
The device for screening and displaying in table software comprises a processor and a memory connected with the processor, wherein a computer program for the processor to execute is stored in the memory, and when the processor executes the computer program, the method for screening and displaying in table software is performed.
The above-mentioned embodiments only express the embodiments of the present invention, and the description is more specific and detailed, but not understood as the limitation of the patent scope of the present invention, but all the technical solutions obtained by using the equivalent substitution or the equivalent transformation should fall within the protection scope of the present invention.
Claims (10)
1. A method for screening and displaying in table software is characterized by comprising the following steps:
monitoring the use condition of table software in real time;
when the table software is monitored to start a screening function, acquiring character contents in each cell to be screened and a first maximum character quantity simultaneously displayed in each row supported by a screening frame of the table software;
and generating a suspension frame on the screening frame, and displaying the acquired character content in each cell to be screened in the suspension frame, wherein the second maximum character quantity simultaneously displayed in each row supported by the suspension frame is larger than the first maximum character quantity.
2. The method as claimed in claim 1, wherein before generating a floating frame on the filtering frame and displaying the acquired character contents in each cell to be filtered in the floating frame, the method further comprises:
and counting and comparing the character quantity of each cell to be screened according to the character content in each cell to be screened to obtain the required maximum character quantity, and executing the next step if the required maximum character quantity is larger than the first maximum character quantity.
3. The method of claim 2, wherein if the maximum required character size is less than the first maximum character size, no further steps are performed.
4. The method for screening and displaying in form software according to claim 2, wherein the method for statistically comparing the character quantity of each cell to be screened to obtain the required maximum character quantity comprises: the method comprises the steps of firstly counting the character quantity occupied by the character content in each cell to be screened, then comparing the character quantity of each cell to be screened obtained through counting, and taking the maximum character quantity as the required maximum character quantity.
5. The method for filtering presentation in table software according to claim 1, wherein the character content in each cell to be filtered is self-aligned in the floating frame.
6. The method for performing screening presentation in spreadsheet software as claimed in claim 1, wherein said second maximum character size is not less than said desired maximum character size.
7. The method for filtering and displaying in table software according to claim 1, wherein the filtering box includes a display area for displaying the character content in each cell to be filtered; the size of the suspension frame is larger than that of the display area, so that the suspension frame can cover the display area in a stacked mode.
8. The method for filtering and displaying in table software according to claim 7, wherein the filtering frame further includes a selection frame corresponding to the character content in each cell to be filtered in the display area; and the character content in each cell to be screened in the suspension frame is aligned with the corresponding selection frame in the screening frame.
9. The method as claimed in claim 1, wherein a new selection box is generated in the floating frame, and the new selection box is aligned with the corresponding character content in the floating frame.
10. An apparatus for performing screening presentation in table software, comprising a processor and a memory connected to the processor, wherein the memory stores a computer program for the processor to execute, and when the processor executes the computer program, the method for performing screening presentation in table software according to any one of claims 1 to 9 is performed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011517972.XA CN112486375A (en) | 2020-12-21 | 2020-12-21 | Method and device for screening and displaying in table software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011517972.XA CN112486375A (en) | 2020-12-21 | 2020-12-21 | Method and device for screening and displaying in table software |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112486375A true CN112486375A (en) | 2021-03-12 |
Family
ID=74914969
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011517972.XA Pending CN112486375A (en) | 2020-12-21 | 2020-12-21 | Method and device for screening and displaying in table software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112486375A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115129199A (en) * | 2022-06-21 | 2022-09-30 | 北京字跳网络技术有限公司 | Information display method and device, electronic equipment, storage medium and program product |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678496A (en) * | 2013-11-18 | 2014-03-26 | 乐视网信息技术（北京）股份有限公司 | Method and system for adjusting screening display of search page |
| CN108090183A (en) * | 2017-12-15 | 2018-05-29 | 东软集团股份有限公司 | Filename methods of exhibiting, device and equipment |
| CN109002505A (en) * | 2018-06-29 | 2018-12-14 | 郑州云海信息技术有限公司 | A kind of display methods and relevant apparatus of target string |
| CN109446506A (en) * | 2018-11-12 | 2019-03-08 | 江苏中威科技软件系统有限公司 | A kind of method and apparatus that electronic spreadsheet table reproduces automatically |
| CN109992750A (en) * | 2017-12-29 | 2019-07-09 | 珠海金山办公软件有限公司 | Table objects screening technique, device, electronic equipment and storage medium |
| CN111190516A (en) * | 2019-12-27 | 2020-05-22 | 广东金赋科技股份有限公司 | Tabular data display method |
| WO2020187118A1 (en) * | 2019-03-18 | 2020-09-24 | 智慧芽信息科技(苏州)有限公司 | Page presentation method and apparatus |
-
2020
- 2020-12-21 CN CN202011517972.XA patent/CN112486375A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678496A (en) * | 2013-11-18 | 2014-03-26 | 乐视网信息技术（北京）股份有限公司 | Method and system for adjusting screening display of search page |
| CN108090183A (en) * | 2017-12-15 | 2018-05-29 | 东软集团股份有限公司 | Filename methods of exhibiting, device and equipment |
| CN109992750A (en) * | 2017-12-29 | 2019-07-09 | 珠海金山办公软件有限公司 | Table objects screening technique, device, electronic equipment and storage medium |
| CN109002505A (en) * | 2018-06-29 | 2018-12-14 | 郑州云海信息技术有限公司 | A kind of display methods and relevant apparatus of target string |
| CN109446506A (en) * | 2018-11-12 | 2019-03-08 | 江苏中威科技软件系统有限公司 | A kind of method and apparatus that electronic spreadsheet table reproduces automatically |
| WO2020187118A1 (en) * | 2019-03-18 | 2020-09-24 | 智慧芽信息科技(苏州)有限公司 | Page presentation method and apparatus |
| CN111190516A (en) * | 2019-12-27 | 2020-05-22 | 广东金赋科技股份有限公司 | Tabular data display method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115129199A (en) * | 2022-06-21 | 2022-09-30 | 北京字跳网络技术有限公司 | Information display method and device, electronic equipment, storage medium and program product |
| CN115129199B (en) * | 2022-06-21 | 2024-03-12 | 北京字跳网络技术有限公司 | Information display method, information display device, electronic equipment, storage medium and program product |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US4872167A (en) | Method for displaying program executing circumstances and an apparatus using the same | |
| US20200310841A1 (en) | Method and system for accessing table content in a digital image of the table | |
| US11710264B2 (en) | Multi-graph display method and computer-readable storage medium | |
| CN106909393B (en) | Display adjustment method of input method panel and mobile terminal | |
| EP2289022B1 (en) | Method and apparatus for automatically determining control elements in computer applications | |
| CN105528200A (en) | Browser tab display method and device | |
| CN112486375A (en) | Method and device for screening and displaying in table software | |
| CN107340886B (en) | Soft keyboard state determination method, device, medium and terminal | |
| JP2016162128A (en) | Display control system, graph display method and graph display program | |
| US20210157928A1 (en) | Information processing apparatus, information processing method, and program | |
| JP5122343B2 (en) | Action management system and action management method | |
| US8887077B2 (en) | Synchronized graphical and tabular performance data display | |
| CN108255916A (en) | Method, equipment, client terminal device and the electronic equipment that Webpage is presented | |
| CN113297313B (en) | Table data display method and device, electronic equipment and storage medium | |
| EP1857928A1 (en) | Resizing controls during localisation | |
| CN108304118B (en) | Screenshot method and device | |
| CN115525270A (en) | Method, system, terminal device and storage medium for rendering form page based on dragging | |
| CN107085530A (en) | Refresh the method, device and mobile terminal of application interface | |
| CN109741417B (en) | Method and device for generating graphic file, computing equipment and storage medium | |
| CN105302375A (en) | Method and system for operating intelligent terminal touch screen failure area | |
| CN112231802A (en) | Multi-window examination method and device of BIM file and computer storage medium | |
| CN111596984A (en) | List data display method | |
| CN111399836A (en) | Method and device for modifying page attribute | |
| CN110837507B (en) | Dynamic processing method, equipment and storage medium of data table | |
| CN116048699A (en) | Graph display method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210312 |