CN113655939A - Data content processing method and device, electronic equipment and storage medium - Google Patents

Data content processing method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN113655939A
CN113655939A CN202110961298.2A CN202110961298A CN113655939A CN 113655939 A CN113655939 A CN 113655939A CN 202110961298 A CN202110961298 A CN 202110961298A CN 113655939 A CN113655939 A CN 113655939A
Authority
CN
China
Prior art keywords
area
data
state
data content
selection
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.)
Granted
Application number
CN202110961298.2A
Other languages
Chinese (zh)
Other versions
CN113655939B (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.)
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Wuhan Kingsoft Office Software Co Ltd
Original Assignee
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Wuhan Kingsoft Office Software 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 Beijing Kingsoft Office Software Inc, Zhuhai Kingsoft Office Software Co Ltd, Wuhan Kingsoft Office Software Co Ltd filed Critical Beijing Kingsoft Office Software Inc
Priority to CN202110961298.2A priority Critical patent/CN113655939B/en
Publication of CN113655939A publication Critical patent/CN113655939A/en
Application granted granted Critical
Publication of CN113655939B publication Critical patent/CN113655939B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842Selection of displayed objects or displayed text elements
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Human Computer Interaction (AREA)
  • Document Processing Apparatus (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention relates to a data content processing method, a device, an electronic device and a storage medium, wherein the method comprises the following steps: receiving a first operation on a data collaboration document; determining a first area of a data collaboration document for performing a first operation; updating the selected states of all data contents of the first area to the same state; alternatively, the option state of a part of the data content of the first area is updated to a selected data content state and the option state of another part of the data content of the first area is updated to a non-selected data content state. Therefore, through one operation step (namely, the first operation), the selection state of the batch data content in the first area can be flexibly and quickly adjusted, the data content required by the user can be conveniently and efficiently selected, the working efficiency of selecting the batch data content is improved, and the use convenience feeling of the user is improved.

Description

Data content processing method and device, electronic equipment and storage medium
Technical Field
The embodiment of the invention relates to the field of automated office, in particular to a data content processing method and device, electronic equipment and a storage medium.
Background
The data content can be edited and stored by using the data collaboration document, and the data content in the data collaboration document can be displayed in a grid table form or a view form. According to the usage requirement, a user usually selects batch data content in a grid table used for presenting data content, so as to perform batch processing on the selected data content, for example, referring the batch data content to other documents and the like.
In the related technology, the selection steps of the batch data content are as follows: the user selects the data contents one by one and executes the selection operation repeatedly until all the required data contents are selected. Therefore, selection operation for the batch data content is complicated and redundant, and related work efficiency of selection of the batch data content is low and user experience is poor.
Disclosure of Invention
The invention provides a data content processing method, a data content processing device, electronic equipment and a storage medium, which can conveniently and efficiently select data contents required by a user, improve the working efficiency of selecting batch data contents and increase the use convenience of the user.
According to a first aspect of the present invention, there is provided a data content processing method, comprising:
receiving a first operation on a data collaboration document;
determining a first region of the data collaboration document for which the first operation is performed;
updating the selected states of all data contents of the first area to be the same state; or, the optional state of the partial data content of the first area is updated to a selected data content state and the optional state of the other partial data content of the first area is updated to a non-selected data content state.
Optionally, the selected states of all data contents of the first area are updated to the same state; or, updating the optional state of the partial data content of the first area to a selected data content state and updating the optional state of the other partial data content of the first area to a non-selected data content state, includes:
determining a second region in the data collaboration document;
and setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
Optionally, the second region is arranged at an interval with the first region in the data collaboration document; or the second area and the first area are continuously arranged in the data collaboration document; or, in the data collaboration document, the second region is included in the first region layout.
Optionally, the setting, according to the selected state of the data content in the second area, the selected state of the data content in the first area to be consistent with the selected state of the data content in the second area includes:
acquiring a second number of second selected data identifiers of the second area; wherein the data content of the second region is divided into the second number of portions, each portion corresponding to a corresponding second option data identifier one-to-one;
according to the second quantity, dividing the first area into at least one first sub-area, wherein the first quantity of the first selected data marks of each first sub-area is the same as the second quantity;
and updating the selection state of the first selected data identifier according to the selection state of the second selected data identifier and the arrangement sequence of the selection states.
Optionally, the dividing the first region into at least one first sub-region according to the second number includes:
under the condition that the second area contains a second selected data identifier, dividing the first area along the first direction or the second direction by taking each first sub-area containing a first selected data identifier as a unit;
or, under the condition that the second area contains a plurality of second optional data identifiers, dividing the first area along the first direction or the second direction by taking a unit that each first sub-area contains a plurality of first optional data identifiers; the number of the second optional data identifiers is the same as that of the first optional data identifiers.
Optionally, before dividing the first region in the first direction or the second direction by using a unit that each first sub-region includes a plurality of first optional data identifiers, the method further includes:
judging whether the selection states of the plurality of second selection data identifiers are unique or not;
under the condition that the selection states of the plurality of second selection data identifications are not unique, determining the coordinate position and the selection state corresponding to each second selection data identification;
and sorting the selection states of the plurality of second selection data identifications according to the coordinate position of each second selection data identification, and setting the selection state of each first selection data identification in the first sub-area according to a sorting result.
Optionally, the selected states of all data contents of the first area are updated to the same state; or, updating the optional state of the partial data content of the first area to a selected data content state and updating the optional state of the other partial data content of the first area to a non-selected data content state, includes:
determining a current selection state of each first selection data identifier of the first area;
and automatically setting the selection state of each first selection data identifier of the first area to be opposite to each corresponding current selection state.
Optionally, the selected states of all data contents of the first area are updated to the same state; the method comprises the following steps:
determining associated data content;
the option status of the associated data content is automatically set to the same option status.
Optionally, after the selected states of all data contents of the first area are updated to the same state; or after updating the optional state of the partial data content of the first area to the selected data content state and updating the optional state of the other partial data content of the first area to the unselected data content state, the method further comprises:
receiving a second operation on the data collaboration document;
judging whether a third area of the data collaboration document subjected to the second operation is located in the first area;
and in the case that the third area is determined to be located in the first area, re-determining the first area of the data collaboration document which performs the first operation.
According to a second aspect of the present invention, there is also provided a data content processing apparatus comprising:
the receiving module is used for receiving a first operation on the data collaboration document;
a determination module to determine a first region of the data collaboration document for performing the first operation;
the processing module is used for updating the selected states of all the data contents of the first area to the same state; or, the optional state of the partial data content of the first area is updated to a selected data content state and the optional state of the other partial data content of the first area is updated to a non-selected data content state.
Optionally, the processing module includes:
a determination submodule configured to determine a second region in the data collaboration document;
and the processing submodule is used for setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
According to a third aspect of the present invention, there is also provided an electronic device comprising a memory for storing a computer program and a processor; the processor is adapted to execute the computer program to implement the method according to the first aspect of the invention.
According to a fourth aspect of the present invention, there is also provided a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method according to the first aspect of the present invention.
By adopting the data content processing method, the data content processing device, the electronic equipment and the storage medium, the first operation on the data cooperation document can be received, then the first area for executing the first operation is determined in the data cooperation document, and the selection state of the data content in the first area is updated. Specifically, the updating of the selection state of the data content of the first area may be updating the selection states of all the data contents of the first area to the same state; it may also be that the optional status of a part of the data content of the first area is updated to a selected data content status and the optional status of another part of the data content of the first area is updated to a non-selected data content status. In this way, the selection state of the batch data content in the first area can be flexibly and quickly adjusted through one operation step (i.e., the first operation), so that not only can the co-selection state of the batch data content be updated through one operation step, but also the selection state of each data content part of the batch data content can be updated through one operation step, and the selection states of each data content part are different from each other. The data content that can be convenient, high-efficiently need the user chooses for use, promotes the work efficiency that data content chooseed for use in batches, increases user's convenient impression of using.
Further features of embodiments of the present invention and advantages thereof will become apparent from the following detailed description of exemplary embodiments of the invention, which is to be read in connection with the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the embodiments of the invention.
FIG. 1 is a method flow diagram of a data content processing method according to some embodiments of the invention;
FIG. 2a is a schematic diagram of a trajectory of a moving mouse cursor in a first operation in accordance with some embodiments of the present invention;
FIG. 2b is a schematic view of a first region of some embodiments of the present invention;
FIG. 3 is a method flow diagram of another data content processing method of some embodiments of the present invention;
FIG. 4a is a schematic illustration of the positional relationship of a first region and a second region in accordance with some embodiments of the present invention;
FIG. 4b is a schematic illustration of another positional relationship of the first region and the second region of some embodiments of the present invention;
FIG. 5a is a schematic view of a first region and a second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 5b is a schematic view of another first region and second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 5c is a schematic illustration of yet another first region and second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 5d is a schematic illustration of another first region and second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 5e is a schematic illustration of another first region and second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 5f is a schematic illustration of another first region and second region in the case where the first region comprises the second region in some embodiments of the present invention;
FIG. 6 is a method flow diagram of yet another data content processing method of some embodiments of the present invention;
FIG. 7a is a schematic view of a first subregion in some embodiments of the invention;
FIG. 7b is a schematic view of another first subregion in some embodiments of the invention;
FIG. 7c is a schematic illustration of yet another first subregion in some embodiments of the invention;
FIG. 7d is a schematic illustration of a further first subregion in some embodiments of the invention;
FIG. 8 is a schematic diagram illustrating a comparison of the selected status of data content before and after updating in accordance with some embodiments of the present invention;
FIG. 9 is a diagrammatic illustration of a content selection interface in a method of data content processing according to some embodiments of the present invention;
FIG. 10 is a schematic illustration of a content selection interface in another data content processing method according to some embodiments of the invention;
FIG. 11 is a diagram illustrating content selection results in a method of processing data content according to some embodiments of the invention;
FIG. 12 is a functional block diagram representation of a data content processing apparatus according to some embodiments of the inventions;
FIG. 13 is a hardware architecture diagram of an electronic device according to some embodiments of the invention.
Detailed Description
Various exemplary embodiments of the present application will be described in detail below with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, the numerical expressions, and numerical values set forth in these embodiments do not limit the scope of the present application unless specifically stated otherwise.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the application, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail but are intended to be part of the specification where appropriate.
In all examples shown and discussed herein, any particular value should be construed as merely illustrative, and not limiting. Thus, other examples of the exemplary embodiments may have different values.
It will be understood that, although the terms first, second, etc. may be used herein in one or more embodiments to describe various information, these information should not be limited by these terms. These terms are only used to distinguish one type of information from another. For example, a first can also be referred to as a second and, similarly, a second can also be referred to as a first without departing from the scope of one or more embodiments of the present description.
In addition, in one or more embodiments of the present description, a first direction and a second direction are adopted, where the first direction may be a transverse direction, and a corresponding second direction may be a longitudinal direction; or the first direction may be a longitudinal direction and the corresponding second direction may be a transverse direction. The horizontal and horizontal line directions refer to the horizontal direction parallel to the horizontal ground by taking the display interface which can be recognized by naked eyes when a user looks flat and is used for normally and accurately displaying the data content as the reference aiming at the data content displayed on the display interface of the client; the directions of the longitudinal line and the vertical line refer to the vertical direction which is perpendicular to the horizontal ground and is based on the display interface which can be recognized by naked eyes when a user looks flat and displays the data content normally and accurately for the data content displayed on the display interface of the client.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
The invention can be applied to data cooperation documents, the data cooperation documents can be displayed in a grid table mode and can also be displayed in a view mode, and the invention belongs to a data management type document with multiple display forms. In the case where the data contents in the data cooperation document are displayed in the form of a grid table, the data contents are laid out in the respective cells constituting the rows and/or in the respective cells constituting the columns. Aiming at the data content displayed on the display interface of the client, the display interface which can be recognized by naked eyes when a user looks flat is taken as a reference, the data content is normally and accurately displayed on the display interface, and the rows are areas formed by transverse lines; the columns are areas formed by vertical lines; the table formed by intersecting rows and columns is a cell.
It should be noted that the execution subject of the embodiment of the present invention may be an application running on a browser, and the application is a web page program (web App) of the browser on the terminal.
In addition, the terminal device according to the embodiment of the present invention may include, but is not limited to, a mobile phone, a Personal Digital Assistant (PDA), a wireless handheld device, a Tablet Computer (Tablet Computer), a Personal Computer (PC), a palmtop Computer (PDA), a wearable device (such as smart glasses, a smart watch, and the like), and the like.
Various embodiments and examples according to the present invention are described below with reference to the accompanying drawings.
< method examples >
Fig. 1 is a flowchart of a method for processing data content according to an embodiment of the present invention. As shown in fig. 1, the method includes the following steps S110 to S130.
Step S110: a first operation on a data collaboration document is received.
The first operation may be a dragging operation of a mouse cursor, for example, a user drags the mouse cursor of the terminal interface by long pressing a left mouse button; or, the user drags the mouse cursor of the terminal interface by long-pressing the right mouse button; or, the user drags the mouse cursor of the terminal interface by rolling the mouse wheel; alternatively, the user controls dragging the mouse cursor on the touch display screen by a finger, a stylus, or the like.
Step S120: a first region of a data collaboration document that is subject to a first operation is determined.
And taking the area in the data collaboration document where the first operation is performed as a first area. According to the execution starting to the execution stopping of the first operation, the first operation is determined to be started at a first position of the data cooperation document, the first operation is determined to be stopped at a second position of the data cooperation document, and a continuous section formed from the first position to the second position is the first area. Exemplarily, taking the first operation as a dragging operation of a mouse cursor, taking a received instruction of pressing a left button of a mouse for a long time by a user as a first operation instruction for starting execution, and taking a position of a data collaboration document where the mouse cursor is currently located as a start position of a first area; and taking the received instruction of releasing the left mouse button by the user as an instruction for stopping executing the first operation, and taking the position of the data cooperation document where the mouse cursor is located at present as the termination position of the first area.
For example, if the mouse cursor is located at the row identifier "3" of the data collaboration document when the first operation instruction is executed, the initial position is the third row; when the mouse cursor is located at the line identifier "15" of the data cooperation document under the condition of stopping the first operation instruction, the termination position is the fifteenth line, and thus the continuous region from the third line to the fifteenth line is the first region for performing the first operation. For another example, if the mouse cursor is located in the first cell corresponding to the 1 st column in the 2 nd row of the data collaboration document under the condition of executing the first operation instruction, the initial position is the first cell; and if the mouse cursor is positioned in a second cell corresponding to the 1 st column in the 18 th row of the data cooperation document under the condition of stopping the first operation instruction, the termination position is the second cell, and therefore the continuous area from the first cell to the second cell is the first area for performing the first operation.
It should be noted that the first operation may be performed on any one of the objects in the row, column, and cell of the data collaboration document. However, the objects each time the first operation is performed need to be of the same type, and the direction in which the first operation is performed each time is one of the lateral direction or the longitudinal direction. For example, if the first operation command is started to be executed on the row in the row, column or cell, the corresponding first operation command is stopped to be executed on the row, in which case the dragging direction of the mouse cursor is vertical; if the first operation instruction is executed on the three cells which are sequentially and adjacently arranged, the corresponding first operation instruction which is stopped to be executed is also executed on the three cells which are sequentially and adjacently arranged. If the first operation command is executed on a plurality of cells which are sequentially and adjacently arranged, the corresponding first operation command is also executed on a plurality of cells which are sequentially and adjacently arranged. The dragging direction of the mouse cursor can be horizontal or vertical, and so on.
Taking the grid table as an example, as shown in fig. 2a, the data content in the leftmost column in the grid table 20 (i.e. the column where the sequence numbers such as "1", "2", "3", "4" … …, etc. are located in fig. 2 a) is a row number (i.e. the sequence numbers such as "1", "2", "3", "4" … …, etc. in fig. 2 a), and each row number corresponds to one row in the grid table 20, i.e.: the first row corresponding to row number 1, the second row … … corresponding to row number 2, and so on. Dragging the mouse cursor from the first row to the sixth row, that is, dragging the mouse cursor from the first row corresponding to row number 1 to the sixth row corresponding to row number 6, as shown in fig. 2b, the first area is an area corresponding to a shaded portion in fig. 2b, and the area includes areas of all cells in the first row to the sixth row.
The left side of the grid table refers to the position of the grid table which is displayed on the display interface of the client and can be seen by the naked eyes of the user to the left by taking the display interface which can be recognized by the naked eyes when the user looks flat and the display interface displays the data content normally and accurately as a reference; the right side of the grid table refers to the position of the grid table which is displayed on the display interface of the client side and can be recognized by naked eyes when a user looks flat, and the grid table is looked rightwards by naked eyes of the user on the basis that the display interface normally and accurately displays data content.
In some examples, as shown in fig. 2b, after the first area is determined according to the first operation, the row number of each row in the first area may be updated to be an icon 21 to distinguish the first area from other areas except the first area in the grid table 20, in which case, the user may explicitly know the first area corresponding to the first operation.
Of course, it is understood that the manner of distinguishing the first area from the other areas in the grid table 20 except the first area shown in fig. 2b is only an example, and in the embodiment of the present invention, the row number of each row in the first area is not updated to the icon 21, that is, the row number of each row is continuously displayed, but only the background color of the first area and/or the other areas in the grid table 20 except the first area are adjusted, so that the background color of the first area is different from the background color of the other areas, so as to distinguish the first area from the other areas in the grid table 20 except the first area.
It is understood that the column of "number" in the grid table 20 only illustrates the case that the highest number of the number is four-digit, and in practical cases, the highest number of the number may include, but is not limited to, four-digit, for example, N-digit numbers such as five-digit numbers, six-digit numbers, etc. (N is a natural number and N is greater than or equal to 1).
The components in the system may be constructed by a layered architecture, and in this case, the system may be logically divided into a User Interface Layer (UIL), a Business Logic Layer (BLL), and a Data Access Layer (DAL). The UIL can collect information and operation input by a user through a terminal, the BLL can acquire the information and operation collected by the UIL from the UIL, execute service logic on the information and operation, and return result data of executing the service logic to the UIL for displaying; the UIL may also invoke the BLL to display data retrieved by the BLL from the database via the DAL (the BLL may invoke the DAL to read the data from the database) on an interface of the terminal application. Based on this, in the embodiment of the present invention, after the user inputs the first operation, the first operation is recorded in the UIL, so that the position of the mouse cursor currently in the data collaboration document (i.e. the above-mentioned starting position) can be recorded in the case where the user starts to perform the first operation with the mouse; the position of the mouse cursor currently in the data cooperation document (i.e., the above-described termination position) may be recorded in a case where the user releases the mouse to stop performing the first operation.
Step S130: updating the selected states of all data contents of the first area to the same state; alternatively, the option state of a part of the data content of the first area is updated to a selected data content state and the option state of another part of the data content of the first area is updated to a non-selected data content state.
The data content is characters, numbers, characters, letters, pictures and the like filled in the cells.
Updating, namely, automatically setting the selection state according to the data content in the data collaboration document, wherein the process is performed without any manual operation auxiliary adjustment of an external user. The selected data content state and the unselected data content state can be embodied by identifiers, namely, the data content and the state identifiers establish an association relationship, and under the condition that the state identifiers are selected (for example, a pair of hooks and dots are marked in the state identifiers), the data content corresponding to the state identifiers is in a selected state; if the status indicator is not selected (e.g., the status indicator remains unchanged), the data content corresponding to the status indicator is in an unselected state. The user may refer to the data content in the selected state to other documents or perform calculation statistics, etc., which is not limited in the present invention.
In some embodiments, in the case of determining a first region of the data collaboration document in which to perform the first operation, the selected state of all data contents of the first region may be updated to the same state; the same state refers to that the selected states of all the data contents of the first area are the same state. That is, the selected state of all the data contents of the first area is the selected data content state, or the selected state of all the data contents of the first area is the unselected data content state.
In other embodiments, where a first region of a data collaboration document is determined for a first operation, the opt-in status of a portion of the data content of the first region may be updated to a selected data content state and the opt-in status of another portion of the data content of the first region may be updated to an unselected data content state. The partial data content and the other partial data content are combined to form the whole data content of the first area, and the partial data content and the other partial data content have no association relation such as inclusion and overlapping and are independent parts.
For example, the first area is an area of all cells in rows 2 to 8 of the data collaboration document, and the data content in rows 2 to 5 may be partial data content of the first area; the data content of lines 6 to 8 may be another part of the data content of the first area. For another example, the first area is an area of all cells in rows 2 to 8 of the data collaboration document, and the data content in rows 2, 5, and 7 may be partial data content of the first area; the data content of the 3 rd, 4 th, 6 th and 8 th rows other than the 2 nd, 5 th and 7 th rows may be another part of the data content of the first area.
The entire data content of the first area is divided into a plurality of portions, and the optional state of the data content of each portion comprises one of a selected data content state or an unselected data content state. The optional status of the entire data content including at least one of the selected data content status and the unselected data content status may include the following three conditions:
first, the selection states of all the data contents of the automatically set (updated) first area are all the selected data content states, that is, all the data contents of the first area are selected, in which case, the selection states of all the data contents only include the selected data content states.
Secondly, the updated selected states of all the data contents of the first area are unselected data content states, that is, all the data contents of the first area are unselected, in this case, the selected states of all the data contents only include the unselected data content states.
Thirdly, the selected state of a part of the updated total data content in the first area is a selected data content state, and the selected state of the other part of the updated total data content is an unselected data content state.
Therefore, in the embodiment of the invention, the selection state of the data content in the first area is updated by receiving the first operation on the data collaboration document, and then determining the first area for executing the first operation in the data collaboration document. Specifically, the updating of the selection state of the data content of the first area may be updating the selection states of all the data contents of the first area to the same state; it may also be that the optional status of a part of the data content of the first area is updated to a selected data content status and the optional status of another part of the data content of the first area is updated to a non-selected data content status. In this way, the user can flexibly and quickly adjust the selection state of the batch data content in the first area only by inputting the first operation (one operation step), so that the simultaneous selection state update of the batch data content through one operation step can be realized, the selection state update of each data content part of the batch data content through one operation step can also be realized, and the selection states of each data content part are different from each other. That is, other operations do not need to be executed, automatic setting of the selection states of all data contents in the first area can be achieved, setting operation of the selection states of the batch data is simplified, the purpose of selecting data contents needed by a user conveniently and efficiently is achieved, working efficiency of selection of the batch data contents is improved, and use convenience of the user is improved.
The manner of updating the option status of the entire data content of the first area may be various, and is described in detail below by several embodiments.
In some embodiments, as shown in FIG. 3, the execution of step S130 may include the following steps S310-S320.
Step S310: a second region is determined in the data collaboration document.
In some embodiments, the second region may be laid out at a data collaboration document interval from the first region. The interval arrangement means that other areas are arranged between the second area and the first area. The other area may be a blank area or a non-blank area having data content.
Taking the grid table as an example, as shown in fig. 4a, in the grid table 20, the first area 31 includes areas of all cells in the first row corresponding to the row number 1, the second row corresponding to the row number 2, and the third row corresponding to the row number 3, the second area 32 includes areas of all cells in the sixth row corresponding to the row number 6, the seventh row corresponding to the row number 7, and the eighth row corresponding to the row number 8, the first area 31 and the second area 32 are separated by areas of all cells in the fourth row corresponding to the row number 4 and the fifth row corresponding to the row number 5 located therebetween, and the areas of all cells in the fourth row corresponding to the row number 4 and the fifth row corresponding to the row number 5 are the separation areas 30.
The spacing region 30 may be a blank region or a non-blank region. For example, at least one cell of the space region 30 is filled with data content, in which case the space region 30 is a non-blank region; if all cells of the space area 30 are not filled with data, the space area 30 is a blank area.
Fig. 4a only exemplarily shows a case where the first region, the second region, and the spacing region are regions of all cells of one or more rows. In the embodiment of the present application, the first region, the second region, and the spacing region are not limited to the region of all the cells of one or more rows. For example, the first region includes a plurality of cells arranged adjacently (for example, three cells arranged adjacently), the second region includes a plurality of cells arranged adjacently (for example, three cells arranged adjacently), and the partition region includes a plurality of cells arranged adjacently (for example, three cells arranged adjacently).
It is understood that the first region 31, the spacing region 30 and the second region 32 shown in fig. 4a are arranged in a longitudinal direction, and in practical cases, the first region 31, the spacing region 30 and the second region 32 may also be arranged in a transverse direction.
In other embodiments, the second region may be laid out continuously with the first region in the data collaboration document. The continuous arrangement means that the second region is adjacent to the first region, and no other region is present between the second region and the first region. For example, the second region is a portion of the border line shared with the first region. For example, in the grid table, the first area is surrounded by the first border line, the second border line, the third border line and the fourth border line. The first border wire is adjacent to the second border wire and the fourth border wire, respectively, and the first border wire is opposite to the third border wire. The second region is a region that shares the first border wire, the second border wire, the third border wire, or the fourth border wire with the first region. Taking the grid table as an example, as shown in fig. 4b, the first area 41 is an area of one cell, and the second area 42 is an area of another cell. The first region 41 and the second region 42 are continuously arranged, and the second region 42 is a region located in the periphery of the first region 41 and is one of the cells sharing a part of the frame line with the cells in the first region 41. In fig. 4b, the filling pattern of the cells that can be the second region 42 is the same. The first region may include a plurality of continuous cell regions. Continuing to refer to fig. 4b, taking a plurality of continuous cells as two adjacent cells as an example, the first area 41 'includes areas of two adjacent cells, in this case, the second area 42' is an area of another cell except the first area 41, such as an area where the "name" column and the seventh row with row number 7 in fig. 4b intersect; alternatively, the second area 42 'also includes a plurality of continuous cells, and the number of cells included in the second area is the same as the number of cells included in the first area 41, for example, the second area 42' in fig. 4b may be an area within any one of two dashed frames, and the area within one of the two dashed frames includes an area of two cells, where the area of one cell is an area where a column of "number" and a sixth row with a row number of 6 intersect, and the area of the other cell is an area where a column of "date" and a sixth row with a row number of 6 intersect; the area within the other of the two dashed boxes includes two cell areas, where the area of one cell is the area where the column of "number" crosses the eighth row with a row number of 8, and the area of the other cell is the area where the column of "date" crosses the eighth row with a row number of 8.
In the data collaboration document, the second region is laid out to be included in the first region. The term "comprising" means that the second region is located in the first region and is a part of the first region. In this case, the occupied interface size of the second region is smaller than the occupied interface size of the first region.
The first region and the second region in the above-described inclusion relationship will be described below by way of a few examples.
Taking a grid table as an example, the first area includes areas of all cells in one row in the grid table, and the second area is an area of any cell in the first area; or the first area comprises the area of all cells in one column in the grid table, and the second area is the area of any cell in the first area. Example two, taking the grid table as an example, the first area includes an area of all cells in a plurality of consecutive rows in the grid table, and the second area includes an area of all cells in a row in the plurality of consecutive rows.
As shown in fig. 5a, the first region 51 (the region within the dashed box in fig. 5 a) includes regions of all cells of the first to sixth rows in the grid table 20, and the second region 52 (the shaded region in fig. 5 a) includes regions of all cells of the first row in the grid table 20.
Taking the grid table as an example, the first area includes an area of all cells in a plurality of consecutive rows in the grid table, and the second area includes an area of all cells in at least two rows of the plurality of consecutive rows. At least two rows may be continuous or spaced. Wherein, at least two rows in the second area are arranged continuously, that is, at least two rows in the second area are continuous and are not separated by other areas except the second area. The at least two rows of the second region are spaced apart, i.e. the second region is spaced apart into a plurality of sections, each section comprising one or more of the at least two rows of the second region, and the regions of any two of the plurality of sections do not overlap.
As shown in fig. 5b and 5c, the first region 51 (the region within the dotted frame in fig. 5b and 5 c) includes regions of all cells of the first to sixth rows in the grid table 20, and the second region 52 (the shaded region in fig. 5b and 5 c) includes regions of all cells of the three rows in the grid table 20. Wherein, in fig. 5b, the second area 52 includes areas of all cells in the first to third rows of the grid table 20, and three rows in the second area 52 are continuous; in fig. 5c, the second area 52 includes areas of all cells in the first, third and fourth rows of the grid table 20, and three rows in the second area 52 are arranged at intervals.
Example four, the first region includes a region of all cells in a plurality of consecutive columns in the grid table, in which case the second region may include a region of all cells in a column of the plurality of consecutive columns.
As shown in fig. 5d, the first region 51 (the region within the dashed box in fig. 5 d) includes the regions of all cells in the first column to the third column in the grid table 20, and the second region 52 (the shaded region in fig. 5 d) includes the regions of all cells in the first column (i.e., the "name" column) in the grid table 20.
Example five, the first region comprises a region of all cells in a plurality of consecutive columns in the grid table, in which case the second region may comprise a region of all cells in at least two columns of the plurality of consecutive columns. At least two columns can be continuous or arranged at intervals. At least two rows in the second area are continuously arranged, namely at least two rows in the second area are continuous and are not separated by other areas except the second area. At least two columns in the second area are arranged at intervals, namely the second area is divided into a plurality of parts, each part comprises one or more columns in at least two columns in the second area, and the areas of any two parts in the plurality of parts are not overlapped.
As shown in fig. 5e and 5f, the first region 51 (the region within the dashed box in fig. 5e and 5 f) includes regions of all cells of the first to third columns in the grid table 20, and the second region 52 (the shaded region in fig. 5e and 5 f) includes regions of all cells of the two columns in the grid table 20. Wherein, in fig. 5e, the second area 52 includes areas of all cells in the first column and the second column in the grid table 20, and two columns in the second area 52 are continuous; in fig. 5f, the second area 52 includes areas of all cells in the first and third columns of the grid table 20, and two columns of the second area 52 are spaced apart.
The manner in which the second region is determined may be various. For example, in the grid table, it is understood that fig. 5a to 5f exemplarily show only one of the above-described examples two to five. Any one of the first region and the second region that conforms to examples one to five falls within the scope of the present invention.
Step S320: and setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
The fact that the selection state of the data content of the first area is consistent with the selection state of the data content of the second area means that: the arrangement sequence of the selected states of the data contents in the first area is consistent with the arrangement sequence of the selected states of the data contents in the second area.
For example, the arrangement order of the selected states of the data content in the second area is the selected data content state, the unselected data content state, and the selected data content state in turn, and the arrangement order of the selected states of the data content in the first area is also the selected data content state, the unselected data content state, and the selected data content state in turn. In this way, when the data content of the second area includes only one option state, the purpose of updating the option states of all the data content of the first area to the same state, that is, updating the option states of all the data content of the first area to the same option states as the option states of the data content of the second area, can be achieved. Under the condition that the data content of the second area contains multiple selection states, the selection state of part of the data content of the first area can be updated to a selected data content state, and the selection state of the other part of the data content of the first area can be updated to an unselected data content state, so that the batch data content of the first area is subjected to composite selection state updating, the user operation is simplified, and the requirement of efficiently selecting multiple data contents required by a user is met.
In some examples, as shown in fig. 6, the execution process of step S320 may include the following steps S610 to S630:
step S610: and acquiring a second number of second selected data identifications of the second area.
The data content of the second region is divided into a second number of portions, each portion having a corresponding and uniquely corresponding second option data identification. The optional state of the data content corresponding to each second optional data identifier is unique, that is, the data content corresponding to each second optional data identifier can be regarded as a whole to specify whether the optional state is the selected data content state or the unselected data content state.
The second optional data identifier refers to a mark for representing the optional state of the data content. The association relationship is established between the second optional data identifier and the data content, and the user can control the optional state of the data content associated with the second optional data identifier to be one of the states (the states include a selected data content state and an unselected data content state) through the operation of selecting (for example, making a pair of hooks and dots in the state identifier) or not selecting the mark.
The selected data content state and the unselected data content state may be embodied by identifiers, that is, the data content and the state identifiers are associated, and in a case that the state identifiers are selected (for example, in fig. 2b, a tick mark is marked in the state identifiers, or a dot mark is marked in the state identifiers, or the like), the selected state of the data content corresponding to the state identifiers is the selected data content state, or the data content corresponding to the state identifiers is in the selected state; when the status flag is not selected (for example, the status flag remains as it is), the selected status of the data content corresponding to the status flag is an unselected status of the data content, or the data content corresponding to the status flag is in an unselected status.
Taking the grid table as an example, the second area includes a plurality of cells in the grid table. For example, the entire content data of the second area may be divided into a portion of each cell, and the data content in each cell is associated with a second option data identifier. For another example, the entire content data of the second area may be divided into two rows, and the data content of each row is associated with a second optional data identifier.
It should be noted that the data collaboration document may identify and locate the cells, rows, or columns that need to be processed in the selected state according to the positions of the cells, rows, or columns therein. The location identity may be stored in the form of a manifest at the server or locally.
Therefore, the purpose of determining the selection state of the second selection data identifier of the second area can be achieved, and the selection state update matched with the second selection data identifier can be accurately carried out on the data content of the first area.
Step S620: and dividing the first area into at least one first sub-area according to the second quantity, wherein the first quantity of the first selected data identifications of each first sub-area is the same as the second quantity.
The first option data identification refers to a flag for embodying an option status of data content in the first area. And a relationship is established between the first selected data identifier and the data content in the first area, and the user controls the selected state of the data content associated with the first selected data identifier to be a selected data content state or an unselected data content state through the operation of selecting (for example, punching a pair of hooks and dots in the state identifier) or not selecting the first selected data identifier.
Under the condition that the first quantity of the first selected data identifiers of the first sub-area is the same as the second quantity of the second selected data identifiers, the data content of the first sub-area and the data content of the second area can be matched according to the first selected data identifiers and the selected data identifiers, and the selected state of the data content of each first selected data identifier in the first sub-area is updated according to the matching result and the selected state of the data content of each second selected data identifier in the second area.
Step S630: and updating the selection state of the first selection data identifier according to the selection state and the arrangement sequence of the selection state of the second selection data identifier.
The arrangement order of the selected states may be a sorting result obtained by sorting the selected states of each second selected data identifier from small to large or from large to small of the position identifier. The location identification can be recorded in a location form of the server, and can also be recorded locally.
Taking the position identifiers from small to large as an example, the position identifier corresponding to each second selected data identifier is a position identifier of one row. In this case, if the second number of the second optional data identifiers in the second area is 3, the 3 second optional data identifiers include the second optional data identifier in the 2 nd row, the second optional data identifier in the 3 rd row, and the second optional data identifier in the 4 th row, the position identifiers of the data contents corresponding to the 3 second optional data identifiers include the position identifier in the 2 nd row, the position identifier in the 3 rd row, and the position identifier in the 4 th row, and the optional states of the data contents corresponding to the 3 second optional data identifiers are, in order, the selected data content state, the unselected data content state, and the selected data content state, and under this condition, according to the position identifier in the 2 nd row, the position identifier in the 3 rd row, and the position identifier in the 4 th row, it is determined that the optional states of the second optional data identifiers are arranged in order from small to large according to the position identifiers are, in order: the selected data content state, the unselected data content state and the selected data content state are arranged in sequence, after the first selected data identifier of the first subregion is also arranged in the sequence from small to large according to the position identifier, the selected state of the first selected data identifier arranged at the first position in the arrangement result is updated to the selected data content state, the selected state of the first selected data identifier arranged at the second position in the arrangement result is updated to the unselected data content state, the selected state of the first selected data identifier arranged at the third position in the arrangement result is updated to the selected data content state, so that in the updated first subregion, the selected state of the first selected data identifier and the selected state of the second selected data identifier are arranged in the sequence from small to large according to the position identifier of the 2 nd row, the position identifier of the 3 rd row and the position identifier of the 4 th row, and the selected state of the first selected data identifier and the selected state of the second selected data identifier are arranged in the sequence from small to large according to the position identifier The subsequent arrangement order is consistent.
Dividing the first area into at least one first sub-area according to the second number, including:
under the condition that the second area contains a second selected data identifier, dividing the first area along the first direction or the second direction by taking the first selected data identifier contained in each first sub-area as a unit; or, under the condition that the second area contains a plurality of second optional data identifiers, dividing the first area along the first direction or the second direction by taking the unit that each first sub-area contains a plurality of first optional data identifiers. The number of the second selective data identifiers in the second area is two or more than two, and the second number of the second selective data identifiers in the second area and the first number of the first selective data identifiers in the first sub-area are the same numerical value. That is, in the case that the second area includes 3 second option data identifiers, the first sub-area also includes 3 first option data identifiers.
The first direction may be a transverse direction and the corresponding second direction may be a longitudinal direction. Or the first direction may be a longitudinal direction and the corresponding second direction may be a transverse direction.
Taking the grid table as an example, the first direction is a horizontal direction, the second direction is a vertical direction, the second area may include a cell group, the cell group may include all cells in a row or all cells in multiple rows, or the cell group may include all cells in a column or all cells in multiple columns, or the cell group may include a plurality of cells arranged continuously or at intervals.
Illustratively, taking a grid table as an example, the first area includes an area of all cells in a row in the grid table, and the second area includes a cell group in the first area, where the cell group includes a plurality of cells arranged consecutively or at intervals in the row; or the second area comprises an area of all cells in a column in the grid table, and the second area comprises a cell group in the first area, wherein the cell group comprises a plurality of cells which are continuously arranged or arranged at intervals in the column.
The first direction is a horizontal direction, the second direction is a vertical direction, and in the case where the cell group includes all the cells in one row, as shown in fig. 7a, the first region 51 includes regions of all the cells in the first row to the third row, and in this case, the second region 52 may be regarded as a divided range region, and the first region may be divided into at least one first sub-region from the first row (the second region 52) of the first region along the vertical direction, to obtain two first sub-regions, the region 71 (diagonally shaded region) is one of the two first sub-regions, and the region 72 is the other of the two first sub-regions (diagonally shaded region). The number of cells in the areas 71 and 72 is the same as the number of cells in the second area 52, and the number of cells in the areas 71 and 72 is the same as the number of cells in the second area 52.
Illustratively, the first direction is a horizontal direction, the second direction is a vertical direction, and in a case that the cell group may include all the cells of one column, as shown in fig. 7b, the first region 51 includes regions of all the cells of the first column to the third column, in this case, the second region 52 may be taken as a divided range region, and the first region may be divided into at least one first sub-region from the first column (the second region 52) of the first region along the horizontal direction, resulting in two first sub-regions, as shown in fig. 7b, the region 71 (diagonally shaded region) is one first sub-region, and the region 72 is another first sub-region (horizontally shaded region). Since fig. 7b also belongs to the case where the second area is laid out in the first area, the cell group in the second area is also divided when dividing, but the resulting first sub-area does not include the cell group in the second area. It should be noted that, when the first area is divided and a complete first sub-area remains (for example, two lines remain after the division, and the first sub-area needs to be divided in units of every three lines), the remaining area corresponding to the complete first sub-area that cannot be divided is used as the second sub-area, and the selection state of each first selection data identifier in the second sub-area is continuously updated according to the manner of updating the selection state of each data content in the first sub-area, but only the selection state of the first selection data identifier corresponding to the last position identifier of the second sub-area is updated.
Therefore, by dividing the first area into a plurality of first sub-areas, at least one first sub-area with the same number and arrangement mode of the cells can be quickly selected in the first area according to the number and arrangement mode of the cells in the cell group of the second area, and the purpose of integrally copying the selection states of the cells to the plurality of areas in the table (such as the grid table) is achieved.
In some embodiments, before the first region is divided in the first direction or the second direction by using each first sub-region including the plurality of first optional data identifiers as a unit, it may be further determined whether the optional states of the plurality of second optional data identifiers are unique, if the determination result is negative, the coordinate position and the optional state corresponding to each second optional data identifier are determined, then the optional states of the plurality of second optional data identifiers are sorted according to the coordinate position of each second optional data identifier, and the optional state of each first optional data identifier in the first sub-region is set according to the sorting result. The unique selection state refers to the same selection state, namely the selection states of the second selection data identifier are all selected data content states; or, the selected states of the second selected data identifier are all unselected data content states.
The two optional states are not unique, that is, the optional state of the second optional data identifier includes both the selected data content state and the unselected data content state.
And under the condition that the judgment result is negative, namely the selection states of the plurality of second selection data identifications are not unique, determining the coordinate position and the selection state corresponding to each second selection data identification.
Taking the grid table as an example, the coordinate position of the cell in the grid table where the data content corresponding to each second optional data identifier is located may be determined (for example, Am: Cn; where m and n are natural numbers greater than or equal to 1 and represent row position identifiers; A, C is a natural number greater than or equal to 1 and represent column position identifiers). The optional state is either a data content selected state or a data content unselected state. And sorting the selection states of the plurality of second selection data identifiers according to the coordinate position of each second selection data identifier, and setting the selection state of each first selection data identifier in the first sub-area according to a sorting result.
The sorting means that the data are sorted one by one in ascending order or descending order according to the size of the coordinate position identifier of the second selected data identifier.
For example, referring to fig. 7c, the data contents corresponding to the plurality of second optional data identifiers are arranged in three cells, and the data content of each cell corresponds to one optional data identifier. In the embodiment of the application, the coordinate position of the cell corresponding to each second selected data identifier is determined, and the selection states of the three second selected data identifiers are sorted according to the size of the coordinate position identifier in an ascending order or a descending order. In the present example, the text in parentheses in each cell of the second area 52 of fig. 7c represents the selected state of each cell, and referring to fig. 7c, the sorted result of the selected states identified by the 3 second selected data may be selected data content state (i.e., "selected" in the second area 52 of fig. 7 c) -unselected data content state (i.e., "unselected" in the second area 52 of fig. 7 c) -unselected data content state. In addition, the sorting result of the optional states identified by the three second optional data may also be unselected data content state-selected data content state. And setting the selection state of each first selection data identifier in the first subarea according to the sequencing result. According to the position identification size of each cell of each first subregion, sequentially setting the selection states of the cells of the first subregions to be a selected data content state, an unselected data content state and an unselected data content state according to ascending or descending order; or the selection states of the cells in the first subregion are sequentially set to be the unselected data content state, the unselected data content state and the selected data content state.
And under the condition that the selection states of the data contents corresponding to the second selection data identifications are unique, setting the selection state of the data contents in the first area as the selection state of the data contents corresponding to the second selection data identifications.
In other embodiments, after step S130 is executed, the embodiment of the present invention may further receive a second operation on the data collaboration document, and determine whether a third area of the data collaboration document on which the second operation is performed is located in the first area; in a case where it is determined that the third area is located in the first area, the first area of the data cooperation document in which the first operation is performed is newly determined.
The second operation may be an operation of adding or deleting an area in the data collaboration document. Taking a grid table as an example, the second operation may be an operation of adding a row or a column in the data collaboration document.
When judging whether the third area of the data cooperation document for performing the second operation is located in the first area, taking the grid table as an example, the coordinate positions of the first area and the third area may be obtained, and then, according to the coordinate positions of the first area and the third area, it is determined whether the third area is located in the first area. In the case where the determination result is yes, that is, the third area is located within the first area, the step of determining the first area of the data cooperation document to which the first operation is performed, that is, the step S120 and the subsequent steps thereof, are re-executed. And if the judgment result is negative, namely the third area is not located in the first area, ending the flow.
In some embodiments, in step S130, a current selection state of each first selection option data identifier of the first area may also be determined, and then the selection state of each first selection option data identifier of the first area is automatically set to be opposite to each corresponding current selection state. And each corresponding current selection state is the current selection state of the first selection data identifier. But rather refers to another selected state that is different from the current selected state.
As shown in fig. 7d, the first area 51 in fig. 7d includes three rows, and the first area 51 has three first optional data identifiers, which are in one-to-one correspondence with the three rows. For example, the current selection state of the first optional data identifier of the first row is determined to be the selected data content state, the current selection state of the first optional data identifier of the second row is the unselected data content state, and the current selection state of the first optional data identifier of the third row is the selected data content state, then the selection state of the first optional data identifier of the first row is automatically set to be the unselected data content state opposite to the current selection state of the first row, the selection state of the first optional data identifier of the second row is automatically set to be the selected data content state opposite to the current selection state of the second row, and the selection state of the first optional data identifier of the third row is automatically set to be the unselected data content state opposite to the current selection state of the third row.
For example, as shown in a part a and a part b in fig. 8, the selection icon indicates that the selected state is the selected data content state when the selection icon is checked, and indicates that the data content state is not selected when the selection icon is not checked.
Referring to FIG. 8, section a, the grid table includes 10 rows, with rows 1-3 and 5-7 being selected data content states and rows 4 and 8-10 being unselected data content states. In this case, the current selection state of all rows is obtained. The selection state of each row is automatically set to the selection state opposite to the current selection state. The setting result is as shown in part b of fig. 8, the current selection state of the 1 st to 3 rd lines and the 5 th to 7 th lines is updated to the unselected data content state, and the current selection state of the 4 th lines and the 8 th to 10 th lines is set to the selected data content state. The current selection state of the various lines may be obtained through the corresponding operations recorded in the UIL.
In some embodiments, updating the selected status of all data content of the first area to the same status comprises: the associated data content is determined and then the opt-in status of the associated data content is automatically set to the same opt-in status.
Associated data content means that there is a computational relationship or the same or similar or reference between data content, etc. The association degree between the data contents may be determined according to the selection of the user, and may be specifically set by a person skilled in the art according to the actual situation, which is not limited in the embodiment of the present invention.
In determining the associated data content, at least one region may be determined in the data collaboration document in response to a target operation specifying the target content, the data content in the region being the same as the target content.
The target operation may include a click operation on one cell in a plurality of rows or columns in the grid table, and in response to the click operation, pop up a content selection interface corresponding to the cell (as shown in fig. 9), where the content selection interface displays options corresponding to contents in all cells in the row or column in which the cell is located, and the target operation further includes an operation of selecting the corresponding options by a user, and the user selects the corresponding options in the content selection interface so as to select the contents corresponding to the options as target contents.
As shown in fig. 9, options corresponding to the contents of the cells included in each cell in the column (the column corresponding to the a number) selected by the user are displayed in the content selection interface. Namely: the content of the cells in the column includes "0001", "0002", "0003" and "0004" in the first to seventh rows, in which case the options displayed by the content selection interface include the options corresponding to "0001", "0002", "0003" and "0004". The user can select the above options. For example, the user has selected the option corresponding to "0004".
In some examples, in the case that the data content in the cell is blank, the options presented by the content selection interface may further include an option corresponding to "blank".
In some examples, as shown in fig. 9, the number of cells corresponding to the content of each option may also be displayed in the content selection interface. For example, "(2)" is also displayed behind "0001", indicating that the number of cells whose cell contents are 0001 is 2.
In some examples, as shown in fig. 9, the options presented in the content selection interface further include an option corresponding to "all-select", that is, after the option corresponding to "all-select" is selected, the data content in all the cells in the column corresponding to the a number may be selected as the associated data content immediately.
In some embodiments, a column selection pop-up window may pop up in response to a user clicking on a predetermined column selection control. In this case, the target column may be determined in response to an operation of a user to designate a target column among the plurality of columns in the column selection pop, for example, to designate the target column among the plurality of columns in the column selection pop.
For example, after the user clicks the predetermined column selection control, a pop-up window shown in fig. 10 pops up, in which the user is prompted to "specify a column, the row with the same content will be selected", and the user specifies the column corresponding to the a number, and then the column corresponding to the a number is the target column.
After that, a first line is designated as a target line, the data content in the cell where the target line and the target column intersect is taken as the target data content, and after that, the cell with the same target data content is determined in the target column, and the line where the cell is located is selected. As shown in fig. 11, the first row is selected by the user and the second row is automatically selected.
Fig. 12 is a functional block diagram of a data content processing apparatus according to some embodiments of the present invention. As shown in fig. 12, the data content processing device 160 includes:
a receiving module 161 is configured to receive a first operation on a data collaboration document.
The first operation may be a dragging operation of a mouse cursor, for example, a user drags the mouse cursor of the terminal interface by long pressing a left mouse button; or, the user drags the mouse cursor of the terminal interface by long-pressing the right mouse button; or, the user drags the mouse cursor of the terminal interface by rolling the mouse wheel; alternatively, the user controls dragging the mouse cursor on the touch display screen by a finger, a stylus, or the like.
A determination module 162 to determine a first region of the data collaboration document for performing the first operation.
And taking the area in the data collaboration document where the first operation is performed as a first area. According to the execution starting to the execution stopping of the first operation, the first operation is determined to be started at a first position of the data cooperation document, the first operation is determined to be stopped at a second position of the data cooperation document, and a continuous section formed from the first position to the second position is the first area. Exemplarily, taking the first operation as a dragging operation of a mouse cursor, taking a received instruction of pressing a left button of a mouse for a long time by a user as a first operation instruction for starting execution, and taking a position of a data collaboration document where the mouse cursor is currently located as a start position of a first area; and taking the received instruction of releasing the left mouse button by the user as an instruction for stopping executing the first operation, and taking the position of the data cooperation document where the mouse cursor is located at present as the termination position of the first area.
For example, if the mouse cursor is located at the row identifier "3" of the data collaboration document when the first operation instruction is executed, the initial position is the third row; when the mouse cursor is located at the line identifier "15" of the data cooperation document under the condition of stopping the first operation instruction, the termination position is the fifteenth line, and thus the continuous region from the third line to the fifteenth line is the first region for performing the first operation. For another example, if the mouse cursor is located in the first cell corresponding to the 1 st column in the 2 nd row of the data collaboration document under the condition of executing the first operation instruction, the initial position is the first cell; and if the mouse cursor is positioned in a second cell corresponding to the 1 st column in the 18 th row of the data cooperation document under the condition of stopping the first operation instruction, the termination position is the second cell, and therefore the continuous area from the first cell to the second cell is the first area for performing the first operation.
It should be noted that the first operation may be performed on any one of the objects in the row, column, and cell of the data collaboration document. However, the objects each time the first operation is performed need to be of the same type, and the direction in which the first operation is performed each time is one of the lateral direction or the longitudinal direction. For example, if the first operation command is started to be executed on the row in the row, column or cell, the corresponding first operation command is stopped to be executed on the row, in which case the dragging direction of the mouse cursor is vertical; if the first operation instruction is executed on three cells which are sequentially and adjacently arranged, the corresponding first operation instruction is stopped to be executed on the three cells which are sequentially and adjacently arranged, and the dragging direction of the mouse cursor can be transverse or longitudinal, and so on.
The processing module 163 is configured to update the selected states of all data contents of the first area to the same state; alternatively, the option state of a part of the data content of the first area is updated to a selected data content state and the option state of another part of the data content of the first area is updated to a non-selected data content state.
Therefore, in the data content processing apparatus provided by the embodiment of the present invention, the receiving module can receive the first operation on the data collaboration document, the determining module determines the first area for performing the first operation on the data collaboration document, and finally the processing module updates the selection status of the data content in the first area. Specifically, the updating of the selection state of the data content of the first area may be updating the selection states of all the data contents of the first area to the same state; it may also be that the optional status of a part of the data content of the first area is updated to a selected data content status and the optional status of another part of the data content of the first area is updated to a non-selected data content status. In this way, the selection state of the batch data content in the first area can be flexibly and quickly adjusted through one operation step (i.e., the first operation), so that not only can the co-selection state of the batch data content be updated through one operation step, but also the selection state of each data content part of the batch data content can be updated through one operation step, and the selection states of each data content part are different from each other. The data content that can be convenient, high-efficiently need the user chooses for use, promotes the work efficiency that data content chooseed for use in batches, increases user's convenient impression of using.
Optionally, the processing module comprises: a determining submodule for determining a second region in the data collaboration document; and the processing submodule is used for setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
Optionally, the second area and the first area are arranged at intervals in the data collaboration document; or the second area and the first area are continuously arranged in the data collaboration document; alternatively, in the data collaboration document, the second region is included in the first region layout.
Optionally, the processing submodule is configured to: acquiring a second number of second selected data identifiers of a second area; the data content of the second area is divided into a second number of parts, and each part is in one-to-one correspondence with the corresponding second optional data identifier; according to the second quantity, dividing the first area into at least one first sub-area, wherein the first quantity of the first selected data marks of each first sub-area is the same as the second quantity; and updating the selection state of the first selection data identifier according to the selection state and the arrangement sequence of the selection state of the second selection data identifier.
Optionally, the processing submodule is configured to: under the condition that the second area contains a second selected data identifier, dividing the first area along the first direction or the second direction by taking the first selected data identifier contained in each first sub-area as a unit; or, under the condition that the second area contains a plurality of second optional data identifiers, dividing the first area along the first direction or the second direction by taking the unit that each first sub-area contains a plurality of first optional data identifiers; the quantity of the second optional data identifications is the same as that of the first optional data identifications.
Optionally, the data content processing apparatus further comprises: the judging module is used for judging whether the selection states of the second selection data identifiers are unique or not; under the condition that the selection states of the plurality of second selection data identifications are not unique, determining the coordinate position and the selection state corresponding to each second selection data identification; and sorting the selection states of the plurality of second selection data identifications according to the coordinate position of each second selection data identification, and setting the selection state of each first selection data identification in the first sub-area according to a sorting result.
Optionally, the processing module is configured to: determining the current selection state of each first selection data identifier of the first area; the selection state of each first selection data identifier of the automatically set first area is opposite to each corresponding current selection state.
Optionally, the processing module is configured to: determining associated data content; the option status of the associated data content is automatically set to the same option status.
Optionally, the data content processing apparatus further comprises: the second operation receiving module is used for receiving a second operation on the data collaboration document; the area judgment module is used for judging whether a third area of the data collaboration document for performing the second operation is located in the first area; and re-determining the first area of the data collaboration document for which the first operation is performed, in a case where it is determined that the third area is located in the first area.
Fig. 13 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present invention.
As shown in fig. 13, the electronic device 100 comprises a processor 101 and a memory 102, the memory 102 being configured to store an executable computer program, the processor 101 being configured to perform a method according to any of the above method embodiments, under control of the computer program.
The electronic device 100 may be a Personal Computer (PC).
The modules of the data content processing device 160 may be implemented by the processor 101 executing the computer program stored in the memory 102 in the present embodiment, or may be implemented by other circuit configurations, which is not limited herein.
The present invention may be a system, method and/or computer program product. The computer program product may include a readable storage medium having computer-readable program instructions embodied thereon for causing a processor to implement various aspects of the present invention.
The readable storage medium may be a tangible device that can hold and store instructions for use by an instruction execution device. The readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. A readable storage medium as used herein is not to be construed as a transitory signal per se, such as a radio wave or other freely propagating electromagnetic wave, an electromagnetic wave propagating through a waveguide or other transmission medium (e.g., a light pulse through a fiber optic cable), or an electrical signal transmitted through an electrical wire.
The computer-readable program instructions described herein may be downloaded from a readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present invention may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, aspects of the present invention are implemented by personalizing an electronic circuit, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA), with state information of computer-readable program instructions, which can execute the computer-readable program instructions.
Aspects of the present invention are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.
These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. It is well known to those skilled in the art that implementation by hardware, by software, and by a combination of software and hardware are equivalent.
Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is chosen in order to best explain the principles of the embodiments, the practical application, or improvements made to the technology in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein. The scope of the invention is defined by the appended claims.

Claims (13)

1. A method for processing data content, comprising:
receiving a first operation on a data collaboration document;
determining a first region of the data collaboration document for which the first operation is performed;
updating the selected states of all data contents of the first area to be the same state; or, the optional state of the partial data content of the first area is updated to a selected data content state and the optional state of the other partial data content of the first area is updated to a non-selected data content state.
2. The method according to claim 1, wherein the selected status of all data contents of the first area is updated to the same status; or, updating the optional state of the partial data content of the first area to a selected data content state and updating the optional state of the other partial data content of the first area to a non-selected data content state, includes:
determining a second region in the data collaboration document;
and setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
3. The method of claim 2, wherein the second region is spaced from the first region by the data collaboration document; or the second area and the first area are continuously arranged in the data collaboration document; or, in the data collaboration document, the second region is included in the first region layout.
4. The method according to claim 2 or 3, wherein the setting the option state of the data content of the first area to be consistent with the option state of the data content of the second area according to the option state of the data content of the second area comprises:
acquiring a second number of second selected data identifiers of the second area; wherein the data content of the second region is divided into the second number of portions, each portion corresponding to a corresponding second option data identifier one-to-one;
according to the second quantity, dividing the first area into at least one first sub-area, wherein the first quantity of the first selected data marks of each first sub-area is the same as the second quantity;
and updating the selection state of the first selected data identifier according to the selection state of the second selected data identifier and the arrangement sequence of the selection states.
5. The method of claim 4, wherein the dividing the first region into at least one first sub-region according to the second number comprises:
under the condition that the second area contains a second selected data identifier, dividing the first area along the first direction or the second direction by taking each first sub-area containing a first selected data identifier as a unit;
or, under the condition that the second area contains a plurality of second optional data identifiers, dividing the first area along the first direction or the second direction by taking a unit that each first sub-area contains a plurality of first optional data identifiers; the number of the second optional data identifiers is the same as that of the first optional data identifiers.
6. The method of claim 5, wherein prior to dividing the first region in the first or second direction in units of each first sub-region containing a plurality of first optional data identifiers, the method further comprises:
judging whether the selection states of the plurality of second selection data identifiers are unique or not;
under the condition that the selection states of the plurality of second selection data identifications are not unique, determining the coordinate position and the selection state corresponding to each second selection data identification;
and sorting the selection states of the plurality of second selection data identifications according to the coordinate position of each second selection data identification, and setting the selection state of each first selection data identification in the first sub-area according to a sorting result.
7. The method according to claim 1, wherein the selected status of all data contents of the first area is updated to the same status; or, updating the optional state of the partial data content of the first area to a selected data content state and updating the optional state of the other partial data content of the first area to a non-selected data content state, includes:
determining a current selection state of each first selection data identifier of the first area;
and automatically setting the selection state of each first selection data identifier of the first area to be opposite to each corresponding current selection state.
8. The method according to claim 1, wherein the selected status of all data contents of the first area is updated to the same status; the method comprises the following steps:
determining associated data content;
the option status of the associated data content is automatically set to the same option status.
9. The method according to claim 1, wherein after the selected status of all data contents of the first area is updated to the same status; or after updating the optional state of the partial data content of the first area to the selected data content state and updating the optional state of the other partial data content of the first area to the unselected data content state, the method further comprises:
receiving a second operation on the data collaboration document;
judging whether a third area of the data collaboration document subjected to the second operation is located in the first area;
and in the case that the third area is determined to be located in the first area, re-determining the first area of the data collaboration document which performs the first operation.
10. A data content processing apparatus, characterized by comprising:
the receiving module is used for receiving a first operation on the data collaboration document;
a determination module to determine a first region of the data collaboration document for performing the first operation;
the processing module is used for updating the selected states of all the data contents of the first area to the same state; or, the optional state of the partial data content of the first area is updated to a selected data content state and the optional state of the other partial data content of the first area is updated to a non-selected data content state.
11. The apparatus of claim 10, wherein the processing module comprises:
a determination submodule configured to determine a second region in the data collaboration document;
and the processing submodule is used for setting the selection state of the data content of the first area to be consistent with the selection state of the data content of the second area according to the selection state of the data content of the second area.
12. An electronic device comprising a memory and a processor, the memory for storing a computer program; the processor is adapted to execute the computer program to implement the method according to any of claims 1-9.
13. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method according to any one of claims 1-9.
CN202110961298.2A 2021-08-20 2021-08-20 Data content processing method and device, electronic equipment and storage medium Active CN113655939B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110961298.2A CN113655939B (en) 2021-08-20 2021-08-20 Data content processing method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110961298.2A CN113655939B (en) 2021-08-20 2021-08-20 Data content processing method and device, electronic equipment and storage medium

Publications (2)

Publication Number Publication Date
CN113655939A true CN113655939A (en) 2021-11-16
CN113655939B CN113655939B (en) 2024-09-17

Family

ID=78491758

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110961298.2A Active CN113655939B (en) 2021-08-20 2021-08-20 Data content processing method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113655939B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100332017A1 (en) * 2008-02-26 2010-12-30 Keba Ag Configuration of machine processes
CN109032460A (en) * 2018-06-05 2018-12-18 深圳市买买提信息科技有限公司 A kind of chart switching method, device, user terminal and storage medium
CN112037545A (en) * 2020-08-31 2020-12-04 腾讯科技(深圳)有限公司 Information management method, information management device, computer equipment and storage medium
CN112613286A (en) * 2020-12-17 2021-04-06 深圳集智数字科技有限公司 Method, device and equipment for editing table contents in batch

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100332017A1 (en) * 2008-02-26 2010-12-30 Keba Ag Configuration of machine processes
CN109032460A (en) * 2018-06-05 2018-12-18 深圳市买买提信息科技有限公司 A kind of chart switching method, device, user terminal and storage medium
CN112037545A (en) * 2020-08-31 2020-12-04 腾讯科技(深圳)有限公司 Information management method, information management device, computer equipment and storage medium
CN112613286A (en) * 2020-12-17 2021-04-06 深圳集智数字科技有限公司 Method, device and equipment for editing table contents in batch

Also Published As

Publication number Publication date
CN113655939B (en) 2024-09-17

Similar Documents

Publication Publication Date Title
CN107861784B (en) Desktop icon sorting method and device and mobile terminal
CA2795367C (en) Spin control user interface for selecting options
JP6018045B2 (en) Temporary formatting and graphing of selected data
US20150234549A1 (en) Relationship visualizations
CN106210297A (en) A kind of message treatment method and mobile terminal
CN109960448B (en) Scene special effect display method, electronic device and computer storage medium
US20220200944A1 (en) Systems and methods for sorting unread messages in a group-based communication platform
US10210150B2 (en) Grid-based user interface system
US20160110069A1 (en) Information processing apparatus and method of controlling information processing apparatus
CN106982283A (en) Contact person&#39;s packet processing method, device and mobile terminal
CN111124564A (en) Method and device for displaying user interface
CN111744181B (en) Method and device for displaying information in game, game client and medium
CN113361525A (en) Page generation method and device based on OCR, computer equipment and storage medium
CN114239524A (en) Questionnaire generation method, questionnaire generation device, computer equipment and storage medium
CN104020923A (en) Method for displaying icons of touch control terminal of electronic product and electronic product
US10809904B2 (en) Interactive time range selector
CN103513857A (en) Method and device for processing messages in irregular window
CN111310093B (en) Information processing method and device, electronic equipment and storage medium
CN113655939A (en) Data content processing method and device, electronic equipment and storage medium
CN116301861A (en) Page configuration method, electronic device and storage medium
US9098171B2 (en) Navigating a network of options
GB2583799A (en) Layered idea mapping
US20230072246A1 (en) Workflow interface in a communication platform
CN110908550A (en) Operation processing method and device in cursor hovering state
CN109521924B (en) Method and device for assisting user in selecting target application

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant