CN113268964B - Table editing method, device, equipment and storage medium - Google Patents

Table editing method, device, equipment and storage medium Download PDF

Info

Publication number
CN113268964B
CN113268964B CN202010715894.8A CN202010715894A CN113268964B CN 113268964 B CN113268964 B CN 113268964B CN 202010715894 A CN202010715894 A CN 202010715894A CN 113268964 B CN113268964 B CN 113268964B
Authority
CN
China
Prior art keywords
target
social
page
editing
users
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202010715894.8A
Other languages
Chinese (zh)
Other versions
CN113268964A (en
Inventor
何丹
何芬
孙雪君
刘立强
王军利
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN202010715894.8A priority Critical patent/CN113268964B/en
Publication of CN113268964A publication Critical patent/CN113268964A/en
Application granted granted Critical
Publication of CN113268964B publication Critical patent/CN113268964B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/01Social networking

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Business, Economics & Management (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computing Systems (AREA)
  • Economics (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Information Transfer Between Computers (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The embodiment of the application discloses a table editing method, a table editing device, equipment and a storage medium, wherein the table editing method comprises the following steps: displaying N social pages participated by users in a social application program, wherein the social pages comprise table messages, a target table is displayed in the table messages, and N is an integer greater than 1; when M users in the N users carry out collaborative editing on the target table, table contents generated by the collaborative editing are displayed in the social page in real time, wherein M is an integer larger than 1 and M is not more than N. By adopting the embodiment of the application, the collaborative editing table can be realized in the social page of the social application program, and the table content generated by collaborative editing can be displayed in the social page of the social application program in real time, so that the information collection efficiency and the statistical efficiency are improved.

Description

Table editing method, device, equipment and storage medium
Technical Field
The present application relates to the field of internet technologies, and in particular, to the field of page processing technologies, and in particular, to a form editing method, a form editing apparatus, a form editing device, and a computer-readable storage medium.
Background
Situations are often encountered in social scenarios where information and statistics need to be collected, such as collecting and counting information for individual session users in an instant messaging session page of an instant messaging session application. The ways of collecting information and statistical information in social scenarios mainly include the following two ways: the first is to collect and count information by way of online documents (e.g., online forms); the second is to collect and count information by means of offline documents (e.g., local forms). In the process, the social users need to jump from the social scene to the editing page of the application program corresponding to the online document or the local document to edit the document content, and the information collection efficiency and the statistical efficiency are low.
Disclosure of Invention
The embodiment of the application provides a form editing method, a form editing device and a storage medium, which can realize collaborative editing of a form in a social page of a social application program, display the content of the form generated by collaborative editing in the social page of the social application program in real time, and improve information collection efficiency and statistical efficiency.
In one aspect, an embodiment of the present application provides a table editing method, where the table editing method includes:
displaying N social pages participated by users in a social application program, wherein the social pages comprise table messages, a target table is displayed in the table messages, and N is an integer greater than 1;
when M users in the N users carry out collaborative editing on the target table, table contents generated by the collaborative editing are displayed in the social page in real time, wherein M is an integer larger than 1 and M is not more than N.
In another aspect, an embodiment of the present application provides a form editing apparatus, including:
the display unit is used for displaying N social pages participated by the users in the social application program, the social pages comprise table messages, target tables are displayed in the table messages, and N is an integer greater than 1;
and the processing unit is used for displaying the table content generated by the collaborative editing in real time in the social page when M users in the N users carry out the collaborative editing on the target table, wherein M is an integer larger than 1 and M is not more than N.
In one implementation, the social pages in which the N users participate include any of: the method comprises the steps of obtaining an instant messaging conversation page to which N users belong together, and obtaining a social dynamic page which is opened to the N users by any one of the N users.
In one implementation, a social page contains a table creation entry;
a processing unit further to:
when the form creation entry is selected, displaying a form configuration window in the social page, wherein the form configuration window is used for configuring the attribute data of the target form;
and when the attribute data configuration of the target form is completed, displaying the target form in the form of a form message in the social page.
In one implementation, the social page includes a message input area, the message input area includes a shortcut input area, and the form creation entry is disposed in the shortcut input area.
In one implementation, a social page includes a message entry area that includes an input box;
and the processing unit is also used for displaying a selection bar in the social page when the input box is triggered, and the table creation inlet is arranged in the selection bar.
In one implementation, the social page is an instant messaging session page to which the N users belong together, the instant messaging session page includes a message display area, the message display area is used for displaying an instant messaging message flow among the N users, and the tabular messages are displayed in the instant messaging message flow in the message display area.
In one implementation, the target table includes at least one cell, the target cell is any one cell in the target table, and the first user is any one of the M users;
and the processing unit is specifically used for displaying the table content generated by editing in the target cell when the first user edits the target cell.
In one implementation, the processing unit is further configured to:
displaying an auto fill option when the target cell is edited;
when the automatic filling option is selected, displaying an automatic filling list, wherein the automatic filling list comprises at least one type of filling information, and the target filling information is any one type of filling information in the automatic filling list;
when the target filling information is selected, filling the target cell with the target filling information.
In one implementation, the social page is an instant messaging session page to which N users belong together, and the populating information in the auto-populating list includes at least one of: user information of N users and message content in an instant messaging message stream between the N users.
In one implementation, the processing unit is further configured to:
when the target cell is edited, displaying a plurality of cell attribute options, wherein each cell attribute option is used for controlling one attribute data of the target cell;
changing the attribute data of the target cell according to the selected cell attribute option;
wherein the attribute data of the target cell includes any one of: font, font size, cell background color and cell alignment mode.
In one implementation, the processing unit is further configured to:
if the length of the table content in the target cell exceeds the accommodating space of the target cell, folding and displaying the table content in the target cell, and displaying a browsing identifier in the target cell;
and when the browsing identifier is triggered, displaying the complete table content of the target cell in the floating layer window.
In one implementation, the processing unit is further configured to, when the target table is subjected to collaborative editing, highlight the edited cell in the target table in the table message and display user information for performing editing in the edited cell.
In another aspect, an embodiment of the present application provides a form editing apparatus, including:
a processor adapted to implement computer instructions; and the number of the first and second groups,
a computer readable storage medium having stored thereon computer instructions adapted to be loaded by a processor and to execute the above-described table editing method.
In another aspect, an embodiment of the present application provides a computer-readable storage medium, which stores computer instructions, and when the computer instructions are read and executed by a processor of a computer device, the computer device is caused to execute the above table editing method.
In another aspect, embodiments of the present application provide a computer program product or a computer program, which includes computer instructions stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to execute the table editing method described above.
In the embodiment of the application, a plurality of social pages participated by users are displayed in a social application program, and a target table to be edited is displayed in the social pages in a form of table messages; when some or all users participating in the social page perform collaborative editing on the target form, the form content generated by the collaborative editing is displayed in the social page in real time; in the process, the target table displayed on the social page supports multi-user collaborative editing participating in the social page, the page skipping and the application program switching are not needed in the process of collaborative editing of the target table, table contents generated by collaborative editing are displayed in the social page of the social application program in real time, the table editing requirements of users are met, the user experience is improved, and the information collection efficiency and the statistical efficiency are improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1a is a schematic diagram of a page showing an existing collection method according to an exemplary embodiment of the present application;
FIG. 1b is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application;
FIG. 1c is a schematic view of a page showing an existing collection method according to another exemplary embodiment of the present application;
FIG. 1d is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application;
FIG. 1e is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application;
FIG. 2 illustrates an architectural diagram of a form editing system provided by an exemplary embodiment of the present application;
FIG. 3a illustrates a flow diagram of a table editing scheme provided by an exemplary embodiment of the present application;
FIG. 3b is a flow chart illustrating a table content display manner provided by an exemplary embodiment of the present application;
FIG. 4 is a flowchart illustrating a method for editing a form according to an exemplary embodiment of the present application;
FIG. 5a is a flowchart illustrating a table creation method according to an exemplary embodiment of the present application;
FIG. 5b illustrates a flowchart for automatically populating form content provided by an exemplary embodiment of the present application;
FIG. 5c is a schematic diagram illustrating a flowchart of a cell property data modification provided by an exemplary embodiment of the present application;
FIG. 5d is a flowchart illustrating a cell selection method provided by an exemplary embodiment of the present application;
FIG. 5e is a flowchart illustrating a page flip display provided by an exemplary embodiment of the present application;
FIG. 6 is a flowchart illustrating a table editing method according to another exemplary embodiment of the present application;
FIG. 7 is a diagram illustrating interaction processing logic provided by an exemplary embodiment of the present application;
fig. 8 is a schematic structural diagram of modules in a terminal according to an exemplary embodiment of the present application;
FIG. 9 is a diagram illustrating form task module processing logic provided by an exemplary embodiment of the present application;
FIG. 10 is a diagram illustrating an exemplary structure of a table editing apparatus according to an embodiment of the present application;
fig. 11 is a schematic structural diagram illustrating a table editing apparatus according to an exemplary embodiment of the present application.
Detailed description of the invention
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The embodiment of the application relates to a form, which is also called a table and is a visual communication mode, namely a means for organizing, sorting and collecting information. The form is widely applied to various scenes such as instant messaging communication, scientific research, data analysis activities and the like; such as collecting and counting information in an instant messaging application (e.g., QQ (an instant messaging application), WeChat (an instant messaging application), etc.) via a table, calculating and analyzing various pieces of statistical data via a table, etc. A table generally comprises a plurality of cells, each cell in the table may be filled with data contents such as numbers, characters, pictures and the like, and the cells in the table are organized into rows and columns. The tables may be divided into online tables (e.g., online table for Tencent document, online table for Google document, etc.) and local tables (e.g., Microsoft Office Excel (Microsoft corporation's spreadsheet software)); the online table is a table supporting online editing and online storage, and table contents generated by editing are stored in a network server or a cloud server; the local table is a table edited in a local application, and contents generated by editing are stored in a local storage space.
In the related art of the present application, situations that information and statistical information need to be collected are frequently encountered in a social scene, and an instant messaging session scene is taken as an example, and for requirements of information collection and statistics in the instant messaging session scene, the following schemes mainly exist in the prior art:
(1) information is collected and statistically collected in an instant messaging session page of an instant messaging application by way of an online document. Online documents are generally displayed in the instant messaging session page in the form of structured messages, URLs (Uniform Resource locators), and the like; FIG. 1a is a schematic diagram of a page of an existing collection method provided by an exemplary embodiment of the present application, as shown in FIG. 1a, a user A collects and counts information through an online form 101, and the online form 101 is displayed in an instant messaging session page in the form of a structured message; FIG. 1b is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application, as shown in FIG. 1b, a user A collects and counts information through a collection table 102, and the collection table 102 is displayed in the instant messaging session page in the form of a structured message; FIG. 1c is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application, in which, as shown in FIG. 1c, a user A collects and counts information through a URL of an online document 103, and the online document 103 is displayed in an instant messaging session page in the form of a URL; in the above manner, when a user participating in a session edits an online document, information collection and statistics can be realized only by switching from an instant messaging session scene to an editing page of the online document or to an application program corresponding to the online document, and the operation is complex and the efficiency is low.
(2) Information is collected and statistically collected in the instant messaging session page of the instant messaging application by way of a local document. Local documents are typically displayed in the instant messaging session page in the form of structured messages; FIG. 1d is a schematic diagram of a page showing an existing collection method according to another exemplary embodiment of the present application, as shown in FIG. 1d, user A collects and counts information through a local form 104, and the local form 104 is displayed in an instant messaging session page in the form of a structured message; in the above manner, when a user participating in a session edits a local document, the instant messaging session scene needs to be switched to an editing page of the local document or an application program corresponding to the local document needs to be downloaded, otherwise, the local document cannot be edited; in addition, after the local documents are edited by a plurality of users participating in the session, the contents in the plurality of local documents must be merged and adjusted, which also results in low information collection efficiency and statistical efficiency.
(3) And collecting and counting information in an instant messaging session page of the instant messaging application program in a message connection mode. FIG. 1e is a schematic diagram of a page of a conventional collection method according to another exemplary embodiment of the present application, and as shown in FIG. 1e, a user A collects names of users who receive a message in a message recipient 105, and the message recipient is displayed in an instant messaging session page; in the above manner, when a plurality of users participating in a session simultaneously perform message relay, a situation of collection failure is easily caused, the users participating in the session need to perform message relay by copying and pasting, and the information collection efficiency and statistical efficiency are also low, and the information collected by the method has a weak formatting degree.
Based on the above description, the embodiment of the application provides a table editing scheme, which can implement a collaborative editing table in a social page of a social application program, and display content generated by collaborative editing in real time in the social page of the social application program; the main improvement technical points of the scheme are as follows: firstly, a target form of information to be collected is displayed in a social page of a social application program in a message form, and users participating in social contact can visually see the information to be filled in the target form; when the users participating in social contact collaboratively edit the target table in the social contact page of the social contact application program, the user does not need to jump the page or open or download another application program, the table editing mode is convenient and quick, the editing requirements of the user are met, and the information collection efficiency and the statistical efficiency are high; and the table content generated by collaborative editing is displayed in a target table of the social page in real time, and each user participating in social contact can clearly and intuitively look up the information filled in the target table, so that the information transmission efficiency is improved.
Fig. 2 is a schematic diagram illustrating an architecture of a table editing system according to an exemplary embodiment of the present application, where as shown in fig. 2, the table editing system includes N terminals (e.g., a first terminal 201, a second terminal 202, etc.) and a server 203, where N is an integer greater than 1. Any one of the N terminals (for example, the first terminal 201 or the second terminal 202, etc.) may be a smart phone, a tablet computer, a notebook computer, a desktop computer, a smart speaker, a smart watch, etc., but is not limited thereto; any one of the N terminals may support installation and operation of various applications, where the applications may include, but are not limited to, social applications (e.g., a microblog application, an instant messaging application, a map application with a social function, etc.), audio and video applications (e.g., a video-on-demand application, an audio player, etc.), game applications, and so on; the server 203 may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing cloud computing services, and the embodiment of the present application is not limited herein. The N terminals and the server may be directly or indirectly connected through wired communication or wireless communication, and the application is not limited herein.
In the table editing system shown in fig. 2, the processing flow of the table editing scheme proposed by the embodiment of the present application on any terminal side is as follows:
(1) displaying N social pages participated by users in the social application program, wherein N is an integer larger than 1.
In one implementation mode, N users respectively use the N terminals to participate in social contact to form N social contact pages participated by the users, and the N social contact pages participated by the users can be respectively displayed in the N terminals; for example, a user a uses a first terminal to participate in social contact, a user B uses a second terminal to participate in social contact, a user C uses a third terminal to participate in social contact, and the like, and the social pages participated in by the 3 users can be respectively displayed in the first terminal, the second terminal and the third terminal; the social pages in which the N users participate may include any of: an instant messaging session page (e.g., a chat page of QQ, WeChat, Business WeChat, live, short video, social software, etc.) to which the N users belong in common, a social dynamic page (e.g., a circle of friends, a personal home page, a personal dynamic page, etc.) that any one of the N users open to the N users (e.g., user a opens to the N users participating in social interaction). Taking an instant messaging session scenario as an example, a social page is an instant messaging session page to which N users belong together, fig. 3a shows a flowchart of a form editing scheme provided in an exemplary embodiment of the present application, and as shown in fig. 3a, the social page is an instant messaging session page in which N users (e.g., user a, user B, user C, etc.) participate, and a session name of the instant messaging session page is "XXX group". It should be noted that, the following contents of the embodiment of the present application are all described by taking the instant messaging session scenario shown in fig. 3a as an example.
In one implementation, the social page includes a table message in which a target table is displayed, where the target table is a table to be edited by each social participating user. In one implementation, the social page is an instant messaging session page to which N users belong together, the instant messaging session page includes a message display area, the message display area is used for displaying instant messaging message streams among the N users, and a form message containing a target form is displayed in the instant messaging message stream of the message display area, that is, the target form is displayed in the message display area as an instant messaging message; the position of the form message in the message display area of the instant messaging session page may change with the flow of the instant messaging message stream, the form message may also be displayed in a target area in the message display area of the instant messaging session page, the position of the target area in the message display area is fixed, and the position of the target area in the message display area may include at least one of: a top position, a bottom position, any position between the top position and the bottom position; the target form may include a form title and at least one cell, and the user participating in the instant messaging session may edit the target form, that is, the user participating in the instant messaging session may edit the form title, one or more cells in the target form. As shown in fig. 3a, a target form with the form title "afternoon overtime statistics" is displayed in form message 301, which is located at the top position of the message presentation area of the instant messaging session page. In the mode, the target form is displayed in the social page in the form of the form message, the users participating in social contact can clearly and intuitively see the information to be filled in the target form, the information transmission is more visual and efficient, and the user experience is better.
(2) When M users in the N users carry out collaborative editing on the target table, table contents generated by the collaborative editing are displayed in the social page in real time, wherein M is an integer larger than 1 and M is not more than N.
In one implementation, when any cell in the target table is edited, the user terminals of the users participating in social interaction display the table content generated by editing in the social interaction page in real time. As shown in fig. 3a, the process of editing any cell (target cell) in the target table by the users participating in social interaction is as follows: the user clicks the target cell, and a message input area 303 containing an input box 302 is displayed in the instant messaging session page; after the user inputs the content '27 number' in the input box, the content input in the input box is displayed in the target cell in real time; the user clicks a submission identifier 304 contained in the message input area, or the user clicks any cell except the target cell, or the user clicks a blank area of a message display area in the instant messaging session page (namely, an area in the message display area where the instant messaging message stream is not displayed), and the content in the input target cell is saved; the table title cells of the target table can also be edited, and the editing operation of the table title cells is the same as that of the target cells, which can be referred to specifically as the editing operation of the target cells.
It should be noted that, in the embodiment of the present application, the editing operation performed on the target table is described by taking cell content filling as an example, and besides performing content filling on the target table, the editing operation performed on the target table in the embodiment of the present application may further include at least one of the following operations: for example, the method may further include changing attribute data of the target table (for example, changing font, font size, cell background color, cell alignment, etc.), inserting or deleting rows or columns in the target table, and the like, which may be specifically described with reference to the embodiment in fig. 4.
In one implementation mode, when the target table is subjected to collaborative editing, table content generated by the collaborative editing is displayed in real time in the social page, the edited cells in the target table are highlighted, and user information for performing editing is also displayed in the edited cells in the target table. The collaborative editing of the target form means that a plurality of users participating in social interaction edit the target form at the same time or in the same time period. Wherein the user information may include at least one of: user name, user head portrait, and user account. The highlighting means that the cells being edited and the cells not being edited are displayed in a differentiated manner by color display, brightness display or the like; for example, the background color or border of the edited cells is displayed as a first color, and the background color or border of the unedited cells is displayed as a second color; alternatively, the background color or border of the edited cell is displayed with a first brightness and the background color or border of the unedited cell is displayed with a second brightness. In one implementation, cells edited by different users may also be displayed in different colors; as shown in fig. 3a, the user B, and the user C perform collaborative editing on the target table, the border of the cell edited by the user a is displayed in a first color, the border of the cell edited by the user B is displayed in a second color, and the border of the cell edited by the user C is displayed in a third color; the cell edited by user a displays the user name of user a, the cell edited by user B displays the user name of user B, and the cell edited by user C displays the user name of user C. In one implementation, an editing prompt is also displayed in the social page, and the editing prompt is used for indicating the number of users currently performing collaborative editing on the target form; as shown in fig. 3a, the instant messaging session page displays an edit prompt 305 indicating that the number of users currently performing collaborative editing on the target form is 3. By the method, when the users participating in social contact collaboratively edit the target table in the social contact page of the social contact application program, the pages do not need to be jumped, and another application program does not need to be opened or downloaded, so that the table editing mode is convenient and quick, the editing requirements of the users are met, and the information collection efficiency and the statistical efficiency are high; the table content generated by collaborative editing is displayed in a target table of a social page in real time, and each user participating in social contact can clearly and intuitively look up information filled in the target table, so that the information transmission efficiency is more intuitive and efficient; the edited cells in the target table are highlighted, user information for executing editing is also displayed in the edited cells, users participating in social contact can look up the editing state of the target table in real time, the editing requirements of the users are met, and the user experience is good.
In one implementation, the accommodation space of each cell in the target table is limited, and the width of each cell is set to be a minimum width value, a maximum width value and a table content line number threshold; if the width of the table content filled into each cell is within the range of the width value formed by the lowest width value and the highest width value, the table content is normally displayed in the cell; if the width of the table content filled in each cell exceeds the highest width value, the table content is automatically displayed in the cells in a line-feed manner; if the line number of the table content filled in each cell exceeds the threshold value of the line number of the table content, folding and displaying the table content in the cell, and displaying a browsing identifier in the cell; and when the browsing identifier is triggered, displaying the complete table content of the cell in the floating layer window. Fig. 3b illustrates a flowchart of a table content display method according to an exemplary embodiment of the present application, and as shown in fig. 3b, the table content in the cell corresponding to the user a is displayed in a folded manner, a browsing identifier 306 is displayed in the cell, and when the user clicks the browsing identifier, a floating window is displayed in the instant messaging session page, and the complete content of the cell is displayed in the floating window. In this way, the table contents beyond the cell accommodating space are folded and displayed in the cells, the released accommodating space can be used for filling other table contents, and the contents in each cell are effectively managed.
It is understood that, in the form editing system shown in fig. 2, the terminal may also implement the above form editing process by means of interaction with the server, and the interaction process may be described with reference to fig. 6 to 8.
In the embodiment of the application, a plurality of social pages participated by users are displayed in a social application program, and a target table to be edited is displayed in the social pages in a form of table messages; when some or all users participating in the social page perform collaborative editing on the target form, the form content generated by the collaborative editing is displayed in the social page in real time; in the process, the target table displayed on the social page supports multi-user collaborative editing participating in the social page, the page skipping and the application program switching are not needed in the process of the collaborative editing of the target table, and the table content generated by the collaborative editing is displayed in the social page of the social application program in real time, so that the table editing requirements of users are met, the user experience is improved, the information transmission is more visual and efficient, and the information collection efficiency and the statistical efficiency are improved; the target form is displayed in the social contact page in a form of form information, and the user participating in social contact can clearly and intuitively see the information to be filled in the target form displayed in the form information, so that the information transmission is more intuitive and clear, and the user experience is better; the edited cells in the target table are highlighted, user information for executing editing is also displayed in the edited cells, and users participating in social contact can look up the editing state of the target table in real time, so that the edited cells can be displayed more intuitively; the content exceeding the cell accommodating space is displayed in the cells in a folding mode, the released accommodating space can be used for filling other table contents, so that the display space in the interface is saved, the content in each cell is effectively managed, and the information transmission efficiency is improved.
It can be understood that the form editing system described in the embodiment of the present application is for more clearly illustrating the technical solution of the embodiment of the present application, and does not constitute a limitation to the technical solution provided in the embodiment of the present application, and as a person having ordinary skill in the art knows that along with the evolution of the system architecture and the appearance of a new service scenario, the technical solution provided in the embodiment of the present application is also applicable to similar technical problems.
Referring to fig. 4, fig. 4 is a flowchart illustrating a table editing method provided in an exemplary embodiment of the present application, where the table editing method may be executed by any one of the terminals in the table editing system shown in fig. 2, for example, the table editing method may be executed by a first terminal 201 in N terminals, or the table editing method may be executed by a second terminal 202 in the N terminals, and the table editing method includes the following steps S401 to S402:
step S401, displaying N social pages participated by users in the social application program, wherein N is an integer larger than 1.
In one implementation, the social page includes a table message in which a target table is displayed. The specific creation process of the target table is as follows: the social page comprises a form creation entry, and when the form creation entry is selected, a form configuration window is displayed in the social page and used for configuring attribute data of a target form; after the attribute data configuration of the target form is completed, displaying the target form in a form of form information in the social page; here, the attribute data of the target table may include at least one of: table title, table row number, table column number.
In the specific implementation, the social page comprises a message input area, the message input area comprises a shortcut input area, and a form creation inlet is arranged in the shortcut input area; or the social page comprises a message input area, and the message input area comprises an input box; when the input box is triggered, a tab is displayed in the social page, and a form creation entry is set in the tab. Fig. 5a is a flowchart illustrating a form creating manner according to an exemplary embodiment of the present application, and as shown in fig. 5a, a social page includes a message input area 303, the message input area includes a shortcut input area 501, and a form creating entry 502 is disposed in the shortcut input area; alternatively, the social page contains a message entry field containing input box 302; when the input box is triggered, a tab 503 is displayed in the social page, and a table creation entry 502 is set in the tab; when the table creation entry is selected, a table configuration window 504 is displayed in the social page, which may be used to configure the table title of the target table, the table row number of the target table, and the table column number of the target table; when the attribute data configuration of the target form is completed, the target form is displayed in the form of a form message 301 in the social page. By the method, the method for initiating the collaborative editing of the target table is convenient and fast, and the information collection efficiency and the statistical efficiency are effectively improved.
Step S402, when M users in the N users carry out collaborative editing on the target table, table contents generated by the collaborative editing are displayed in a social page in real time, wherein M is an integer larger than 1 and M is not larger than N.
In one implementation, the target table includes at least one cell, the target cell is any one cell in the target table, and the first user is any one of the M users; when the first user edits the target cell, the table content generated by editing is displayed in the target cell in real time.
In a specific implementation, when the target cell is edited, an automatic filling option is displayed in the social page; when the automatic filling option is selected, displaying an automatic filling list in the social page, wherein the automatic filling list comprises at least one filling information, and the target filling information is any filling information in the automatic filling list; when the target filling information is selected, filling the target cell with the target filling information. In one implementation, the social page is an instant messaging session page to which N users belong together, and the populated information contained in the auto-populated list includes at least one of: user information of N users and message content in instant messaging message flow among the N users; message content in an instant messaging message stream between N users may include at least one of: messages sent between N users, files sent between N users, and pictures sent between N users.
Taking an instant messaging session scene as an example, fig. 5b shows a schematic flow chart of automatically filling in form content according to an exemplary embodiment of the present application, as shown in fig. 5b, when a target cell is edited, an automatically filling option 505 is displayed in an instant messaging session page, and when the automatically filling option is selected, an automatically filling list is displayed in the instant messaging session page; the auto-fill list includes at least one type of fill information, such as "user name", "user name participating in social interaction + user avatar", "sent message", "sent file", "sent picture", "custom field", and other fill information shown in fig. 5 b; when the user name option is selected, automatically filling the user name of the user corresponding to the terminal in the target cell; when the 'user name participating in social contact' option is selected, vertically filling user names of all users participating in social contact from a target cell, if the number of rows of a table of the target table is smaller than the number of users participating in social contact, automatically inserting rows in the target table and filling the user names, or when the 'user name participating in social contact' option is selected, horizontally filling the user names of all users participating in social contact from the target cell, and if the number of columns of the table of the target table is smaller than the number of users participating in social contact, automatically inserting columns in the target table and filling the user names; when the option of 'message sent' is selected, a time selection window 506 is displayed in the instant messaging session page, and after a target time period is set in the time selection window, the instant messaging messages participating in social contact in the target time period are automatically filled after each user name; when the option of 'sent pictures' is selected, displaying a time selection window in the instant messaging session page, and automatically filling pictures participating in social contact in a target time period after each user name after the target time period is set in the time selection window; when the option of 'sent files' is selected, displaying a time selection window in an instant messaging session page, and automatically filling files participating in social contact in a target time period after each user name after the target time period is set in the time selection window; when the 'custom field' option is selected, the custom field of the user, such as a telephone number, an identity card number, gender information and the like which are set in advance by the user, is automatically filled in the target cell.
In specific implementation, when a target cell is edited, a plurality of cell attribute options are displayed, wherein each cell attribute option is used for controlling one attribute data of the target cell; changing the attribute data of the target cell according to the selected cell attribute option; wherein the attribute data of the target cell includes any one of: font, font size, cell background color and cell alignment mode.
Taking an instant messaging session scene as an example, fig. 5c shows a schematic flow diagram of cell attribute data modification provided in an exemplary embodiment of the present application, as shown in fig. 5c, a cell format modification option 507, a cell alignment mode option 508, and a cell insertion option 509 are displayed in an instant messaging session page; the cell format change option is used for changing the format of the cell, when the cell format change option is selected, at least one cell format template is displayed in the instant messaging session page, each cell format template is set with a font, a character color, a character size and a cell background color by default, and when the target cell format template is selected, the target cell is updated to the cell format corresponding to the target cell format template; the cell alignment option is used to change the alignment of the table content filled in the target cell (e.g., left alignment, right alignment, center alignment, etc.); the cell insert option is used to insert a row or column around the target cell (e.g., insert a row below the target cell, insert a column to the right of the target cell, etc.).
In one implementation, fig. 5d illustrates a flowchart of a cell selection method provided by an exemplary embodiment of the present application, and as shown in fig. 5d, a cell supports sliding selection of multiple items, one or more cells may be selected through a sliding operation, and the selected one or more cells may be simultaneously edited in a social page. By the method, one or more selected cells are edited simultaneously, the editing efficiency of the target table can be accelerated, and the information collection efficiency and the statistical efficiency are further improved.
In one implementation, the receiving space of the table message is limited, and the table message sets a highest receiving upper limit of the number of table columns or a highest receiving upper limit of the number of table rows, for example, the upper limit of the number of table columns that can be displayed in the table message is 4 columns, and the upper limit of the number of table rows that can be displayed in the table message is 5 rows; when the table row number of the target table is within the highest accommodating upper limit of the table row number and the table column number of the target table is within the highest accommodating upper limit of the table column number, all the rows or all the columns of the target table can be directly displayed in the social page; when the table row number of the target table exceeds the highest accommodating upper limit of the table row number or the table column number of the target table exceeds the highest accommodating upper limit of the table column number, the target table is displayed in a folded mode (namely a partial row or a partial column of the target table is displayed, and the rest rows or the rest columns of the target table are displayed in a hidden mode), and meanwhile a page turning icon is displayed in the social page and can be used for page turning to view hidden contents in the target table, such as the hidden row or the hidden column. Fig. 5e is a flowchart illustrating a page turning display according to an exemplary embodiment of the present application, and as shown in fig. 5e, a page turning icon 510 is displayed in the social page, and may be used to page and view hidden contents, such as hidden columns and rows, in the target table. By the mode, flexible and various table display and viewing modes are provided, and the user requirements are met.
In one implementation, the target form is supported to be shared or forwarded, the social page includes a form sharing entry, when the form sharing entry is selected, the target form is shared or forwarded, and the users participating in social interaction can share or forward the target form to other social pages, for example, the target form is shared or forwarded to other instant messaging session pages, and is shared or forwarded to social dynamic pages such as a friend circle, a personal homepage, and a personal dynamic page; the shared or forwarded manner may include at least one of the following: form messages, emails, short messages; the target form is collaboratively edited by users participating in other social pages, and the form content generated by collaborative editing is displayed in real time in each social page containing the target form. For example, the first instant messaging session page is an instant messaging session page corresponding to the finance department, the second instant messaging session page is an instant messaging session page corresponding to the administration department, the user a wants to collect the shift-over-work situation of each employee of the finance department and the administration department at the same time, the user a can share the target table with the format title of "shift-over-work statistics" in the table message 301 shown in fig. 3a into the first instant messaging session page and the second instant messaging session page in the form of table messages, the user in the first instant messaging session page and the user in the second instant messaging session page can cooperatively edit the target table, and the table content generated by the cooperative editing is displayed in the table messages of the first instant messaging session page and the table messages of the second instant messaging session page in real time. Through the method, the cross-social page collaborative editing of the target form is realized, the information collection mode of the target form is more flexible and diversified, and the information collection efficiency and the statistical efficiency are further improved.
In one implementation, the user participating in social interaction also selects the presentation form of the table content in the target table in the social page, for example, the table content in the target table may be presented in the social page in a table form (i.e., containing cell borders), or the content in the target table may be presented in a purely text form (i.e., not containing cell borders). In this way, flexible and various table content display forms are provided, for example, more table contents are displayed on a limited instant messaging interface, and the table reading efficiency and the table filling efficiency under different application scenes can be improved.
In an implementation manner, the target form in the embodiment of the application supports a form export operation, after the target form is edited, any user participating in social interaction may export the target form into a form file through a form export option, and the exported form file also supports to be shared or forwarded, for example, the form file may be shared or forwarded to another social page, the form file is shared in the form of an email, and the like. In this way, the target form is exported as a form file, which is convenient for saving, managing and sharing the target form.
In the embodiment of the application, a plurality of social pages participated by users are displayed in a social application program, and a target table to be edited is displayed in the social pages in a form of table messages; when some or all users participating in the social page perform collaborative editing on the target form, the form content generated by the collaborative editing is displayed in the social page in real time; in the process, the target table displayed on the social page supports multi-user collaborative editing participating in the social page, the page skipping and the application program switching are not needed in the process of the collaborative editing of the target table, and the table content generated by the collaborative editing is displayed in the social page of the social application program in real time, so that the table editing requirement of a user is met, the user experience is improved, the information collection efficiency and the statistical efficiency are improved, and the information collection and statistics are more real-time, more visual and clear; in addition, the embodiment of the application provides rich table editing operations, for example, automatic filling of the target table, modification of attribute data of each cell in the target table, insertion of the cell in the target table and the like, and the table editing operations are rich and diverse and meet the table editing requirements in different application scenes; when the table information exceeds the containing space of the table information, the part of the target table exceeding the containing space is hidden and displayed, and the page turning icon in the target table is used for viewing the table content hidden and displayed, so that flexible and various table display and viewing modes are provided, and the table viewing requirements of users in different application scenes are met; in addition, the target table supports sharing and forwarding, collaborative editing of the target table across social pages is achieved, information collection modes of the target table are flexible and diverse, and information collection efficiency and statistical efficiency are further improved; the display forms of the table contents of the target table are flexible and various, and the table reading efficiency and the table filling efficiency under different application scenes are improved; the target table supports table export operation, and the target table is exported to be a table file, so that the target table is convenient to store and manage, such as store, forward or share.
Fig. 6 is a flowchart illustrating a table editing method according to another exemplary embodiment of the present application. The form editing method may be interactively executed by the first terminal 201, the second terminal 202 and the server 203 shown in fig. 2, it should be noted that the form editing method is interactively implemented by the first terminal 201, the second terminal 202 and the server 203 for example only, and in a practical case, the form editing method is implemented by N terminals and a server; the table editing method includes the following steps S601 to S612:
in step S601, the first terminal sends the attribute data of the target table to the server.
The first terminal is a terminal for initiating collaborative editing. Specifically, as shown in fig. 5a, when the first terminal triggers a table creation entry in the social page, the first terminal displays a table configuration window in the social page; correspondingly, the user can configure the attribute data of the target form in the form configuration window, and after the configuration of the attribute data of the target form is completed, the first terminal sends the attribute data of the target form to the server.
In step S602, the server creates a target table.
In one implementation, the server creates a target table according to the received attribute data of the target table; when the server creates the target table, the table identifier of the target table is generated and stored, wherein the table identifier of the target table may include but is not limited to: target table version number, target table link address, etc.
Step S603, the server sends the table identifier of the target table to the first terminal and the second terminal.
In step S604, the server sends the target table to the first terminal and the second terminal in the form of a table message.
The second terminal is a terminal that includes the same social page as the first terminal, and it can also be understood that the user of the second terminal and the user of the first terminal have an association relationship in the social application (the user of the first terminal and the user of the second terminal belong to the same social page together). The server sends the target form to the first terminal and the second terminal in the form of a form message, the form message is displayed in social pages of the first terminal and the second terminal, and the target form is displayed in the form message.
Step S605, when the target cell in the target table of the second terminal is selected, generating a collaborative editing request, where the collaborative editing request is used to request the server for the permission to perform collaborative editing in the target table.
The collaborative editing request carries the table identifier of the target table and the identity information of the second terminal (e.g., the identity information of the user of the second terminal).
Step S606, the second terminal sends the collaborative editing request to the server.
In step S607, the server detects whether the second terminal has the authority to edit the target form.
Specifically, the server may verify that the second terminals all have the authority to edit the target form based on the collaborative editing request sent by the second terminal; the specific verification method may be as follows: and verifying whether the user corresponding to the second terminal and the user corresponding to the first terminal participate in the same social page or not, or verifying whether the table identifier of the target table sent by the second terminal is consistent with the table identifier of the target table initiated by the first terminal.
In step S608, the server returns a response message to the second terminal.
The response message is used to indicate a response result of the collaborative editing request of the server to the second terminal, for example, the response message is used to indicate that the second terminal has a right to edit the target table, or the response message is used to indicate that the second terminal does not have a right to edit the target table.
In step S609, the second terminal edits the target table.
Specifically, if the second terminal has the authority to edit the target table, the second terminal edits each cell of the target table, and the table content generated by editing is displayed in the target table of the social page of the second terminal in real time.
In step S610, the second terminal sends the form editing operation to the server.
In step S611, the server sends the table editing operation algorithm expression generated by the second terminal to the first terminal.
It can be understood that the first terminal may also edit each cell of the target table, and the table content generated by editing is displayed in the target table of the social page of the first terminal in real time, and meanwhile, the first terminal also sends the table editing operation to the server; similarly, the server sends the form editing operation of the first terminal to the second terminal.
In step S612, the first terminal (second terminal) merges the table contents.
In detail, after receiving the form editing operation of the second terminal (the first terminal), the first terminal (the second terminal) may adopt a collaborative editing algorithm (OT algorithm) to merge the form editing operation of the second terminal (the first terminal) into a current target form of the first terminal (the second terminal), so as to display the content of the form being collaboratively edited by each user in real time in the social page.
In the embodiment of the application, the first terminal can send the attribute data of the target form submitted by the user for the first time to the server; the server generates a target table and a table identifier of the target table, sends the table identifier of the target table to the first terminal and the second terminal, and sends the target table to the first terminal and the second terminal in a form of table messages; the second terminal requests a verification authority (whether the editing authority of the target form is provided or not) from the server; and the server sends the response message to the second terminal, and if the second terminal has the authority of editing the target form, the second terminal can directly edit each cell of the target form, and the form content edited by the second terminal can be displayed in real time in the social page of the first terminal or other terminals. In the process, the server provides data processing service for each terminal participating in collaborative editing, for example, the server verifies the form editing authority of each terminal, the server performs conflict processing on the submitted form editing operation of each terminal, and the server stores the form content submitted by each terminal; in the process of performing collaborative editing on the target form, the existence of the server accelerates the data interaction process and the collaborative editing process among the terminals participating in the collaborative editing, and further improves the information collection efficiency and the statistical efficiency.
The form editing scheme depicted in fig. 6 involves interaction between both the terminal and the server. The following describes the processing logic of the server and the terminal in the table editing scheme. The interactive processing logic of the terminal and the server in the form editing scheme can be seen in fig. 7, and the processing logic of the terminal in the form editing scheme can be seen in fig. 8, which is specifically as follows:
fig. 7 is a schematic diagram illustrating an interaction processing logic according to an exemplary embodiment of the present application, and as shown in fig. 7, when a terminal and a server are used for processing a form editing scheme according to an embodiment of the present application, the following eight parts are mainly involved: big data channel, write-together logic layer, document list, Websocket access layer, interatrial layer storage, web instant collaboration document (Hackpad), and distributed database (TDSQL). The big data channel is used for transmitting data interacted between the terminal and the server, for example, the terminal submits attribute data of the target form to a collaborative editing background (writing background together) of the server through the big data channel, and the collaborative editing background of the big data channel docking server returns the target form generated by the collaborative editing background of the server and a form identifier (for example, a target form version number) of the target form to the terminal; the document list is used for storing a target table which currently exists and table contents of the target table; the write-together logic layer is responsible for processing submitted form editing operation when a plurality of users collaboratively edit a target form and performing conflict processing on the submitted form editing operation of the plurality of users, and returning the latest form content or form editing operation to the terminal; the Websocket access layer is responsible for the table editing operation between the butt joint terminal and the server, and the Websocket is used as long connection (the long connection refers to a connection mode that the connection state is kept not closed after the connection is established between the terminal and the server), so that the table content or the table editing operation can be returned to the terminal in real time, and the table content can be updated in the social page of the terminals in real time; the middle house layer is responsible for managing the authority of each user participating in social contact and maintaining the state of the user currently performing collaborative editing on the target table.
Fig. 8 shows a schematic structural diagram of modules in a terminal according to an exemplary embodiment of the present application, and as shown in fig. 8, when the terminal is used for processing a table editing scheme mentioned in the embodiment of the present application, the following eight parts are mainly involved: a form editor, a form task module, a form management module, a form collaborative editing algorithm, a room protocol, a form collaborative alteration protocol, and a message. The terminal interacts with the server through a protocol layer, and the form protocol is responsible for processing the opening of the target form and the acquisition of form contents in the target form. The room protocol is responsible for handling the collaborative editing rights of the user. The form co-change protocol (OT change protocol) is responsible for handling form editing operations and form editing conflicts. The form management module and the form task module are both responsible for managing stored logical relations between a plurality of target forms and each social page, for example, a target form with a form identifier of A of the target form is a target form belonging to a first social page, and a target form with a form identifier of B of the target form is a target form belonging to the first social page, so that the incidence relations between the plurality of target forms and the plurality of social pages are ensured; the form task module also has the following functions: table editing operation or table editing conflict generated by a table editor is butted; receiving the table editing operation returned by the protocol layer (including but not limited to the table protocol and the room protocol) to the terminal; processing the conflict between the table editing operation generated by the terminal and the table editing operation generated by the server; and fourthly, submitting the local form editing operation to the protocol layer and transmitting the operation to the server. Specifically, the processing logic of the form task module can be seen in fig. 9, and fig. 9 is a schematic diagram of the processing logic of the form task module according to an exemplary embodiment of the present application. And the table collaborative editing algorithm is responsible for processing the conflict and combination of the table editing operation pushed to the terminal by the background and the table editing operation generated by the terminal. The form editor is responsible for displaying form contents generated by collaborative editing of a plurality of users participating in social interaction, and transferring form editing operations generated by the plurality of users participating in social interaction to the form task module, and submitting the form editing operations to the server by the form task module.
Referring to fig. 10, fig. 10 is a schematic structural diagram of a form editing apparatus provided in an exemplary embodiment of the present application, where the form editing apparatus 100 may be a computer program (including program code) running on any one of the N terminals shown in fig. 2, for example, may be an application software in the first terminal 201; the form editing apparatus 100 may be used to perform corresponding steps in the form editing methods shown in fig. 4 or fig. 6. Referring to fig. 10, the table editing apparatus 100 includes the following units:
the display unit 1001 is configured to display, in a social application, social pages in which N users participate, where the social pages include table messages, a target table is displayed in the table messages, and N is an integer greater than 1;
the processing unit 1002 is configured to display, in real time, table content generated by collaborative editing in the social page when M users of the N users perform collaborative editing on the target table, where M is an integer greater than 1 and M is not greater than N.
In one implementation, the social pages in which the N users participate include any of: the method comprises the steps of obtaining an instant messaging conversation page to which N users belong together, and obtaining a social dynamic page which is opened to the N users by any one of the N users.
In one implementation, a social page contains a table creation entry;
the processing unit 1002 is further configured to:
when the form creation entry is selected, displaying a form configuration window in the social page, wherein the form configuration window is used for configuring the attribute data of the target form;
and when the attribute data configuration of the target form is completed, displaying the target form in the form of a form message in the social page.
In one implementation, the social page includes a message input area, the message input area includes a shortcut input area, and the form creation entry is disposed in the shortcut input area.
In one implementation, a social page includes a message entry area that includes an input box;
the processing unit 1002 is further configured to display a tab in the social page when the input box is triggered, where the form creation entry is set in the tab.
In one implementation, the social page is an instant messaging session page to which the N users belong together, the instant messaging session page includes a message display area, the message display area is used for displaying an instant messaging message flow among the N users, and the tabular messages are displayed in the instant messaging message flow in the message display area.
In one implementation, the target table includes at least one cell, the target cell is any one cell in the target table, and the first user is any one of the M users;
the processing unit 1002 is specifically configured to, when the first user edits the target cell, display the table content generated by editing in the target cell.
In one implementation, the processing unit 1002 is further configured to:
displaying an auto fill option when the target cell is edited;
when the automatic filling option is selected, displaying an automatic filling list, wherein the automatic filling list comprises at least one type of filling information, and the target filling information is any one type of filling information in the automatic filling list;
when the target filling information is selected, filling the target cell with the target filling information.
In one implementation, the social page is an instant messaging session page to which N users belong together, and the populating information in the auto-populating list includes at least one of: user information of N users and message content in an instant messaging message stream between the N users.
In one implementation, the processing unit 1002 is further configured to:
displaying a plurality of cell attribute options when the target cell is edited, each cell attribute option for controlling one attribute data of the cell;
changing the attribute data of the target cell according to the selected cell attribute option;
wherein the attribute data of the target cell includes any one of: font, font size, cell background color and cell alignment mode.
In one implementation, the processing unit 1002 is further configured to:
if the length of the table content in the target cell exceeds the accommodating space of the target cell, folding and displaying the table content in the target cell, and displaying a browsing identifier in the target cell;
and when the browsing identifier is triggered, displaying the complete table content of the target cell in the floating layer window.
In one implementation, the processing unit 1002 is further configured to, when the target table is subjected to collaborative editing, highlight the edited cell in the target table in the table message and display user information for performing editing in the edited cell.
According to an embodiment of the present application, the units in the table editing apparatus 100 shown in fig. 10 may be respectively or entirely combined into one or several other units to form the table editing apparatus, or some unit(s) therein may be further split into multiple units with smaller functions to form the table editing apparatus, which may implement the same operation without affecting implementation of technical effects of the embodiment of the present application. The units are divided based on logic functions, and in practical application, the functions of one unit can be realized by a plurality of units, or the functions of a plurality of units can be realized by one unit. In other embodiments of the present application, the table editing apparatus 100 may also include other units, and in practical applications, these functions may also be implemented by being assisted by other units, and may be implemented by cooperation of multiple units. According to another embodiment of the present application, the table editing apparatus 100 as shown in fig. 10 may be constructed by running a computer program (including program codes) capable of executing the steps involved in the corresponding method as shown in fig. 4 or fig. 6 on a general-purpose computing device including a general-purpose computer such as a Central Processing Unit (CPU), a random access storage medium (RAM), a read only storage medium (ROM), and the like, and a storage element, and the video delivery method of the embodiment of the present application may be implemented. The computer program may be, for example, loaded on a computer-readable storage medium and loaded into and executed in any one of the above-mentioned N terminals through the computer-readable storage medium.
In the embodiment of the application, a plurality of social pages participated by users are displayed in a social application program, and a target table to be edited is displayed in the social pages in a form of table messages; when some or all users participating in the social page perform collaborative editing on the target form, the form content generated by the collaborative editing is displayed in the social page in real time; in the process, the target table displayed on the social page supports multi-user collaborative editing participating in the social page, the page skipping and the application program switching are not needed in the process of collaborative editing of the target table, table contents generated by collaborative editing are displayed in the social page of the social application program in real time, the table editing requirements of users are met, the user experience is improved, and the information collection efficiency and the statistical efficiency are improved.
Referring to fig. 11, fig. 11 is a schematic structural diagram of a table editing apparatus according to an exemplary embodiment of the present application, where the table editing apparatus 110 includes at least a processor 1101 and a computer-readable storage medium 1102. The processor 1101 and the computer-readable storage medium 1102 may be connected by a bus or other means. A computer-readable storage medium 1102 may be stored in the memory, the computer-readable storage medium 1102 being configured to store a computer program comprising computer instructions, the processor 1101 being configured to execute the computer instructions stored by the computer-readable storage medium 1102. The processor 1101 (or CPU) is a computing core and a control core of the table editing apparatus 110, and is adapted to implement computer instructions, and specifically, adapted to load and execute the computer instructions so as to implement corresponding method flows or corresponding functions.
Embodiments of the present application further provide a computer-readable storage medium (Memory), which is a Memory device in the table editing apparatus 110 and is used to store computer programs and data. It is understood that the computer readable storage medium 1102 herein may include a built-in storage medium in the form editing apparatus 110, and may also include an extended storage medium supported by the form editing apparatus 110. The computer-readable storage medium 1102 provides a storage space that stores the operating system of the table editing apparatus 110. Also stored in this memory space are computer instructions, which may be one or more computer programs (including program code), suitable for being loaded and executed by the processor 1101. It should be noted that the computer-readable storage medium 1102 may be a high-speed RAM Memory, or may be a Non-Volatile Memory (Non-Volatile Memory), such as at least one disk Memory; optionally, at least one computer readable storage medium located remotely from the aforementioned processor 1101.
In one implementation, the form editing apparatus 110 may be any one of the N terminals shown in fig. 2, such as a first terminal 201, a second terminal 201, and the like; the computer-readable storage medium 1102 has stored therein computer instructions; the computer instructions stored in the computer-readable storage medium 1102 are loaded and executed by the processor 1101 to implement the corresponding steps in the above-described method embodiments; in particular implementations, the computer instructions in the computer-readable storage medium 1102 are loaded by the processor 1101 and perform the following steps:
displaying N social pages participated by users in a social application program, wherein the social pages comprise table messages, a target table is displayed in the table messages, and N is an integer greater than 1;
and when M users in the N users carry out collaborative editing on the target table, displaying table contents generated by the collaborative editing in real time in the social page, wherein M is an integer larger than 1 and is not more than N.
In one implementation, the social pages in which the N users participate include any of: the method comprises the steps of obtaining an instant messaging conversation page to which N users belong together, and obtaining a social dynamic page which is opened to the N users by any one of the N users.
In one implementation, a social page contains a table creation entry; the computer instructions in the computer-readable storage medium 1102 being loaded by the processor 1101 further performs the steps of:
when the form creation entry is selected, displaying a form configuration window in the social page, wherein the form configuration window is used for configuring the attribute data of the target form;
and when the attribute data configuration of the target form is completed, displaying the target form in the form of a form message in the social page.
In one implementation, the social page includes a message input area, the message input area includes a shortcut input area, and the form creation entry is disposed in the shortcut input area.
In one implementation, a social page includes a message entry area that includes an input box; the computer instructions in the computer-readable storage medium 1102 being loaded by the processor 1101 further performs the steps of: when the input box is triggered, a tab is displayed in the social page, and a form creation entry is set in the tab.
In one implementation, the social page is an instant messaging session page to which the N users belong together, the instant messaging session page includes a message display area, the message display area is used for displaying an instant messaging message flow among the N users, and the tabular messages are displayed in the instant messaging message flow in the message display area.
In one implementation, the target table includes at least one cell, the target cell is any one cell in the target table, and the first user is any one of the M users;
the computer instructions in the computer-readable storage medium 1102 are loaded by the processor 1101 to perform the following steps: when the first user edits the target cell, the table content generated by editing is displayed in the target cell.
In one implementation, the computer instructions in the computer-readable storage medium 1102 being loaded by the processor 1101 further performs the steps of:
displaying an auto fill option when the target cell is edited;
when the automatic filling option is selected, displaying an automatic filling list, wherein the automatic filling list comprises at least one type of filling information, and the target filling information is any one type of filling information in the automatic filling list;
when the target filling information is selected, filling the target cell with the target filling information.
In one implementation, the social page is an instant messaging session page to which N users belong together, and the populating information in the auto-populating list includes at least one of: user information of N users and message content in an instant messaging message stream between the N users.
In one implementation, the computer instructions in the computer-readable storage medium 1102 being loaded by the processor 1101 further performs the steps of:
when the target cell is edited, displaying a plurality of cell attribute options, wherein each cell attribute option is used for controlling one attribute data of the cell;
changing the attribute data of the target cell according to the selected cell attribute option;
wherein the attribute data of the target cell includes any one of: font, font size, cell background color and cell alignment mode.
In one implementation, the computer instructions in the computer-readable storage medium 1102 being loaded by the processor 1101 further performs the steps of:
if the length of the table content in the target cell exceeds the accommodating space of the target cell, folding and displaying the table content in the target cell, and displaying a browsing identifier in the target cell;
and when the browsing identifier is triggered, displaying the complete table content of the target cell in the floating layer window.
In one implementation, the processing unit is further configured to, when the target table is subjected to collaborative editing, highlight the edited cell in the target table in the table message and display user information for performing editing in the edited cell.
In the embodiment of the application, a plurality of social pages participated by users are displayed in a social application program, and a target table to be edited is displayed in the social pages in a form of table messages; when some or all users participating in the social page perform collaborative editing on the target form, the form content generated by the collaborative editing is displayed in the social page in real time; in the process, the target table displayed on the social page supports multi-user collaborative editing participating in the social page, the page skipping and the application program switching are not needed in the process of collaborative editing of the target table, table contents generated by collaborative editing are displayed in the social page of the social application program in real time, the table editing requirements of users are met, the user experience is improved, and the information collection efficiency and the statistical efficiency are improved.
According to an aspect of the application, a computer program product or computer program is provided, comprising computer instructions, the computer instructions being stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to perform the table editing method provided in the above-described various alternatives.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims (14)

1. A method of table editing, the method comprising:
displaying a social page participated in by N users in a social application program, wherein the social page comprises a table creation entrance; n is an integer greater than 1;
when the form creation entry is selected, displaying a form configuration window in the social page, wherein the form configuration window is used for configuring attribute data of a target form;
after the attribute data configuration of the target form is completed, displaying the target form in a form of form message in the social page;
and when M users in the N users carry out collaborative editing on the target table, displaying table contents generated by the collaborative editing in real time in the social page, wherein M is an integer larger than 1 and is not more than N.
2. The method of claim 1, wherein the social pages in which the N users participate include any of: the instant messaging system comprises an instant messaging session page to which the N users belong together and a social dynamic page which is opened to the N users by any one of the N users.
3. The method of claim 1, wherein the social page includes a message entry field including a shortcut entry field, the form creation entry being disposed in the shortcut entry field.
4. The method of claim 1, wherein the social page includes a message entry area, the message entry area including an input box; the method further comprises the following steps:
when the input box is triggered, a option bar is displayed in the social page, and the form creation entry is arranged in the option bar.
5. The method of claim 2, wherein the social page is an instant messaging session page to which the N users belong in common, the instant messaging session page including a message presentation area for displaying a stream of instant messaging messages between the N users, the form message being displayed in the stream of instant messaging messages in the message presentation area.
6. The method of claim 1, wherein the target table includes at least one cell, wherein a target cell is any one of the cells in the target table, and wherein a first user is any one of the M users;
when M users of the N users perform collaborative editing on the target form, displaying form content generated by the collaborative editing in the social page, including:
and when the first user edits the target cell, displaying the table content generated by editing in the target cell.
7. The method of claim 6, wherein the method further comprises:
displaying an auto-fill option when the target cell is edited;
when the automatic filling option is selected, displaying an automatic filling list, wherein the automatic filling list comprises at least one type of filling information, and the target filling information is any one type of filling information in the automatic filling list;
and when the target filling information is selected, filling the target filling information into the target cell.
8. The method of claim 7, wherein the social page is an instant messaging session page to which the N users collectively belong, and wherein the populating information in the auto-populating list includes at least one of: user information of the N users and message content in an instant messaging message stream between the N users.
9. The method of claim 6, wherein the method further comprises:
when the target cell is edited, displaying a plurality of cell attribute options, wherein each cell attribute option is used for controlling one attribute data of the target cell;
changing the attribute data of the target cell according to the selected cell attribute option;
wherein the attribute data of the target cell includes any one of: font, font size, cell background color and cell alignment mode.
10. The method of claim 6, wherein the method further comprises:
if the length of the table content in the target cell exceeds the accommodating space of the target cell, folding and displaying the table content in the target cell, and displaying a browsing identifier in the target cell;
and when the browsing identifier is triggered, displaying the complete table content of the target cell in a floating layer window.
11. The method of claim 1, wherein the method further comprises:
when the target table is executed with collaborative editing, the edited cells in the target table are highlighted in the table message, and user information for executing editing is displayed in the edited cells.
12. A form editing apparatus, characterized in that the form editing apparatus comprises:
the display unit displays N social pages participated by the users in the social application program, wherein the social pages comprise table creation entries; n is an integer greater than 1;
the processing unit is used for displaying a form configuration window in the social page when the form creation inlet is selected, and the form configuration window is used for configuring the attribute data of a target form; after the attribute data configuration of the target form is completed, displaying the target form in a form of form message in the social page;
the processing unit is further configured to display table content generated by collaborative editing in real time in the social page when M users of the N users perform collaborative editing on the target table, where M is an integer greater than 1 and M is not greater than N.
13. A form editing apparatus characterized by comprising:
a processor adapted to implement computer instructions; and the number of the first and second groups,
a computer readable storage medium having stored thereon computer instructions adapted to be loaded by the processor and to execute the table editing method according to any of claims 1 to 11.
14. A computer-readable storage medium storing computer instructions adapted to be loaded by a processor and to perform the table editing method of any of claims 1 to 11.
CN202010715894.8A 2020-07-23 2020-07-23 Table editing method, device, equipment and storage medium Active CN113268964B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010715894.8A CN113268964B (en) 2020-07-23 2020-07-23 Table editing method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010715894.8A CN113268964B (en) 2020-07-23 2020-07-23 Table editing method, device, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN113268964A CN113268964A (en) 2021-08-17
CN113268964B true CN113268964B (en) 2022-01-18

Family

ID=77227668

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010715894.8A Active CN113268964B (en) 2020-07-23 2020-07-23 Table editing method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113268964B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114528816B (en) * 2022-01-27 2023-03-17 北京飞书科技有限公司 Collaborative editing information display method and device, electronic equipment and readable medium
CN114862376A (en) * 2022-07-07 2022-08-05 深圳市泽维电子科技有限公司 Multidimensional information acquisition cooperative management method, management system and storage medium
CN116306521A (en) * 2023-03-15 2023-06-23 北京中宏立达科技发展有限公司 Editing authority allocation method, system, equipment and medium in collaborative editing
CN116882374B (en) * 2023-09-06 2023-11-14 南京嘉恒信息技术有限公司 Online collaboration method, system and storage medium based on Json structure data

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107943777A (en) * 2017-12-14 2018-04-20 北京久蓉科技有限公司 A kind of collaborative editing, cooperative processing method, device, equipment and storage medium
CN109753620A (en) * 2018-12-27 2019-05-14 永中软件股份有限公司 web document processing method and system
CN110601959A (en) * 2019-09-09 2019-12-20 腾讯科技(深圳)有限公司 Session message display method, device, terminal and storage medium
CN110688829A (en) * 2019-09-24 2020-01-14 北京字节跳动网络技术有限公司 Table generation method, device, equipment and storage medium
CN110738037A (en) * 2019-10-15 2020-01-31 深圳逻辑汇科技有限公司 Method, apparatus, device and storage medium for automatically generating electronic form
US10614796B2 (en) * 2014-08-29 2020-04-07 Yandex Europe Ag Method of and system for processing a user-generated input command
US10621225B2 (en) * 2016-01-19 2020-04-14 Regwez, Inc. Hierarchical visual faceted search engine
CN111368520A (en) * 2020-02-28 2020-07-03 中国平安人寿保险股份有限公司 Editing method and device for electronic forms

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9378065B2 (en) * 2013-03-15 2016-06-28 Advanced Elemental Technologies, Inc. Purposeful computing
CN106610774B (en) * 2015-10-23 2020-03-31 北京国双科技有限公司 Webpage table editing method and device
US10650193B1 (en) * 2018-01-18 2020-05-12 Bevilacqua Research Corp System and method for semiotic digital encoding

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10614796B2 (en) * 2014-08-29 2020-04-07 Yandex Europe Ag Method of and system for processing a user-generated input command
US10621225B2 (en) * 2016-01-19 2020-04-14 Regwez, Inc. Hierarchical visual faceted search engine
CN107943777A (en) * 2017-12-14 2018-04-20 北京久蓉科技有限公司 A kind of collaborative editing, cooperative processing method, device, equipment and storage medium
CN109753620A (en) * 2018-12-27 2019-05-14 永中软件股份有限公司 web document processing method and system
CN110601959A (en) * 2019-09-09 2019-12-20 腾讯科技(深圳)有限公司 Session message display method, device, terminal and storage medium
CN110688829A (en) * 2019-09-24 2020-01-14 北京字节跳动网络技术有限公司 Table generation method, device, equipment and storage medium
CN110738037A (en) * 2019-10-15 2020-01-31 深圳逻辑汇科技有限公司 Method, apparatus, device and storage medium for automatically generating electronic form
CN111368520A (en) * 2020-02-28 2020-07-03 中国平安人寿保险股份有限公司 Editing method and device for electronic forms

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
"Controlled remote implementation of quantum operations with high-dimensional systems";詹佑邦 等;《Chinese Physics B》;20130415;第22卷(第4期);第112-118页 *
"浅谈电子表格的协作和共享在教学工作中应用";赵书文;《信息记录材料》;20200701;第21卷(第7期);第96-98页 *

Also Published As

Publication number Publication date
CN113268964A (en) 2021-08-17

Similar Documents

Publication Publication Date Title
CN113268964B (en) Table editing method, device, equipment and storage medium
WO2020199840A1 (en) Conversation message display method, apparatus, device, and storage medium
CN102362270B (en) Providing access to a conversation in a hosted conversation system
US7698660B2 (en) Shared space for communicating information
US20140068467A1 (en) Method of providing instant messaging service and multiple services expanded from instant messaging service
EP1786161A2 (en) Communication system, device, and program
US10320863B2 (en) Context-based analytics for collaboration tools
US20130326362A1 (en) Electronic communicating
WO2021164288A1 (en) File commenting method and apparatus, comment viewing method and apparatus, computer device, and storage medium
EP2712132A1 (en) A method for displaying e-mail messages to a user
US11962630B2 (en) Methods and systems for multimedia communication while accessing network resources
CN113711618B (en) Authoring comments including hyperlinks referencing typing of video content
US12003555B2 (en) Methods and systems for multimedia communication while accessing network resources
CN115567471A (en) Method, device, equipment and storage medium for presenting session message
KR20220002850A (en) Method and apparatus for displaying an interface for providing a social network service through an anonymous based profile
US20220179595A1 (en) Systems and Methods for Documentation Through Gleaning Content with an Intuitive User Experience
CN113971392A (en) Document editing method, device, equipment and medium
US11876771B2 (en) Message display method and apparatus, computer device, storage medium, and program product
CN113767408A (en) Out-of-context contact activity in-context display
CN114089894B (en) Picture editing method and device
CN113810203B (en) Theme session processing method, device, computer equipment and storage medium
KR102302106B1 (en) Method and apparatus for providing information of social network service related activity to chat rooms
WO2023134255A1 (en) Information insertion method and apparatus, device, medium, and computer program product
WO2023169238A1 (en) Interaction data processing method and apparatus, and program product, computer device and medium
US11784955B1 (en) Virtual space server redundancy across geographic regions

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
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 40050589

Country of ref document: HK

GR01 Patent grant
GR01 Patent grant