WO2024087751A1 - 在线文档编辑区域定位方法、装置、服务器及存储介质 - Google Patents

在线文档编辑区域定位方法、装置、服务器及存储介质 Download PDF

Info

Publication number
WO2024087751A1
WO2024087751A1 PCT/CN2023/108037 CN2023108037W WO2024087751A1 WO 2024087751 A1 WO2024087751 A1 WO 2024087751A1 CN 2023108037 W CN2023108037 W CN 2023108037W WO 2024087751 A1 WO2024087751 A1 WO 2024087751A1
Authority
WO
WIPO (PCT)
Prior art keywords
editing
editing area
area
online document
document
Prior art date
Application number
PCT/CN2023/108037
Other languages
English (en)
French (fr)
Inventor
冉锋
尉伟东
Original Assignee
天津联想协同科技有限公司
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 天津联想协同科技有限公司 filed Critical 天津联想协同科技有限公司
Publication of WO2024087751A1 publication Critical patent/WO2024087751A1/zh

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction 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/04842—Selection of displayed objects or displayed text elements
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Definitions

  • the present invention relates to the field of online document technology, and in particular to an online document editing area positioning method, device, server and storage medium.
  • online document editing usually uses a real-time editing mode, that is, for the same online document, each editing action of an editor will be synchronized to the main version of the server and synchronized to the versions of other co-editors through the server.
  • the editor When editing a document online, the editor can set the editing area corresponding to the editor in the document to prevent certain important information from being modified or deleted by other editors, thereby improving the security of the online editing document.
  • the inventor found the following technical problem: when the editor edits the online document, he needs to traverse all the permission settings and find the editable area to locate the location where he needs to pay attention to or input content. For some online documents with more content, not only is the operation cumbersome and time-consuming, but it also affects the efficiency of editing the online document.
  • the embodiments of the present invention provide a method, device, server and storage medium for locating an online document editing area to solve the technical problem in the prior art that an editor needs to perform cumbersome operations to locate input content and a focus position in an online editing document.
  • an embodiment of the present invention provides a method for locating an online document editing area, comprising:
  • querying metadata of the online document to determine an editing area, the editing area including: editing paragraphs or cells;
  • Sorting the editing areas and determining whether the editing areas corresponding to the first sorting are in an activated state, wherein the activated state is generated by other users having editing authority for the editing areas operating on the editing areas;
  • the next sort editing area is used as the editing area corresponding to the first sort, and the cursor is moved to the editing area corresponding to the first sort.
  • an embodiment of the present invention further provides a device for locating an online document editing area, comprising:
  • a receiving module configured to receive a user's request to access an online document, and determine whether the user has editing authority for the online document according to the request;
  • a judgment module used to judge whether the online document is provided with document protection when the user has the editing authority
  • a determination module used to query the metadata of the online document and determine an editing area when document protection is set, wherein the editing area includes: an editing paragraph or a cell;
  • An adjustment module used for adjusting the display attribute of the editing area so that the editing area is highlighted
  • a sorting module is used to sort the editing area and determine whether the editing area corresponding to the first sorting is in an activated state, and the activated state is generated by other users with editing authority of the editing area operating on the editing area;
  • a moving module is used to use the next sorting editing area as the editing area corresponding to the first sorting when in an activated state, and move the cursor to the editing area corresponding to the first sorting.
  • an embodiment of the present invention further provides a server, including:
  • processors one or more processors
  • a storage device for storing one or more programs
  • the one or more processors When the one or more programs are executed by the one or more processors, the one or more processors implement the online document editing area positioning method provided in the above embodiment.
  • an embodiment of the present invention further provides a storage medium comprising computer executable instructions, which, when executed by a computer processor, are used to execute the online document editing area positioning method provided in the above embodiment.
  • the method, device, server and storage medium for locating the editing area of an online document receive a user's request to access an online document, and determine whether the user has editing authority for the online document according to the request; if the user has editing authority, determine whether the online document is provided with document protection; if document protection is provided, query the metadata of the online document to determine the editing area, the editing area includes: editing paragraphs or cells; adjusting the display attributes of the editing area so that the editing area is highlighted; sorting the editing area, and determining whether the editing area corresponding to the first sorting is in an activated state, the activation state is generated by other users with editing authority for the editing area operating the editing area; when in an activated state, the next sorted editing area is used as the editing area corresponding to the first sorting, and the cursor is moved to the editing area corresponding to the first sorting.
  • the editor's editable area for the collaborative document is obtained, and the editable area is highlighted, so that the editor can quickly and intuitively understand the operable area in the current collaborative document, and the editing area can be sorted according to the editor's editing habits and edited content, and the cursor is moved to the editing area corresponding to the first sorting, so that the editor can quickly edit the collaborative document.
  • the document starts editing.
  • the display area can be sorted according to the conflict of the editing area.
  • Editors do not need to traverse all permission settings, and can intuitively find the editable area and adjust the cursor to the editing area corresponding to the first sort, so that editors can directly start editing, effectively improving the efficiency of editing online documents.
  • FIG1 is a schematic diagram of a flow chart of a method for locating an online document editing area provided in Embodiment 1 of the present invention
  • FIG. 2 is a schematic diagram of a flow chart of a method for locating an online document editing area according to a second embodiment of the present invention
  • FIG. 3 is a schematic diagram of a flow chart of a method for locating an online document editing area provided in Embodiment 3 of the present invention.
  • FIG. 4 is a schematic diagram of the structure of an online document editing area positioning device provided by a fourth embodiment of the present invention.
  • FIG5 is a structural diagram of a server provided in Embodiment 5 of the present invention.
  • FIG1 is a flow chart of a method for locating an online document editing area provided in Embodiment 1 of the present invention. This embodiment is applicable to the case of quickly providing an online document editing area to an editor.
  • the method can be executed by an online document editing area locating device and can be integrated in a server. Specifically, the method includes the following steps:
  • Step 110 receiving a user's request to access an online document, and determining whether the user has editing authority for the online document according to the request.
  • An online document may be provided with permissions for setting permissions for different users.
  • the administrator or creator of the online document may set different permissions for different users according to actual needs to prevent leakage of important content.
  • Step 120 When the editing authority is granted, determine whether the online document is provided with document protection.
  • the online document may also be provided with document protection to prevent the content that is not related to the editor from being modified, resulting in changes in the content.
  • Document protection can still be achieved by setting the metadata of the online document in the online document metadata. By obtaining the metadata of the online document, it can be determined whether the online document is provided with document protection.
  • Step 130 when document protection is set, query the metadata of the online document to determine the editing area, and the editing area includes: editing paragraphs or cells.
  • querying the metadata of the online document to determine the editing area may include: when the current document is a word processing file, querying the protection data information of the word processing file, and obtaining the authorized editing paragraph of the current user in the word processing file as the editing area; when the current document is a spreadsheet file, querying the protection data information of the spreadsheet file, and obtaining the authorized editing table of the current user in the spreadsheet file as the editing area.
  • Online documents can be divided into word processing files and spreadsheet files.
  • the metadata can set corresponding paragraphs or cells for each editor.
  • the corresponding editing area is determined by querying the metadata.
  • the editing area can correspond to multiple paragraphs or multiple cells.
  • Step 140 Adjust the display properties of the editing area so that the editing area is highlighted.
  • the editing area can be adjusted to be highlighted, so that the editor can quickly and intuitively understand the location distribution of the editable area in the online document.
  • Step 150 sorting the editing areas, and determining whether the editing areas corresponding to the first sorting are in an activated state, wherein the activated state is generated by other users having the editing authority of the editing areas operating on the editing areas.
  • the cursor position can also be adjusted so that the editor can directly start editing the online document.
  • the editing area can be sorted.
  • the editing area can be sorted according to the order of the document.
  • the online document can support multiple editors to edit the same document at the same time. In this case, there may be a conflict in the editing areas of multiple editors. In this case, it is necessary to determine whether the editing area corresponding to the first sorting is in an activated state. In this embodiment, the activation state is used to indicate that the editing area is currently being edited by other editors.
  • the determination of whether the editing area corresponding to the first sorting is in an activated state includes: detecting whether there is an active collaborator in the online document; when there is an active collaborator, determining the current editing processing area of the active collaborator; when the editing processing area coincides with the editing area corresponding to the first sorting, determining that the editing area corresponding to the first sorting is in an activated state.
  • the editing area corresponding to the first sorting can be determined to be in an activated state in the above manner.
  • Step 160 When in the activated state, the next sort editing area is used as the editing area corresponding to the first sort, and the cursor is moved to the editing area corresponding to the first sort.
  • the next sort editing area can be used as the first sort editing area. If the editing area is still activated, the next sort editing area will continue to be used as the first sort editing area until the current first sort editing area is inactive.
  • the activated editing area will be added to the sorting queue for sorting.
  • the cursor will be moved to the editing area corresponding to the first sort. This is convenient for editors to move to the editing area corresponding to the first sort without using the mouse. Or use the keyboard or other external input devices to adjust the cursor position to start editing.
  • This embodiment receives a user's request to access an online document, and determines whether the user has editing authority for the online document according to the request; if the user has editing authority, determines whether the online document is provided with document protection; if document protection is provided, queries the metadata of the online document to determine the editing area, the editing area includes: editing paragraphs or cells; adjusts the display attributes of the editing area so that the editing area is highlighted; sorts the editing area, determines whether the editing area corresponding to the first sort is in an activated state, and the activation state is generated by other users with editing authority for the editing area operating the editing area; when in an activated state, takes the next sorted editing area as the editing area corresponding to the first sort, and moves the cursor to the editing area corresponding to the first sort.
  • the editor's editable area for the collaborative document is obtained, and the editable area is highlighted, so that the editor can quickly and intuitively understand the operable area in the current collaborative document, and can sort the editing area according to the editor's editing habits and edited content, and move the cursor to the editing area corresponding to the first sort, so that the editor can quickly start editing the collaborative document.
  • the display area can also be sorted according to the conflict of the editing area. Editors do not need to go through all permission settings, but can intuitively find the editable area and adjust the cursor to the editing area corresponding to the first sort, so that editors can directly start editing operations, effectively improving the efficiency of editing online documents.
  • the method may further add the following step: after receiving the preset area editing completion operation, move the cursor to the editing area corresponding to the next sort.
  • the preset area editing completion operation may include: an operation of inputting a specific symbol, such as the Enter key, or an operation of moving the mouse wheel up and down.
  • Figure 2 is a flow chart of the method for locating the editing area of an online document provided in Example 2 of the present invention.
  • This embodiment is optimized based on the above embodiment.
  • the editing area is limited to cells in a spreadsheet file, and the next sorting editing area is used as the first sorting editing area.
  • the specific optimization is: when the editing area is a spreadsheet, the cell that is closest to the first sorted cell and has no reference relationship with the first sorted cell is selected as the next sorting editing area.
  • the online document editing area positioning method provided in this embodiment specifically includes:
  • Step 210 receiving a user's request to access an online document, and determining whether the user has editing authority for the online document according to the request.
  • Step 220 When the user has the editing permission, determine whether the online document is protected.
  • Step 230 when document protection is set, query the metadata of the online document to determine the editing area, and the editing area includes: cells.
  • Step 240 Adjust the display properties of the editing area so that the editing area is highlighted.
  • Step 250 sorting the editing areas, and determining whether the editing areas corresponding to the first sorting are in an activated state, wherein the activated state is generated by other users having the editing authority of the editing areas operating on the editing areas.
  • Step 260 when in an activated state, select a cell that is closest to the cells of the first sort and has no reference relationship with the cells of the first sort as the next sort editing area.
  • a cell is a special document, and there may be reference relationships between cells. Therefore, you can select the cell that is closest to the activated cell and does not include the reference relationship as the next sorting editing area. Since the closest relationship includes up, down, left, and right relationships, there may be multiple tables that are closest. In this case, after the sorting is adjusted, the user can be prompted through a notification bar or other means. If the user does not perform other operations, the first sorted cell after the adjustment can be used as the next sorting editing area.
  • it may also include: when there is a cell that is closest to multiple cells in the first sort and has no reference relationship with the cells in the first sort, determining the next sort editing area according to the header of the spreadsheet and the user's editing habits.
  • each person is responsible for filling in the data that he or she knows, which is usually reflected in the same row or column in the spreadsheet.
  • the next sorting editing area can be determined based on the electronic form header and the user's editing habits.
  • headers with associations can be used as sorting conditions. For example, sales revenue and tax amounts can be regarded as associated headers. After filling in the sales revenue, the corresponding table for tax amounts is used as the next sorting editing area.
  • multiple associated headers may appear. For example, sales, tax amounts, and profit amounts are associated headers.
  • the user's filling habits can be determined based on historical statistics. For example, if the user is accustomed to calculating the profit amount first, the unit table of the profit amount will be used as the next editing area.
  • Step 270 Move the cursor to the editing area corresponding to the first sort.
  • This embodiment limits the editing area to cells in a spreadsheet file, and uses the next sorting editing area as the first sorting editing area. Specifically, when the editing area is a spreadsheet, the cell closest to the first sorted cell and not having a reference relationship with the first sorted cell is selected as the next sorting editing area.
  • the association relationship between cells in a spreadsheet can be used to sort the editing area, which can accurately The cell corresponding to the next editing area is determined, further improving the editor's work efficiency in editing online documents.
  • Figure 3 is a flow chart of the method for locating the editing area of an online document provided in the third embodiment of the present invention.
  • This embodiment is optimized based on the above embodiment.
  • the editing areas are sorted, and the specific optimization is as follows: the time when the user last edited and saved the online document and the time when other users edited and saved the online document are obtained, and the time difference between the two is calculated; when the time difference is less than the preset time threshold, the next area of the last user editing area is used as the first sorting editing area; when the time difference is greater than the preset time threshold, the adjacent area of the last other user editing area is used as the first sorting editing area.
  • the online document editing area positioning method provided in this embodiment specifically includes:
  • Step 310 receiving a user's request to access an online document, and determining whether the user has editing authority for the online document according to the request.
  • Step 320 When the user has the editing permission, determine whether the online document is protected.
  • Step 330 when document protection is set, query the metadata of the online document to determine the editing area, and the editing area includes: editing paragraphs or cells.
  • Step 340 Adjust the display properties of the editing area so that the editing area is highlighted.
  • Step 350 Obtain the time when the user last edited and saved the online document and the time when other users edited and saved the online document, and calculate the time difference between the two.
  • the sorting can be adjusted according to the last editing position and the editing position and duration of other co-editing users, so as to make the sorting more accurate and meet the editing needs of the editor.
  • the time when the user last edited and saved the online document and the time when other users edited and saved the online document can be calculated, and the time difference between the two can be calculated.
  • the above data can be obtained from the server management log.
  • Step 360 When the duration difference is less than a preset duration threshold, the next area of the previous user edited area is used as the first sorted edited area.
  • the next area of the previous user editing area can also be used as the first sorting editing area.
  • Step 370 When the duration difference is greater than a preset duration threshold, the adjacent region of the previous editing region of other users is used as the first sorted editing region.
  • the absolute value of the duration difference is less than the preset duration threshold, it may mean that the previous editing time is longer than the current editing time, and the current editing may need to refer to the editing content of other editors before continuing editing.
  • the contents edited by other editors are highly related. Therefore, the adjacent editable area of the area edited by other users last time can be used as the first sorted edit area.
  • Step 380 determining whether the editing area corresponding to the first sorting is in an activated state, wherein the activated state is generated by other users having the editing authority of the editing area operating on the editing area.
  • Step 390 when in the activated state, the next sort editing area is used as the editing area corresponding to the first sort, and the cursor is moved to the editing area corresponding to the first sort.
  • This embodiment optimizes the sorting of the editing area by: obtaining the time when the user last edited and saved the online document and the time when other users edited and saved the online document, and calculating the time difference between the two; when the time difference is less than the preset time threshold, the next area of the last user editing area is used as the first sorting editing area; when the time difference is greater than the preset time threshold, the adjacent area of the last other user editing area is used as the first sorting editing area.
  • the sorting of the editing area can be adjusted according to the real-time editing situation of the online document. The next editing area can be accurately determined, which improves the work efficiency of the editor in editing online documents.
  • FIG. 4 is a schematic diagram of the structure of an online document editing area positioning device provided in Embodiment 5 of the present invention. As shown in FIG. 4 , the device includes:
  • the receiving module 410 is used to receive a user's request to access an online document, and determine whether the user has editing authority for the online document according to the request;
  • a determination module 420 for determining whether the online document is provided with document protection when the user has the editing authority
  • the determination module 430 is used to query the metadata of the online document and determine the editing area when document protection is set, and the editing area includes: editing paragraphs or cells;
  • An adjustment module 440 configured to adjust the display attribute of the editing area so that the editing area is highlighted
  • the sorting module 450 is used to sort the editing area and determine whether the editing area corresponding to the first sort is in an activated state, and the activated state is generated by other users with editing authority of the editing area operating on the editing area; the moving module 460 is used to use the next sorting editing area as the editing area corresponding to the first sort when in an activated state, and move the cursor to the editing area corresponding to the first sort.
  • the present embodiment provides a method of receiving a user's request to access an online document, and determining whether the user has editing authority for the online document according to the request; if the user has editing authority, determining whether the online document is provided with document protection; if the user has document protection, querying metadata of the online document to determine an editing area, wherein the editing area includes: editing paragraphs or cells; adjusting display attributes of the editing area to highlight the editing area; sorting the editing area, determining whether the editing area corresponding to the first sorting is in an activated state, and determining whether the editing area corresponding to the first sorting is in an activated state.
  • the editing area is generated by other users who have the editing authority of the editing area; when in the activated state, the next sorted editing area is used as the editing area corresponding to the first sort, and the cursor is moved to the editing area corresponding to the first sort.
  • the editor's editable area of the collaborative document is obtained, and the editable area is highlighted, so that the editor can quickly and intuitively understand the operable area in the current collaborative document, and the editing area can be sorted according to the editor's editing habits and edited content, and the cursor is moved to the editing area corresponding to the first sort, so that the editor can quickly start editing the collaborative document.
  • the display area can also be sorted according to the conflict of the editing area.
  • the judging unit includes:
  • a detection subunit used to detect whether there is an active collaborator for the online document at present
  • a determination subunit used for determining a current editing processing area of an active collaborator when there is an active collaborator
  • the activation state determination subunit is used to determine that the editing area corresponding to the first sorting is in an activated state when the editing processing area coincides with the editing area corresponding to the first sorting.
  • the determining module further includes:
  • the protection data information of the spreadsheet file is queried to obtain the authorized editing table of the current user in the spreadsheet file as the editing area.
  • the device further includes:
  • the second moving module is used to move the cursor to the editing area corresponding to the next sort after receiving the preset area editing completion operation.
  • the sorting module includes:
  • the electronic table sorting unit is used to select a cell which is closest to a first-sorted cell and has no reference relationship with the first-sorted cell as a next sorting editing area when the editing area is an electronic table.
  • the electronic table sorting unit is used to calculate the electronic table sorting unit.
  • the next sort editing area is determined according to the header of the electronic sheet and the user's editing habits.
  • the sorting module includes:
  • the acquisition unit is used to acquire the time when the user last edited and saved the online document and the time when other users edited and saved the online document.
  • the time of the online document and calculate the time difference between the two;
  • the first as a unit is used to take the next area of the previous user editing area as the first sorting editing area when the time difference is less than a preset time threshold;
  • the second as unit is used to take the adjacent area of the previous editing area of other users as the first sorted editing area when the duration difference is greater than a preset duration threshold.
  • the online document editing area positioning device provided in the embodiment of the present invention can execute the online document editing area positioning method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
  • Figure 5 is a schematic diagram of the structure of a server provided in Embodiment 5 of the present invention.
  • Figure 5 shows a block diagram of an exemplary server 12 suitable for implementing the embodiments of the present invention.
  • the server 12 shown in Figure 5 is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
  • the server 12 is in the form of a general purpose computing device.
  • the components of the server 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 connecting different system components (including the system memory 28 and the processing unit 16).
  • Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. These architectures include, by way of example, but are not limited to, an Industry Standard Architecture (I-Step A) bus, a Micro Channel Architecture (MAC) bus, an Enhanced I-Step A bus, a Video Electronics Standards Association (VE-Step A) local bus, and a Peripheral Component Interconnect (PCI) bus.
  • I-Step A Industry Standard Architecture
  • MAC Micro Channel Architecture
  • VE-Step A Video Electronics Standards Association
  • PCI Peripheral Component Interconnect
  • the server 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the server 12, including volatile and non-volatile media, removable and non-removable media.
  • the system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and/or cache 32.
  • the server 12 may further include other removable/non-removable, volatile/non-volatile computer system storage media.
  • the storage system 34 may be used to read and write non-removable, non-volatile magnetic media (not shown in FIG. 5 , commonly referred to as a “hard drive”).
  • a disk drive for reading and writing to a removable non-volatile disk (e.g., a “floppy disk”) and an optical drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM or other optical media) may be provided.
  • each drive may be connected to the bus 18 via one or more data media interfaces.
  • the system memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of various embodiments of the present invention.
  • a program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment.
  • Program modules 42 generally perform the functions and/or methods of the embodiments described herein.
  • the server 12 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), may also communicate with one or more devices that enable users to interact with the server 12, and/or communicate with any device that enables the server 12 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed through an input/output (I/O) interface 22.
  • the server 12 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and/or public networks, such as the Internet) through a network adapter 20. As shown, the network adapter 20 communicates with other modules of the server 12 through a bus 18.
  • LANs local area networks
  • WANs wide area networks
  • public networks such as the Internet
  • the processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the online document editing area positioning method provided in the embodiment of the present invention.
  • Embodiment 6 further provides a storage medium containing computer executable instructions, which, when executed by a computer processor, are used to execute the online document editing area positioning method provided in the above embodiment.
  • the computer storage medium of the embodiment of the present invention can adopt any combination of one or more computer-readable media.
  • the computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium.
  • the computer-readable storage medium can be, for example, - but not limited to - an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above.
  • a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
  • Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate, or transmit data for execution of instructions. programs for use by or in conjunction with a system, apparatus or device.
  • Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
  • Computer program code for performing the operations of the present invention may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, program malltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages.
  • the program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server.
  • 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 may be connected to an external computer (e.g., through the Internet using an Internet service provider).
  • LAN local area network
  • WAN wide area network
  • Internet service provider e.g., AT&T, MCI, Sprint, EarthLink, MSN, GTE, etc.

Landscapes

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

Abstract

本发明公开了一种在线文档编辑区域定位方法、装置、服务器及存储介质，其中，所述方法包括：接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；在具有编辑权限时，判断所述在线文档是否设有文档保护；在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；对所述编辑区域进行排序，并将光标移动到第一排序对应的编辑区域。无需编辑者遍历所有的权限设置，能够直观寻找到能够编辑的区域，并将光标调整到第一排序对应的编辑区域，便于编辑者直接开始编辑操作，有效提高了对在线文档进行编辑的效率。

Description

在线文档编辑区域定位方法、装置、服务器及存储介质 技术领域
本发明涉及在线文档技术领域，尤其涉及一种在线文档编辑区域定位方法、装置、服务器及存储介质。
背景技术
随着互联网云计算技术的高速发展，用户可以对文档进行在线编辑，同时也可以针对同一文档进行远程协同作业，因此能够极大程度的提高文档处理的便利性和灵活性。
目前，在线文档编辑通常使用实时编辑模式，即针对同一在线文档，某编辑者每有一条编辑动作都会同步到服务器的主版本以及通过服务器同步到其他共同编辑者的版本中。
在线编辑文档可以在文档中设定编辑者对应的编辑区域，以防止某些重要信息被其它编辑者修改或者删除，提升在线编辑文档的安全性。在实现本发明的过程中，发明人发现如下技术问题：在编辑者对在线文档进行编辑操作时，需要遍历所有的权限设置，寻找能够编辑的区域，才能定位到其需要关注或者输入内容的位置。对于一些内容较多的在线文档，不仅操作繁琐且耗时较长，影响了对在线文档进行编辑的效率。
发明内容
本发明实施例提供了一种在线文档编辑区域定位方法、装置、服务器及存储介质，以解决现有技术中编辑人需要繁琐操作才能定位到在线编辑文档中输入内容和关注位置的技术问题。
第一方面，本发明实施例提供了一种在线文档编辑区域定位方法，包括：
接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；
在具有编辑权限时，判断所述在线文档是否设有文档保护；
在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；
调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；
对所述编辑区域进行排序，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；
在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
第二方面，本发明实施例还提供了一种在线文档编辑区域定位装置，包括：
接收模块，用于接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；
判断模块，用于在具有编辑权限时，判断所述在线文档是否设有文档保护；
确定模块，用于在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；
调整模块，用于调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；
排序模块，用于对所述编辑区域进行排序，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；移动模块，用于在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
第三方面，本发明实施例还提供了一种服务器，包括：
一个或多个处理器；
存储装置，用于存储一个或多个程序，
当所述一个或多个程序被所述一个或多个处理器执行，使得所述一个或多个处理器实现如上述实施例提供的在线文档编辑区域定位方法。
第四方面，本发明实施例还提供了一种包含计算机可执行指令的存储介质，所述计算机可执行指令在由计算机处理器执行时用于执行如上述实施例提供的在线文档编辑区域定位方法。
本发明实施例提供的在线文档编辑区域定位方法、装置、服务器及存储介质，通过接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；在具有编辑权限时，判断所述在线文档是否设有文档保护；在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；对所述编辑区域进行排序，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。通过查看当前文档的元数据，获取编辑者对协同文档的可编辑区域，并对可编辑区域进行突出显示，便于编辑者快速直观的了解到当前协同文档内的可操作区域，并可根据编辑者的编辑习惯、已编辑内容对编辑区域进行排序，并将光标对应移动到第一排序对应的编辑区域，方便编辑者快速对协同 文档开始编辑操作。同时，还可根据编辑区域的冲突情况，对显示区域进行排序。无需编辑者遍历所有的权限设置，能够直观寻找到能够编辑的区域，并将光标调整到第一排序对应的编辑区域，便于编辑者直接开始编辑操作，有效提高了对在线文档进行编辑的效率。
附图说明
通过阅读参照以下附图所作的对非限制性实施例所作的详细描述，本发明的其它特征、目的和优点将会变得更明显：
图1是本发明实施例一提供的在线文档编辑区域定位方法的流程示意图；
图2是本发明实施例二提供的在线文档编辑区域定位方法的流程示意图；
图3是本发明实施例三提供的在线文档编辑区域定位方法的流程示意图；
图4是本发明实施例四提供的在线文档编辑区域定位装置的结构示意图；
图5是本发明实施例五提供的服务器的结构图。
具体实施方式
下面结合附图和实施例对本发明作进一步的详细说明。可以理解的是，此处所描述的具体实施例仅仅用于解释本发明，而非对本发明的限定。另外还需要说明的是，为了便于描述，附图中仅示出了与本发明相关的部分而非全部结构。
实施例一
图1是本发明实施例一提供的在线文档编辑区域定位方法的流程图，本实施例可适用于向编辑者快速提供在线文档编辑区域的情况，该方法可以由在线文档编辑区域定位装置来执行，并可集成于服务器中，具体包括如下步骤：
步骤110，接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限。
在线文档可设有权限，用于设定该文档对不同用户的权限。在本实施例中，管理员或者在线文档的创建者可根据实际需要对在线文档对不同的用户设定不同的权限，避免重要内容外泄。在接收到用户访问在线文档请求时，根据所述请求确定对应的在线文档，并通过在服务器数据库中查找该在线文档的管理元数据，确定当前用户对所述在线文档是否具有编辑权限。
步骤120，在具有编辑权限时，判断所述在线文档是否设有文档保护。
在线文档还可设有文档保护，用于防止与编辑者不相关的内容部分被修改，导致内容发生变化。文档保护仍然可以通过在在线文档元数据设定在线文档的元数据实现文档保护的设定。通过获取所述在线文档的元数据，可确定所述在线文档是否设有文档保护。
步骤130，在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格。
示例性的，所述查询所述在线文档的元数据，确定编辑区域，可以包括：在当前文档为文字处理文件时，查询文字处理文件的保护数据信息，获取所述当前用户在文字处理文件的授权编辑段落，做为编辑区域；在当前文档为电子表格文件时，查询电子表格文件的保护数据信息，获取所述当前用户在电子表格文件的授权编辑表格，作为编辑区域。
在线文档可分为文字处理文件和电子表格文件，针对上述两种文件，元数据中可针对每个编辑者设定对应的段落，或者单元格。通过查询元数据确定对应的编辑区域。所述编辑区域可对应多个段落或者多个单元格。
步骤140，调整所述编辑区域的显示属性，以使得所述编辑区域突出显示。
可通过调整上述步骤确定的编辑区域的显示属性，示例性的，可将所述编辑区域调整为高亮显示，以方便编辑者快速直观的了解到在线文档内可编辑区域的位置分布。
步骤150，对所述编辑区域进行排序，判断第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成。
在本实施例中，还可对光标位置进行调整，以使得编辑者可以直接开始对在线文档进行编辑。可选的，可以对所述编辑区域进行排序。在编辑者初次打开在线文档时，可根据文档的前后顺序，对编辑区域进行排序。在线文档可支持多个编辑者同时对同一文档进行编辑。在此种情况下，可能存在多个编辑者编辑区域冲突的情况。在此种情况下，需要确定第一排序对应的编辑区域是否处于激活状态。在本实施例中，所述激活状态用于表明该编辑区域目前正处于其他编辑者进行编辑的状态。示例性的，所述判断所述第一排序对应的编辑区域是否处于激活状态，包括：检测所述在线文档当前是否存在活跃协同者；在存在活跃协同者时，确定所述活跃协同者当前的编辑处理区域；在所述编辑处理区域与所述第一排序对应的编辑区域重合时，确定所述第一排序对应的编辑区域处于激活状态。可以通过上述方式确定第一排序对应的编辑区域处于激活状态。
步骤160，在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
在第一排序的编辑区域处于激活状态时，可将下一排序编辑区域作为第一排序编辑区域。如果该编辑区域仍然处于激活状态，则继续将下一排序编辑区域作为第一排序编辑区域，直至当前第一排序编辑区域处于非激活状态。并将激活状态的编辑区域重新加入到排序队列中进行排序。并将光标移动到第一个排序对应的编辑区域。以方便编辑者无需通过鼠标 或者键盘等其它外设输入设备调整光标的位置即可开始编辑。
本实施例接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；在具有编辑权限时，判断所述在线文档是否设有文档保护；在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；对所述编辑区域进行排序，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。通过查看当前文档的元数据，获取编辑者对协同文档的可编辑区域，并对可编辑区域进行突出显示，便于编辑者快速直观的了解到当前协同文档内的可操作区域，并可根据编辑者的编辑习惯、已编辑内容对编辑区域进行排序，并将光标对应移动到第一排序对应的编辑区域，方便编辑者快速对协同文档开始编辑操作。同时，还可根据编辑区域的冲突情况，对显示区域进行排序。无需编辑者遍历所有的权限设置，能够直观寻找到能够编辑的区域，并将光标调整到第一排序对应的编辑区域，便于编辑者直接开始编辑操作，有效提高了对在线文档进行编辑的效率。
在本实施例的一个优选实施方式中，所述方法还可增加如下步骤：在接收到预设的区域编辑完成操作后，将光标移动到下一排序对应的编辑区域。示例性的，所述预设的区域编辑完成操作可以包括：输入特定符号的操作，例如。回车键等，又或者为鼠标滚轮上下移动操作。在接收到预设的区域编辑完成操作时，可以判断当前编辑区域编辑完成，可以将光标移动到下一排序对应的编辑区域。以方便编辑者快速转到下一编辑区域进行在线文档的编辑。
实施例二
图2为本发明实施例二提供的在线文档编辑区域定位方法的流程示意图。本实施例以上述实施例为基础进行优化，在本实施例中，将编辑区域限定为电子表格文件中的单元格，并将所述将下一排序编辑区域作为第一排序编辑区域，具体优化为：在所述编辑区域为电子表格时，选取与第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域。
相应的，本实施例所提供的在线文档编辑区域定位方法，具体包括：
步骤210，接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限。
步骤220,在具有编辑权限时，判断所述在线文档是否设有文档保护。
步骤230,在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：单元格。
步骤240，调整所述编辑区域的显示属性，以使得所述编辑区域突出显示。
步骤250，对所述编辑区域进行排序，判断第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成。
步骤260，在处于激活状态时，选取与第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域。
单元格是一种特殊的文档，在单元格之间可能会存在引用关系。因此，可以选取与正处于激活状态的单元格距离最近的单元格，且不包括引用关系的单元格作为下一排序编辑区域。由于最近关系包括上下左右关系，所以距离最近的可能存在多个表格，在此种情况下，可在排序调整后，通过通知栏等方式提示用户，如果用户没有进行其它操作，则可将调整后排序的第一排序的单元格作为下一排序编辑区域。
进一步的，还可以包括：在存在与多个第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格时，根据电子表格的表头和用户编辑习惯，确定下一排序编辑区域。
通常在在线电子表格文档协同编辑时，每个人负责填写自身掌握的数据，在电子表格中通常反映为同一行或者同一列。
同时，用户的编辑习惯也需要考虑。因为编辑习惯为用户思考数据关联性的反映结果。因此，不同用户之间的编辑顺序也不同。因此，在本实施例中，可以根据电子表格的表头和用户编辑习惯，确定下一排序的编辑区域。示例性的，可将具有关联性的表头作为排序条件，例如：销售收入和纳税额可以视为关联性表头，在填写完成销售收入后，将纳税额对应表格作为下一排序编辑区域。此外，还可能出现多个关联性表头，例如：销售额、纳税额和利润额为关联性表头，在此种情况下，可根据历史统计情况确定用户的填写习惯，例如，用户习惯先计算利润额，则将利润额的单元表格作为下一编辑区域。
步骤270，将光标移动到第一排序对应的编辑区域。
本实施例将编辑区域限定为电子表格文件中的单元格，并将所述将下一排序编辑区域作为第一排序编辑区域，具体优化为：在所述编辑区域为电子表格时，选取与第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域。可以利用电子表格中各个单元格之间的关联关系，对编辑区域进行排序，可以准确 的判断下一编辑区域对应的单元格，进一步提升编辑者编辑在线文档的工作效率。
实施例三
图3为本发明实施例三提供的在线文档编辑区域定位方法的流程示意图。本实施例以上述实施例为基础进行优化，在本实施例中，将对所述编辑区域进行排序，具体优化为：获取前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在线文档的时间，并计算二者之间的时长差值；在所述时长差值小于预设时长阈值时，将前次所述用户编辑区域的下一区域作为第一排序编辑区域；在所述时长差值大于预设时长阈值时，将前次其它用户编辑区域的相邻区域作为第一排序编辑区域。
相应的，本实施例所提供的在线文档编辑区域定位方法，具体包括：
步骤310，接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限。
步骤320,在具有编辑权限时，判断所述在线文档是否设有文档保护。
步骤330,在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格。
步骤340，调整所述编辑区域的显示属性，以使得所述编辑区域突出显示。
步骤350，获取前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在线文档的时间，并计算二者之间的时长差值。
在编辑者非首次打开在线文档时，可根据前次编辑位置和其它协同编辑用户的编辑位置和时长对排序进行调整，以使得排序更加准确，满足编辑者的编辑需求。在本实施例中，可计算前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在线文档的时间，并计算二者之间的时长差值。上述数据可从服务器管理日志中获取。
步骤360，在所述时长差值小于预设时长阈值时，将前次所述用户编辑区域的下一区域作为第一排序编辑区域。
如果时长差值的绝对值小于预设时长阈值，则可说明，当前编辑者前次编辑和本次编辑是由于其它事件中断引起，因此，还可将前次所述用户编辑区域的下一区域作为第一排序编辑区域。
步骤370，在所述时长差值大于预设时长阈值时，将前次其它用户编辑区域的相邻区域作为第一排序编辑区域。
如果时长差值的绝对值小于预设时长阈值，则可能说明前次编辑时间与当前编辑时间较长，此次编辑可能是需要参考其他编辑者编辑内容后，才能继续编辑。本次编辑内容与 其他编辑者编辑的内容关联性较强。因此，可以将前次其它用户编辑区域的相邻可编辑区域作为第一排序编辑区域。
步骤380，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成。
步骤390，在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
本实施例通过将对所述编辑区域进行排序，具体优化为：获取前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在线文档的时间，并计算二者之间的时长差值；在所述时长差值小于预设时长阈值时，将前次所述用户编辑区域的下一区域作为第一排序编辑区域；在所述时长差值大于预设时长阈值时，将前次其它用户编辑区域的相邻区域作为第一排序编辑区域。可根据在线文档的实时编辑情况，对编辑区域排序进行调整。可以准确的判断下一编辑区域，提升编辑者编辑在线文档的工作效率。
实施例四
图4是本发明实施例五提供的在线文档编辑区域定位装置的结构示意图，如图4所示，所述装置包括：
接收模块410，用于接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；
判断模块420，用于在具有编辑权限时，判断所述在线文档是否设有文档保护；
确定模块430，用于在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；
调整模块440，用于调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；
排序模块450，用于对所述编辑区域进行排序，判断第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；移动模块460，用于在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
本实施例提供的通过接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；在具有编辑权限时，判断所述在线文档是否设有文档保护；在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；对所述编辑区域进行排序，判断所述第一排序对应的编辑区域是否处于激活状态，所述激活状态 由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。通过查看当前文档的元数据，获取编辑者对协同文档的可编辑区域，并对可编辑区域进行突出显示，便于编辑者快速直观的了解到当前协同文档内的可操作区域，并可根据编辑者的编辑习惯、已编辑内容对编辑区域进行排序，并将光标对应移动到第一排序对应的编辑区域，方便编辑者快速对协同文档开始编辑操作。同时，还可根据编辑区域的冲突情况，对显示区域进行排序。无需编辑者遍历所有的权限设置，能够直观寻找到能够编辑的区域，并将光标调整到第一排序对应的编辑区域，便于编辑者直接开始编辑操作，有效提高了对在线文档进行编辑的效率。
在上述各实施例的基础上，所述判断单元包括：
检测子单元，用于检测所述在线文档当前是否存在活跃协同者；
确定子单元，用于在存在活跃协同者时，确定所述活跃协同者当前的编辑处理区域；
激活状态确定子单元，用于在所述编辑处理区域与所述第一排序对应的编辑区域重合时，确定所述第一排序对应的编辑区域处于激活状态。
在上述各实施例的基础上，所述确定模块，还包括：
在当前文档为文字处理文件时，查询文字处理文件的保护数据信息，获取所述当前用户在文字处理文件的授权编辑段落，做为编辑区域；
在当前文档为电子表格文件时，查询电子表格文件的保护数据信息，获取当前用户在电子表格文件的授权编辑表格，作为编辑区域。
在上述各实施例的基础上，所述装置还包括：
第二移动模块，用于在接收到预设的区域编辑完成操作后，将光标移动到下一排序对应的编辑区域。
在上述各实施例的基础上，所述排序模块，包括：
电子表格排序单元，用于在所述编辑区域为电子表格时，选取与第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域。
在上述各实施例的基础上，所述电子表格排序单元，用于
在存在与多个第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格时，根据电子表格的表头和用户编辑习惯，确定下一排序编辑区域。
在上述各实施例的基础上，所述排序模块，包括：
获取单元，用于获取前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在 线文档的时间，并计算二者之间的时长差值；
第一作为单元，用于在所述时长差值小于预设时长阈值时，将前次所述用户编辑区域的下一区域作为第一排序编辑区域；
第二作为单元，用于在所述时长差值大于预设时长阈值时，将前次其它用户编辑区域的相邻区域作为第一排序编辑区域。
本发明实施例所提供的在线文档编辑区域定位装置可执行本发明任意实施例所提供的在线文档编辑区域定位方法，具备执行方法相应的功能模块和有益效果。
实施例五
图5为本发明实施例五提供的一种服务器的结构示意图。图5示出了适于用来实现本发明实施方式的示例性服务器12的框图。图5显示的服务器12仅仅是一个示例，不应对本发明实施例的功能和使用范围带来任何限制。
如图5所示，服务器12以通用计算设备的形式表现。服务器12的组件可以包括但不限于：一个或者多个处理器或者处理单元16，系统存储器28，连接不同系统组件(包括系统存储器28和处理单元16)的总线18。
总线18表示几类总线结构中的一种或多种，包括存储器总线或者存储器控制器，外围总线，图形加速端口，处理器或者使用多种总线结构中的任意总线结构的局域总线。举例来说，这些体系结构包括但不限于工业标准体系结构(I步骤A)总线，微通道体系结构(MAC)总线，增强型I步骤A总线、视频电子标准协会(VE步骤A)局域总线以及外围组件互连(PCI)总线。
服务器12典型地包括多种计算机系统可读介质。这些介质可以是任何能够被服务器12访问的可用介质，包括易失性和非易失性介质，可移动的和不可移动的介质。
系统存储器28可以包括易失性存储器形式的计算机系统可读介质，例如随机存取存储器(RAM)30和/或高速缓存32。服务器12可以进一步包括其它可移动/不可移动的、易失性/非易失性计算机系统存储介质。仅作为举例，存储系统34可以用于读写不可移动的、非易失性磁介质(图5未显示，通常称为“硬盘驱动器”)。尽管图5中未示出，可以提供用于对可移动非易失性磁盘(例如“软盘”)读写的磁盘驱动器，以及对可移动非易失性光盘(例如CD-ROM,DVD-ROM或者其它光介质)读写的光盘驱动器。在这些情况下，每个驱动器可以通过一个或者多个数据介质接口与总线18相连。系统存储器28可以包括至少一个程序产品，该程序产品具有一组(例如至少一个)程序模块，这些程序模块被配置以执行本发明各实施例的功能。
具有一组(至少一个)程序模块42的程序/实用工具40，可以存储在例如系统存储器28中，这样的程序模块42包括但不限于操作系统、一个或者多个应用程序、其它程序模块以及程序数据，这些示例中的每一个或某种组合中可能包括网络环境的实现。程序模块42通常执行本发明所描述的实施例中的功能和/或方法。
服务器12也可以与一个或多个外部设备14(例如键盘、指向设备、显示器24等)通信，还可与一个或者多个使得用户能与该服务器12交互的设备通信，和/或与使得该服务器12能与一个或多个其它计算设备进行通信的任何设备(例如网卡，调制解调器等等)通信。这种通信可以通过输入/输出(I/O)接口22进行。并且，服务器12还可以通过网络适配器20与一个或者多个网络(例如局域网(LAN)，广域网(WAN)和/或公共网络，例如因特网)通信。如图所示，网络适配器20通过总线18与服务器12的其它模块通信。应当明白，尽管图中未示出，可以结合服务器12使用其它硬件和/或软件模块，包括但不限于：微代码、设备驱动器、冗余处理单元、外部磁盘驱动阵列、RAID系统、磁带驱动器以及数据备份存储系统等。处理单元16通过运行存储在系统存储器28中的程序，从而执行各种功能应用以及数据处理，例如实现本发明实施例所提供的在线文档编辑区域定位方法。
实施例六
实施例六还提供了一种包含计算机可执行指令的存储介质，所述计算机可执行指令在由计算机处理器执行时用于执行如上述实施例提供的在线文档编辑区域定位方法。
本发明实施例的计算机存储介质，可以采用一个或多个计算机可读的介质的任意组合。计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导体的系统、装置或器件，或者任意以上的组合。计算机可读存储介质的更具体的例子(非穷举的列表)包括：具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机存取存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本文件中，计算机可读存储介质可以是任何包含或存储程序的有形介质，该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。
计算机可读的信号介质可以包括在基带中或者作为载波一部分传播的数据信号，其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式，包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读的信号介质还可以是计算机可读存储介质以外的任何计算机可读介质，该计算机可读介质可以发送、传播或者传输用于由指令执 行系统、装置或者器件使用或者与其结合使用的程序。
计算机可读介质上包含的程序代码可以用任何适当的介质传输，包括——但不限于无线、电线、光缆、RF等等，或者上述的任意合适的组合。
可以以一种或多种程序设计语言或其组合来编写用于执行本发明操作的计算机程序代码，所述程序设计语言包括面向对象的程序设计语言—诸如Java、步骤malltalk、C++，还包括常规的过程式程序设计语言—诸如”C”语言或类似的程序设计语言。程序代码可以完全地在用户计算机上执行、部分地在用户计算机上执行、作为一个独立的软件包执行、部分在用户计算机上部分在远程计算机上执行、或者完全在远程计算机或服务器上执行。在涉及远程计算机的情形中，远程计算机可以通过任意种类的网络——包括局域网(LAN)或广域网(WAN)—连接到用户计算机，或者，可以连接到外部计算机(例如利用因特网服务提供商来通过因特网连接)。
注意，上述仅为本发明的较佳实施例及所运用技术原理。本领域技术人员会理解，本发明不限于这里所述的特定实施例，对本领域技术人员来说能够进行各种明显的变化、重新调整和替代而不会脱离本发明的保护范围。因此，虽然通过以上实施例对本发明进行了较为详细的说明，但是本发明不仅仅限于以上实施例，在不脱离本发明构思的情况下，还可以包括更多其他等效实施例，而本发明的范围由所附的权利要求范围决定。

Claims (10)

  1. 一种在线文档编辑区域定位方法，其特征在于，包括：
    接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；
    在具有编辑权限时，判断所述在线文档是否设有文档保护；
    在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；
    调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；
    对所述编辑区域进行排序，判断第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；
    在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
  2. 根据权利要求1所述的方法，其特征在于，所述判断第一排序对应的编辑区域是否处于激活状态，包括：
    检测所述在线文档当前是否存在活跃协同者；
    在存在活跃协同者时，确定所述活跃协同者当前的编辑处理区域；
    在所述编辑处理区域与所述第一排序对应的编辑区域重合时，确定所述第一排序对应的编辑区域处于激活状态。
  3. 根据权利要求1所述的方法，其特征在于，所述查询所述在线文档的元数据，确定编辑区域，包括：
    在当前文档为文字处理文件时，查询文字处理文件的保护数据信息，获取当前用户在文字处理文件的授权编辑段落，作为编辑区域；
    在当前文档为电子表格文件时，查询电子表格文件的保护数据信息，获取当前用户在电子表格文件的授权编辑表格，作为编辑区域。
  4. 根据权利要求1所述的方法，其特征在于，所述方法还包括：
    在接收到预设的区域编辑完成操作后，将光标移动到下一排序对应的编辑区域。
  5. 根据权利要求2所述的方法，其特征在于，所述将下一排序编辑区域作为第一排序编辑区域，包括：
    在所述编辑区域为电子表格时，选取与第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域。
  6. 根据权利要求5所述的方法，其特征在于，所述选取与第一排序的单元格距离最近，且 与所述第一排序的单元格之间不存在引用关系的单元格作为下一排序编辑区域，包括：
    在存在与多个第一排序的单元格距离最近，且与所述第一排序的单元格之间不存在引用关系的单元格时，根据电子表格的表头和用户编辑习惯，确定下一排序编辑区域。
  7. 根据权利要求1所述的方法，其特征在于，所述对所述编辑区域进行排序，包括：
    获取前次所述用户编辑保存所述在线文档的时间和其它用户编辑保存所述在线文档的时间，并计算二者之间的时长差值；
    在所述时长差值小于预设时长阈值时，将前次所述用户编辑区域的下一区域作为第一排序编辑区域；
    在所述时长差值大于预设时长阈值时，将前次其它用户编辑区域的相邻区域作为第一排序编辑区域。
  8. 一种在线文档编辑区域定位装置，其特征在于，包括：
    接收模块，用于接收用户访问在线文档的请求，并根据所述请求确定所述用户对所述在线文档是否具有编辑权限；
    判断模块，用于在具有编辑权限时，判断所述在线文档是否设有文档保护；
    确定模块，用于在设有文档保护时，查询所述在线文档的元数据，确定编辑区域，所述编辑区域包括：编辑段落或者单元格；
    调整模块，用于调整所述编辑区域的显示属性，以使得所述编辑区域突出显示；
    排序模块，用于对所述编辑区域进行排序，判断第一排序对应的编辑区域是否处于激活状态，所述激活状态由具有所述编辑区域编辑权限的其它用户对所述编辑区域进行操作生成；
    移动模块，用于在处于激活状态时，将下一排序编辑区域作为第一排序对应的编辑区域，并将光标移动到第一排序对应的编辑区域。
  9. 一种服务器，其特征在于，所述服务器包括：
    一个或多个处理器；
    存储装置，用于存储一个或多个程序，
    当所述一个或多个程序被所述一个或多个处理器执行，使得所述一个或多个处理器实现如权利要求1-7中任一所述的在线文档编辑区域定位方法。
  10. 一种包含计算机可执行指令的存储介质，所述计算机可执行指令在由计算机处理器执行时用于执行如权利要求1-7任一所述的在线文档编辑区域定位方法。
PCT/CN2023/108037 2022-10-24 2023-07-19 在线文档编辑区域定位方法、装置、服务器及存储介质 WO2024087751A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202211298855.8A CN115374759B (zh) 2022-10-24 2022-10-24 在线文档编辑区域定位方法、装置、服务器及存储介质
CN202211298855.8 2022-10-24

Publications (1)

Publication Number Publication Date
WO2024087751A1 true WO2024087751A1 (zh) 2024-05-02

Family

ID=84072535

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2023/108037 WO2024087751A1 (zh) 2022-10-24 2023-07-19 在线文档编辑区域定位方法、装置、服务器及存储介质

Country Status (2)

Country Link
CN (1) CN115374759B (zh)
WO (1) WO2024087751A1 (zh)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115374759B (zh) * 2022-10-24 2023-03-10 天津联想协同科技有限公司 在线文档编辑区域定位方法、装置、服务器及存储介质
CN115952525B (zh) * 2023-02-23 2023-08-11 天津联想协同科技有限公司 在线文档区域权限设置方法、装置、服务器及存储介质
CN116108811B (zh) * 2023-04-11 2023-08-11 天津联想协同科技有限公司 一种升级SaaS应用特定格式文档内容的方法及系统

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100174783A1 (en) * 2007-10-12 2010-07-08 Rony Zarom System and method for coordinating simultaneous edits of shared digital data
US20130339847A1 (en) * 2012-06-13 2013-12-19 International Business Machines Corporation Managing concurrent editing in a collaborative editing environment
CN111767702A (zh) * 2020-08-14 2020-10-13 腾讯科技（深圳）有限公司 在线文档的显示控制方法、装置、电子设备和存储介质
CN112906353A (zh) * 2019-11-19 2021-06-04 北京沃东天骏信息技术有限公司 一种协同编辑文档的方法和系统
CN114021531A (zh) * 2021-11-18 2022-02-08 北京索为系统技术股份有限公司 文档协同编辑方法、装置、电子设备及存储介质
CN114528816A (zh) * 2022-01-27 2022-05-24 北京飞书科技有限公司 协同编辑的信息展示方法、装置、电子设备和可读介质
CN115374759A (zh) * 2022-10-24 2022-11-22 天津联想协同科技有限公司 在线文档编辑区域定位方法、装置、服务器及存储介质

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1979466A (zh) * 2005-11-29 2007-06-13 国际商业机器公司 允许多个用户同时编辑一个共享的电子文档的方法及装置
US10896192B2 (en) * 2016-09-08 2021-01-19 Salesforce.Com, Inc. Allowing in-line edit to data table of linked data of a data store
US10936804B2 (en) * 2018-07-27 2021-03-02 Microsoft Technology Licensing, Llc Spreadsheet cell calculation view providing multiple-representation editing

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100174783A1 (en) * 2007-10-12 2010-07-08 Rony Zarom System and method for coordinating simultaneous edits of shared digital data
US20130339847A1 (en) * 2012-06-13 2013-12-19 International Business Machines Corporation Managing concurrent editing in a collaborative editing environment
CN112906353A (zh) * 2019-11-19 2021-06-04 北京沃东天骏信息技术有限公司 一种协同编辑文档的方法和系统
CN111767702A (zh) * 2020-08-14 2020-10-13 腾讯科技（深圳）有限公司 在线文档的显示控制方法、装置、电子设备和存储介质
CN114021531A (zh) * 2021-11-18 2022-02-08 北京索为系统技术股份有限公司 文档协同编辑方法、装置、电子设备及存储介质
CN114528816A (zh) * 2022-01-27 2022-05-24 北京飞书科技有限公司 协同编辑的信息展示方法、装置、电子设备和可读介质
CN115374759A (zh) * 2022-10-24 2022-11-22 天津联想协同科技有限公司 在线文档编辑区域定位方法、装置、服务器及存储介质

Also Published As

Publication number Publication date
CN115374759A (zh) 2022-11-22
CN115374759B (zh) 2023-03-10

Similar Documents

Publication Publication Date Title
WO2024087751A1 (zh) 在线文档编辑区域定位方法、装置、服务器及存储介质
US7689578B2 (en) Dealing with annotation versioning through multiple versioning policies and management thereof
US10068104B2 (en) Conditional redaction of portions of electronic documents
US8201079B2 (en) Maintaining annotations for distributed and versioned files
US9880989B1 (en) Document annotation service
US10503821B2 (en) Dynamic workflow assistant with shared application context
US7716365B2 (en) Automatically targeting and filtering shared network resources
CN110263311B (zh) 一种网络页面的生成方法及设备
CN109885819B (zh) 数据表格动态调整方法、系统、设备及存储介质
WO2017105971A1 (en) Aggregate visualizations of activities performed with respect to portions of electronic documents
CN114416667A (zh) 快速分享网盘文件的方法、装置、网盘及存储介质
WO2023029275A1 (zh) 数据关联分析方法、装置、计算机设备和存储介质
CN112463800A (zh) 数据读取方法、装置、服务器及存储介质
CN112269799A (zh) 一种数据查询方法、装置、设备和介质
US8756520B2 (en) Individual information element access for unopened objects
US20240126985A1 (en) Method and apparatus for processing information in document, and device and medium
CN110262870A (zh) 利用dump文件定位异常的方法、装置、计算机设备及存储介质
WO2024198166A1 (zh) 文档批注生成方法、装置、网盘及存储介质
US10176152B2 (en) Method and system for assigning a content item as a link target to a managed object
CN114817990A (zh) 对敏感数据的管理方法、装置、电子设备及存储介质
EP4285269A1 (en) Content frames for productivity applications
WO2022103506A1 (en) Controlling a productivity application to integrate a revision stream and an undo stack to perform out of order undo operations
US11704094B2 (en) Data integrity analysis tool
WO2024109376A1 (zh) 一种数据处理的方法、电子设备及存储介质
CN115952525B (zh) 在线文档区域权限设置方法、装置、服务器及存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 23881339

Country of ref document: EP

Kind code of ref document: A1