A method for implementing table functions that supports active help-seeking and real-time feedback

Abstract

The present invention proposes a method for implementing a table function that supports active help and real-time feedback, and belongs to the field of intelligent interaction technology. The method includes the following steps: S100: obtaining the user's table operation; S200: storing the operation data corresponding to the table operation into a cache stack; S300: judging whether the cache stack is full; S400: providing real-time feedback of prompt information to the user based on the operation data stored in the full cache stack; S500: judging whether the user's response to the prompt information is received; if so, writing the operation data stored in the cache stack into the operation log, clearing the cache stack, and returning to step S100. The present invention also proposes a human-computer interaction terminal and a storage medium for implementing the method. The present invention introduces real-time interactive feedback and active help functions into the operation process of the table software, which improves the convenience of the table operation while avoiding data processing blockage, and is conducive to the closed-loop update of the table software.

Description

Technical Field

[0001] The present invention belongs to the field of intelligent interaction technology, and in particular relates to a table function implementation supporting active help and real-time feedback, a human-computer interaction terminal and a computer-readable storage medium for implementing the method. Background Art

[0002] Spreadsheet software is the most common office software. Many spreadsheet software are powerful and can perform complex calculations, statistics and visualization functions. However, beginners are usually unaware of these complex functions; even if they know these functions, they may not know when to call them, which makes many functions of many office software, especially spreadsheet software, not fully utilized, resulting in low office efficiency.

[0003] At the same time, tables usually require a lot of repeated operations when used for data processing; at the same time, different users will customize various shortcut operations for the same set of data processing. In order to improve the efficiency of table operations, existing table operation software itself also provides corresponding shortcut operation buttons. However, on the one hand, most of the time, ordinary users cannot quickly master these shortcut operations; on the other hand, the operation attributes provided by the table operation software itself are mostly expressed in English or mixed languages, which makes it impossible for users to accurately find their meanings, thereby reducing the efficiency of table operations.

[0004] In addition, even if the functions of spreadsheet software are becoming more and more complete, users' demands are also increasing, and the functions provided by existing spreadsheet software may not meet users' actual needs.

[0005] Therefore, how to give auxiliary prompts in a timely manner according to the user's operating habits during office processing, especially when using spreadsheet processing software, while not increasing the system data processing burden (which may affect the response speed of the spreadsheet processing software itself) has become a technical problem that technical personnel in this field urgently need to solve; at the same time, how to further update software functions based on user needs is also one of the difficulties in spreadsheet software development. Summary of the invention

[0006] In order to solve the above technical problems, the present invention proposes a table function implementation supporting active help-seeking and real-time feedback, a human-computer interaction terminal and a computer-readable storage medium for implementing the method.

[0007] In a first aspect of the present invention, a method for implementing a table function that supports active help-seeking and real-time feedback is provided.

[0008] Specifically, the method comprises the following steps:

[0009] S100: Obtaining the user's table operation;

[0010] S200: storing the operation data corresponding to the table operation into a cache stack;

[0011] Specifically, the acquired user table operations may be stored in the cache stack in sequence according to the operation sequence.

[0012] In the technical solution of the present invention, as one of the outstanding advantages, the storage space size of the cache stack is adjustable and has an upper limit value and a lower limit value of the storage space.

[0013] S300: Determine whether the cache stack is full, if not, return to step S100;

[0014] If yes, then execute step S400:

[0015] S400: Based on the operation data stored in the cache stack, providing prompt information to the user in real time;

[0016] S500: Determine whether a user response to the prompt information is received;

[0017] If yes, the operation data stored in the cache stack is written into the operation log, the cache stack is cleared, and the process returns to step S100.

[0018] As another advantage, if a user response to the prompt information is received, the storage space of the cache stack is reduced;

[0019] At this point, the steps also continue to include:

[0020] Determining whether the storage space of the cache stack is lower than a storage space lower limit;

[0021] If yes, follow these steps:

[0022] After obtaining the user's current form operation in real time, predict the user's next form operation;

[0023] Based on the predicted next form operation of the user, prompt information is fed back to the user in real time.

[0024] On the contrary, if no response to the prompt information from the user is received, the storage space of the cache stack is increased.

[0025] At this point, the steps also continue to include:

[0026] Determining whether the storage space of the cache stack is greater than an upper limit of the storage space;

[0027] If yes, a help control is popped up, and the help control is used to prompt the user to input help information.

[0028] In the above technical solution of the present invention, it is necessary to establish a relationship comparison table between table operation data and prompt information in advance, and the relationship comparison table can be updated.

[0029] In the relationship comparison table, one prompt information corresponds to multiple continuous table operations.

[0030] Specifically, determining whether the storage space of the cache stack is greater than an upper limit of the storage space;

[0031] If yes, a help control is popped up, wherein the help control is used to prompt the user to input help information, and the relationship comparison table is updated based on the help information.

[0032] The step S400 includes:

[0033] Acquire current table operation data from the cache stack as target table operation data;

[0034] Determine whether there is prompt information corresponding to the target table operation data in the relationship comparison table;

[0035] If yes, prompt the current user;

[0036] If not, the next table operation data is obtained from the cache stack, the next table operation data is associated with the current table operation data as the target table operation data, and the step of determining whether there is prompt information corresponding to the target table operation data in the relationship comparison table is returned to execute.

[0037] Specifically, when the cache stack is full, the table operation data that has not been currently obtained is obtained from the cache stack as the target table operation data;

[0038] Determine whether there is prompt information corresponding to the target table operation data in the relationship comparison table;

[0039] If yes, prompt the current user;

[0040] If not, obtain the next table operation data that has not been obtained from the cache stack, associate the next table operation data that has not been obtained with the currently obtained table operation data as the target table operation data, and return to execute the step of determining whether there is prompt information corresponding to the target table operation data in the relationship comparison table until all table operation data in the cache stack are obtained.

[0041] In this process, once there is prompt information corresponding to the target table operation data in the relationship comparison table, the cache stack is cleared while the current user is prompted.

[0042] To implement the above method steps, in a second aspect of the present invention, a human-computer interaction terminal is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the above steps are implemented when the processor executes the computer program.

[0043] In a fourth aspect of the present invention, a data storage medium is provided, which may be, for example, a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above steps are implemented.

[0044] The present invention introduces real-time interactive feedback and active help-seeking functions into the operation process of the spreadsheet software, which improves the convenience of spreadsheet operation while avoiding data processing blockage, and is conducive to the closed-loop update of the spreadsheet software.

[0045] Further advantages of the present invention will be further reflected in detail in the specific embodiments section in conjunction with the drawings of the specification. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0047] Figure 1 It is a flow chart of the main steps of a method for realizing a table function supporting active help and real-time feedback according to an embodiment of the present invention;

[0048] Figure 2-Figure 4 yes Figure 1 A schematic flow chart of a further preferred embodiment of the method;

[0049] Figure 5 It is a structural schematic diagram of an electronic device that implements the technical solution of the present invention DETAILED DESCRIPTION

[0050] The invention is further described below in conjunction with the accompanying drawings and specific implementation methods.

[0051] Reference Figure 1 , is a flow chart of the main steps of a method for implementing a table function that supports active help and real-time feedback according to an embodiment of the present invention.

[0052] exist Figure 1 In the method, the method includes each cycle process of steps S100-S500, which is specifically implemented as follows:

[0053] S100: Obtaining the user's table operation;

[0054] S200: storing the operation data corresponding to the table operation into a cache stack;

[0055] S300: Determine whether the cache stack is full;

[0056] If not, return to step S100;

[0057] If yes, then execute step S400:

[0058] S400: Based on the operation data stored in the cache stack, providing prompt information to the user in real time;

[0059] S500: Determine whether a user response to the prompt information is received;

[0060] If yes, the operation data stored in the cache stack is written into the operation log, the cache stack is cleared, and the process returns to step S100.

[0061] It can be seen that the embodiment of the present invention does not perform recognition for each form operation of the user, which will significantly increase the data processing pressure of the system and affect the performance of the form processing software itself.

[0062] In contrast, the present invention uses a cache stack to sequentially store multiple table operation data of the user, and performs subsequent processing only after the cache stack is full, thereby avoiding frequent data recognition and interaction.

[0063] At the same time, the above improvements of this embodiment also fully consider the actual use scenario of the form processing software itself. When operating the form processing software, a single operation itself does not have auxiliary significance, so there is no need to perform subsequent operations for a single form operation, but it is necessary to collect multiple continuous operations before identification.

[0064] In the above embodiment, the prompt information fed back in step S400 may be: prompting the current user that there is currently an available voice assistance function and prompting a voice activation instruction.

[0065] As an example of table operation, continuous table operations may be, for example, open-insert-picture-display picture address, etc.

[0066] Therefore, the plurality of table operation data stored in the cache stack may be “open-insert-picture-display picture address”.

[0067] It should be noted that various embodiments of the present invention use "stack" storage rather than queue storage or other storage methods.

[0068] This is because a stack is a first-in-last-out structure, while a queue is a first-in-first-out structure.

[0069] In the scenario of the present invention, each operation on table data needs to obtain the latest user operation, that is, the last one to enter needs to come out first. Therefore, to meet this need, the present invention adopts stack storage, which is also one of the specific improvements of the present invention for table operation itself.

[0070] Therefore, the order of data actually stored in the cache stack is "display picture address-picture-insert-open", and the order of data popped from the stack is "display picture address-picture-insert-open".

[0071] exist Figure 1 On the basis of Figure 2-Figure 4 Show Figure 1 A further preferred embodiment of the method is shown in a flow chart.

[0072] exist Figure 2 In the preferred embodiment, the steps are as follows:

[0073] S100: Obtaining the user's table operation;

[0074] S200: storing the acquired user table operations in the cache stack in sequence according to the operation sequence;

[0075] S300: Determine whether the cache stack is full, if not, return to step S100;

[0076] If yes, then execute step S400:

[0077] S400: Based on the operation data stored in the cache stack, feedback prompt information to the user in real time, and after adjusting the storage space size of the cache stack, return to step S100.

[0078] The storage space of the cache stack is adjusted based on the response to the prompt information to determine the accuracy of the current prompt information; when the prompt information is accurate, the storage space size of the cache stack is reduced; otherwise, the storage space size of the cache stack is increased.

[0079] When the accuracy is further improved, the cache space can be reduced to provide auxiliary functions more quickly; and when the accuracy is reduced, in order to avoid disturbing the user, the cache space can be increased to capture more user operations before trying to prompt.

[0080] Specifically, in Figure 2 Based on the embodiments described, see Figure 3 The further preferred embodiments are as follows:

[0081] S100: Obtaining the user's table operation;

[0082] S200: storing the acquired user table operations in the cache stack in sequence according to the operation sequence;

[0083] S300: Determine whether the cache stack is full, if not, return to step S100;

[0084] If yes, determining the target table data from the cache stack;

[0085] Determine whether there is prompt information corresponding to the target table operation data in the relationship comparison table;

[0086] If yes, the current user is prompted; otherwise, the target table data is re-determined from the cache stack and the above process is repeated;

[0087] Next, determine whether a user response to the above prompt information is received;

[0088] If yes, reduce the storage space of the cache stack and return to step S100;

[0089] If yes, the storage space of the cache stack is increased and the process returns to step S100.

[0090] As a further specific implementation, the implementation method of determining the target table data from the cache stack is as follows:

[0091] When determining the target table operation data from the current cache stack for the first time, obtaining the table operation data that has not been obtained currently (that is, the first table operation data that can be popped from the cache stack) from the cache stack as the target table operation data;

[0092] As a specific example, assume that the order of data stored in the cache stack is "display picture address-picture-insert-open", and the order of data popped from the stack is "display picture address-picture-insert-open";

[0093] At this time, the target table operation data is "display image address";

[0094] Assume that in the relationship comparison table, only the continuous table operation of "open - insert - picture - display picture address" has corresponding prompt information;

[0095] Then there is no prompt information corresponding to the target table operation data in the relationship comparison table;

[0096] At this time, the above process needs to be repeated, that is, after the first time, if the target table data needs to be re-determined from the cache stack, the next table operation data that has not been obtained is obtained from the cache stack, and the next table operation data that has not been obtained is associated with the currently obtained table operation data as the target table operation data.

[0097] At this time, the target table operation data is "Picture-Display Picture Address";

[0098] The above steps are executed in a loop until the target table operation data is determined to be "Open - Insert - Picture - Display Picture Address".

[0099] As an example, the current user can be prompted through a pop-up window with a certain transparency that there is currently a voice assistance function available, and the continuous form operation of "open-insert-picture-display picture address" can be called through voice input. The activation password called by voice input is "activate insert picture".

[0100] The user may respond to the above prompt information by actively clicking on the pop-up window within a predetermined time period;

[0101] Of course, if the user does not click on the pop-up window within the preset time period, it is deemed that no response to the above prompt information from the user has been received, and the pop-up window will automatically disappear after the preset time period.

[0102] As mentioned above, in the above embodiment, the storage space size of the cache stack is adjustable;

[0103] When the user clicks on the pop-up window, it means that the accuracy of the prompt is improved; otherwise, the accuracy is reduced.

[0104] At this time, when the accuracy is further improved, the cache space can be reduced to provide auxiliary functions more quickly; and when the accuracy is reduced, in order to avoid disturbing the user, the cache space can be increased to capture more user operations before trying to prompt.

[0105] As a further improvement, the cache stack has a storage space upper limit value and a storage space lower limit value.

[0106] If a response to the prompt information is received from the user, reducing the storage space of the cache stack;

[0107] At this time, see Figure 4 , the step S500 further includes:

[0108] Determining whether the storage space of the cache stack is lower than a storage space lower limit;

[0109] If yes, follow these steps:

[0110] After obtaining the user's current form operation in real time, predict the user's next form operation;

[0111] Based on the predicted next form operation of the user, prompt information is fed back to the user in real time.

[0112] In this improved embodiment, the improved effect obtained is: when the cache space reaches the lower limit value and there is still a high matching degree, the prompt is directly captured after each operation of the user, and no longer waits for the cache stack to be full, which can further improve the user experience.

[0113] If no response to the prompt information is received from the user, increasing the storage space of the cache stack;

[0114] At this time, see Figure 4 , the step S500 further includes:

[0115] Determining whether the storage space of the cache stack is greater than an upper limit of the storage space;

[0116] If yes, a help control is popped up, the help control is used to prompt the user to input help information, and the relationship comparison table is updated based on the help information;

[0117] In this improved embodiment, the improved effect obtained is: when the cache space reaches the upper limit value and still cannot match, it is necessary to update the relationship comparison table between the table operation and the prompt information in the background. At this time, the user is prompted to enter help information, and the relationship comparison table is updated based on the help information, which helps developers respond to user needs in a timely manner.

[0118] In all the above embodiments, after all the mentioned step S500, the process returns to step S100, thereby forming a closed-loop user experience and feedback.

[0119] Figure 1-Figure 4 The steps or methods and processes can be automatically implemented by computer program instructions. Figure 5 , provides an electronic device, which may be a human-computer interaction terminal, including a processor, a memory and a bus, wherein the memory is used to store a table processing program, the table processing program includes program instructions, and the processor is used to execute the program instructions stored in the computer storage medium, thereby implementing the method steps.

[0120] In another embodiment, the present invention further provides a data storage medium, such as a computer-readable storage medium (Memory), which is a memory power secondary device in a terminal power secondary device, and is used to store programs and data. It is understandable that the computer-readable storage medium here can include both the built-in storage medium in the terminal power secondary device and the extended storage medium supported by the terminal power secondary device. The computer-readable storage medium provides a storage space, which stores the operating system of the terminal. In addition, one or more instructions suitable for being loaded and executed by the processor are also stored in the storage space, and these instructions can be one or more computer programs (including program codes). It should be noted that the computer-readable storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk memory.

[0121] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0122] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

[0123] The present invention does not particularly specify the structure of some modules, which shall be subject to the contents recorded in the prior art. The prior art mentioned in the above background technology section of the present invention can be used as part of the present invention to understand the meaning of some technical features or parameters. The scope of protection of the present invention shall be subject to the contents actually recorded in the claims.

Claims

1. A method for implementing a table function that supports active help-seeking and real-time feedback, characterized in that: The method comprises the following steps: S100: Obtaining the user's table operation; S200: storing the operation data corresponding to the table operation into a cache stack; S300: Determine whether the cache stack is full, if not, return to step S100; If yes, then execute step S400: S400: Based on the operation data stored in the cache stack, providing prompt information to the user in real time; S500: Determine whether a user response to the prompt information is received; If yes, the operation data stored in the cache stack is written into the operation log, the cache stack is cleared, and the process returns to step S100.

2. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 1, characterized in that: The step S200 includes: storing the acquired user table operations in the cache stack in sequence according to the operation sequence.

3. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 1, characterized in that: Before step S100, the method further includes: Pre-establish a comparison table of the relationship between table operation data and prompt information; The step S400 includes: Acquire current table operation data from the cache stack as target table operation data; Determine whether there is prompt information corresponding to the target table operation data in the relationship comparison table; If yes, prompt the current user; If not, the next table operation data is obtained from the cache stack, the next table operation data is associated with the current table operation data as the target table operation data, and the step of determining whether there is prompt information corresponding to the target table operation data in the relationship comparison table is returned to execute.

4. A method for implementing a table function supporting active help-seeking and real-time feedback according to any one of claims 1 to 3, characterized in that: The storage space size of the cache stack is adjustable and has a storage space upper limit value and a storage space lower limit value.

5. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 4, characterized in that: The step S500 further includes: If a user response to the prompt information is received, the storage space of the cache stack is reduced.

6. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 4, characterized in that: The step S500 further includes: If no response to the prompt information is received from the user, the storage space of the cache stack is increased.

7. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 5, characterized in that: The step S500 further includes: Determining whether the storage space of the cache stack is lower than a storage space lower limit; If yes, follow these steps: After obtaining the user's current form operation in real time, predict the user's next form operation; Based on the predicted next form operation of the user, prompt information is fed back to the user in real time.

8. A method for implementing a table function supporting active help-seeking and real-time feedback as claimed in claim 6, characterized in that: The step S500 further includes: Determining whether the storage space of the cache stack is greater than an upper limit of the storage space; If yes, a help control is popped up, and the help control is used to prompt the user to input help information.

9. A human-computer interaction terminal, comprising a memory and a processor, wherein the memory stores a form processing program, and the processor executes the form processing program to implement a form function implementation method supporting active help-seeking and real-time feedback as described in any one of claims 1-8.

10. A computer-readable storage medium, storing one or more computer programs, wherein the computer programs are used to implement the method according to any one of claims 1 to 8 when executed.

Images