Table display method and device, program product and electronic equipment

By displaying the type information and statistical information of abnormal cells in the graphical user interface, the problem of inefficient form filling is solved, and rapid perception and classification display is achieved, improving the filling efficiency and user experience.

CN119067086APending Publication Date: 2024-12-03NETEASE (HANGZHOU) NETWORK CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411123918.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-15
Publication Date
2024-12-03

AI Technical Summary

Technical Problem

In the graphical user interface, after the cell verification fails when filling in the form, the user needs to check the highlighted cells one by one, resulting in inefficient filling and unable to quickly perceive the error type in the form.

Method used

By providing a graphical user interface on the terminal device, verifying the input content in the cell, determining the exception cell, and displaying exception type information in its display area. At the same time, providing exception statistics information display controls, allowing users to view exceptions through triggering operations Type information and its associated statistics.

Benefits of technology

Users can quickly locate and understand the type information of abnormal cells, improve the efficiency of table modification, and display abnormal cells through classification, simplifying unified modification of the same errors, significantly improving the filling efficiency and user experience.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119067086A_ABST
    Figure CN119067086A_ABST
Patent Text Reader

Abstract

The invention provides a table display method and device, a program product and electronic equipment, and relates to the technical field of computers. The table display method comprises the steps that input content in cells is verified, and under the condition that verification of the input content in the cells fails, the cells which fail in verification are determined as abnormal cells; obtaining abnormal type information of the abnormal cell, displaying content prompt information corresponding to the abnormal type information in a display area of the abnormal cell, and providing an abnormal statistical information display control in the graphical user interface; and in response to a trigger operation for the abnormal statistical information display control, displaying abnormal type information existing in the to-be-checked table and statistical information of abnormal cells associated with each kind of abnormal type information in the graphical user interface. The form filling efficiency is improved, and the user experience is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular to a table display method, a table display device, a computer program product, and an electronic device. Background Art

[0002] In graphical user interfaces, such as web pages, tables are often used to visualize input boxes so that multiple input boxes can be neatly arranged in the interface.

[0003] In the related art, when a cell in a table fails to be verified, the cell that fails to be verified is highlighted, and a global prompt box pops up to inform the user that the form content does not meet the content requirements. However, this method requires the user to check the highlighted cells one by one to modify the filled content, and cannot quickly perceive the error type currently existing in the table, resulting in low efficiency in form filling. Summary of the invention

[0004] The present disclosure provides a form display method, a form display device, a computer program product and an electronic device, thereby improving the problem of low form filling efficiency at least to a certain extent.

[0005] Other features and advantages of the present disclosure will become apparent from the following detailed description, or may be learned in part by the practice of the present disclosure.

[0006] According to a first aspect of the present disclosure, a table display method is provided, wherein a graphical user interface is provided through a terminal device, the graphical user interface at least displays a table to be verified, the table to be verified includes one or more cells, and the method includes: verifying input content in the cell, and in a case where the input content verification of the cell fails, determining the cell that fails the verification as an abnormal cell; obtaining abnormal type information of the abnormal cell, and displaying content prompt information corresponding to the abnormal type information in a display area of ​​the abnormal cell, and providing an abnormal statistical information display control in the graphical user interface; in response to a trigger operation on the abnormal statistical information display control, displaying the abnormal type information existing in the table to be verified and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface.

[0007] According to a second aspect of the present disclosure, a table display device is provided, which provides a graphical user interface through a terminal device, wherein the graphical user interface at least displays a table to be verified, and the table to be verified includes one or more cells, and the device includes: an abnormal cell determination module, configured to verify the input content in the cell, and in the case that the input content in the cell fails to be verified, the cell that fails to be verified is determined as an abnormal cell; an abnormal type information acquisition module, configured to obtain abnormal type information of the abnormal cell, and display content prompt information corresponding to the abnormal type information in a display area of ​​the abnormal cell, and provide an abnormal statistical information display control in the graphical user interface; a statistical information display module, configured to display the abnormal type information existing in the table to be verified and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface in response to a trigger operation on the abnormal statistical information display control.

[0008] According to a third aspect of the present disclosure, a computer program is provided, which, when executed by a processor, implements the table display method of the first aspect and possible implementation methods thereof.

[0009] According to a fourth aspect of the present disclosure, an electronic device is provided, comprising: a processor; and a memory for storing executable instructions of the processor, wherein the processor is configured to execute the table display method of the first aspect and possible implementation thereof by executing the executable instructions.

[0010] The technical solution disclosed in this disclosure has the following beneficial effects:

[0011] On the one hand, the abnormal type information is displayed in the display area of ​​the abnormal cell, so that the user can quickly locate the abnormal cell and obtain the abnormal type information of the abnormal cell. Compared with the prior art, it realizes the rapid perception of the abnormal type information currently existing in the table, and improves the modification efficiency of the table. On the other hand, while the abnormal type information is displayed in the display area of ​​the abnormal cell, an abnormal statistical information display control is provided, so that the user can trigger the abnormal statistical information display control, the abnormal type information currently existing in the table, and the statistical information of the abnormal cells associated with the abnormal type information, and realize the classification and display of abnormal cells according to the abnormal type information, which provides the possibility for users to uniformly modify abnormal cells with the same abnormal type information, further improves the modification efficiency of the table, and improves the user experience.

[0012] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] The accompanying drawings herein are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the specification are used to explain the principles of the present disclosure. Obviously, the accompanying drawings described below are only some embodiments of the present disclosure, and for ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without creative work.

[0014] Figure 1 The system operation architecture of this exemplary embodiment is shown;

[0015] Figure 2 A flowchart showing a table display method in this exemplary embodiment is shown;

[0016] Figure 3 A schematic diagram showing a graphical user interface including a table to be checked and an abnormal statistical information display control in this exemplary embodiment is shown;

[0017] Figure 4 A schematic diagram showing a statistical information and abnormal detail viewing control of an abnormal cell in this exemplary embodiment;

[0018] Figure 5 A flowchart showing a method for generating an abnormal cell list in this exemplary embodiment;

[0019] Figure 6 A schematic diagram showing an abnormal cell list in this exemplary embodiment;

[0020] Figure 7A to Figure 7C The schematic diagrams of only three display positions of abnormal cell controls are shown in this exemplary embodiment respectively;

[0021] Figure 8 A schematic structural diagram of a table display device in this exemplary embodiment is shown;

[0022] Fig. 9 A schematic structural diagram of an electronic device in this exemplary embodiment is shown. DETAILED DESCRIPTION

[0023] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as being limited to the examples set forth herein; on the contrary, these embodiments are provided so that the present disclosure will be more comprehensive and complete, and the concepts of the example embodiments are fully conveyed to those skilled in the art. The described features, structures, or characteristics may be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced while omitting one or more of the specific details, or other methods, components, devices, steps, etc. may be adopted. In other cases, known technical solutions are not shown or described in detail to avoid obscuring various aspects of the present disclosure.

[0024] In addition, the accompanying drawings are only schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the figures represent the same or similar parts, and their repeated description will be omitted. Some of the block diagrams shown in the accompanying drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software form, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and / or processor devices and / or microcontroller devices.

[0025] In the related art, after the user completes the form filling, he needs to click OK / Submit to verify the information. Only after the verification is passed can the next operation be performed. When the cell verification in the table fails, the cell that fails the verification is highlighted, and a global prompt box pops up to inform the user that the form filling content does not meet the content requirements. However, this method requires the user to check the highlighted cells one by one to modify the filled content, resulting in low efficiency in form filling.

[0026] In view of one or more of the above problems, the exemplary embodiments of the present disclosure first provide a table display method. Figure 1 The system architecture of the operating environment of this exemplary embodiment will be described.

[0027] refer to Figure 1 As shown, the system architecture 100 may include a terminal device 110. The terminal device 110 may be an electronic device such as a smart phone, a tablet computer, a laptop computer, a desktop computer, etc. The terminal device 110 may be used to provide a graphical user interface to display the form to be verified.

[0028] The table display method in this exemplary embodiment can be executed by the terminal device 110. For example, in the application scenario of filling in web page information, the above-mentioned graphical user interface can include a web page, and the table to be checked can be used to visualize the input box to be filled in by the user, and the user can enter content in the table to be checked to fill in the information. The terminal device 110 verifies the input content in the table to be checked by executing the table display method, so as to determine the abnormal cells in the table when the input content verification of the cell fails, and display the abnormal type information in the display area of ​​the abnormal cell, and provide an abnormal statistical information display control at the same time, so that the user can view the abnormal type information currently existing in the table to be checked and the statistical information of the abnormal cells associated with the abnormal type information by triggering the abnormal statistical information display control.

[0029] As can be seen from the above, the table display method in this exemplary embodiment can be executed by the above terminal device 110. Yes, the terminal device provides a graphical user interface, which at least displays the table to be verified, and the table to be verified includes one or more cells.

[0030] Combine the following Figure 2 Describe the table display method. Figure 2 An exemplary process of the table display method is shown, including the following steps S210 to S230:

[0031] Step S210, verifying the input content in the cell, and if the input content in the cell fails to be verified, determining the cell that fails to be verified as an abnormal cell;

[0032] Step S220, obtaining abnormal type information of the abnormal cell, and displaying content prompt information corresponding to the abnormal type information in the display area of ​​the abnormal cell, and providing an abnormal statistical information display control in the graphical user interface;

[0033] Step S230, in response to the triggering operation on the abnormal statistical information display control, the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information are displayed in the graphical user interface.

[0034] Based on the above method, on the one hand, the abnormal type information is displayed in the display area of ​​the abnormal cell, so that the user can quickly locate the abnormal cell and obtain the abnormal type information of the abnormal cell. Compared with the prior art, it realizes the rapid perception of the abnormal type information currently existing in the table, and improves the modification efficiency of the table. On the other hand, while displaying the abnormal type information in the display area of ​​the abnormal cell, an abnormal statistical information display control is provided, so that the user can trigger the abnormal statistical information display control, the abnormal type information currently existing in the table, and the statistical information of the abnormal cells associated with the abnormal type information, and realize the classification and display of abnormal cells according to the abnormal type information, which provides the possibility for users to uniformly modify abnormal cells with the same abnormal type information, further improving the modification efficiency of the table and improving the user experience.

[0035] Below Figure 2 Each step in the procedure is described in detail.

[0036] refer to Figure 1 In step S210, the input content in the cell is verified. If the input content of the cell fails to be verified, the cell that fails to be verified is determined as an abnormal cell.

[0037] Among them, the above-mentioned input content is the content filled in by the user in the cell, and the above-mentioned verification refers to the format verification of the content filled in by the user to check whether the user's input content meets the filling requirements of the cell. For example, it can be checked whether the input content is empty, whether the input content has repeated words, whether the input content conforms to a specific format, such as an email format, and whether the number of words in the input content exceeds the upper limit of the number of words required by the cell, whether the input content exceeds the numerical range required by the cell, etc.

[0038] It should be noted that the verification of the input content in the cell can be performed after the input content exists in the cell, or after the user triggers the table submission control of the table to be verified, and the present disclosure does not make any special limitation on this.

[0039] Continue to refer Figure 2 In step S220, the abnormal type information of the abnormal cell is obtained, and the content prompt information corresponding to the abnormal type information is displayed in the display area of ​​the abnormal cell, and an abnormal statistical information display control is provided in the graphical user interface.

[0040] The above-mentioned exception type information is used to characterize the specific reasons why the input content in the cell fails to be verified, such as "required item verification failed", "number of words verification failed", "field name duplicated", etc. The content prompt information corresponds to the exception type information one by one, and is used to prompt the user for the content requirements of the cell, so that the user can enter the content that meets the cell requirements. For example, the content prompt information corresponding to the exception type information "required item verification failed" can be "required items must be non-empty". The abnormal statistical information display control is used for the statistical information of abnormal cells. The present disclosure does not specifically limit the display position of the abnormal statistical information display control.

[0041] For example, refer to Figure 3 As shown, Figure 3 The graphical user interface shown shows a table to be checked 310 and an abnormal prompt box 320, wherein the table to be checked 310 includes the table title information 311, content prompt information 312, and cells 313 to 316 in the table to be checked; the abnormal prompt box 320 includes an abnormal statistical information display control 321, and an abnormal prompt text 322 with an abnormal prompt icon; if the user triggers the table submission control, the cells 313 to 316 in the table to be checked 310 can be checked, and it is found that the verification of cells 313 and 315 fails, then cells 313 and 315 are determined as abnormal cells, and the abnormal type information of the abnormal cells is obtained as "mandatory item verification failed"; at this time, the abnormal cells 313 and 315 can be highlighted, and the content prompt information 312 can be suspended on the abnormal cells 313 and 315. The statistical information of the abnormal cells can also be viewed by triggering the abnormal statistical information display control 321.

[0042] In one implementation, while the content prompt information corresponding to the abnormal type information is displayed in the display area of ​​the abnormal cell, the abnormal identification information corresponding to the abnormal type information may also be displayed in the row to which the abnormal cell belongs.

[0043] Among them, the above-mentioned exception identification information is used to prompt the user which rows in the table contain abnormal cells. The present disclosure does not make any special restrictions on the specific content of the exception identification information. For example, the exception identification information may include an icon or text identification information; the exception identification information corresponding to different exception type information may be the same or different, and the present disclosure does not make any special restrictions on this; if the exception identification information corresponding to different exception type information is different, the exception identification information corresponding to all abnormal cells in the current row can be displayed in the row to which the abnormal cell belongs.

[0044] By displaying the abnormal type information corresponding to the abnormal identification information in the row to which the abnormal cell belongs, the user can be prompted which rows in the table to be checked have abnormal cells, so that the user can quickly locate the abnormal cells.

[0045] Continue to refer Figure 2 In step S230, in response to the triggering operation on the abnormal statistical information display control, the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information are displayed in the graphical user interface.

[0046] The trigger operation may include a sliding touch operation, a pressing touch operation, a gesture touch operation, a long press touch operation, a click touch operation, a drag touch operation, an air gesture operation, a double click operation, a drag operation, a key input, a floating touch operation, etc. It should be noted that the present disclosure does not specifically limit the specific form of the trigger operation.

[0047] In one embodiment, before displaying the abnormal type information in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface, the method may further include:

[0048] Get the number of abnormal cells associated with the abnormal type information in the table to be checked, and generate statistical information based on the number of abnormal cells.

[0049] That is, after the abnormal statistical information display control is triggered, the abnormal type information and the number of abnormal cells associated with it can be displayed in the graphical user interface. Figure 4 As shown, when the user triggers the abnormal statistics information display control through a trigger operation, a pop-up Figure 4 The prompt box shown, Figure 4 Includes exception type information, such as "Required field verification failed", and its associated statistical information, such as "8". Figure 4 The prompt box indicates that: there are 8 abnormal cells in the table to be verified whose verification failed because "required field verification failed", there are 4 abnormal cells in the table to be verified whose verification failed because "field verification failed", and there are 3 abnormal cells in the table to be verified whose verification failed because "field name is repeated".

[0050] In one embodiment, while displaying the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface, the above method may also include:

[0051] An exception detail viewing control is provided in the graphical user interface. In response to a trigger operation on the exception detail viewing control, an exception cell list is displayed; the exception cell list includes exception type information existing in the table to be checked, and a list of abnormal cells associated with each exception type information.

[0052] The above-mentioned abnormal detail viewing control can be used to view the abnormal cell list. The present disclosure does not specifically limit the specific form of the abnormal detail viewing control. For example, refer to Figure 4 As shown, the exception detail viewing control can refer to that shown in 401, that is, while the user is viewing the exception type information and its corresponding statistical information, the exception detail viewing control 401 can also be provided to allow the user to further view the list of specific exception cells corresponding to each exception type information.

[0053] By showing the user a list of abnormal cells, the abnormal cells are classified and displayed according to the abnormal type information, so that the user can quickly perceive which cells have the same error cause, making it easier for the user to uniformly modify cells with the same abnormal type information, thereby improving the efficiency of table modification.

[0054] In one embodiment, an abnormal detail viewing control is provided in the graphical user interface. In response to the abnormal detail viewing control, before displaying the abnormal cell list, the method further includes:

[0055] Generate an abnormal cell list according to the position information of the abnormal cells associated with any abnormal type information.

[0056] The above-mentioned position information includes the first position information and / or the second position information, the first position information is used to describe the row number of the row to which the abnormal cell belongs in the table to be checked, and the second position information is used to describe the column number of the column to which the abnormal cell belongs in the table to be checked; the above-mentioned position information of the abnormal cell associated with any abnormal type information generates an abnormal cell list, and the reference Figure 5 As shown, steps S510 to S530 may be included:

[0057] Step S510, obtaining first position information and / or second position information of an abnormal cell associated with any abnormal type information;

[0058] Step S520, obtaining identification information of an abnormal cell associated with any abnormal type information;

[0059] Step S530: sort the identification information of the abnormal cells according to the first position information or the second position information to obtain an abnormal cell list.

[0060] That is to say, each abnormal cell in the abnormal cell list can be sorted according to its row number or column number. Among them, the above identification information may include one or more of the first position information, the second position information, and the title information of the abnormal cell. The title information is used to characterize the type of content input in the cell. For example, the title information may include "category", "name", etc.

[0061] For example, after the user submits the form to be checked, the filled-in content of each cell can be checked for abnormalities through a loop, and the abnormal type information of the cells with abnormalities, as well as the first position information, second position information, and title information of the abnormal cells are cached; in the process of generating the abnormal cell list, the abnormal type information in the cache and the first position information of the abnormal cells associated with the abnormal type information can be obtained, and the abnormal cells are sorted according to the first position information to obtain the abnormal cell list; the abnormal cell list and the abnormal type information are displayed in correspondence to obtain the abnormal cell list; illustratively, the abnormal cell list can refer to Figure 6 As shown, Figure 6 The abnormal cell list shown includes two abnormal type information and their associated abnormal cell lists; taking the first abnormal type information as an example, 601 shows the statistical information of the first abnormal type information "required item verification failed" and its associated abnormal cells, and 602 is the abnormal cell list associated with the abnormal type information, wherein the identification information stored in the abnormal cell list includes the first position information of the abnormal cell, that is, the row number of the abnormal cell, and the abnormal cells in the abnormal cell list are sorted according to the first position information.

[0062] By generating a list of abnormal cells based on the location information of abnormal cells, users can quickly perceive which abnormal cells have abnormal type information, thereby improving table modification efficiency.

[0063] In one embodiment, the abnormal cell list further includes an abnormal cell viewing control corresponding to each abnormal type information; the method may further include the following steps:

[0064] In response to a triggering operation of an abnormal cell viewing control corresponding to any abnormal type information, determining the first abnormal cell in the abnormal cell list associated with any abnormal type information as a target cell;

[0065] Slide the table to be verified to the display position of the target cell.

[0066] That is to say, reference Figure 6 As shown, the abnormal cell list includes not only the abnormal type information and its associated abnormal cell list, but also its corresponding abnormal cell viewing control; the abnormal cell viewing control is used to view the abnormal cell closest to the first row or the first column of the table to be checked among the abnormal cells associated with each abnormal type information, that is, the first abnormal cell in the abnormal cell list.

[0067] Exemplary, reference Figure 6As shown, 603 is the abnormal cell viewing control corresponding to the abnormal type information 601. When the user triggers the abnormal cell viewing control 603, the table to be checked in the graphical user interface will slide to the third row of the table to be checked, so that the third row is used as the first row of the table to be checked viewed by the user, so that the user can modify the input content in the abnormal cell.

[0068] By providing users with abnormal cell viewing controls, the speed of locating abnormal cells can be further accelerated, thereby improving the efficiency of modifying and filling abnormal cells and improving the user experience.

[0069] In one embodiment, while providing the abnormal statistical information display control, the above method may also include:

[0070] A control for displaying only abnormal cells is provided in the graphical user interface. In response to a trigger operation for the control for displaying only abnormal cells, in the graphical user interface, a display area of ​​the table to be checked only displays abnormal cells in the table to be checked.

[0071] That is, the user can trigger the display only abnormal cells control so that only abnormal cells are displayed in the graphical user interface, so that the user can quickly modify the abnormal cells with incorrect filling.

[0072] It should be noted that the present disclosure does not specifically limit the display position of only displaying abnormal cell controls. For example, Fig. 7A As shown, the abnormal cell display control 701 can be displayed in the same row as the abnormal statistical information display control 702. When the user triggers 701 again, it means that the user needs to view all cells, so all cells are displayed in the graphical user interface. Figure 3 As shown in 310; reference Figure 7B As shown, the control 703 for displaying only abnormal cells can also be displayed in the same row as the table header. Currently, all cells are displayed. When the user clicks "display only error rows" in 703, only abnormal cells are displayed in the graphical user interface; refer to Figure 7C As shown, the control 704 for showing only abnormal cells can also be displayed separately as a column of the table to be checked. When the user selects "show only error rows" in 704 and clicks "OK", only the abnormal cells are displayed in the graphical user interface. When the user clicks "Reset", all cells can be displayed in the graphical user interface.

[0073] In one embodiment, the above method may also include: verifying the input content in the cell, and if the input content verification of the cell fails, determining the cell that failed the verification as an abnormal cell; obtaining abnormal type information of the abnormal cell, and displaying content prompt information corresponding to the abnormal type information in the display area of ​​the abnormal cell; displaying the abnormal type information existing in the table to be verified in a graphical user interface, as well as the statistical information of the abnormal cells associated with each abnormal type information.

[0074] That is to say, when it is determined that there are abnormal cells in the table to be checked, the abnormal type information and the statistical information of the associated abnormal cells can also be directly displayed.

[0075] Based on the above method, it is convenient for users to quickly locate abnormal cells and modify the input content, which improves the efficiency of table modification and further improves the efficiency of table filling, thereby improving the user experience.

[0076] The exemplary embodiment of the present disclosure further provides a table display device, which provides a graphical user interface through the terminal device 110, and the graphical user interface at least displays a table to be verified, and the table to be verified includes one or more cells.

[0077] like Figure 8 As shown, the table display device 800 may include:

[0078] The abnormal cell determination module 810 is configured to verify the input content in the cell, and if the input content of the cell fails to be verified, the cell that fails to be verified is determined as an abnormal cell;

[0079] The abnormality type information acquisition module 820 is configured to acquire the abnormality type information of the abnormal cell, and display the content prompt information corresponding to the abnormality type information in the display area of ​​the abnormal cell, and provide an abnormality statistical information display control in the graphical user interface;

[0080] The statistical information display module 830 is configured to display the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface in response to the trigger operation on the abnormal statistical information display control.

[0081] In one embodiment, before displaying the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface, the above-mentioned device may further include:

[0082] Get the number of abnormal cells associated with the abnormal type information in the table to be checked, and generate statistical information based on the number of abnormal cells.

[0083] In one embodiment, while displaying the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface, the above-mentioned device may also include:

[0084] An exception detail viewing control is provided in the graphical user interface. In response to a trigger operation on the exception detail viewing control, an exception cell list is displayed; the exception cell list includes exception type information existing in the table to be checked, and a list of abnormal cells associated with each exception type information.

[0085] In one embodiment, an abnormal detail viewing control is provided in the graphical user interface. In response to the abnormal detail viewing control, before displaying the abnormal cell list, the above-mentioned device may further include:

[0086] Generate an abnormal cell list according to the position information of the abnormal cells associated with any abnormal type information.

[0087] In one embodiment, the above-mentioned position information includes first position information and / or second position information, the first position information is used to describe the row number of the row to which the abnormal cell belongs in the table to be checked, and the second position information is used to describe the column number of the column to which the abnormal cell belongs in the table to be checked; generating an abnormal cell list according to the position information of the abnormal cell associated with any abnormal type information may include:

[0088] Acquire first position information and / or second position information of an abnormal cell associated with any abnormal type information;

[0089] Obtain identification information of abnormal cells associated with any abnormal type information;

[0090] The identification information of the abnormal cells is sorted according to the first position information or the second position information to obtain an abnormal cell list.

[0091] In one implementation, the identification information includes one or more of the first position information, the second position information, and the title information of the abnormal cell.

[0092] In one embodiment, the abnormal cell list further includes an abnormal cell viewing control corresponding to each abnormal type information.

[0093] In one embodiment, the above device may further include:

[0094] In response to a triggering operation of an abnormal cell viewing control corresponding to any abnormal type information, determining the first abnormal cell in the abnormal cell list associated with any abnormal type information as a target cell;

[0095] Slide the table to be verified to the display position of the target cell.

[0096] In one embodiment, while providing the abnormal statistical information display control, the above device may also include:

[0097] A control for displaying only abnormal cells is provided in the graphical user interface. In response to a trigger operation for the control for displaying only abnormal cells, in the graphical user interface, a display area of ​​the table to be checked only displays abnormal cells in the table to be checked.

[0098] The specific details of each part of the above device have been described in detail in the implementation method part, so they will not be repeated here.

[0099] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the exemplary embodiments of the present disclosure, the features and functions of two or more modules or units described above can be embodied in one module or unit. Conversely, the features and functions of one module or unit described above can be further divided into multiple modules or units to be embodied.

[0100] The exemplary embodiments of the present disclosure further provide a computer program product, which includes a computer program. When the computer program is executed by a processor, the above table display method is implemented.

[0101] Computer programs for performing the operations of the present disclosure may be written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Java, C++, etc., and conventional procedural programming languages ​​such as "C" or similar programming languages. The computer program may be executed entirely on the user computing device, partially on the user device, as a stand-alone software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In cases involving a remote computing device, the remote computing device may be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., through the Internet using an Internet service provider).

[0102] In one embodiment, the computer program product may be an intangible product including a computer program. Exemplarily, the computer program product may be implemented as a virtual digital product, such as a digital file storing an executable file, an installation package, etc. of the computer program.

[0103] The code of the computer program can be written in one or more programming languages. Programming languages ​​such as C language, Java, C++, etc. The program code can be executed entirely on the user computing device, or partially on the user computing device, or as a separate software package, or partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, such as a local area network (LAN), a wide area network (WAN), etc., or can be connected to an external computing device (e.g., an Internet connection provided by an operator).

[0104] The computer program can be carried or transmitted by electrical, magnetic, optical, electromagnetic, infrared and other signals. The electronic device can convert the signal carrying the computer program into a digital signal, and then run the computer program. When the computer program is running on the electronic device, its code is used to make the electronic device execute (more specifically, the processor of the electronic device can be executed) the method steps of various exemplary embodiments of the present disclosure, such as the above-mentioned table display method, which includes the following steps: verifying the input content in the cell, and in the case where the input content verification of the cell fails, determining the cell that fails the verification as an abnormal cell; obtaining the abnormal type information of the abnormal cell, and displaying the content prompt information corresponding to the abnormal type information in the display area of ​​the abnormal cell, and providing an abnormal statistical information display control in the graphical user interface; in response to the triggering operation for the abnormal statistical information display control, displaying the abnormal type information in the table to be verified in the graphical user interface, and the statistical information of the abnormal cells associated with each abnormal type information.

[0105] By executing the above method steps through a computer program, on the one hand, the abnormal type information is displayed in the display area of ​​the abnormal cell, so that the user can quickly locate the abnormal cell and obtain the abnormal type information of the abnormal cell. Compared with the prior art, it realizes the rapid perception of the abnormal type information currently existing in the table, and improves the modification efficiency of the table. On the other hand, while the abnormal type information is displayed in the display area of ​​the abnormal cell, an abnormal statistical information display control is provided, so that the user can trigger the abnormal statistical information display control, the abnormal type information currently existing in the table, and the statistical information of the abnormal cells associated with the abnormal type information, realize the classification and display of abnormal cells according to the abnormal type information, and provide the possibility for users to uniformly modify abnormal cells with the same abnormal type information, further improve the modification efficiency of the table, and improve the user experience.

[0106] The exemplary embodiments of the present disclosure also provide an electronic device, such as the terminal device 110 described above. The electronic device may include a processor and a memory. The memory stores executable instructions of the processor, such as a computer program. The processor executes the method steps of various exemplary embodiments of the present disclosure by executing the executable instructions. In addition, the electronic device may also include a display for displaying a graphical user interface.

[0107] Reference below Fig. 9 , the electronic device is exemplarily described in the form of a general-purpose computing device. It should be understood that Fig. 9 The electronic device 900 shown is merely an example and should not limit the functions and scope of use of the embodiments of the present disclosure.

[0108] like Fig. 9 As shown, the electronic device 900 may include: a processor 910 , a memory 920 , a bus 930 , an I / O (input / output) interface 940 , a network adapter 950 , and a display 960 .

[0109] The processor 910 may include one or more processing units. For example, the processor 910 may include an AP (Application Processor), a modem processor, a GPU (Graphics Processing Unit), an ISP (Image Signal Processor), a controller, an encoder, a decoder, a DSP (Digital Signal Processor), a baseband processor and / or an NPU (Neural-Network Processing Unit), etc.

[0110] The processor 910 can be used to execute executable instructions stored in the memory 920, such as the above-mentioned table display method, which includes the following steps: verifying the input content in the cell, and if the input content verification of the cell fails, determining the cell that fails the verification as an abnormal cell; obtaining abnormal type information of the abnormal cell, and displaying content prompt information corresponding to the abnormal type information in the display area of ​​the abnormal cell, and providing an abnormal statistical information display control in a graphical user interface; in response to a trigger operation on the abnormal statistical information display control, displaying the abnormal type information existing in the table to be verified in the graphical user interface, and the statistical information of the abnormal cells associated with each abnormal type information.

[0111] By executing the above method steps through a computer program, on the one hand, the abnormal type information is displayed in the display area of ​​the abnormal cell, so that the user can quickly locate the abnormal cell and obtain the abnormal type information of the abnormal cell. Compared with the prior art, it realizes the rapid perception of the abnormal type information currently existing in the table, and improves the modification efficiency of the table. On the other hand, while the abnormal type information is displayed in the display area of ​​the abnormal cell, an abnormal statistical information display control is provided, so that the user can trigger the abnormal statistical information display control, the abnormal type information currently existing in the table, and the statistical information of the abnormal cells associated with the abnormal type information, realize the classification and display of abnormal cells according to the abnormal type information, and provide the possibility for users to uniformly modify abnormal cells with the same abnormal type information, further improve the modification efficiency of the table, and improve the user experience.

[0112] The memory 920 may include a volatile memory, such as a RAM 921, a cache unit 922, and may also include a non-volatile memory, such as a ROM 923. The memory 920 may also include one or more program modules 924, such program modules 924 include but are not limited to: an operating system, one or more application programs, other program modules, and program data, each of which or a combination thereof may include the implementation of a network environment. For example, the program module 924 may include each module in the above-mentioned device 800.

[0113] The bus 930 is used to realize the connection between different components of the electronic device 900, and may include a data bus, an address bus, and a control bus.

[0114] The electronic device 900 can communicate with one or more external devices 1000 (eg, a keyboard, a mouse, an external controller, etc.) through the I / O interface 940 .

[0115] The electronic device 900 can communicate with one or more networks through the network adapter 950. For example, the network adapter 950 can provide mobile communication solutions such as 3G / 4G / 5G, or provide wireless communication solutions such as wireless LAN, Bluetooth, near field communication, etc. The network adapter 950 can communicate with other modules of the electronic device 900 through the bus 930.

[0116] The electronic device 900 may display a graphical user interface through the display 960 , such as a web page interface including a form to be verified.

[0117] although Fig. 9 Not shown, other hardware and / or software modules may also be provided in the electronic device 900, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, etc.

[0118] As can be seen from the above, the technical solution of the present disclosure can be implemented as a method, an apparatus, a system, a computer program product, an electronic device, etc. Those skilled in the art can understand that various aspects of the present disclosure can be specifically implemented in the following forms, namely: a complete hardware implementation, a complete software implementation (including firmware, microcode, etc.), or an implementation combining hardware and software, such as being respectively referred to as a "circuit", "module" or "system".

[0119] It should be understood that the present disclosure is not limited to the specific method steps or structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from the scope thereof. Those skilled in the art will easily think of other embodiments based on the specific embodiments provided by the present disclosure. Therefore, the specific embodiments provided by the present disclosure are only exemplary, and the scope and spirit of the present disclosure are indicated by the claims, and any variations, uses or adaptive changes of the present disclosure should be covered, which follow the general principles of the present disclosure and include common knowledge or customary technical means in the technical field that are not disclosed in the present disclosure.

Claims

1. A table display method, characterized in that: Providing a graphical user interface through a terminal device, the graphical user interface at least displays a table to be verified, the table to be verified includes one or more cells, and the method includes: Verifying the input content in the cell, and if the input content in the cell fails to be verified, determining the cell that fails to be verified as an abnormal cell; Acquire the abnormal type information of the abnormal cell, display the content prompt information corresponding to the abnormal type information in the display area of ​​the abnormal cell, and provide an abnormal statistical information display control in the graphical user interface; In response to a trigger operation on the abnormal statistical information display control, the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each type of the abnormal type information are displayed in the graphical user interface.

2. The method according to claim 1, characterized in that Before displaying the abnormal type information existing in the table to be checked and the statistical information of abnormal cells associated with each abnormal type information in the graphical user interface, the method further includes: The number of abnormal cells associated with the abnormal type information in the table to be checked is obtained, and the statistical information is generated according to the number of abnormal cells.

3. The method according to claim 1, characterized in that: While displaying the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface, the method further includes: An exception detail viewing control is provided in the graphical user interface, and in response to a trigger operation on the exception detail viewing control, an abnormal cell list is displayed; the abnormal cell list includes the abnormal type information existing in the table to be checked, and a list of abnormal cells associated with each abnormal type information.

4. The method according to claim 3, characterized in that An abnormal detail viewing control is provided in the graphical user interface. Before displaying the abnormal cell list in response to the abnormal detail viewing control, the method further includes: The abnormal cell list is generated according to the position information of the abnormal cells associated with any of the abnormal type information.

5. The method according to claim 4, characterized in that The position information includes first position information and / or second position information, the first position information is used to describe the row number of the row to which the abnormal cell belongs in the table to be checked, and the second position information is used to describe the column number of the column to which the abnormal cell belongs in the table to be checked; The generating the abnormal cell list according to the position information of the abnormal cells associated with any one of the abnormal type information comprises: Acquire the first position information and / or the second position information of the abnormal cell associated with any abnormal type information; Obtaining identification information of an abnormal cell associated with any abnormal type information; The identification information of the abnormal cells is sorted according to the first position information or the second position information to obtain the abnormal cell list.

6. The method according to claim 5, characterized in that The identification information includes one or more of the first position information, the second position information, and the title information of the abnormal cell.

7. The method according to claim 3, characterized in that The abnormal cell list also includes an abnormal cell viewing control corresponding to each type of abnormal type information.

8. The method according to claim 7, characterized in that The method further comprises: In response to a triggering operation of the abnormal cell viewing control corresponding to any of the abnormal type information, determining the first abnormal cell in the abnormal cell list associated with any of the abnormal type information as a target cell; Slide the table to be checked to the display position of the target cell.

9. The method according to claim 1, characterized in that: While providing the abnormal statistical information display control, the method further includes: A control for displaying only abnormal cells is provided in the graphical user interface. In response to a triggering operation on the control for displaying only abnormal cells, in the graphical user interface, the display area of ​​the table to be checked only displays the abnormal cells in the table to be checked.

10. A table display device, characterized in that: A graphical user interface is provided by a terminal device, wherein the graphical user interface at least displays a table to be verified, wherein the table to be verified includes one or more cells, and the apparatus includes: an abnormal cell determination module, configured to verify the input content in the cell, and if the input content in the cell fails to be verified, determine the cell that fails to be verified as an abnormal cell; an abnormality type information acquisition module, configured to acquire the abnormality type information of the abnormal cell, display content prompt information corresponding to the abnormality type information in the display area of ​​the abnormal cell, and provide an abnormality statistical information display control in the graphical user interface; The statistical information display module is configured to display the abnormal type information existing in the table to be checked and the statistical information of the abnormal cells associated with each abnormal type information in the graphical user interface in response to the trigger operation on the abnormal statistical information display control.

11. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the method according to any one of claims 1 to 9 is implemented.

12. An electronic device, characterized in that: include: processor; A memory, configured to store executable instructions of the processor; The processor is configured to perform the method of any one of claims 1 to 9 by executing the executable instructions.