CN105988655B - A kind of spreadsheet line column region method of adjustment and device - Google Patents

Abstract

The embodiment of the present invention discloses a method and device for adjusting the row and column areas of an electronic form. A method for adjusting the row and column areas of an electronic form is used to add or delete rows and columns of an electronic form. adjustment trigger operation; determine the adjustment object type, adjustment action type, and adjustment quantity; adjust the row and column area of the current spreadsheet according to the determination result; wherein, determining the adjustment object type includes: determining the current need to adjust the number of rows, or the need to Adjust the number of columns; determining the type of adjustment action includes: determining that an add operation or a delete operation needs to be performed; determining the adjustment amount includes: displaying an adjustment amount query interface; according to the user input or selection in the adjustment amount query interface to determine the adjustment amount. Applying the technical solutions provided by the embodiments of the present invention is convenient for users to use and can improve user experience.

Description

A method and device for adjusting row and column areas of an electronic form

technical field

The invention relates to the technical field of office software, in particular to a method and device for adjusting row and column areas of an electronic form.

Background technique

Spreadsheet software is one of the commonly used office software. Users can use spreadsheet software to create spreadsheets in various formats for information recording and data statistics. When the number of rows or columns of the spreadsheet does not meet the current needs of the user, the user needs to adjust the row and column area of the spreadsheet, adding or deleting the corresponding number of rows or columns, such as adding or deleting the corresponding row, or add or delete columns between or at the end of the spreadsheet.

An existing row and column area adjustment method is to set operation buttons at the end of the rows and columns of the electronic form, such as button 110 and button 120 shown in Figure 1, and the user drags down, up, left or right to operate button to complete the corresponding operation of adding or deleting rows and columns, and the number of rows or columns to be added is determined according to the multiple relationship between the dragging distance and the set reference value.

This method has certain disadvantages. First, the user easily loses control of the operation button during the process of dragging the operation button; second, when the user needs to add rows and columns, it is impossible to accurately determine the The multiple relationship between the current dragging distance and the set reference value makes it impossible to determine whether the current dragging distance can meet the requirements of the number of rows or columns you want to increase. Therefore, using this method to add and delete rows and columns of the electronic form may require the user to perform repeated adjustments many times to complete the corresponding operations of adding and deleting rows and columns, which is inconvenient for users and has poor user experience.

Contents of the invention

The purpose of the embodiments of the present invention is to provide a method and device for adjusting row and column areas of an electronic form, so as to facilitate the use of users and improve user experience. The technical scheme is as follows:

A method for adjusting the row and column area of an electronic form, which is used to add or delete the row and column of the electronic form, the method comprising:

Receive the user's adjustment trigger operation for the row and column areas of the current spreadsheet;

Determine the adjustment object type, adjustment action type, and adjustment quantity;

Adjust the row and column area of the current spreadsheet according to the determination result;

in,

The determining the adjustment object type includes: determining that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted;

The determination of the adjustment action type includes: determining that an add operation or a delete operation is currently required;

The determining the adjustment amount includes: displaying an adjustment amount inquiry interface; and determining the adjustment amount according to a value input or selected by the user on the adjustment amount inquiry interface.

In a specific embodiment of the present invention,

The receiving user's adjustment trigger operation for the row and column area of the current spreadsheet includes:

Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons;

Accordingly, the adjustment object type is determined through the following steps:

According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined.

In a specific implementation manner of the present invention, the adjustment action type is determined through the following steps:

displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user;

An adjustment action type is determined according to the user's selection among the adjustment action type options.

In a specific embodiment of the present invention,

The receiving user's adjustment trigger operation for the row and column area of the current spreadsheet includes:

Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons;

Correspondingly, determine the adjustment object type and determine the adjustment action type through the following steps:

According to the corresponding relationship between the second type of adjustment button clicked by the user and the rows and columns of the current electronic form, determine the type of adjustment object;

determining the number of times the user clicks on the second type of adjustment button according to the user's click operation;

The adjustment action type is determined according to the preset relationship between the number of clicks and the adjustment action type.

In a specific embodiment of the present invention, the type of adjustment action and the amount of adjustment are determined through the following steps:

Displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type;

According to the user's selection on the adjustment amount selection interface, the type of adjustment action and the adjustment amount are determined.

In a specific implementation manner of the present invention, in the case where the determined adjustment action type is an increase operation, the adjustment of the row and column area of the current spreadsheet according to the determination result includes:

According to the determined adjustment object type and adjustment quantity, add a corresponding number of rows or increase a corresponding number of columns;

Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row;

The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column.

An electronic form row and column area adjustment device is used to realize the addition or deletion of the electronic form row and column, and the device includes:

The receiving module is used to receive the user's adjustment trigger operation for the row and column areas of the current spreadsheet;

A determining module, configured to determine the adjustment object type, adjustment action type, and adjustment quantity;

An adjustment module, configured to adjust the row and column areas of the current spreadsheet according to the determination result of the determination module;

in,

The determining module is specifically used to: determine that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted;

The determination module is specifically used to: determine that an add operation or a delete operation is currently required;

The determining module is specifically configured to: display an adjustment quantity inquiry interface; and determine the adjustment quantity according to the value input or selected by the user on the adjustment quantity inquiry interface.

In a specific embodiment of the present invention,

The receiving module is specifically used for:

Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons;

Correspondingly, the determination module is specifically used for:

According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined.

In a specific implementation manner of the present invention, the determination module is specifically used for:

displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user;

An adjustment action type is determined according to the user's selection among the adjustment action type options.

In a specific embodiment of the present invention,

The receiving module is specifically used for:

Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons;

Correspondingly, the determination module is specifically used for:

According to the corresponding relationship between the second type of adjustment button clicked by the user and the rows and columns of the current electronic form, determine the type of adjustment object;

determining the number of times the user clicks on the second type of adjustment button according to the user's click operation;

The adjustment action type is determined according to the preset relationship between the number of clicks and the adjustment action type.

In a specific implementation manner of the present invention, the determination module is specifically used for:

Displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type;

According to the user's selection on the adjustment amount selection interface, the type of adjustment action and the adjustment amount are determined.

In a specific implementation manner of the present invention, the adjustment module is specifically used for:

When the determined adjustment action type is an increase operation, according to the determined adjustment object type and adjustment quantity, increase a corresponding number of rows or increase a corresponding number of columns;

Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row;

The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column.

Applying the technical solution provided by the embodiment of the present invention, when the user needs to adjust the row and column areas of the electronic form, the user is shown the adjustment quantity inquiry interface, and the user enters or selects a corresponding value on the adjustment quantity inquiry interface to determine the adjustment. Quantity, the determined adjustment quantity matches the actual needs of the user, and the corresponding addition and deletion operations can be completed without repeated adjustment by the user, which is convenient for the user and can improve the user experience.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.

Fig. 1 shows a schematic diagram of an electronic form in the background technology;

Fig. 2 shows the implementation flowchart of the method for adjusting the row and column regions of the electronic form provided by the embodiment of the present invention;

FIG. 3a is a schematic diagram of an electronic form adjustment button provided by an embodiment of the present invention;

FIG. 3b is another schematic diagram of the electronic form adjustment button provided by the embodiment of the present invention;

FIG. 4 is a schematic diagram of an adjustment quantity selection interface provided by an embodiment of the present invention;

FIG. 5 is another schematic diagram of the electronic form adjustment button provided by the embodiment of the present invention;

FIG. 6 is a schematic structural diagram of an apparatus for adjusting row and column areas of an electronic form provided by an embodiment of the present invention.

Detailed ways

In order to enable those skilled in the art to better understand the technical solutions in the embodiments of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

Referring to FIG. 2 , it is an implementation flowchart of a method for adjusting row and column regions of an electronic form provided by an embodiment of the present invention. The method may include the following steps:

S210: Receive a user's adjustment trigger operation for the row and column areas of the current spreadsheet;

In practical applications, when the number of rows or columns of the current spreadsheet does not meet the current needs of the user, it is necessary to adjust the row and column area of the current spreadsheet, such as adding a certain number of rows, adding a certain number of columns, Delete a certain number of rows, or delete a certain number of columns. When the user has such an adjustment requirement, a corresponding adjustment command needs to be issued to trigger a trigger operation on the row and column areas of the current spreadsheet. In practical applications, corresponding adjustment buttons or adjustment options can be set in the electronic form and provided to the user, so that the user operates the adjustment button or adjustment option to trigger an adjustment operation on the row and column areas of the electronic form. For example, an adjustment button may be set in the row and column area of the spreadsheet or an adjustment option may be set in the menu of the spreadsheet software, and the user may click the adjustment button or select a corresponding adjustment option to be deemed to have issued an adjustment instruction.

After the user's adjustment trigger operation on the row and column areas of the current electronic form is received, step S220 may continue to be executed.

S220: Determine the adjustment object type, the adjustment action type, and the adjustment quantity;

Wherein, the determining the adjustment object type includes: determining that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted;

The determination of the adjustment action type includes: determining that an add operation or a delete operation is currently required;

The determining the adjustment amount includes: displaying an adjustment amount inquiry interface; and determining the adjustment amount according to a value input or selected by the user on the adjustment amount inquiry interface.

It can be understood that before adjusting the row and column area of the spreadsheet, it is necessary to determine the type of adjustment object, the type of adjustment action, and the number of adjustments, that is, determine how many rows or columns need to be added, or how many rows or columns need to be deleted .

When determining the adjustment quantity, specific value options can be provided in the displayed adjustment quantity query interface, and the adjustment quantity can be determined according to the value selected by the user; an adjustment quantity input box can also be provided, and the user can enter the corresponding value according to the actual demand, and according to the user input The value of determines the amount of adjustment. The display form of the specific value options and the input box for adjusting the quantity can be designed according to the characteristics of the terminal operating system. For example, in a smart terminal, the user can select the value that meets the actual needs by swiping each option. In a computer terminal, you can use the Set the scroll bar to allow the user to scroll through the options to select a value that meets actual needs. The present invention is not limited thereto.

It can be understood that the adjustment object type, adjustment action type, and adjustment quantity may be determined separately or simultaneously.

In a specific implementation manner of the present invention, step S210 receives the user's adjustment trigger operation for the row and column area of the current electronic form, which may include the following steps:

Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons;

Correspondingly, the adjustment object type can be determined through the following steps:

According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined.

In practical applications, there may be multiple first-type adjustment buttons corresponding to different rows and columns of the spreadsheet. The position of each first-type adjustment button in the spreadsheet can be preset, such as on the axis of each row of the spreadsheet, on the axis of each column, or between rows and columns of the spreadsheet, specifically Referring to the positions shown in Fig. 3a and Fig. 3b, the button 310 and the button 330 correspond to the first column respectively, and the button 320 and the button 340 respectively correspond to the third row, and the other buttons are similar.

It can be understood that no matter which position of the first-type adjustment button is preset in the electronic form, different first-type adjustment buttons correspond to different rows and columns of the electronic form. When the user clicks a first-type adjustment button, it can be regarded as an adjustment instruction. According to the corresponding relationship between the first-type adjustment button clicked by the user and the current spreadsheet row and column, the type of adjustment object can be determined, that is, the user wants to be determined. Do you make adjustments to the number of rows or do you want to make adjustments to the number of columns. For example, if the user clicks the button 310 shown in FIG. 3a, it can be determined that the number of columns needs to be adjusted currently.

In another specific implementation manner of the present invention, the adjustment action type may be determined through the following steps:

Step 1: displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user;

Step 2: Determine the adjustment action type according to the user's selection in the adjustment action type options.

It is understandable that the first type of adjustment button can have the function of adding and deleting operations at the same time. When the user clicks on a certain first type of adjustment button, the adjustment action type option corresponding to the first type of adjustment button is displayed. Specifically, On the basis of the first type of adjustment button, it can be expanded into adding an operation button and deleting an operation button, so that the user can further select an option of an adjustment action type. When the user's actual requirement is to add a row or column, the user can click the Add operation option, or when the user's actual requirement is to delete a row or column, the user can click the Delete operation option. The adjustment action type is determined according to the user's selection of the adjustment action type option.

In a specific implementation manner of the present invention, step S210 receives the user's adjustment trigger operation for the row and column area of the current electronic form, which may include the following steps:

Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons;

Correspondingly, the adjustment object type and the adjustment action type can be determined through the following steps:

The first step: determine the type of adjustment object according to the correspondence between the second type of adjustment button clicked by the user and the ranks and columns of the current spreadsheet;

The second step: according to the user's click operation, determine the number of times the user clicks on the second type of adjustment button;

Step 3: Determine the type of adjustment action according to the preset relationship between the number of clicks and the type of adjustment action.

Similar to the first type of adjustment button, there can be multiple second type of adjustment buttons, corresponding to different rows and columns of the spreadsheet. The position of each second-type adjustment button in the spreadsheet can be preset, such as on the axis of each row of the spreadsheet, on the axis of each column, or between rows and columns of the spreadsheet, specifically Referring to the positions shown in Fig. 3a and Fig. 3b, the button 310 and the button 330 correspond to the first column respectively, and the button 320 and the button 340 respectively correspond to the third row, and the other buttons are similar.

It can be understood that no matter which position of the second-type adjustment button is preset in the electronic form, different second-type adjustment buttons correspond to different rows and columns of the electronic form. When the user clicks a second-type adjustment button, it can be regarded as an adjustment instruction. According to the corresponding relationship between the second-type adjustment button clicked by the user and the current spreadsheet row and column, the type of adjustment object can be determined, that is, the user wants to be determined. Do you make adjustments to the number of rows or do you want to make adjustments to the number of columns. For example, if the user clicks the button 310 shown in FIG. 3a, it can be determined that the number of columns needs to be adjusted currently.

The second type of adjustment button can have the function of adding and deleting operations at the same time. According to the user's click operation, determine the number of times the user clicks on the second type of adjustment button, and determine the type of adjustment action according to the relationship between the preset number of clicks and the type of adjustment action. It should be noted that the preset relationship between the number of clicks and the type of adjustment action may be set by default by the system, or may be set by the user according to personal habits. The present invention is not limited thereto. For example, the setting is: the user clicks the second type of adjustment button, and when the user clicks once, it corresponds to an increase operation, and when it is clicked twice, it corresponds to a delete operation.

It should be noted that the second step and the third step need to be executed sequentially, but there is no restriction on the execution order of the first step and these two steps.

In another specific embodiment of the present invention, the type of adjustment action and the amount of adjustment can be determined through the following steps:

Step 1: displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type;

Step 2: Determine the adjustment action type and the adjustment amount according to the user's selection on the adjustment amount selection interface.

After the user's adjustment trigger operation on the row and column area of the current spreadsheet is received in step S210, an adjustment quantity selection interface may be displayed, which includes at least one option, and each option provides the user with a combination of an adjustment quantity and an adjustment action type. Referring to FIG. 4, after the user clicks the button 330 shown in FIG. 3b, an adjustment amount selection interface 410 is displayed. After the user makes a selection according to actual needs, the type of adjustment action and the adjustment amount can be determined. For example, the user selects the option "+ 2", indicating that the type of adjustment action to be performed by the user is an increase operation, and the adjustment amount is 2, because the button 330 corresponds to the first column, so it can be determined that the type of adjustment object is the number of columns, that is, adding 2 columns to the column of the current spreadsheet.

S230: Adjust the row and column areas of the current electronic form according to the determination result.

After the adjustment object type, adjustment action type, and adjustment amount are determined separately or simultaneously in step S220, the row and column areas of the current electronic form are adjusted according to the determined results.

It can be seen from the above description that different first-type adjustment buttons or second-type adjustment buttons correspond to different rows and columns of the spreadsheet. For the convenience of description, in the description of this step, the first-type adjustment buttons and the second-type adjustment buttons are Class adjustment buttons are collectively referred to as adjustment buttons, and different adjustment buttons correspond to different rows and columns of the spreadsheet. When the user clicks an adjustment button, it can correspond to a specific row or column. In practical applications, the row or column may be added or deleted based on the row or column corresponding to the adjustment button clicked by the user. The positions of adding rows, adding columns, deleting rows and deleting columns can be preset by the system, and setting items can also be provided for users to set according to personal habits. For example, according to the button 320 shown in Figure 3a clicked by the user, it can be determined that the number of rows needs to be adjusted currently, and it is further determined that the adjustment action type is an increase operation, and the adjustment number is 3, then the third row corresponding to the button 320 can be used as a reference , add 3 lines above the 3rd line, or add 3 lines below the 3rd line; if the further determined adjustment action type is a delete operation and the number of adjustments is 2, then the 3rd line corresponding to the button 320 can be used as a benchmark, Either delete lines 2 and 3, or delete lines 1 and 2.

It should be noted that different adjustment position rules may be set for different positions of the adjustment buttons.

In practical applications, users frequently add or delete operations at the end of rows and columns in the spreadsheet. In this case, you can only set the adjustment button at the end of the row or column, as shown in Figure 5. When the user When there is an adjustment requirement for the row and column area of the current spreadsheet, directly add the corresponding number of rows at the end of the row, or add the corresponding number of columns at the end of the column, or delete the corresponding number of rows at the end of the row, or delete the corresponding number of rows at the end of the column. List.

In a specific implementation manner of the present invention, when the determined adjustment action type is an increase operation, step S230 may include the following steps:

According to the determined adjustment object type and adjustment quantity, add a corresponding number of rows or increase a corresponding number of columns;

Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row;

The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column.

It is understandable that the user will set various formats according to the actual needs of the electronic form created by the electronic form software, and may wish to keep the format of the new row or column consistent with the original row or column format of the electronic form. In this way, users can save time by avoiding format editing of new rows or columns. The format of the newly added row may be determined according to the adjacent row format of the newly added row, and the format of the newly added column may be determined according to the adjacent column format of the newly added column.

For example, according to the determination results of the adjustment object type, adjustment action type, and adjustment quantity in step S220, if the newly added row is between the second row and the third row of the current spreadsheet, then the format of the newly added row can be the same as that of the second row. The same format, or the same format as line 3. Specifically, it may be determined according to preset rules.

Applying the technical solution provided by the embodiment of the present invention, when the user needs to adjust the row and column areas of the electronic form, the user is shown the adjustment quantity inquiry interface, and the user enters or selects a corresponding value on the adjustment quantity inquiry interface to determine the adjustment. Quantity, the determined adjustment quantity matches the actual needs of the user, and the corresponding addition and deletion operations can be completed without repeated adjustment by the user, which is convenient for the user and can improve the user experience.

Corresponding to the above method embodiment, the embodiment of the present invention also provides a device for adjusting the row and column area of a spreadsheet, as shown in FIG. 6 , the device is used to add or delete rows and columns of a spreadsheet, and may include the following modules:

The receiving module 510 is used to receive the user's adjustment trigger operation for the row and column area of the current spreadsheet;

A determining module 520, configured to determine the type of adjustment object, the type of adjustment action, and the amount of adjustment;

An adjustment module 530, configured to adjust the current spreadsheet row and column area according to the determination result of the determination module;

in,

The determining module 520 is specifically configured to: determine that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted;

The determination module 520 is specifically configured to: determine that an add operation or a delete operation is currently required;

The determining module 520 is specifically configured to: display an adjustment quantity inquiry interface; and determine the adjustment quantity according to the value input or selected by the user on the adjustment quantity inquiry interface.

In a specific implementation manner of the present invention, the receiving module 510 is specifically used for:

Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons;

Correspondingly, the determination module 520 is specifically used for:

According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined.

In a specific implementation manner of the present invention, the determination module 520 is specifically used to:

displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user;

An adjustment action type is determined according to the user's selection among the adjustment action type options.

In a specific implementation manner of the present invention, the receiving module 510 is specifically used for:

Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons;

Correspondingly, the determination module 520 is specifically used for:

According to the corresponding relationship between the second type of adjustment button clicked by the user and the rows and columns of the current electronic form, determine the type of adjustment object;

determining the number of times the user clicks on the second type of adjustment button according to the user's click operation;

The adjustment action type is determined according to the preset relationship between the number of clicks and the adjustment action type.

In a specific implementation manner of the present invention, the determination module 520 is specifically used to:

Displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type;

According to the user's selection on the adjustment amount selection interface, the type of adjustment action and the adjustment amount are determined.

In a specific implementation manner of the present invention, the adjustment module 530 is specifically used for:

When the determined adjustment action type is an increase operation, according to the determined adjustment object type and adjustment quantity, increase a corresponding number of rows or increase a corresponding number of columns;

Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row;

The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column.

Applying the device provided by the embodiment of the present invention, when the user needs to adjust the row and column areas of the electronic form, the adjustment quantity inquiry interface is displayed to the user, and the user inputs or selects a corresponding value on the adjustment quantity inquiry interface to determine the adjustment quantity , the determined number of adjustments matches the actual needs of the user, and the corresponding addition and deletion operations can be completed without repeated adjustments by the user, which is convenient for the user and can improve user experience.

It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that there is a relationship between these entities or operations. There is no such actual relationship or order between them. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of or also include elements inherent in such a process, method, article, or device. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.

Each embodiment in this specification is described in a related manner, the same and similar parts of each embodiment can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, as for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for relevant parts, please refer to part of the description of the method embodiment.

Those of ordinary skill in the art can understand that all or part of the steps in the implementation of the above method can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, referred to herein as Storage media, such as: ROM/RAM, disk, CD, etc.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present invention are included in the protection scope of the present invention.

Claims (10)

1. an electronic form row and column area adjustment method, for realizing the increase or deletion of electronic form row and column, it is characterized in that, described method comprises: Receive the user's adjustment trigger operation for the row and column areas of the current spreadsheet; Determine the adjustment object type, adjustment action type, and adjustment quantity; Adjust the row and column area of the current spreadsheet according to the determination result; in, The determining the adjustment object type includes: determining that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted; The determination of the adjustment action type includes: determining that an add operation or a delete operation is currently required; The determining the adjustment quantity includes: displaying an adjustment quantity inquiry interface; determining the adjustment quantity according to the value input or selected by the user on the adjustment quantity inquiry interface; The receiving user's adjustment trigger operation for the row and column area of the current spreadsheet includes: Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons; Correspondingly, determine the adjustment object type and determine the adjustment action type through the following steps: According to the corresponding relationship between the second type of adjustment button clicked by the user and the rows and columns of the current electronic form, determine the type of adjustment object; determining the number of times the user clicks on the second type of adjustment button according to the user's click operation; The adjustment action type is determined according to the preset relationship between the number of clicks and the adjustment action type. 2. The method of claim 1, wherein, The receiving user's adjustment trigger operation for the row and column area of the current spreadsheet includes: Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons; Accordingly, the adjustment object type is determined through the following steps: According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined. 3. The method according to claim 2, wherein the adjustment action type is determined through the following steps: displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user; An adjustment action type is determined according to the user's selection among the adjustment action type options. 4. The method according to claim 1 or 2, characterized in that the type of adjustment action and the amount of adjustment are determined through the following steps: Displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type; According to the user's selection on the adjustment amount selection interface, the type of adjustment action and the adjustment amount are determined. 5. The method according to claim 1, wherein, in the case where the determined adjustment action type is an increase operation, said adjusting the row and column area of the current spreadsheet according to the determination result comprises: According to the determined adjustment object type and adjustment quantity, add a corresponding number of rows or increase a corresponding number of columns; Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row; The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column. 6. A device for adjusting the row and column area of an electronic form is used to realize the addition or deletion of the rows and columns of an electronic form, and it is characterized in that the device comprises: The receiving module is used to receive the user's adjustment trigger operation for the row and column areas of the current spreadsheet; A determining module, configured to determine the adjustment object type, adjustment action type, and adjustment quantity; An adjustment module, configured to adjust the row and column areas of the current spreadsheet according to the determination result of the determination module; in, The determining module is specifically used to: determine that the number of rows needs to be adjusted currently, or the number of columns needs to be adjusted; The determination module is specifically used to: determine that an add operation or a delete operation is currently required; The determining module is specifically used for: displaying an adjustment quantity inquiry interface; determining the adjustment quantity according to the value input or selected by the user on the adjustment quantity inquiry interface; The receiving module is specifically used for: Receiving the user's click operation on the second type of adjustment button in the row and column area of the current electronic form, where different rows and columns of the current electronic form correspond to different second type of adjustment buttons; Correspondingly, the determination module is specifically used for: According to the corresponding relationship between the second type of adjustment button clicked by the user and the rows and columns of the current electronic form, determine the type of adjustment object; determining the number of times the user clicks on the second type of adjustment button according to the user's click operation; The adjustment action type is determined according to the preset relationship between the number of clicks and the adjustment action type. 7. The device of claim 6, wherein: The receiving module is specifically used for: Receive the user's click operation on the first type of adjustment button in the row and column area of the current electronic form, and the different rows and columns of the current electronic form correspond to different first type of adjustment buttons; Correspondingly, the determination module is specifically used for: According to the corresponding relationship between the first type of adjustment button clicked by the user and the rows and columns of the current electronic form, the type of the adjustment object is determined. 8. The device according to claim 7, wherein the determining module is specifically used for: displaying adjustment action type options corresponding to the first type of adjustment button clicked by the user; An adjustment action type is determined according to the user's selection among the adjustment action type options. 9. The device according to claim 6 or 7, wherein the determination module is specifically used for: Displaying an adjustment amount selection interface, the adjustment amount selection interface includes at least one option, and each option provides the user with a combination of an adjustment amount and an adjustment action type; According to the user's selection on the adjustment amount selection interface, the type of adjustment action and the adjustment amount are determined. 10. The device according to claim 6, wherein the adjustment module is specifically used for: When the determined adjustment action type is an increase operation, according to the determined adjustment object type and adjustment quantity, increase a corresponding number of rows or increase a corresponding number of columns; Wherein, the format of the newly added row is determined according to the adjacent row format of the newly added row, and the adjacent row of the newly added row is determined according to a preset first rule, and the adjacent row of the newly added row includes: the newly added row A row on the lower side, or a row on the upper side of the newly added row; The format of the newly added column is determined according to the adjacent column format of the newly added column. The adjacent column of the newly added column is determined according to the second preset rule. The adjacent columns of the newly added column include: the left side of the newly added column , or a column to the right of the new column.