Spreadsheet processing method, apparatus, device, and computer-readable storage medium

Abstract

The application discloses a kind of processing method, device, equipment and computer readable storage medium of electronic form, belong to computer technical field.Method includes: display electronic form, the first frozen reference line is displayed in the electronic form, the first frozen reference line is horizontal line or vertical line, the content area in the side of the first frozen reference line is the frozen area of the electronic form;In response to the drag operation for the first frozen reference line, change the position of the first frozen reference line in the electronic form;In response to the operation of ending dragging the first frozen reference line, the frozen area is adjusted to first area, and the first area is determined based on the first frozen reference line after being dragged.The method makes the adjustment process of the frozen area of electronic form more flexible, and can improve the adjustment efficiency of the frozen area of electronic form, improve the processing efficiency of electronic form.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a method, apparatus, device, and computer-readable storage medium for processing spreadsheets. Background Technology

[0002] Spreadsheets are an indispensable tool for people to process data in their daily work. As people's needs continue to change, spreadsheets are becoming more and more functional, for example, they have a freeze function.

[0003] In related technologies, when the cell in row M and column N of a spreadsheet is selected, the freeze function can be used to freeze the first row, the first column, or up to row M and column N of the spreadsheet. Here, M and N are both integers greater than or equal to 1.

[0004] However, when you want to adjust the frozen area of ​​a spreadsheet, you need to unfreeze the previously frozen area and then reselect and freeze the area in the same way as described above. This makes the process of adjusting the frozen area of ​​a spreadsheet cumbersome and results in low processing efficiency. Summary of the Invention

[0005] This application provides a method, apparatus, device, and computer-readable storage medium for processing spreadsheets, which can be used to solve the problem in related technologies where the adjustment process of the frozen area of ​​a spreadsheet is relatively complex, resulting in low processing efficiency. The technical solution is as follows:

[0006] On one hand, embodiments of this application provide a method for processing spreadsheets, the method comprising:

[0007] A spreadsheet is displayed, which has a first freeze baseline. The first freeze baseline is either a horizontal line or a vertical line. The content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet.

[0008] In response to a drag operation on the first frozen baseline, the position of the first frozen baseline in the spreadsheet is changed;

[0009] In response to the end of the dragging of the first freeze baseline, the frozen area is adjusted to a first area, which is determined based on the dragged first freeze baseline.

[0010] On the other hand, embodiments of this application provide a spreadsheet processing apparatus, the apparatus comprising:

[0011] The display module is used to display a spreadsheet, which displays a first freeze baseline. The first freeze baseline is a horizontal line or a vertical line, and the content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet.

[0012] A change module is configured to change the position of the first frozen baseline in the spreadsheet in response to a drag operation on the first frozen baseline;

[0013] An adjustment module is used to adjust the frozen area to a first area in response to the end of the dragging of the first frozen baseline, the first area being determined based on the dragged first frozen baseline.

[0014] In one possible implementation, the first region includes a first side region located along the first border line of the reference strip region; or,

[0015] The first region includes a first side region located on the second border line of the reference strip region;

[0016] Wherein, the reference bar area is the area where the first frozen baseline is located after being dragged, and the reference bar area is a reference column or reference column; based on the reference bar area being a reference column, the first border line is the left border line, the second border line is the right border line, and the first side is the left side; based on the reference bar area being a reference row, the first border line is the top border line, the second border line is the bottom border line, and the first side is the top side.

[0017] In one possible implementation, the first frozen baseline is a vertical line; the first region includes the region to the left of the left border line of the reference column; or,

[0018] The first region includes the region to the left of the right frame of the reference column;

[0019] The reference column is the column where the first frozen baseline is located after being dragged.

[0020] In one possible implementation, the first freeze baseline is a horizontal line; the first region includes the region above the upper border line of the reference row; or,

[0021] The first region includes the region located above the lower border line of the reference row;

[0022] The reference line is the row where the first frozen baseline is located after being dragged.

[0023] In one possible implementation, the device further includes:

[0024] The determination module is used to determine the reference line based on the first frozen baseline after being dragged.

[0025] The content area located on one side of the reference line is defined as the first area.

[0026] In one possible implementation, the determining module is used to determine the reference column where the dragged first frozen baseline is located, based on the fact that the first frozen baseline is a vertical line.

[0027] The reference line is determined based on the reference column;

[0028] The content area located to the left of the reference line is defined as the first area.

[0029] In one possible implementation, the determining module is configured to determine the left border line of the reference column as the reference line; or,

[0030] The right border of the reference column is defined as the reference line; or,

[0031] If the first frozen baseline after being dragged is located to the left of the center line of the reference column, the left border line of the reference column is determined as the reference line; if the first frozen baseline after being dragged is located to the right of the center line of the reference column, the right border line of the reference column is determined as the reference line; or,

[0032] If the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than the area ratio threshold, the left border line of the reference column is determined as the reference line; if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than the area ratio threshold, the right border line of the reference column is determined as the reference line.

[0033] The first rectangle is determined based on the first frozen baseline after being dragged, the left border line of the reference column, the top border line of the reference column, and the bottom border line of the reference column, and the second rectangle is the rectangle corresponding to the reference column.

[0034] In one possible implementation, the determining module is used to determine the number of columns before the left border line of the reference column;

[0035] If the number of columns before the left border line of the reference column is not higher than the frozen column number threshold, the left border line of the reference column is determined as the reference line.

[0036] In one possible implementation, the determining module is further configured to determine the right border of the column in the spreadsheet whose number of columns is equal to the frozen column number threshold as the reference line if the number of columns before the left border of the reference column is higher than the frozen column number threshold.

[0037] In one possible implementation, the determining module is used to determine the reference row where the dragged first frozen baseline is located, based on the fact that the first frozen baseline is a horizontal line.

[0038] The reference line is determined based on the reference row;

[0039] The content area located above the reference line is defined as the first area.

[0040] In one possible implementation, the determining module is configured to determine the upper border line of the reference row as the reference line; or,

[0041] The lower border line of the reference row is defined as the reference line; or,

[0042] If the first frozen baseline after being dragged is located above the center line of the reference row, the top border line of the reference row is determined as the reference line; if the first frozen baseline after being dragged is located below the center line of the reference row, the bottom border line of the reference row is determined as the reference line; or,

[0043] If the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is lower than the area ratio threshold, the upper border line of the reference row is determined as the reference line; if the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is higher than the area ratio threshold, the lower border line of the reference row is determined as the reference line.

[0044] The third rectangle is determined based on the first frozen baseline after being dragged, the top border line of the reference row, the left border line of the reference row, and the right border line of the reference row, and the fourth rectangle is the rectangle corresponding to the reference row.

[0045] In one possible implementation, the display module is further configured to display a freeze drag control in response to a trigger operation on the first frozen baseline, the freeze drag control being used to indicate that the first frozen baseline can be dragged.

[0046] If the display duration of the freeze drag control exceeds a duration threshold, a prompt message is displayed, which instructs the user to drag the first freeze baseline to adjust the freeze area.

[0047] In one possible implementation, the device further includes:

[0048] A sliding module is used to slide the content area to the right of the first frozen baseline, based on the first frozen baseline as a vertical line, in response to a drag operation on the first frozen baseline, when the number of columns of the first column displayed to the right of the first frozen baseline is not adjacent to the number of columns of the first column displayed to the left of the first frozen baseline, so that the number of columns of the first column displayed to the right of the first frozen baseline is adjacent to the number of columns of the first column displayed to the left of the first frozen baseline.

[0049] Since the first freeze baseline is a horizontal line, in response to a drag operation on the first freeze baseline, if the number of rows of the first row displayed above the first freeze baseline is not adjacent to the number of rows of the first row displayed below the first freeze baseline, the content area below the first freeze baseline is slid so that the number of rows of the first row displayed below the first freeze baseline is adjacent to the number of rows of the first row displayed above the first freeze baseline.

[0050] In one possible implementation, the spreadsheet also displays a second freeze baseline, which is a horizontal or vertical line. The second freeze baseline is different from the first freeze baseline. The content area located on one side of the second freeze baseline is a frozen area. The first freeze baseline and the second freeze baseline intersect at a reference point.

[0051] The change module is also configured to change the position of the reference point in the spreadsheet in response to a drag operation on the reference point;

[0052] The adjustment module is further configured to adjust the frozen area to a second area in response to the end of the dragging operation of the reference point, the second area being determined based on the dragged reference point.

[0053] In one possible implementation, the second region includes the region to the left of the left border line of the reference cell and the region above the top border line; or,

[0054] The second region includes the area to the left of the left border line and the area above the bottom border line of the reference cell; or,

[0055] The second region includes the area to the left of the right border line and the area above the top border line of the reference cell; or,

[0056] The second region includes the area to the left of the right border line and the area above the bottom border line of the reference cell;

[0057] The reference cell is the cell where the reference point is located after it has been dragged.

[0058] In one possible implementation, the device further includes:

[0059] The determination module is used to determine the reference cell where the dragged reference point is located.

[0060] Based on the reference cell, determine the first reference line and the second reference line;

[0061] The content area located above the first reference line and the content area located to the left of the second reference line are defined as the second region.

[0062] On the other hand, embodiments of this application provide a computer device, which includes a processor and a memory. The memory stores at least one piece of program code, which is loaded and executed by the processor to enable the computer device to implement any of the spreadsheet processing methods described above.

[0063] On the other hand, a computer-readable storage medium is also provided, wherein at least one piece of program code is stored therein, the at least one piece of program code being loaded and executed by a processor to enable a computer to implement any of the spreadsheet processing methods described above.

[0064] On the other hand, a computer program or computer program product is also provided, wherein the computer program or computer program product stores at least one computer instruction, which is loaded and executed by a processor to enable the computer to implement any of the above-described spreadsheet processing methods.

[0065] The technical solution provided in this application has at least the following beneficial effects:

[0066] The technical solution provided in this application allows for adjustments to frozen areas in a spreadsheet. Simply drag the first freeze baseline indicating the frozen area to adjust it. There's no need to unfreeze the frozen area and then re-define it. This reduces the complexity of adjusting frozen areas, making the adjustment more flexible and improving efficiency, thus enhancing overall spreadsheet processing efficiency. Attached Figure Description

[0067] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0068] Figure 1 This is a schematic diagram of a spreadsheet processing method provided in an embodiment of this application;

[0069] Figure 2 This is a schematic diagram of the structure of a computer system provided in an embodiment of this application;

[0070] Figure 3 This is a flowchart of a spreadsheet processing method provided in an embodiment of this application;

[0071] Figure 4 This is a schematic diagram of a spreadsheet display provided in an embodiment of this application;

[0072] Figure 5 This is a schematic diagram of another spreadsheet display provided in an embodiment of this application;

[0073] Figure 6 This is a schematic diagram illustrating a frozen drag control provided in an embodiment of this application;

[0074] Figure 7 This is a schematic diagram illustrating the display of a prompt message provided in an embodiment of this application;

[0075] Figure 8 This is a schematic diagram illustrating the adjustment of an electronic spreadsheet according to an embodiment of this application;

[0076] Figure 9 This is a schematic diagram illustrating another form of spreadsheet adjustment provided in this application embodiment;

[0077] Figure 10 This is a schematic diagram of a reference line provided in an embodiment of this application;

[0078] Figure 11 This is a schematic diagram of another spreadsheet display provided in an embodiment of this application;

[0079] Figure 12 This is a schematic diagram illustrating another type of spreadsheet display provided in an embodiment of this application;

[0080] Figure 13 This is a schematic diagram of a reference cell provided in an embodiment of this application;

[0081] Figure 14This is a schematic diagram of a first reference line and a second reference line provided in an embodiment of this application;

[0082] Figure 15 This is a schematic diagram of yet another first reference line and second reference line provided in the embodiments of this application;

[0083] Figure 16 This is a schematic diagram of another first reference line and second reference line provided in the embodiments of this application;

[0084] Figure 17 This is a schematic diagram of another first reference line and second reference line provided in the embodiments of this application;

[0085] Figure 18 This is a schematic diagram of a spreadsheet after adjusting the frozen area, provided in an embodiment of this application;

[0086] Figure 19 This is a flowchart of a spreadsheet processing method provided in an embodiment of this application;

[0087] Figure 20 This is a schematic diagram of the structure of a spreadsheet processing device provided in an embodiment of this application;

[0088] Figure 21 This is a schematic diagram of the structure of a terminal device provided in an embodiment of this application;

[0089] Figure 22 This is a schematic diagram of the structure of a server provided in an embodiment of this application. Detailed Implementation

[0090] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0091] It should be noted that the terms "first," "second," etc., used in this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such terms can be used interchangeably where appropriate so that the embodiments of this application described herein can be implemented in orders other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.

[0092] First, the abbreviations and key terms involved in the embodiments of this application are defined.

[0093] Freezed Areas: Areas within the spreadsheet's content area that do not support scrolling. Examples include the first row and first column. When certain rows and / or columns are frozen, only scrolling within the spreadsheet's content area remains unaffected; other adjustments (such as adjusting row height, column width, or modifying cell content) still take effect.

[0094] Active area: The scrollable portion of the spreadsheet's content area. In other words, the active area is the portion of the spreadsheet's content area excluding the frozen sections. Since the spreadsheet's content area is usually larger than the screen size, you can scroll the mouse to view the content that extends beyond the screen.

[0095] Content area: The area that combines the frozen area and the active area is called the content area, which is the entire spreadsheet.

[0096] Spreadsheets are an indispensable tool for people to process data in their daily work. As people's needs continue to change, spreadsheets are becoming more and more functional, such as having a freeze function.

[0097] In related technologies, when the cell in row M and column N of a spreadsheet is selected, the first row of the spreadsheet, the first column of the spreadsheet, or the cell in row M and column N can be frozen using the freeze function, where M and N are both integers greater than or equal to 1.

[0098] However, when it is necessary to adjust the frozen area of ​​a spreadsheet, it is necessary to first unfreeze the previously frozen area and then select a new area to freeze in the same way as described above. This makes the process of adjusting the frozen area of ​​a spreadsheet cumbersome, resulting in low efficiency in adjusting the frozen area of ​​a spreadsheet, and consequently, low processing efficiency of the spreadsheet.

[0099] The technical solution provided in this application adjusts the frozen area of ​​the spreadsheet without unfreezing it, making the adjustment of the frozen area more flexible and improving the efficiency of the adjustment, thereby improving the processing efficiency of the spreadsheet.

[0100] Figure 1 A schematic diagram of a spreadsheet processing method according to an embodiment of this application is shown. The method includes at least one of the following steps:

[0101] 1. Displaying the spreadsheet: Spreadsheet 101 displays a first freeze baseline 102. The first freeze baseline 102 is either a horizontal or vertical line. The content area located to one side of the first freeze baseline 102 is the frozen area of ​​the spreadsheet. For example... Figure 1In the spreadsheet 101 shown, the first freeze baseline 102 is a vertical line, and the content area to the left of the first freeze baseline 102 is the frozen area, that is, Figure 1 The content area of ​​the first column in a spreadsheet is the frozen area. For example, in a spreadsheet, the first freeze line is a horizontal line, and the content area above the first freeze line is the frozen area.

[0102] 2. Display freeze drag control: In response to a trigger operation on the first freeze baseline 102 and having spreadsheet editing permissions, display freeze drag control 103, which indicates that the first freeze baseline can be dragged.

[0103] Optionally, a freeze drag control 103 is displayed on the first freeze baseline 102.

[0104] 3. Display prompt information: Based on the fact that the display duration of the freeze drag control 103 is greater than the duration threshold, display prompt information 104. Prompt information 104 is used to indicate that the first freeze baseline 102 is dragged to adjust the freeze area.

[0105] The duration threshold is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. For example, the duration threshold is 300 milliseconds (ms).

[0106] 4. Drag the first freeze baseline: In response to a drag operation on the first freeze baseline 102, change the position of the first freeze baseline 102 in the spreadsheet.

[0107] In one possible implementation, when the first freeze baseline 102 is dragged, the position of the first freeze baseline 102 in the spreadsheet is changed according to the drag operation on the first freeze baseline 102. For example... Figure 1 The first frozen baseline 105 after being dragged is in the third column of the spreadsheet.

[0108] 5. Adjust the frozen area: In response to the end of the operation of dragging the first freeze baseline 102, the frozen area is adjusted to the first area, which is determined based on the first freeze baseline after being dragged.

[0109] Before adjusting the frozen area to the first area, the first area needs to be determined first. The first area can be determined either after dragging the first freeze baseline or after finishing dragging the first freeze baseline. This application embodiment does not limit the timing of determining the first area.

[0110] The process of determining the first region includes: determining a reference line based on the first frozen baseline after being dragged, and determining the content area located on one side of the reference line as the first region.

[0111] Optionally, when the first frozen area is a vertical line, the content area to the left of the reference line is defined as the first area. When the first frozen area is a horizontal line, the content area above the reference line is defined as the first area.

[0112] When the first frozen baseline is a vertical line, the process of determining the reference line based on the dragged first frozen baseline is different from the process of determining the reference line based on the dragged first frozen baseline when the first frozen baseline is a horizontal line. Taking the first frozen baseline as the vertical line as an example, the process of determining the reference line based on the dragged first frozen baseline includes: determining the reference column where the dragged first frozen baseline is located; determining the left border line of the reference column as the reference line; or, determining the right border line of the reference column as the reference line; or, if the dragged first frozen baseline is to the left of the center line of the reference column, determining the left border line of the reference column as the reference line; if the dragged first frozen baseline is to the right of the center line of the reference column, determining the right border line of the reference column as the reference line; or, if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than the area ratio threshold, determining the left border line of the reference column as the reference line; if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than the area ratio threshold, determining the right border line of the reference column as the reference line; the first rectangle is determined based on the dragged first frozen baseline, the left border line of the reference column, the top border line of the reference column, and the bottom border line of the reference column, and the second rectangle is the rectangle corresponding to the reference column.

[0113] like Figure 1 The first frozen baseline 105 after being dragged is located in the third column. Therefore, the right frame line 106 of the third column is used as a reference line, and the content area to the left of the first reference line 106 is determined as the first area, that is, the determined first area is the content area from the first column to the third column.

[0114] When the first freezing baseline is a horizontal line, the process of determining the reference line based on the dragged first freezing baseline will be described in detail in subsequent embodiments.

[0115] In response to the end of the dragging operation of the first freeze baseline 102, the frozen area is adjusted to the first area. The first freeze baseline is displayed on one border line of the adjusted frozen area so that the user knows which areas are in the adjusted frozen area. Optionally, based on the first freeze baseline being a vertical line, the first freeze baseline is displayed on the right border line of the adjusted frozen area. Based on the first freeze baseline being a horizontal line, the first freeze baseline is displayed on the bottom border line of the adjusted frozen area. Figure 1 The adjusted frozen area is the content area from the first to the third column.

[0116] Since the technical solution provided in this application embodiment can be adjusted based on the original frozen area, it is not necessary to unfreeze the original frozen area and then reselect the frozen area to freeze it. This simplifies the process of adjusting the frozen area of ​​the spreadsheet, improves the efficiency of adjusting the frozen area of ​​the spreadsheet, and thus improves the processing efficiency of the spreadsheet.

[0117] The following will use method embodiments to specifically describe the technical solutions provided in the embodiments of this application.

[0118] Please refer to Figure 2 , Figure 2 This is a schematic diagram of the structure of a computer system provided in an embodiment of this application, such as... Figure 2 As shown, the computer system includes: terminal device 201 and server 202.

[0119] The terminal device 201 has a client installed and running that can process spreadsheets. The spreadsheet processing method provided in this application embodiment can be executed by the terminal device 201 or by the terminal device 201 and the server 202. This application embodiment does not limit this.

[0120] Server 202 provides background services for the spreadsheet-processing client installed on terminal device 201. In one possible implementation, server 202 performs the primary computational work, while terminal device 201 performs secondary computational work. Alternatively, server 202 performs secondary computational work, while terminal device 201 performs the primary computational work. Or, terminal device 201 and server 202 collaborate on computation using a distributed computing architecture.

[0121] For example, a client capable of processing spreadsheets can be an office client, an instant messaging client, a game client, a search client, etc.

[0122] This application does not limit the type of client. For example, the client can be an application that needs to be downloaded and installed, a mini-program that does not need to be downloaded, a web application, etc.

[0123] Optionally, the terminal device 201 can be any electronic device product capable of human-computer interaction with a user through one or more methods such as a keyboard, touchpad, remote control, voice interaction, or handwriting device. For example, the terminal device 201 can be a smartphone, tablet computer, laptop computer, desktop computer, smart speaker, smartwatch, PC (Personal Computer), mobile phone, PDA (Personal Digital Assistant), wearable device, PPC (Pocket PC), smart car system, smart TV, etc.

[0124] Terminal device 201 can refer to one of a plurality of terminal devices. This embodiment uses terminal device 201 as an example. Those skilled in the art will know that the number of terminal devices 201 can be more or less. For example, there may be only one terminal device 201, or there may be dozens or hundreds of terminal devices 201, or more. This application embodiment does not limit the number or type of terminal devices 201.

[0125] Server 202 can be a single server, a server cluster consisting of multiple servers, or any of the following: a cloud computing platform or a virtualization center. This embodiment of the application does not limit this. Server 202 communicates directly or indirectly with terminal device 201 via wired or wireless communication. Server 202 has data receiving, data processing, and data sending functions. Of course, server 202 may also have other functions, which are not limited in this embodiment of the application.

[0126] Those skilled in the art should understand that the terminal device 201 and server 202 described above are merely illustrative examples. Other existing or future terminal devices or servers that are applicable to this application should also be included within the scope of protection of this application, and are hereby incorporated by reference.

[0127] This application provides a method for processing spreadsheets, which can be applied to the above-mentioned... Figure 2 The implementation environment shown is as follows: Figure 3 The flowchart shown in this embodiment of the present application illustrates a method for processing spreadsheets. This method can be implemented by... Figure 2 The terminal device 201 executes. For example... Figure 3 As shown, the method includes the following steps 301 to 303.

[0128] In step 301, a spreadsheet is displayed, which displays a first freeze baseline. The first freeze baseline is either a horizontal line or a vertical line, and the content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet.

[0129] In the exemplary embodiments of this application, the spreadsheet can be an online spreadsheet or an offline spreadsheet; the type of spreadsheet is not limited in this embodiment. The spreadsheet has M rows and N columns, that is, it includes M*N cells, where M and N are both integers greater than or equal to 1. The size of each cell in the spreadsheet can be the same or different; this is not limited in this embodiment either.

[0130] It should be noted that when the size of the spreadsheet is larger than the display screen of the terminal device, the content area of ​​the spreadsheet that overflows the display screen can be displayed by scrolling the content area of ​​the spreadsheet.

[0131] Optionally, based on the first freeze baseline as a horizontal line, the content area above the first freeze baseline is the frozen area of ​​the spreadsheet; based on the first freeze baseline as a vertical line, the content area to the left of the first freeze baseline is the frozen area of ​​the spreadsheet.

[0132] like Figure 4 This is a schematic diagram of a spreadsheet provided in an embodiment of this application. The spreadsheet includes 8 rows and 5 columns, with a total of 40 cells. The spreadsheet displays a first freeze baseline 401, which is a vertical line. The content area to the left of the first freeze baseline 401 is the frozen area of ​​the spreadsheet, that is, the content area included in the first column of the spreadsheet is the frozen area of ​​the spreadsheet.

[0133] like Figure 5 This is a schematic diagram of another spreadsheet provided in this application embodiment. The spreadsheet includes 8 rows and 5 columns, with a total of 40 cells. The spreadsheet displays a first freeze baseline 501, which is a horizontal line. The content area above the first freeze baseline 501 is the frozen area of ​​the spreadsheet, that is, the content area included in the first row of the spreadsheet is the frozen area of ​​the spreadsheet.

[0134] In one possible implementation, after the spreadsheet is displayed, in response to a trigger operation on the first frozen baseline, a freeze drag control is displayed, indicating that the first frozen baseline can be dragged. If the display duration of the freeze drag control exceeds a duration threshold, a prompt message is displayed, instructing the user to drag the first frozen baseline to adjust the frozen area. This implementation, by displaying the freeze drag control and the prompt message, reminds the user to adjust the frozen area of ​​the spreadsheet by dragging the first frozen baseline, thus diversifying the methods for adjusting the frozen area and increasing flexibility.

[0135] The duration threshold is set based on experience or adjusted according to the implementation environment; this application embodiment does not limit this. For example, the duration threshold is 300 milliseconds (ms).

[0136] Optionally, the triggering operation for the first frozen baseline includes any of the following: hovering operation on the first frozen baseline; clicking operation on the first frozen baseline; double-clicking operation on the first frozen baseline.

[0137] When the trigger operation for the first freeze baseline is a hover operation on the first freeze baseline, it refers to the operation of the cursor of the control device (such as a mouse) connected to the terminal device hovering on the first freeze baseline.

[0138] In some embodiments, the process of displaying the frozen drag control in response to a trigger operation on the first frozen baseline includes: displaying the frozen drag control in response to the trigger operation on the first frozen baseline and having editing permissions for the spreadsheet. In this implementation, the frozen drag control is only displayed after a trigger operation on the first frozen baseline if the user has editing permissions for the spreadsheet. This prevents users with viewing permissions for the spreadsheet but not editing permissions from adjusting the frozen area of ​​the spreadsheet, thus facilitating spreadsheet management.

[0139] The process of determining whether editing permissions for a spreadsheet are granted includes: generating a permission request, which includes object information of the terminal device's user and table information of the spreadsheet; sending the permission request to the server; the server receiving the permission request, parsing the request to obtain the object information of the terminal device's user and table information of the spreadsheet, determining the permission granting result based on the object information of the terminal device's user and table information of the spreadsheet, and sending the permission granting result to the terminal device.

[0140] Optionally, the process of determining the permission acquisition result based on the object information of the user of the terminal device and the table information of the spreadsheet includes: determining the object information with editing permissions for the spreadsheet based on the table information of the spreadsheet; if the object information of the user of the terminal device is among the object information with editing permissions for the spreadsheet, the permission acquisition result is determined to be having editing permissions for the spreadsheet; otherwise, if the object information of the user of the terminal device is not among the object information with editing permissions for the spreadsheet, the permission acquisition result is determined to be not having editing permissions for the spreadsheet.

[0141] In one possible implementation, the process of displaying the frozen drag control in response to a trigger operation on the first frozen baseline, and having edit permissions for the spreadsheet, includes: determining a trigger area based on the trigger position corresponding to the trigger operation on the first frozen baseline; and displaying the frozen drag control in the trigger area. In this implementation, by determining the trigger area and displaying the frozen drag control within it, the display position of the frozen drag control is fixed.

[0142] This application does not limit the method by which the trigger area is determined based on the trigger position corresponding to the trigger operation targeting the first freeze baseline. Optionally, the trigger area can be determined in the following two ways.

[0143] Method 1: Determine the trigger area by centering on the trigger position corresponding to the trigger operation on the first freeze baseline, using the first value as the length and the second value as the width.

[0144] The first and second values ​​are set based on experience or adjusted according to the implementation environment, and this application embodiment does not limit this. The first and second values ​​can be the same or different. When the first and second values ​​are the same, the trigger area is a square; when the first and second values ​​are different, the trigger area is a rectangle.

[0145] Method 2: Determine the trigger area by taking the trigger position corresponding to the trigger operation on the first freeze baseline as the center and the third value as the radius.

[0146] The third value is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. The trigger area determined by method two is circular.

[0147] like Figure 6 This is a schematic diagram of a frozen drag control provided in an embodiment of this application, showing a frozen drag control 601.

[0148] When the display duration of the frozen drag control exceeds a duration threshold, a prompt message is displayed in the target area, which is determined based on the frozen drag control. For example, the target area may be an area to the left of the frozen drag control, an area to the right of the frozen drag control, an area above the frozen drag control, an area below the frozen drag control, or an area in any direction of the frozen drag control. The content of the prompt message is not limited in this embodiment. Optionally, the prompt message may be "Drag to adjust the frozen area".

[0149] like Figure 7 This is a schematic diagram of a prompt message provided in an embodiment of this application, in which prompt message 701 is displayed.

[0150] In step 302, in response to a drag operation on the first frozen baseline, the position of the first frozen baseline in the spreadsheet is changed.

[0151] In one possible implementation, the position of the first freeze baseline changes when it is dragged. The position of the first freeze baseline changes with the dragging operation on it.

[0152] For example, if the first freeze baseline is a vertical line, dragging it to the left border of the third column will change its position in the spreadsheet to the left border of the third column. As another example, if the first freeze baseline is a horizontal line, dragging it to the fourth row will change its position in the spreadsheet to the fourth row.

[0153] In one possible implementation, based on the first frozen baseline being a vertical line, in response to a drag operation on the first frozen baseline, if the number of columns of the first column displayed to the right of the first frozen baseline is not adjacent to the number of columns of the first column displayed to the left of the first frozen baseline, the content area to the right of the first frozen baseline is slid so that the number of columns of the first column displayed to the right of the first frozen baseline is adjacent to the number of columns of the first column displayed to the left of the first frozen baseline.

[0154] The first column displayed to the right of the first freeze baseline refers to the column adjacent to and to the right of the first freeze baseline. The first column displayed to the left of the first freeze baseline refers to the column adjacent to and to the left of the first freeze baseline.

[0155] In this implementation, when adjusting the frozen area, if the active area in the spreadsheet does not start from the first column of the active area, the active area of ​​the spreadsheet is slid left or right to make it start from the first column of the active area, that is, to scroll the active area of ​​the spreadsheet to the leftmost position, so as to facilitate subsequent adjustments to the frozen area.

[0156] like Figure 8 This is a schematic diagram illustrating the adjustment of a spreadsheet according to an embodiment of this application. Figure 8 In (1), a first freeze baseline 801 is shown. The first column to the left of the first freeze baseline 801 is the first column, and the first column to the right of the first freeze baseline 801 is the fourth column. Therefore, the first column to the left and the first column to the right of the first freeze baseline 801 are not adjacent. Thus, in response to a drag operation on the first freeze baseline 801, sliding the content area to the right of the first freeze baseline 801 yields... Figure 8 (2) in the middle. Figure 8In (2), a first freeze baseline 802 is shown. The first column to the left of the first freeze baseline 802 is the first column, and the first column to the right of the first freeze baseline 802 is the second column. It can be seen that the first column to the left of the first freeze baseline 802 is adjacent to the first column to the right of the first freeze baseline 802.

[0157] In another possible implementation, based on the first freeze baseline being a horizontal line, in response to a drag operation on the first freeze baseline, if the number of rows of the first row displayed above the first freeze baseline is not adjacent to the number of rows of the first row displayed below the first freeze baseline, the content area below the first freeze baseline is slid so that the number of rows of the first row displayed below the first freeze baseline is adjacent to the number of rows of the first row displayed above the first freeze baseline.

[0158] The first row displayed below the first freeze baseline refers to the row that is adjacent to and below the first freeze baseline, and the first row displayed above the first freeze baseline refers to the row that is adjacent to and above the first freeze baseline.

[0159] In this implementation, when adjusting the frozen area, if the active area in the spreadsheet does not start from the first row of the active area, the active area of ​​the spreadsheet is scrolled up and down to make the active area of ​​the spreadsheet start from the first row of the active area, that is, to scroll the active area of ​​the spreadsheet to the top position, so as to facilitate subsequent adjustments to the frozen area.

[0160] like Figure 9 This is a schematic diagram illustrating the adjustment of a spreadsheet according to an embodiment of this application. Figure 9 In (1), a first freeze baseline 901 is shown. The first row above the first freeze baseline 901 is the first row, and the first row below the first freeze baseline 901 is the third row. Therefore, the first row above the first freeze baseline 901 and the first row below the first freeze baseline 901 are not adjacent. Thus, in response to a drag operation on the first freeze baseline 901, sliding the content area below the first freeze baseline 901 yields... Figure 9 (2) in the middle. Figure 9 In (2), a first freeze baseline 902 is shown. The first row above the first freeze baseline 902 is the first row, and the first row below the first freeze baseline 902 is the second row. It can be seen that the first row above the first freeze baseline 902 is adjacent to the first row below the first freeze baseline 902.

[0161] In one possible implementation, if a tooltip is displayed in the spreadsheet, the tooltip is canceled in response to a drag operation on the first freeze baseline. If a freeze drag control is displayed in the spreadsheet, the freeze drag control moves along with the first freeze baseline, and the movement path of the freeze drag control is the same as the movement path of the first freeze baseline.

[0162] In step 303, in response to ending the operation of dragging the first freeze baseline, the frozen area is adjusted to a first area, which is determined based on the dragged first freeze baseline.

[0163] The first region includes a first side region located on the first border line of the reference strip region; or, the first region includes a first side region located on the second border line of the reference strip region. The reference strip region is the region where the first frozen baseline is located after being dragged, and the reference strip region is a reference column or reference column; if the reference strip region is a reference column, the first border line is the left border line, the second border line is the right border line, and the first side is the left side; if the reference strip region is a reference row, the first border line is the top border line, the second border line is the bottom border line, and the first side is the top side.

[0164] Optionally, when the first freeze baseline is a vertical line, the first region includes the region to the left of the left border line of the reference column; or, the first region includes the region to the left of the right border line of the reference column; the reference column is the column where the dragged first freeze baseline is located. When the first freeze baseline is a horizontal line, the first region includes the region above the top border line of the reference row; or, the first region includes the region above the bottom border line of the reference row; the reference row is the row where the dragged first freeze baseline is located.

[0165] In one possible implementation, before adjusting the frozen area to the first area, the first area needs to be determined first. The first area can be determined either after dragging the first freeze baseline or after finishing dragging the first freeze baseline. This application embodiment does not limit the timing of determining the first area. The first area can be determined by the terminal device or determined by the server and then sent to the terminal device. The process of the terminal device determining the first area is similar to the process of the server determining the first area; this application embodiment only describes the process of the terminal device determining the first area as an example.

[0166] Optionally, a reference line is determined based on the first frozen baseline after being dragged; the content area located on one side of the reference line is determined as the first area.

[0167] Based on the first freeze baseline being a vertical line and the reference line also being a vertical line, the content area to the left of the reference line is defined as the first region. Based on the first freeze baseline being a horizontal line and the reference line also being a horizontal line, the content area above the reference line is defined as the first region.

[0168] The process of determining the reference line based on the dragged first frozen baseline when the first frozen baseline is a vertical line differs from the process when the first frozen baseline is a horizontal line. The following details the process of determining the reference line based on the dragged first frozen baseline when it is a vertical line, and the process of determining the reference line based on the dragged first frozen baseline when it is a horizontal line.

[0169] In one possible implementation, when the first frozen baseline is a vertical line, the process of determining the reference line based on the dragged first frozen baseline includes: determining the reference column where the dragged first frozen baseline is located, based on the first frozen baseline being a vertical line; determining the reference line based on the reference column. Then, the content area to the left of the reference line is determined as the first region.

[0170] The methods for determining the reference line based on the reference column include the first to fourth methods described below.

[0171] The first method involves determining the left border line of the reference column as the reference line.

[0172] For example, if the reference column is the third column, then the left border line of the third column is determined as the reference line. In this implementation, the left border line of the reference column is directly used as the reference line, which simplifies the determination of the reference line, thereby simplifying the determination of the first area and the adjustment of the frozen area of ​​the spreadsheet.

[0173] In one possible implementation, to ensure users can view the content, the active area of ​​the spreadsheet cannot be too small; that is, the frozen area of ​​the spreadsheet cannot be too large. Therefore, when determining the reference line, a frozen column number threshold must also be considered. The number of columns before the left border of the reference column is determined; if the number of columns before the left border of the reference column is not higher than the frozen column number threshold, the left border of the reference column is determined as the reference line. In this implementation, the number of columns to the left of the reference line is not higher than the frozen column number threshold, thus ensuring that the number of columns included in the determined first area is not higher than the frozen column number threshold, and that the number of columns included in the adjusted frozen area is not higher than the frozen column number threshold, still meeting the user's need to view the content.

[0174] The frozen column threshold refers to the number of columns in the spreadsheet that can be frozen. The frozen column threshold is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. The frozen column threshold is lower than the total number of columns in the spreadsheet. For example, the frozen column threshold is 3, meaning that the spreadsheet can have 3 columns frozen.

[0175] When the number of columns before the left border of the reference column exceeds the frozen column count threshold, the right border of the column in the spreadsheet whose number of columns equals the frozen column count threshold is designated as the reference line. In this implementation, when the number of columns before the left border of the reference column exceeds the frozen column count threshold, the right border of the freezeable area is used as the reference line, ensuring that the number of columns included in the adjusted frozen area does not exceed the frozen column count threshold, thus still meeting the user's content viewing needs.

[0176] For example, if the number of columns before the left border of the reference column is 5 and the frozen column threshold is 3, then the number of columns before the left border of the reference column is higher than the frozen column threshold. Therefore, the right border of the third column in the spreadsheet is determined as the reference line.

[0177] The second method involves determining the right border of the reference column as the reference line.

[0178] For example, if the reference column is the third column, then the right border of the third column is determined as the reference line. In this implementation, the right border of the reference column is directly used as the reference line, which simplifies the determination of the reference line, thereby simplifying the determination of the first area and the adjustment of the frozen area of ​​the spreadsheet.

[0179] In one possible implementation, to ensure users can view the content, the active area of ​​the spreadsheet cannot be too small; that is, the frozen area of ​​the spreadsheet cannot be too large. Therefore, when determining the reference line, a frozen column number threshold must also be considered. The number of columns before the right border of the reference column is determined; if the number of columns before the right border of the reference column is not higher than the frozen column number threshold, the right border of the reference column is determined as the reference line. In this implementation, the number of columns to the left of the reference line is not higher than the frozen column number threshold, thus ensuring that the number of columns included in the determined first area is not higher than the frozen column number threshold, and that the number of columns included in the adjusted frozen area is not higher than the frozen column number threshold, still meeting the user's need to view the content.

[0180] The frozen column threshold refers to the number of columns in the spreadsheet that can be frozen. The frozen column threshold is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. The frozen column threshold is lower than the total number of columns in the spreadsheet. For example, the frozen column threshold is 3, meaning that the spreadsheet can have 3 columns frozen.

[0181] When the number of columns before the right border of the reference column exceeds the frozen column count threshold, the right border of the column in the spreadsheet whose number of columns equals the frozen column count threshold is designated as the reference line. In this implementation, when the number of columns before the right border of the reference column exceeds the frozen column count threshold, the right border of the freezeable area is used as the reference line, ensuring that the number of columns included in the adjusted frozen area does not exceed the frozen column count threshold, thus still meeting the user's content viewing needs.

[0182] For example, if the number of columns before the right border of the reference column is 5 and the frozen column threshold is 3, then the number of columns before the right border of the reference column is higher than the frozen column threshold. Therefore, the right border of the third column in the spreadsheet is determined as the reference line.

[0183] The third method is to determine the left border line of the reference column as the reference line when the first frozen baseline after being dragged is to the left of the center line of the reference column; and to determine the right border line of the reference column as the reference line when the first frozen baseline after being dragged is to the right of the center line of the reference column.

[0184] In this implementation, the reference line is determined by determining the relationship between the first frozen baseline after it has been dragged and the center line of the reference column where the first frozen baseline after it has been dragged is located. This makes the determination of the reference line more diverse and more accurate, thereby making the determination of the first region more accurate.

[0185] In the case where the first frozen baseline after being dragged is located to the left of the center line of the reference column, the process of determining the left border line of the reference column as the reference line is similar to the process in the first method described above. In the case where the first frozen baseline after being dragged is located to the right of the center line of the reference column, the process of determining the right border line of the reference column as the reference line is similar to the process in the second method described above, and will not be described again in the embodiments of this application.

[0186] The fourth method is to determine the left border line of the reference column as the reference line when the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than the area ratio threshold; and to determine the right border line of the reference column as the reference line when the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than the area ratio threshold.

[0187] The first rectangle is determined based on the dragged first freeze baseline, the left border line, the top border line, and the bottom border line of the reference column; that is, the first rectangle is the rectangle formed by the dragged first freeze baseline, the left border line, the top border line, and the bottom border line of the reference column. The second rectangle is the rectangle corresponding to the reference column; that is, the second rectangle is the rectangle formed by the right border line, the left border line, the top border line, and the bottom border line of the reference column.

[0188] Optionally, the area ratio threshold may be set based on experience or adjusted according to the implementation environment; this embodiment of the application does not limit this. For example, the area ratio threshold is 50%.

[0189] In one possible implementation, when the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than the area ratio threshold, the process of determining the left border line of the reference column as the reference line is similar to the process in the first method described above. When the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than the area ratio threshold, the process of determining the right border line of the reference column as the reference line is similar to the process in the second method described above. The embodiments of this application will not be described in detail here.

[0190] In one possible implementation, when the first frozen baseline is a horizontal line, the process of determining the reference line based on the dragged first frozen baseline includes: determining the reference row where the dragged first frozen baseline is located, based on the first frozen baseline being a horizontal line; determining the reference line based on the reference row; and then determining the content area above the reference line as the first region.

[0191] Among them, the methods for determining the reference line based on the reference row include the following methods one to four.

[0192] Method 1: Determine the top border line of the reference row as the reference line.

[0193] For example, if the reference row is the third row, then the top border of the third row is determined as the reference line. In this implementation, directly using the top border of the reference row as the reference line simplifies the determination of the reference line, thereby simplifying the determination of the first area and the adjustment of the frozen area of ​​the spreadsheet.

[0194] In one possible implementation, to ensure users can view the content, the active area of ​​the spreadsheet cannot be too small; that is, the frozen area of ​​the spreadsheet cannot be too large. Therefore, when determining the reference line, a frozen row number threshold must also be considered. The number of rows before the top border of the reference row is determined; if the number of rows before the top border of the reference row is not higher than the frozen row number threshold, the top border of the reference row is determined as the reference line. In this implementation, the number of rows above the reference line is not higher than the frozen row number threshold, thus ensuring that the number of rows included in the determined first area is not higher than the frozen row number threshold, and that the number of rows included in the adjusted frozen area is not higher than the frozen row number threshold, still meeting the user's need to view the content.

[0195] The frozen row threshold refers to the number of rows in the spreadsheet that can be frozen. The frozen row threshold is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. The frozen row threshold is lower than the total number of rows in the spreadsheet. For example, the frozen row threshold is 3, meaning that the spreadsheet can have 3 rows frozen.

[0196] When the number of rows before the top border of the reference row exceeds the frozen row count threshold, the bottom border of the row in the spreadsheet whose number of rows equals the frozen row count threshold is designated as the reference line. In this implementation, when the number of rows before the top border of the reference row exceeds the frozen row count threshold, the bottom border of the freezeable area is used as the reference line, ensuring that the number of rows included in the adjusted frozen area does not exceed the frozen row count threshold, thus still meeting the user's content viewing needs.

[0197] For example, if the number of rows before the top border of the reference row is 5 and the frozen row threshold is 3, then the number of rows before the top border of the reference row is higher than the frozen row threshold. Therefore, the bottom border of the third row in the spreadsheet is determined as the reference line.

[0198] Method 2: Determine the bottom border line of the reference row as the reference line.

[0199] For example, if the reference row is the third row, then the bottom border of the third row is determined as the reference line. In this implementation, the bottom border of the reference row is directly used as the reference line, which simplifies the determination of the reference line, thereby simplifying the determination of the first area and the adjustment of the frozen area of ​​the spreadsheet.

[0200] In one possible implementation, to ensure users can view the content, the active area of ​​the spreadsheet cannot be too small; that is, the frozen area of ​​the spreadsheet cannot be too large. Therefore, when determining the reference line, a frozen row number threshold must also be considered. The number of rows before the bottom border of the reference row is determined; if the number of rows before the bottom border of the reference row is not higher than the frozen row number threshold, the bottom border of the reference row is determined as the reference line. In this implementation, the number of rows to the left of the reference line is not higher than the frozen row number threshold, thus ensuring that the number of rows included in the determined first area is not higher than the frozen row number threshold, and that the number of rows included in the adjusted frozen area is not higher than the frozen row number threshold, still meeting the user's need to view the content.

[0201] The frozen row threshold refers to the number of rows in the spreadsheet that can be frozen. The frozen row threshold is set based on experience or adjusted according to the implementation environment; this embodiment does not limit this. The frozen row threshold is lower than the total number of rows in the spreadsheet. For example, the frozen row threshold is 3, meaning that the spreadsheet can have 3 rows frozen.

[0202] When the number of rows before the bottom border of the reference row exceeds the frozen row count threshold, the bottom border of the row in the spreadsheet whose number of rows equals the frozen row count threshold is designated as the reference line. In this implementation, when the number of rows before the bottom border of the reference row exceeds the frozen row count threshold, the bottom border of the freezeable area is used as the reference line, ensuring that the number of rows included in the adjusted frozen area does not exceed the frozen row count threshold, thus still meeting the user's content viewing needs.

[0203] For example, if the number of rows before the bottom border of the reference row is 5 and the frozen row threshold is 3, then the number of rows before the bottom border of the reference row is higher than the frozen row threshold. Therefore, the bottom border of the third row in the spreadsheet is determined as the reference line.

[0204] Method 3: If the first frozen baseline after being dragged is above the center line of the reference row, determine the top border line of the reference row as the reference line; if the first frozen baseline after being dragged is below the center line of the reference row, determine the bottom border line of the reference row as the reference line.

[0205] In this implementation, the reference line is determined by determining the relationship between the first frozen baseline after it has been dragged and the center line of the reference row where the first frozen baseline is located. This makes the determination of the reference line more diverse and the determination of the second reference line more accurate, thereby making the determination of the first region more accurate.

[0206] In the case where the first frozen baseline after being dragged is above the center line of the reference row, the process of determining the upper border line of the reference row as the reference line is similar to the process in Method 1 above. In the case where the first frozen baseline after being dragged is below the center line of the reference row, the process of determining the lower border line of the reference row as the reference line is similar to the process in Method 2 above, and will not be described again in the embodiments of this application.

[0207] Method 4: If the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is lower than the area ratio threshold, determine the top border line of the reference row as the reference line; if the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is higher than the area ratio threshold, determine the bottom border line of the reference row as the reference line.

[0208] The third rectangle is determined based on the dragged first frozen baseline, the top border of the reference row, the left border of the reference row, and the right border of the reference row. In other words, the third rectangle is the rectangle formed by the dragged first frozen baseline, the top border of the reference row, the left border of the reference row, and the right border of the reference row. The fourth rectangle is the rectangle corresponding to the reference row; that is, the fourth rectangle is the rectangle formed by the bottom border of the reference row, the left border of the reference row, the top border of the reference row, and the right border of the reference row.

[0209] Optionally, the area ratio threshold may be set based on experience or adjusted according to the implementation environment; this embodiment of the application does not limit this. For example, the area ratio threshold is 50%.

[0210] In one possible implementation, when the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is lower than the area ratio threshold, the process of determining the upper border line of the reference row as the reference line is similar to the process in Method 1 above. When the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is higher than the area ratio threshold, the process of determining the lower border line of the reference row as the reference line is similar to the process in Method 2 above. The embodiments of this application will not be described in detail here.

[0211] Optionally, after determining the reference line, it can be displayed as a reference state, indicating that the frozen area should be adjusted to one side of the reference line. The reference state can be any state, and this embodiment does not limit its application. For example, displaying the reference line as a reference state can be done by displaying it in a bold style or by displaying it in a blue highlighted style. In this implementation, by displaying the reference line as a reference state, the user can see the adjusted frozen area in real time, making the user aware of the adjustment and enhancing their sense of participation in the adjustment process.

[0212] like Figure 10 This is a schematic diagram of a reference line provided in an embodiment of this application. Figure 10 In the spreadsheet shown in (1), the first frozen baseline 1001, after being dragged, is located to the left of the center line of the third column. Therefore, the left border line 1002 of the third column is used as a reference line, and the left border line 1002 of the third column is displayed in a bold state. Figure 10 In the spreadsheet shown in (2), the first frozen baseline 1003, after being dragged, is located to the right of the center line of the third column. Therefore, the right border line 1004 of the third column is used as a reference line, and the right border line 1004 of the third column is displayed in a bold state. Figure 10 In the spreadsheet shown in (3), the first frozen baseline 1005, after being dragged, is located above the center line of the third row. Therefore, the top border line 1006 of the third row is used as a reference line, and the top border line 1006 of the third row is displayed in a bold state. Figure 10 In the spreadsheet shown in (4), the first frozen baseline 1007 after being dragged is located below the center line of the third row. Therefore, the bottom border line 1008 of the third row is used as a reference line and the bottom border line 1008 of the third row is displayed in a bold state.

[0213] In one possible implementation, after the reference line is determined in the above process, in response to ending the dragging operation of the first frozen baseline, the first frozen baseline is de-displayed and displayed on the reference line. At this time, the frozen area is adjusted to the content area located before the reference line. That is, the frozen area has been adjusted to the first area.

[0214] Optionally, if a freeze drag control is displayed on the first freeze baseline, the freeze drag control can be dedisplayed. You can dedisplay the freeze drag control first, then dedisplay the first freeze baseline; or you can dedisplay the first freeze baseline first, then dedisplay the freeze drag control; or you can dedisplay both the first freeze baseline and the freeze drag control simultaneously.

[0215] In some embodiments, when the reference line is displayed in a reference state, in response to ending the operation of dragging the first frozen baseline, the reference line is restored to its original state. For example, the reference state is faded out over a reference duration. The reference duration is set based on experience or adjusted according to the implementation environment, and this embodiment of the application does not limit it in this way. For example, the reference duration is 300 milliseconds.

[0216] like Figure 11 This is a schematic diagram of another spreadsheet display provided in the embodiments of this application. Figure 11 The spreadsheet shown has a first freeze baseline 1101 in the third column, which means that the frozen area of ​​the spreadsheet has been adjusted from the content area of ​​the first column to the content area of ​​the first to third columns.

[0217] In one possible implementation, after adjusting the frozen area of ​​the spreadsheet, a message indicating successful adjustment of the frozen area can be displayed. This message serves to indicate that the frozen area has been adjusted. This provides feedback to the user regarding the adjustment result, allowing the user to be aware of the outcome. This application does not limit the content of the message indicating successful adjustment of the frozen area. For example, the message may simply be "Frozen area adjustment successful." This application also does not limit the display location of the message. For example, the message may be displayed at the top center of the spreadsheet.

[0218] In another possible implementation, if an anomaly occurs during the adjustment of the frozen area (e.g., a webpage crash or a change in editing permissions), the adjustment will be interrupted, and a "failed to adjust frozen area" message will be displayed to inform the user that the adjustment has failed. This application embodiment does not limit the content of the "failed to adjust frozen area" message. For example, the message is simply "Frozen area adjustment failed." This application embodiment also does not limit the display location of the "failed to adjust frozen area" message. For example, the message is displayed at the top center of the spreadsheet.

[0219] In some embodiments, if the spreadsheet is an online spreadsheet, and the user making the adjustment has poor network conditions, the user's adjustment will take effect in the spreadsheet displayed on the user's terminal device. Later, when the network conditions improve, the adjustment of the frozen area will be submitted to other users who can edit / view the spreadsheet, that is, so that other users can see the current user's adjustment results.

[0220] In one possible implementation, the spreadsheet also displays a second freeze baseline, which can be a horizontal or vertical line. This second freeze baseline differs from the first freeze baseline, and the content area located to one side of the second freeze baseline is the frozen area. The first and second freeze baselines intersect at a reference point. For example... Figure 12 This is a schematic diagram of another spreadsheet display provided in this application embodiment. It shows a first freeze baseline 1201 and a second freeze baseline 1202. The first freeze baseline 1201 is a vertical line, and the second freeze baseline 1202 is a horizontal line. The first freeze baseline 1201 and the second freeze baseline 1202 intersect at point A. The content area of ​​the first row and the first column of the spreadsheet is the frozen area. The frozen area of ​​the spreadsheet can also be adjusted by dragging the reference points.

[0221] Optionally, in response to a drag operation on the reference point, the position of the reference point in the spreadsheet is changed; in response to the end of the drag operation, the frozen area is adjusted to a second area, which is determined based on the dragged reference line. In this implementation, when the spreadsheet has two frozen baselines, the frozen area of ​​the spreadsheet is adjusted by dragging the intersection of the two frozen baselines, making the adjustment of the frozen area of ​​the spreadsheet more diverse and flexible.

[0222] The second region includes the area to the left of the left border line and the area above the top border line of the reference cell; or, the second region includes the area to the left of the left border line and the area above the bottom border line of the reference cell; or, the second region includes the area to the left of the right border line and the area above the top border line of the reference cell; or, the second region includes the area to the left of the right border line and the area above the bottom border line of the reference cell; wherein, the reference cell is the cell where the reference point is located after being dragged.

[0223] In one possible implementation, before adjusting the frozen area to the second area, the second area needs to be determined first. The entity executing the determination of the second area can be a terminal device or a server. This application embodiment only describes the determination of the second area using a terminal device as an example. The process of determining the second area includes: determining the reference cell where the dragged reference line is located; determining the first reference line and the second reference line based on the reference cell; and determining the content area above the first reference line and the content area to the left of the second reference line as the second area.

[0224] In one possible implementation, the process of determining the first reference line and the second reference line based on the reference cell can be implemented in ways 1 to 5.

[0225] Method 1: Determine the line containing the top border of the reference cell as the first reference line, and the line containing the left border of the reference cell as the second reference line.

[0226] In one possible implementation, the number of rows before the top border line of the reference cell and the number of columns before the left border line of the reference cell can also be determined. If the number of rows before the top border line of the reference cell is not higher than the frozen row number threshold and the number of columns before the left border line of the reference cell is not higher than the frozen column number threshold, the line where the top border line of the reference cell is located is determined as the first reference line and the line where the left border line of the reference cell is located is determined as the second reference line.

[0227] If the number of rows before the top border of the reference cell is not higher than the frozen row threshold, and the number of columns before the left border of the reference cell is higher than the frozen column threshold, then the line containing the top border of the reference cell is determined as the first reference line; the right border of the column in the spreadsheet whose number of columns is equal to the target frozen column threshold is determined as the second reference line.

[0228] If the number of rows before the top border of the reference cell is higher than the frozen row count threshold, and the number of columns before the left border of the reference cell is not higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the line containing the left border of the reference cell is determined as the second reference line.

[0229] If the number of rows before the top border of the reference cell is higher than the frozen row count threshold, and the number of columns before the left border of the reference cell is higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the column in the spreadsheet whose column count is equal to the target frozen column count threshold is determined as the second reference line.

[0230] Method 2: Determine the top border line of the reference cell as the first reference line and the right border line of the reference cell as the second reference line.

[0231] In one possible implementation, the number of rows before the top border line of the reference cell and the number of columns before the right border line of the reference cell can also be determined. If the number of rows before the top border line of the reference cell is not higher than the frozen row threshold and the number of columns before the right border line of the reference cell is not higher than the frozen column threshold, the line where the top border line of the reference cell is located is determined as the first reference line and the line where the right border line of the reference cell is located is determined as the second reference line.

[0232] If the number of rows before the top border of the reference cell is no higher than the frozen row threshold, and the number of columns before the right border of the reference cell is higher than the frozen column threshold, then the top border of the reference cell is designated as the first reference line; and the right border of the column in the spreadsheet whose column number is equal to the target frozen column threshold is designated as the second reference line.

[0233] If the number of rows before the top border of the reference cell is higher than the frozen row count threshold, and the number of columns before the right border of the reference cell is not higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the reference cell is determined as the second reference line.

[0234] If the number of rows before the top border of the reference cell is higher than the frozen row count threshold, and the number of columns before the right border of the reference cell is higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the column in the spreadsheet whose column count is equal to the target frozen column count threshold is determined as the second reference line.

[0235] Method 3: Determine the bottom border of the reference cell as the first reference line and the left border of the reference cell as the second reference line.

[0236] In one possible implementation, the number of rows before the bottom border line of the reference cell and the number of columns before the left border line of the reference cell can also be determined. If the number of rows before the bottom border line of the reference cell is not higher than the frozen row number threshold and the number of columns before the left border line of the reference cell is not higher than the frozen column number threshold, the line where the bottom border line of the reference cell is located is determined as the first reference line and the line where the left border line of the reference cell is located is determined as the second reference line.

[0237] If the number of rows before the bottom border of the reference cell is not higher than the frozen row threshold, and the number of columns before the left border of the reference cell is higher than the frozen column threshold, then the bottom border of the reference cell is designated as the first reference line; the right border of the column in the spreadsheet whose number of columns is equal to the target frozen column threshold is designated as the second reference line.

[0238] If the number of rows before the bottom border of the reference cell is higher than the frozen row count threshold, and the number of columns before the left border of the reference cell is not higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the line containing the left border of the reference cell is determined as the second reference line.

[0239] If the number of rows before the bottom border of the reference cell is higher than the frozen row count threshold, and the number of columns before the left border of the reference cell is higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the column in the spreadsheet whose column count is equal to the target frozen column count threshold is determined as the second reference line.

[0240] Method 4: Determine the bottom border of the reference cell as the first reference line, and the right border of the reference cell as the second reference line.

[0241] In one possible implementation, the number of rows before the bottom border line of the reference cell and the number of columns before the right border line of the reference cell can also be determined. If the number of rows before the bottom border line of the reference cell is not higher than the frozen row number threshold and the number of columns before the right border line of the reference cell is not higher than the frozen column number threshold, the line where the bottom border line of the reference cell is located is determined as the first reference line and the line where the right border line of the reference cell is located is determined as the second reference line.

[0242] If the number of rows before the bottom border of the reference cell is no higher than the frozen row threshold, and the number of columns before the right border of the reference cell is higher than the frozen column threshold, then the bottom border of the reference cell is designated as the first reference line; and the right border of the column in the spreadsheet whose column number is equal to the target frozen column threshold is designated as the second reference line.

[0243] If the number of rows before the bottom border of the reference cell is higher than the frozen row count threshold, and the number of columns before the right border of the reference cell is not higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the reference cell is determined as the second reference line.

[0244] If the number of rows before the bottom border of the reference cell is higher than the frozen row count threshold, and the number of columns before the right border of the reference cell is higher than the frozen column count threshold, then the bottom border of the row in the spreadsheet whose row count is equal to the frozen row count threshold is determined as the first reference line, and the right border of the column in the spreadsheet whose column count is equal to the target frozen column count threshold is determined as the second reference line.

[0245] Method 5: When the dragged reference point is located in the upper left area of ​​the reference cell, determine the line containing the top border of the reference cell as the first reference line and the line containing the left border of the reference cell as the second reference line; when the dragged reference point is located in the upper right area of ​​the reference cell, determine the line containing the top border of the reference cell as the first reference line and the line containing the right border of the reference cell as the second reference line; when the dragged reference point is located in the lower left area of ​​the reference cell, determine the line containing the bottom border of the reference cell as the first reference line and the line containing the left border of the reference cell as the second reference line; when the dragged reference point is located in the lower right area of ​​the reference cell, determine the line containing the bottom border of the reference cell as the first reference line and the line containing the right border of the reference cell as the second reference line.

[0246] In this implementation, after determining the reference cell where the dragged reference point is located, the reference cell is divided into four regions: the upper left region, the lower left region, the upper right region, and the lower right region.

[0247] This application does not limit the method of dividing the reference cell. Optionally, the reference cell can be divided according to its horizontal and vertical midpoints to obtain four regions included in the reference cell.

[0248] like Figure 13This is a schematic diagram of a reference cell provided in an embodiment of this application, wherein the first area is the upper left area of ​​the reference cell, the second area is the upper right area of ​​the reference cell, the third area is the lower left area of ​​the reference cell, and the fourth area is the lower right area of ​​the reference cell.

[0249] In the first possible implementation, when the dragged reference point is located in the upper left area of ​​the reference cell, the process of determining the line containing the top border of the reference cell as the first reference line and the line containing the left border of the reference cell as the second reference line is similar to the process in Method 1 above, and will not be repeated here. Figure 14 This is a schematic diagram of a first reference line and a second reference line provided in an embodiment of this application. The dragged reference point A is located in the upper left region of the cell in the third row and third column. Therefore, line 1401, where the top border of the cell in the third row and third column is located, is used as the first reference line, and line 1402, where the left border of the cell in the third row and third column is located, is used as the second reference line.

[0250] In the second possible implementation, when the dragged reference point is located in the upper right area of ​​the reference cell, the process of determining the line containing the top border of the reference cell as the first reference line and the line containing the right border of the reference cell as the second reference line is similar to the process in method 2 above, and will not be repeated here. Figure 15 This is a schematic diagram of a first reference line and a second reference line provided in an embodiment of this application. The reference point A after being dragged is located in the upper right area of ​​the cell in the third row and third column. Therefore, the line 1501 where the top border of the cell in the third row and third column is located is taken as the first reference line, and the line 1502 where the right border of the cell in the third row and third column is located is taken as the second reference line.

[0251] In the third possible implementation, when the dragged reference point is located in the lower left area of ​​the reference cell, the process of determining the line containing the bottom border of the reference cell as the first reference line and the line containing the left border of the reference cell as the second reference line is similar to the process in method 3 above, and will not be repeated here. Figure 16 This is a schematic diagram of a first reference line and a second reference line provided in an embodiment of this application. The reference point A after being dragged is located in the lower left area of ​​the cell in the third row and third column. Therefore, the line 1601 where the bottom border of the cell in the third row and third column is located is taken as the first reference line, and the line 1602 where the left border of the cell in the third row and third column is located is taken as the second reference line.

[0252] In the fourth possible implementation, when the dragged reference point is located in the lower right area of ​​the reference cell, the process of determining the line containing the bottom border of the reference cell as the first reference line and the line containing the right border of the reference cell as the second reference line is similar to the process in method 4 above, and will not be repeated here. Figure 17 This is a schematic diagram of a first reference line and a second reference line provided in an embodiment of this application. The reference point A after being dragged is located in the lower right area of ​​the cell in the third row and third column. Therefore, the line 1701 where the bottom border of the cell in the third row and third column is located is taken as the first reference line, and the line 1702 where the right border of the cell in the third row and third column is located is taken as the second reference line.

[0253] In some embodiments, in response to the end of the dragging reference point operation, a first freeze baseline is displayed on a first reference line, and a second freeze baseline is displayed on a second reference line, such that the frozen area is adjusted to include the content area above the first reference line and the content area to the left of the second reference line. That is, the adjusted frozen area is the content area above the first reference line and the content area to the left of the second reference line. Figure 18 This is a schematic diagram of a spreadsheet after adjusting the frozen area, provided in an embodiment of this application. It shows a first freezing baseline 1801 and a second freezing baseline 1802, indicating that the adjusted frozen area comprises the content areas of the first row, second row, first column, and second column.

[0254] In one possible implementation, when a first and a second freeze baseline are displayed in the spreadsheet, a freeze drag control is also displayed in response to a trigger operation on a reference point. The freeze drag control is used to indicate that a draggable reference point is available. When the display duration of the freeze drag control exceeds a duration threshold, a prompt message is displayed to instruct the user to drag the reference point to adjust the freeze area.

[0255] The triggering operation for the reference point is similar to the triggering operation for the first frozen baseline described above, and will not be repeated here in the embodiments of this application.

[0256] Optionally, after determining the first reference line and the second reference line, the first reference line and the second reference line can also be displayed as reference states so that the user knows which areas are the adjusted frozen areas. The process of displaying the first reference line and the second reference line as reference states is similar to the process of displaying reference lines as reference states described above, and will not be described again in this embodiment.

[0257] When a spreadsheet has frozen areas, adjusting these areas simply requires dragging the first freeze baseline used to indicate the frozen area. There's no need to unfreeze and re-define the frozen areas. This reduces the complexity of adjusting frozen areas, making it more flexible and improving efficiency, thus enhancing overall spreadsheet processing efficiency.

[0258] Figure 19 This is a flowchart of a spreadsheet processing method provided in an embodiment of this application, such as... Figure 19 As shown, the method includes the following steps.

[0259] Step 1901: Display the spreadsheet, which shows the first freeze baseline.

[0260] In one possible implementation, the process of displaying the spreadsheet has been described in step 201 above and will not be repeated here.

[0261] Step 1902: In response to the trigger operation for the first frozen baseline, determine whether there is editing permission.

[0262] In one possible implementation, the process of determining whether there is editing permission in response to a trigger operation on the first frozen baseline has been described in step 201 above and will not be repeated here.

[0263] If you have editing permissions, proceed to step 1903; if you do not have editing permissions, end the process.

[0264] Step 1903: Display the frozen drag control.

[0265] In one possible implementation, the process of displaying the frozen drag control has been described in step 201 above, and will not be repeated here.

[0266] Step 1904: Display a prompt message.

[0267] In one possible implementation, the process of displaying the prompt message has been described in step 201 above, and will not be repeated here.

[0268] Step 1905: In response to a drag operation on the first freeze baseline, change the position of the first freeze baseline in the spreadsheet.

[0269] In one possible implementation, the process of changing the position of the first frozen baseline in the spreadsheet in response to a drag operation on the first frozen baseline has been described in step 202 above and will not be repeated here.

[0270] Step 1906: Determine the reference line based on the first frozen baseline after it has been dragged.

[0271] In one possible implementation, the process of determining the reference line based on the first frozen baseline after being dragged has been described in step 203 above and will not be repeated here.

[0272] Step 1907: Determine the first region based on the reference line.

[0273] In one possible implementation, the process of determining the first region based on the reference line has been described in step 203 above and will not be repeated here.

[0274] Step 1908: In response to the end of the operation of dragging the first freeze baseline, adjust the freeze area to the first area.

[0275] In one possible implementation, the process of adjusting the frozen area to the first area in response to the end of the operation of dragging the first frozen baseline has been described in step 203 above, and will not be repeated here.

[0276] Figure 20 The diagram shown is a schematic representation of a spreadsheet processing device according to an embodiment of this application. Figure 20 As shown, the device includes:

[0277] Display module 2001 is used to display a spreadsheet. The spreadsheet displays a first freeze baseline, which is either a horizontal line or a vertical line. The content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet.

[0278] Modify module 2002 is used to change the position of the first frozen baseline in the spreadsheet in response to a drag operation on the first frozen baseline.

[0279] The adjustment module 2003 is used to adjust the frozen area to a first area in response to the end of the dragging of the first frozen baseline. The first area is determined based on the dragged first frozen baseline.

[0280] In one possible implementation, the first region includes a first side region located on the first border line of the reference strip region; or, the first region includes a first side region located on the second border line of the reference strip region; wherein, the reference strip region is the region where the first frozen baseline is located after being dragged, and the reference strip region is a reference column or reference column; based on the reference strip region being a reference column, the first border line is the left border line, the second border line is the right border line, and the first side is the left side; based on the reference strip region being a reference row, the first border line is the top border line, the second border line is the bottom border line, and the first side is the top side.

[0281] In one possible implementation, the first freeze baseline is a vertical line; the first region includes the region to the left of the left border line of the reference column; or, the first region includes the region to the left of the right border line of the reference column; wherein, the reference column is the column where the first freeze baseline is located after being dragged.

[0282] In one possible implementation, the first freeze baseline is a horizontal line; the first region includes the region above the upper border line of the reference row; or, the first region includes the region above the lower border line of the reference row; wherein the reference row is the row where the first freeze baseline is located after it has been dragged.

[0283] In one possible implementation, the device further includes:

[0284] The determination module is used to determine the reference line based on the first frozen baseline after being dragged; and to determine the content area located on one side of the reference line as the first area.

[0285] In one possible implementation, a determination module is used to determine the reference column where the first frozen baseline is located after being dragged, based on the first frozen baseline as the vertical line; determine the reference line according to the reference column; and determine the content area to the left of the reference line as the first region.

[0286] In one possible implementation, a determining module is used to determine the left border line of the reference column as a reference line; or, to determine the right border line of the reference column as a reference line; or, if the dragged first frozen baseline is located to the left of the center line of the reference column, the left border line of the reference column is determined as a reference line; if the dragged first frozen baseline is located to the right of the center line of the reference column, the right border line of the reference column is determined as a reference line; or, if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than an area ratio threshold, the left border line of the reference column is determined as a reference line; if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than an area ratio threshold, the right border line of the reference column is determined as a reference line; wherein the first rectangle is determined based on the dragged first frozen baseline, the left border line of the reference column, the top border line of the reference column, and the bottom border line of the reference column, and the second rectangle is the rectangle corresponding to the reference column.

[0287] In one possible implementation, a determining module is used to determine the number of columns before the left border line of the reference column; if the number of columns before the left border line of the reference column is not higher than the frozen column number threshold, the left border line of the reference column is determined as the reference line.

[0288] In one possible implementation, the determining module is also used to determine the right border of the column in the spreadsheet whose number of columns is equal to the frozen column number threshold as the reference line if the number of columns before the left border of the reference column is higher than the frozen column number threshold.

[0289] In one possible implementation, a determination module is used to determine the reference row where the first frozen baseline is located after being dragged, based on the first frozen baseline as a horizontal line; determine a reference line according to the reference line; and determine the content area located above the reference line as the first region.

[0290] In one possible implementation, a determining module is used to determine the top border line of the reference row as a reference line; or, to determine the bottom border line of the reference row as a reference line; or, if the dragged first frozen baseline is above the center line of the reference row, the top border line of the reference row is determined as a reference line; if the dragged first frozen baseline is below the center line of the reference row, the bottom border line of the reference row is determined as a reference line; or, if the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is lower than an area ratio threshold, the top border line of the reference row is determined as a reference line; if the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is higher than an area ratio threshold, the bottom border line of the reference row is determined as a reference line; wherein the third rectangle is determined based on the dragged first frozen baseline, the top border line of the reference row, the left border line of the reference row, and the right border line of the reference row, and the fourth rectangle is the rectangle corresponding to the reference row.

[0291] In one possible implementation, the display module 2001 is further configured to, in response to a trigger operation on the first frozen baseline, display a freeze drag control, the freeze drag control being used to indicate that the first frozen baseline can be dragged; and, based on the display duration of the freeze drag control being greater than a duration threshold, display a prompt message, the prompt message being used to indicate that the first frozen baseline can be dragged to adjust the frozen area.

[0292] In one possible implementation, the device further includes:

[0293] A sliding module is used, based on a first frozen baseline as a vertical line, in response to a drag operation on the first frozen baseline, to slide the content area to the right of the first frozen baseline so that the number of columns of the first column displayed to the right of the first frozen baseline is not adjacent to the number of columns of the first column displayed to the left of the first frozen baseline; and based on the first frozen baseline as a horizontal line, in response to a drag operation on the first frozen baseline, to slide the content area below the first frozen baseline so that the number of rows of the first row displayed below the first frozen baseline is not adjacent to the number of rows of the first row displayed below the first frozen baseline.

[0294] In one possible implementation, the spreadsheet also displays a second freeze baseline, which is either a horizontal or vertical line. The second freeze baseline is different from the first freeze baseline. The content area located on one side of the second freeze baseline is the frozen area. The first and second freeze baselines intersect at a reference point.

[0295] Modify module 2002 is also used to change the position of the reference point in the spreadsheet in response to a drag operation on the reference point;

[0296] The adjustment module 2003 is also used to adjust the frozen area to a second area in response to the end of the dragging reference point operation. The second area is determined based on the dragged reference point.

[0297] In one possible implementation, the second region includes the region to the left of the left border line and the region above the top border line of the reference cell; or, the second region includes the region to the left of the left border line and the region above the bottom border line of the reference cell; or, the second region includes the region to the left of the right border line and the region above the top border line of the reference cell; or, the second region includes the region to the left of the right border line and the region above the bottom border line of the reference cell; wherein, the reference cell is the cell where the reference point is located after being dragged.

[0298] In one possible implementation, the device further includes:

[0299] The determination module is used to determine the reference cell where the reference point is located after being dragged; based on the reference cell, determine the first reference line and the second reference line; and determine the content area above the first reference line and the content area to the left of the second reference line as the second region.

[0300] When a frozen area exists in a spreadsheet, adjusting it requires only dragging the first freeze baseline used to indicate the frozen area. There's no need to unfreeze the frozen area and then redefine it. This reduces the complexity of adjusting frozen areas, making the adjustment more flexible and improving efficiency, thus enhancing overall spreadsheet processing efficiency.

[0301] It should be understood that the above-described apparatus is only illustrated by the division of the functional modules described above when implementing its functions. In practical applications, the functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above. In addition, the apparatus and method embodiments provided in the above embodiments belong to the same concept, and their specific implementation process can be found in the method embodiments, which will not be repeated here.

[0302] Figure 21 This illustration shows a structural block diagram of a terminal device 2100 provided in an exemplary embodiment of this application. The terminal device 2100 can be any electronic device product capable of human-computer interaction with a user through one or more methods such as a keyboard, touchpad, remote control, voice interaction, or handwriting device. Examples include PCs (Personal Computers), mobile phones, smartphones, PDAs (Personal Digital Assistants), wearable devices, PPCs (Pocket PCs), tablet computers, smart car systems, smart TVs, smart speakers, and smartwatches.

[0303] Typically, terminal device 2100 includes a processor 2101 and a memory 2102.

[0304] Processor 2101 may include one or more processing cores, such as a quad-core processor, an octa-core processor, etc. Processor 2101 may be implemented using at least one hardware form selected from DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). Processor 2101 may also include a main processor and a coprocessor. The main processor, also known as a CPU (Central Processing Unit), is used to process data in the wake-up state; the coprocessor is a low-power processor used to process data in the standby state. In some embodiments, processor 2101 may integrate a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content required to be displayed on the screen. In some embodiments, processor 2101 may also include an AI (Artificial Intelligence) processor, which is used to handle computational operations related to machine learning.

[0305] The memory 2102 may include one or more computer-readable storage media, which may be non-transitory. The memory 2102 may also include high-speed random access memory and non-volatile memory, such as one or more disk storage devices or flash memory devices. In some embodiments, the non-transitory computer-readable storage media in the memory 2102 are used to store at least one instruction, which is executed by the processor 2101 to implement the spreadsheet processing method provided in the method embodiments of this application.

[0306] In some embodiments, the terminal device 2100 may also optionally include a peripheral device interface 2103 and at least one peripheral device. The processor 2101, memory 2102, and peripheral device interface 2103 can be connected via a bus or signal line. Each peripheral device can be connected to the peripheral device interface 2103 via a bus, signal line, or circuit board. Specifically, the peripheral device includes at least one of the following: radio frequency circuitry 2104, display screen 2105, camera assembly 2106, audio circuitry 2107, and power supply 2108.

[0307] Peripheral device interface 2103 can be used to connect at least one I / O (Input / Output) related peripheral device to processor 2101 and memory 2102. In some embodiments, processor 2101, memory 2102 and peripheral device interface 2103 are integrated on the same chip or circuit board; in some other embodiments, any one or two of processor 2101, memory 2102 and peripheral device interface 2103 can be implemented on separate chips or circuit boards, which is not limited in this embodiment.

[0308] The radio frequency (RF) circuit 2104 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The RF circuit 2104 communicates with communication networks and other communication devices via electromagnetic signals. The RF circuit 2104 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals back into electrical signals. Optionally, the RF circuit 2104 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, etc. The RF circuit 2104 can communicate with other terminal devices through at least one wireless communication protocol. This wireless communication protocol includes, but is not limited to: the World Wide Web, metropolitan area networks, intranets, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and / or WiFi (Wireless Fidelity) networks. In some embodiments, the RF circuit 2104 may also include circuitry related to NFC (Near Field Communication), which is not limited in this application.

[0309] Display screen 2105 is used to display a UI (User Interface). This UI may include graphics, text, icons, videos, and any combination thereof. When display screen 2105 is a touch display screen, it also has the ability to collect touch signals on or above its surface. These touch signals can be input as control signals to processor 2101 for processing. In this case, display screen 2105 can also be used to provide virtual buttons and / or a virtual keyboard, also known as soft buttons and / or a soft keyboard. In some embodiments, there may be one display screen 2105, disposed on the front panel of terminal device 2100; in other embodiments, there may be at least two display screens, disposed on different surfaces of terminal device 2100 or in a folded design; in still other embodiments, display screen 2105 may be a flexible display screen, disposed on a curved or folded surface of terminal device 2100. Furthermore, display screen 2105 may be configured as a non-rectangular, irregular shape, i.e., a non-rectangular screen. The display screen 2105 can be made of materials such as LCD (Liquid Crystal Display) and OLED (Organic Light-Emitting Diode).

[0310] The camera assembly 2106 is used to acquire images or videos. Optionally, the camera assembly 2106 includes a front-facing camera and a rear-facing camera. Typically, the front-facing camera is located on the front panel of the terminal device 2100, and the rear-facing camera is located on the back of the terminal device 2100. In some embodiments, there are at least two rear-facing cameras, which are any one of a main camera, a depth-sensing camera, a wide-angle camera, and a telephoto camera, to achieve background blurring by fusion of the main camera and the depth-sensing camera, panoramic shooting by fusion of the main camera and the wide-angle camera, VR (Virtual Reality) shooting, or other fusion shooting functions. In some embodiments, the camera assembly 2106 may also include a flash. The flash can be a single-color temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm light flash and a cool light flash, which can be used for light compensation at different color temperatures.

[0311] The audio circuit 2107 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, converting the sound waves into electrical signals that are input to the processor 2101 for processing, or input to the radio frequency circuit 2104 for voice communication. For stereo sound acquisition or noise reduction purposes, multiple microphones may be used, each located at a different part of the terminal device 2100. The microphone may also be an array microphone or an omnidirectional microphone. The speaker is used to convert electrical signals from the processor 2101 or the radio frequency circuit 2104 into sound waves. The speaker may be a conventional diaphragm speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can convert electrical signals not only into audible sound waves but also into inaudible sound waves for purposes such as distance measurement. In some embodiments, the audio circuit 2107 may also include a headphone jack.

[0312] Power supply 2108 is used to supply power to the various components in terminal device 2100. Power supply 2108 can be AC ​​power, DC power, a disposable battery, or a rechargeable battery. When power supply 2108 includes a rechargeable battery, the rechargeable battery can be a wired rechargeable battery or a wireless rechargeable battery. A wired rechargeable battery is a battery that is charged via a wired line, and a wireless rechargeable battery is a battery that is charged via a wireless coil. The rechargeable battery can also be used to support fast charging technology.

[0313] In some embodiments, the terminal device 2100 further includes one or more sensors 2109. The one or more sensors 2109 include, but are not limited to: an acceleration sensor 2110, a gyroscope sensor 2111, a pressure sensor 2112, an optical sensor 2113, and a proximity sensor 2114.

[0314] Accelerometer 2110 can detect the magnitude of acceleration along the three coordinate axes of a coordinate system established by terminal device 2100. For example, accelerometer 2110 can be used to detect the components of gravitational acceleration along the three coordinate axes. Processor 2101 can control display screen 2105 to display the user interface in either a landscape or portrait view based on the gravitational acceleration signal acquired by accelerometer 2110. Accelerometer 2110 can also be used for games or for acquiring user motion data.

[0315] The gyroscope sensor 2111 can detect the orientation and rotation angle of the terminal device 2100. The gyroscope sensor 2111 can work in conjunction with the accelerometer sensor 2110 to collect the user's 3D movements on the terminal device 2100. Based on the data collected by the gyroscope sensor 2111, the processor 2101 can perform the following functions: motion sensing (e.g., changing the UI based on the user's tilt), image stabilization during shooting, game control, and inertial navigation.

[0316] The pressure sensor 2112 can be disposed on the side bezel of the terminal device 2100 and / or on the lower layer of the display screen 2105. When the pressure sensor 2112 is disposed on the side bezel of the terminal device 2100, it can detect the user's grip signal on the terminal device 2100, and the processor 2101 can perform left / right hand recognition or quick operation based on the grip signal collected by the pressure sensor 2112. When the pressure sensor 2112 is disposed on the lower layer of the display screen 2105, the processor 2101 can control the operable controls on the UI interface based on the user's pressure operation on the display screen 2105. The operable controls include at least one of button controls, scroll bar controls, icon controls, and menu controls.

[0317] An optical sensor 2113 is used to collect ambient light intensity. In one embodiment, the processor 2101 can control the display brightness of the display screen 2105 based on the ambient light intensity collected by the optical sensor 2113. Specifically, when the ambient light intensity is high, the display brightness of the display screen 2105 is increased; when the ambient light intensity is low, the display brightness of the display screen 2105 is decreased. In another embodiment, the processor 2101 can also dynamically adjust the shooting parameters of the camera assembly 2106 based on the ambient light intensity collected by the optical sensor 2113.

[0318] The proximity sensor 2114, also known as a distance sensor, is typically located on the front panel of the terminal device 2100. The proximity sensor 2114 is used to detect the distance between the user and the front of the terminal device 2100. In one embodiment, when the proximity sensor 2114 detects that the distance between the user and the front of the terminal device 2100 is gradually decreasing, the processor 2101 controls the display screen 2105 to switch from a screen-on state to a screen-off state; when the proximity sensor 2114 detects that the distance between the user and the front of the terminal device 2100 is gradually increasing, the processor 2101 controls the display screen 2105 to switch from a screen-off state to a screen-on state.

[0319] Those skilled in the art will understand that Figure 21 The structure shown does not constitute a limitation on the terminal device 2100, and may include more or fewer components than shown, or combine certain components, or use different component arrangements.

[0320] Figure 22This is a schematic diagram of the server structure provided in the embodiments of this application. The server 2200 can vary considerably due to different configurations or performance. It may include one or more Central Processing Units (CPUs) 2201 and one or more memories 2202. The one or more memories 2202 store at least one line of program code, which is loaded and executed by the one or more processors 2201 to implement the spreadsheet processing methods provided in the various method embodiments described above. Of course, the server 2200 may also have wired or wireless network interfaces, a keyboard, and input / output interfaces for input and output. The server 2200 may also include other components for implementing device functions, which will not be elaborated here.

[0321] In an exemplary embodiment, a computer-readable storage medium is also provided, which stores at least one piece of program code that is loaded and executed by a processor to enable a computer to implement any of the spreadsheet processing methods described above.

[0322] Optionally, the aforementioned computer-readable storage medium may be a read-only memory (ROM), a random access memory (RAM), a compact disc read-only memory (CD-ROM), magnetic tape, floppy disk, and optical data storage device, etc.

[0323] In an exemplary embodiment, a computer program or computer program product is also provided, which stores at least one computer instruction that is loaded and executed by a processor to enable the computer to implement any of the above-described spreadsheet processing methods.

[0324] It should be noted that all information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.), and signals involved in this application have been authorized by the user or fully authorized by all parties, and the collection, use, and processing of related data must comply with the relevant laws, regulations, and standards of the relevant countries and regions. For example, the spreadsheets involved in this application were obtained with full authorization.

[0325] It should be understood that "multiple" as used in this article refers to two or more. "And / or" describes the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, or B alone. The character " / " generally indicates that the preceding and following related objects have an "or" relationship.

[0326] The above description is merely an exemplary embodiment of this application and is not intended to limit this application. Any modifications, equivalent substitutions, improvements, etc., made within the principles of this application should be included within the protection scope of this application.

Claims

1. A method for processing spreadsheets, characterized in that, The method includes: A spreadsheet is displayed, which has a first freeze baseline. The first freeze baseline is either a horizontal line or a vertical line. The content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet. In response to a drag operation on the first frozen baseline, the position of the first frozen baseline in the spreadsheet is changed; In response to the end of the dragging of the first freeze baseline, the frozen area is adjusted to a first area, which is determined based on the dragged first freeze baseline.

2. The method according to claim 1, characterized in that, The first region includes a first side region located on the first border line of the reference strip region; or, The first region includes a first side region located on the second border line of the reference strip region; Wherein, the reference bar area is the area where the first frozen baseline is located after being dragged, and the reference bar area is a reference column or reference column; based on the reference bar area being a reference column, the first border line is the left border line, the second border line is the right border line, and the first side is the left side; based on the reference bar area being a reference row, the first border line is the top border line, the second border line is the bottom border line, and the first side is the top side.

3. The method according to claim 1, characterized in that, The first freeze baseline is a vertical line; the first region includes the region to the left of the left border line of the reference column; or, The first region includes the region to the left of the right frame of the reference column; The reference column is the column where the first frozen baseline is located after being dragged.

4. The method according to claim 1, characterized in that, The first freeze baseline is a horizontal line; the first region includes the region above the upper border line of the reference row; or, The first region includes the region located above the lower border line of the reference row; The reference line is the row where the first frozen baseline is located after being dragged.

5. The method according to claim 1, characterized in that, The method further includes: Determine the reference line based on the first frozen baseline after it has been dragged; The content area located on one side of the reference line is defined as the first area.

6. The method according to claim 5, characterized in that, The step of determining the reference line based on the first frozen baseline after being dragged includes: Based on the fact that the first frozen baseline is a vertical line, determine the reference column where the dragged first frozen baseline is located; The reference line is determined based on the reference column; The step of defining the content area located on one side of the reference line as the first area includes: The content area located to the left of the reference line is defined as the first area.

7. The method according to claim 6, characterized in that, Determining the reference line based on the reference column includes: The left border line of the reference column is defined as the reference line; or, The right border of the reference column is defined as the reference line; or, If the first frozen baseline after being dragged is located to the left of the center line of the reference column, the left border line of the reference column is determined as the reference line; if the first frozen baseline after being dragged is located to the right of the center line of the reference column, the right border line of the reference column is determined as the reference line; or, If the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is lower than the area ratio threshold, the left border line of the reference column is determined as the reference line; if the ratio between the area of ​​the first rectangle and the area of ​​the second rectangle is higher than the area ratio threshold, the right border line of the reference column is determined as the reference line. The first rectangle is determined based on the first frozen baseline after being dragged, the left border line of the reference column, the top border line of the reference column, and the bottom border line of the reference column, and the second rectangle is the rectangle corresponding to the reference column.

8. The method according to claim 7, characterized in that, Determining the left border line of the reference column as the reference line includes: Determine the column number before the left border line of the reference column; If the number of columns before the left border line of the reference column is not higher than the frozen column number threshold, the left border line of the reference column is determined as the reference line.

9. The method according to claim 8, characterized in that, The method further includes: If the number of columns before the left border of the reference column is higher than the frozen column number threshold, the right border of the column in the spreadsheet whose number of columns is equal to the frozen column number threshold is determined as the reference line.

10. The method according to claim 5, characterized in that, The step of determining the reference line based on the first frozen baseline after being dragged includes: Based on the fact that the first frozen baseline is a horizontal line, determine the reference row where the dragged first frozen baseline is located. The reference line is determined based on the reference row; The step of defining the content area located on one side of the reference line as the first area includes: The content area located above the reference line is defined as the first area.

11. The method according to claim 10, characterized in that, Determining the reference line based on the reference row includes: The upper border line of the reference row is defined as the reference line; or, The lower border line of the reference row is defined as the reference line; or, If the first frozen baseline after being dragged is located above the center line of the reference row, the top border line of the reference row is determined as the reference line; if the first frozen baseline after being dragged is located below the center line of the reference row, the bottom border line of the reference row is determined as the reference line; or, If the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is lower than the area ratio threshold, the upper border line of the reference row is determined as the reference line; if the ratio between the area of ​​the third rectangle and the area of ​​the fourth rectangle is higher than the area ratio threshold, the lower border line of the reference row is determined as the reference line. The third rectangle is determined based on the first frozen baseline after being dragged, the top border line of the reference row, the left border line of the reference row, and the right border line of the reference row, and the fourth rectangle is the rectangle corresponding to the reference row.

12. The method according to any one of claims 1 to 11, characterized in that, After displaying the spreadsheet, the method further includes: In response to a trigger operation on the first frozen baseline, a freeze drag control is displayed, the freeze drag control being used to indicate that the first frozen baseline can be dragged; If the display duration of the freeze drag control exceeds a duration threshold, a prompt message is displayed, which instructs the user to drag the first freeze baseline to adjust the freeze area.

13. The method according to any one of claims 1 to 11, characterized in that, The method further includes: Since the first frozen baseline is a vertical line, in response to a drag operation on the first frozen baseline, if the number of columns of the first column displayed to the right of the first frozen baseline is not adjacent to the number of columns of the first column displayed to the left of the first frozen baseline, the content area to the right of the first frozen baseline is slid so that the number of columns of the first column displayed to the right of the first frozen baseline is adjacent to the number of columns of the first column displayed to the left of the first frozen baseline. Since the first freeze baseline is a horizontal line, in response to a drag operation on the first freeze baseline, if the number of rows of the first row displayed above the first freeze baseline is not adjacent to the number of rows of the first row displayed below the first freeze baseline, the content area below the first freeze baseline is slid so that the number of rows of the first row displayed below the first freeze baseline is adjacent to the number of rows of the first row displayed above the first freeze baseline.

14. The method according to any one of claims 1 to 11, characterized in that, The spreadsheet also displays a second freeze baseline, which is either a horizontal or vertical line. The second freeze baseline differs from the first freeze baseline. The content area located to one side of the second freeze baseline is a frozen area. The first and second freeze baselines intersect at a reference point. The method further includes: In response to a drag operation on the reference point, the position of the reference point in the spreadsheet is changed; In response to the end of the dragging of the reference point, the frozen area is adjusted to a second area, which is determined based on the dragged reference point.

15. The method according to claim 14, characterized in that, The second region includes the area to the left of the left border line of the reference cell and the area above the top border line; or, The second region includes the area to the left of the left border line and the area above the bottom border line of the reference cell; or, The second region includes the area to the left of the right border line and the area above the top border line of the reference cell; or, The second region includes the area to the left of the right border line and the area above the bottom border line of the reference cell; The reference cell is the cell where the reference point is located after it has been dragged.

16. The method according to claim 14, characterized in that, The method further includes: Determine the reference cell where the dragged reference point is located; Based on the reference cell, determine the first reference line and the second reference line; The content area located above the first reference line and the content area located to the left of the second reference line are defined as the second region.

17. A spreadsheet processing apparatus, characterized in that, The device includes: The display module is used to display a spreadsheet, which displays a first freeze baseline. The first freeze baseline is a horizontal line or a vertical line, and the content area located on one side of the first freeze baseline is the frozen area of ​​the spreadsheet. A change module is configured to change the position of the first frozen baseline in the spreadsheet in response to a drag operation on the first frozen baseline; An adjustment module is used to adjust the frozen area to a first area in response to the end of the dragging of the first frozen baseline, the first area being determined based on the dragged first frozen baseline.

18. A computer device, characterized in that, The computer device includes a processor and a memory, the memory storing at least one piece of program code, the at least one piece of program code being loaded and executed by the processor to enable the computer device to implement the spreadsheet processing method as described in any one of claims 1 to 16.

19. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores at least one piece of program code, which is loaded and executed by a processor to enable the computer to implement the spreadsheet processing method as described in any one of claims 1 to 16.

20. A computer program product, characterized in that, The computer program product stores at least one computer instruction, which is loaded and executed by a processor to enable the computer to implement the spreadsheet processing method as described in any one of claims 1 to 16.

Images