CN112989776A - Method and device for adjusting table columns, storage medium and terminal equipment - Google Patents

Method and device for adjusting table columns, storage medium and terminal equipment Download PDF

Info

Publication number
CN112989776A
CN112989776A CN202110237009.4A CN202110237009A CN112989776A CN 112989776 A CN112989776 A CN 112989776A CN 202110237009 A CN202110237009 A CN 202110237009A CN 112989776 A CN112989776 A CN 112989776A
Authority
CN
China
Prior art keywords
column
user
control
adjusting
setting window
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110237009.4A
Other languages
Chinese (zh)
Inventor
刘日�
覃冠伟
王升优
徐志峰
张顺生
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yuanguang Software Co Ltd
Original Assignee
Yuanguang Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yuanguang Software Co Ltd filed Critical Yuanguang Software Co Ltd
Priority to CN202110237009.4A priority Critical patent/CN112989776A/en
Publication of CN112989776A publication Critical patent/CN112989776A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/451Execution arrangements for user interfaces

Abstract

The embodiment of the application discloses a method and a device for adjusting a table column, a storage medium and terminal equipment, and belongs to the field of office automation. The method of the embodiment of the application comprises the following steps: when the triggering operation of a user on the table is detected, displaying a column setting window; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control; determining a target column name based on the selection operation of the user, and adjusting the attribute of the target column name based on the setting operation of the user on the adjustment control of the target column name; the attributes comprise one or more of arrangement sequence, display mode and fixed mode; when the confirmation operation of a user on the column setting window is detected, acquiring the attribute of each column name; and adjusting the corresponding columns of the column names in the table based on the attributes. The method and the device have the advantages that the sequencing, display or hiding processing of the columns in the table is realized through interaction of the table interface, and the efficiency of inquiring and processing the table by a user is greatly improved.

Description

Method and device for adjusting table columns, storage medium and terminal equipment
Technical Field
The present application relates to the field of office automation, and in particular, to a method, an apparatus, a storage medium, and a terminal device for adjusting a table column.
Background
The table is a data storage form commonly used in office automation software, the table is composed of a plurality of rows and a plurality of columns, each column has a column name and an attribute value under the column name, the number of columns of the table is increased along with the increase of data volume, and in this case, the problem that the searching time is long and the searching operation is complicated exists when a user searches for the required column in the table.
Disclosure of Invention
In order to solve the above technical problems, the present application provides a method, an apparatus, a storage medium, and a terminal device for adjusting table columns, which solve the problem in the prior art that a user is inconvenient to search due to an excessive number of columns in a table.
In a first aspect, the present application provides a method for adjusting a table column, comprising:
when the triggering operation of a user on the table is detected, displaying a column setting window; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
determining a target column name based on selection operation of a user, and adjusting the attribute of the target column name based on setting operation of the user on an adjusting control of the target column name; the attributes comprise one or more of an arrangement sequence, a display mode and a fixed mode, the arrangement sequence represents an arrangement position of a column in the table, the display mode represents that the column in the table is in a display state or a hidden state, the fixed mode represents that the column in the table is in a fixed state or a flexible state, the column in the fixed state is fixed at a specified position, and a user can freely adjust the arrangement sequence of the column in the flexible state.
When the confirmation operation of the user on the column setting window is detected, acquiring the attribute of each column name;
and adjusting the corresponding columns of the column names in the table based on the attributes.
In a possible design, when the trigger operation of the user on the table is detected, displaying a column setting window, including:
when detecting that a user executes right mouse click operation on a cell selected in the table, displaying a right mouse button window; the right mouse button window comprises a column setting control and a clearing control; the cell is a unit for storing data in the table, and the cell is a storage space formed by intersecting rows and columns.
And displaying a column setting window when detecting that the user executes the left mouse click operation on the column setting control.
In one possible design, the selected column, the selected cell, and the selected column name are represented in a highlighted manner or in a bolded manner.
In one possible design, further comprising:
and when detecting that the user executes the left mouse click operation on the clearing control, clearing the contents of the cells selected in the table.
In one possible design, the position move control is used to move columns in the table up, down, top, bottom, and reset.
In a possible design, the obtaining the attribute of each column name when the confirmation operation of the user on the column setting window is detected includes:
and when detecting the mouse left-click operation of a user on the confirmation control in the column setting window, acquiring the arrangement sequence, the display mode and the fixed mode of each column name in the column setting window.
In one possible design, the display mode control and the fixed mode control are switch controls.
In a second aspect, the present application provides an apparatus for adjusting a table column, the apparatus comprising:
the display unit is used for displaying a column setting window when the triggering operation of a user on the table is detected; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
the setting unit is used for determining a target column name based on the selection operation of a user and adjusting the attribute of the target column name based on the setting operation of the user on the adjustment control of the target column name; wherein the attribute comprises one or more of an arrangement sequence, a display mode and a fixed mode;
the acquisition unit is used for acquiring the attribute of each column name when the confirmation operation of the user on the column setting window is detected;
and the adjusting unit is used for adjusting the corresponding columns of the column names in the table based on the attributes.
In yet another aspect, the present application provides an apparatus that can implement the method for adjusting table columns according to the first aspect. For example, the apparatus may be a chip (such as a baseband chip, or a communication chip, etc.) or a terminal device. The above-described method may be implemented by software, hardware, or by executing corresponding software by hardware.
In one possible implementation manner, the structure of the apparatus includes a processor, a memory; the processor is configured to support the apparatus to perform corresponding functions in the method of adjusting table columns described above. The memory is used for coupling with the processor, which holds the necessary programs (instructions) and/or data for the device. Optionally, the apparatus may further include a communication interface for supporting communication between the apparatus and other network elements.
In another possible implementation manner, the apparatus may include unit modules for performing corresponding actions in the above-described method.
In yet another possible implementation, the wireless communication device includes a processor and a transceiver, the processor is coupled to the transceiver, and the processor is configured to execute a computer program or instructions to control the transceiver to receive and transmit information; the processor is further configured to implement the above-described method when the processor executes the computer program or instructions. The transceiver may be a transceiver, a transceiver circuit, or an input/output interface. When the device is a chip, the transceiver is a transceiver circuit or an input/output interface.
When the device is a chip, the sending unit may be an output unit, such as an output circuit or a communication interface; the receiving unit may be an input unit, such as an input circuit or a communication interface. When the device is a network device, the sending unit may be a transmitter or a transmitter; the receiving unit may be a receiver or a receiver.
Yet another aspect of the present application provides an apparatus, comprising: a memory and a processor; wherein the memory stores a set of program codes, and the processor is configured to call the program codes stored in the memory and execute the method of the aspects.
Yet another aspect of the present application provides a computer-readable storage medium having stored therein instructions, which when executed on a computer, cause the computer to perform the method of the above-described aspects.
Yet another aspect of the present application provides a computer program product containing instructions which, when run on a computer, cause the computer to perform the method of the above-described aspects.
According to the embodiment, the column names of all columns in the table are obtained to generate the column setting window, the arrangement sequence of the columns, whether the columns are hidden or not and whether the columns are fixed or not are adjusted through the position moving control, the display mode control and the fixed mode control in the column setting window, and the problems of inaccurate positioning and complicated operation process caused by dragging a scroll bar through a mouse in the related technology are solved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart illustrating a method for adjusting a table column according to an embodiment of the present disclosure;
FIG. 2 is a schematic diagram of a user interface provided by an embodiment of the present application;
FIG. 3 is a schematic diagram of a user interface provided by an embodiment of the present application;
FIG. 4 is a schematic diagram of a user interface provided by an embodiment of the present application
FIG. 5 is a schematic diagram of an apparatus according to an embodiment of the present disclosure;
fig. 6 is another schematic structural diagram of an apparatus provided herein.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance. It will be apparent to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.
Referring to fig. 1, fig. 1 is a schematic flowchart of a method for adjusting a table column according to an embodiment of the present application, where the method includes:
and S101, displaying a column setting window when the trigger operation of the user on the table is detected.
The trigger operation is generated by a user through interaction with an interaction device such as a keyboard, a mouse or a touch screen, and the trigger operation is an operation of a specified type, for example: when the interactive equipment is a touch screen, the triggering operation is single-point touch operation, multi-point touch operation or sliding touch operation and the like; when the interactive device is a mouse, the triggering operation is right mouse click operation, left mouse click operation, mouse dragging operation or the like. The device for adjusting table columns (hereinafter referred to as a device) of the present application displays a table to be processed first, where the table has a plurality of columns, the head line of each column is a column name, and the other rows except the head line are attribute values. When the device detects that a user triggers the appointed operation of a table, a column setting window is displayed, the column setting window is a floating layer displayed on the table, the user can interactively adjust the columns of the table through the column setting window, the column setting window comprises all column names of the table and adjusting controls of all the column names, each adjusting control comprises a position moving control, a display mode control and a fixed mode control, the position moving controls are used for moving the arrangement sequence of the columns where the column names are located, the display mode controls are used for controlling the columns where the column names are located to be in a display state or a hidden state, the fixed mode controls are used for controlling the columns where the column names are located to be in a fixed state or a flexible state, the fixed state represents that the columns are fixed at the appointed position, and the flexible state represents that the positions of the columns can be adjusted at will.
In a possible implementation manner, when a trigger operation of a user on the table is detected, displaying a column setting window, including:
when detecting that a user executes right mouse click operation on a selected cell in the table, displaying a right mouse button window; the right mouse button window comprises a column setting control and a clearing control;
and displaying a column setting window when detecting that the user executes the left mouse click operation on the column setting control.
Wherein, the user selects a cell on the table displayed first, and the device detects the selection operation of the user on the table, such as: the device detects that the column where the cursor of the mouse is located is the cell selected by the user, or detects that the column where the left key clicking position of the mouse is located is the cell selected by the user, then the device detects that the right key clicking operation of the mouse is executed on the selected cell by the user, a right key window of the mouse is displayed, the right key window of the mouse is a floating layer displayed on the table, the user can interact through the right key window of the mouse, the right key window of the mouse comprises a column setting control and a clearing control, and the column setting control and the clearing control can be two vertically arranged buttons. And when the device detects that the user executes the left mouse click operation on the column setting control, displaying a column setting window. And when the device detects that the user performs the left mouse click operation on the clearing control, performing clearing operation on the content in the selected cell.
For example: referring to fig. 2, the apparatus first displays a table 20 to be processed, and column names in the table in a display state include: index type, index name, measurement unit, entrance management department and the like. The user adjusts the table through the mouse, the device detects that the cell at the position where the mouse cursor is located is a monthly guarantee index, and the border of the cell is thickened to mark the cell as the one selected by the user. Then, when the device detects that the user performs the right mouse click operation, the right mouse button window 21 is displayed, the right mouse button window 21 includes a clear control 210 and a column setting control 211, and when the device detects that the user performs the left mouse click operation on the column setting control 211, the column setting window as shown in fig. 3 is displayed, and the column setting window includes all column names and adjustment controls in the table 20, including a position moving control, a display mode control, and a fixed mode control. Or, the device detects that the user performs mouse left click operation on the clearing control 210, determines that the selected cell is the column of the index category, and performs clearing operation on the content in the cell, namely clearing the monthly assurance index "
S102, determining a target column name based on selection operation of a user, and adjusting the attribute of the target column name based on setting operation of the user on an adjusting control of the target column name.
The user performs a selection operation on the column setting window, the selection operation is generated by the user through an interactive device such as a keyboard, a mouse or a touch screen, the user first selects a target column name from a plurality of column names in the column setting window, and the selection mode may be: the device detects that the column name corresponding to the position where a mouse cursor of a user is located is a target column name, or the column name corresponding to the position where a left mouse button of the user is clicked is the target column name, the target column name corresponds to one column corresponding to the table, and then the user performs setting operation on the adjusting control piece through the mouse to adjust the attribute of the target column name, wherein the attribute comprises the arrangement sequence, the display mode and the fixed mode of the columns.
For example: referring to fig. 3 and 4, the table has a total of 10 columns, and the column setup window includes 10 column names: index name, measurement unit, index category, zbpid, index code, index reference score, entry management department, creation unit, and creation unit ID, each column name has a serial number, and the column setting window 30 includes position movement controls: as can be seen, all column names in the column setting window share the same position moving control, for example, an upward moving control (corresponding to the control indicated by upward movement in fig. 3), a downward moving control (corresponding to the control indicated by downward movement in fig. 3), a top placing control (corresponding to the control indicated by the uppermost movement in fig. 3), a bottom placing control (corresponding to the control indicated by the lowermost movement in fig. 3), and a resetting control (corresponding to the control indicated by resetting in fig. 3). The mode that the user adjusts the arrangement sequence of a certain column name in the column setting window is as follows: firstly, the user selects one column name from 10 column names, and then clicks any one of the 4 position movement controls by using a left mouse button, for example: the column name selected by the user is an index name, the column name is a flexible state and a display state, and then when the device detects the clicking operation of the left mouse button on the upward moving control, the index name is moved upwards by one position, and the serial number of the index name is changed from 5 to 4; when the device detects the left mouse button clicking operation on the downward movement control, the index name is moved downwards by one position, and the serial number of the index name is changed from 5 to 6; when the device detects the clicking operation of the left mouse button on the top control, the index name is moved to the first position, and the serial number of the index name is changed from 5 to 1; when the device detects the left mouse button clicking operation on the bottom placing control, the index name is moved to the last position, and the serial number of the index name is changed from 5 to 10; when the device detects the left mouse button clicking operation on the reset control, the position of the index name is restored to the last position.
In addition, each column name in the column setting window 30 has a display mode control and a fixed mode control. The display mode control and the fixed mode control in fig. 3 and 4 are switch controls, a user dials the switch button of the display mode control to the left through the interactive device to indicate that the column indicated by the column name is in a display state, and when the user dials the switch button of the display mode to the right through the interactive device, the column indicated by the column name is in a hidden state; when a user dials the switch button of the fixed mode control to the left through the interactive equipment, the column indicated by the column name is in a fixed state, and when the user dials the switch button of the fixed mode control to the right through the interactive equipment, the column indicated by the column name is in a flexible state. Referring to fig. 3 and 4, the column name "index name" in the column setting window is in a display state and a fixed state.
S103, when the confirmation operation of the user on the column setting window is detected, the attribute of each column name is obtained.
After the user finishes the setting, the confirmation operation is executed on the column setting window through the interaction equipment, the confirmation operation is the operation of a specified type, when the device detects the confirmation operation, the attribute of each column name in the column setting window is obtained, and the attribute comprises: arrangement order, display mode and fixing mode.
And S104, adjusting the corresponding columns of the column names in the table based on the attributes.
Each column name uniquely corresponds to one column in the table, and the arrangement sequence, the display mode and the fixed mode of the columns in the table are kept consistent with the column names in the column setting window, so that the columns in the table are adjusted.
According to the embodiment of the application, the column names of all columns in the table are acquired to generate the column setting window, the arrangement sequence of the columns, whether the columns are hidden or not and whether the attributes of the columns are fixed or not are adjusted through the position moving control, the display mode control and the fixed mode control in the column setting window, the problems that in the related technology, the arrangement of the columns, the display mode and the fixed mode can be accurately adjusted through the controls, so that the required columns can be rapidly located and inquired, the speed of inquiring the columns in the table is increased, and the complexity of inquiring operation is reduced.
The above-described method of adjusting the table columns is explained in detail in fig. 1 to 4. Correspondingly, the structure of a device in the embodiment of the application is schematically shown.
Referring to fig. 5, fig. 5 is a schematic structural diagram of an apparatus 5 according to an embodiment of the present application, where the apparatus 5 includes: a display unit 501, a setting unit 502, an acquisition unit 503, and an adjustment unit 504.
A display unit 501, configured to display a column setting window when a trigger operation of a user on a table is detected; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
a setting unit 502, configured to determine a target column name based on a selection operation of a user, and adjust an attribute of the target column name based on a setting operation of an adjustment control of the target column name by the user; wherein the attribute comprises one or more of an arrangement sequence, a display mode and a fixed mode;
an obtaining unit 503, configured to obtain an attribute of each column name when a user confirms the column setting window;
an adjusting unit 504, configured to adjust a corresponding column of each column name in the table based on the attribute.
In one or more possible embodiments, the displaying a column setting window when the trigger operation of the user on the table is detected includes:
when detecting that a user executes right mouse click operation on a cell selected in the table, displaying a right mouse button window; the right mouse button window comprises a column setting control and a clearing control;
and displaying a column setting window when detecting that the user executes the left mouse click operation on the column setting control.
In one or more possible embodiments, the selected cell and the selected column name are highlighted.
In one or more possible embodiments, the setting unit 502 is further configured to:
and when detecting that the user executes the left mouse click operation on the clearing control, clearing the contents of the cells selected in the table.
In one or more possible embodiments, the position move control is used to move up, down, top, bottom, and reset columns in the table.
In one or more possible embodiments, the obtaining the attribute of each column name when the confirmation operation of the user on the column setting window is detected includes:
and when detecting the mouse left-click operation of a user on the confirmation control in the column setting window, acquiring the arrangement sequence, the display mode and the fixed mode of each column name in the column setting window.
In one or more possible embodiments, the display mode control and the fixed mode control are switch controls.
The device 5 may be a terminal device, and the device 5 may also be a field-programmable gate array (FPGA), an application-specific integrated chip (asic), a system on chip (SoC), a Central Processing Unit (CPU), a Network Processor (NP), a digital signal processing circuit, a Micro Controller Unit (MCU), or a Programmable Logic Device (PLD) or other integrated chips.
Fig. 6 is a schematic structural diagram of an apparatus according to an embodiment of the present disclosure. As shown in fig. 6, the apparatus 1000 may include: at least one processor 1001, at least one network interface 1004, a user interface 1003, memory 1005, at least one communication bus 1002.
Wherein a communication bus 1002 is used to enable connective communication between these components.
The user interface 1003 may include a Display screen (Display) and a Camera (Camera), and the optional user interface 1003 may also include a standard wired interface and a wireless interface.
The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.
Processor 1001 may include one or more processing cores, among other things. The processor 1001 interfaces with various interfaces and lines throughout the various portions of the drone nest 1000, executing various functions of the drone nest 1000 and processing data by executing or executing instructions, programs, sets of codes, or sets of instructions stored in the memory 1005, as well as invoking data stored in the memory 1005. Alternatively, the processor 1001 may be implemented in at least one hardware form of Digital Signal Processing (DSP), Field-Programmable Gate Array (FPGA), and Programmable Logic Array (PLA). The processor 1001 may integrate one or more of a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), a modem, and the like. Wherein, the CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It is understood that the modem may not be integrated into the processor 1001, but may be implemented by a single chip.
The Memory 1005 may include a Random Access Memory (RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 1005 includes a non-transitory computer-readable medium. The memory 1005 may be used to store an instruction, a program, code, a set of codes, or a set of instructions. The memory 1005 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like; the storage data area may store data and the like referred to in the above respective method embodiments. The memory 1005 may optionally be at least one memory device located remotely from the processor 1001. As shown in fig. 6, the memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and an application program.
In the apparatus 1000 shown in fig. 6, the user interface 1003 is mainly used as an interface for providing input for a user, and acquiring data input by the user; and the processor 1001 may be configured to call an application program stored in the memory 1005 for configuring the application program interface, and specifically perform the following operations:
when the triggering operation of a user on the table is detected, displaying a column setting window; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
determining a target column name based on selection operation of a user, and adjusting the attribute of the target column name based on setting operation of the user on an adjusting control of the target column name; wherein the attribute comprises one or more of an arrangement sequence, a display mode and a fixed mode;
when the confirmation operation of the user on the column setting window is detected, acquiring the attribute of each column name;
and adjusting the corresponding columns of the column names in the table based on the attributes.
In one or more possible embodiments, when processor 1001 executes the detection of the trigger operation of the user on the table, displaying a column setting window, including:
when detecting that a user executes right mouse click operation on a cell selected in the table, displaying a right mouse button window; the right mouse button window comprises a column setting control and a clearing control;
and displaying a column setting window when detecting that the user executes the left mouse click operation on the column setting control.
In one or more possible embodiments, the selected cell and the selected column name are highlighted.
In one or more possible embodiments, the processor 1001 is further configured to perform:
and when detecting that the user executes the left mouse click operation on the clearing control, clearing the contents of the cells selected in the table.
In one or more possible embodiments, the position move control is used to move up, down, top, bottom, and reset columns in the table.
In one or more possible embodiments, when the processor 1001 performs the operation of detecting the confirmation operation of the user on the column setting window, acquiring the attribute of each column name includes:
and when detecting the mouse left-click operation of a user on the confirmation control in the column setting window, acquiring the arrangement sequence, the display mode and the fixed mode of each column name in the column setting window.
In one or more possible embodiments, the display mode control and the fixed mode control are switch controls.
The concept of this embodiment is the same as that of the embodiment of the method in fig. 1, and the technical effects brought by the embodiment are also the same, and the specific process can refer to the description of the embodiment in fig. 1, and will not be described again here.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present application and is not to be construed as limiting the scope of the present application, so that the present application is not limited thereto, and all equivalent variations and modifications can be made to the present application.

Claims (10)

1. A method of adjusting a table column, comprising:
when the triggering operation of a user on the table is detected, displaying a column setting window; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
determining a target column name based on selection operation of a user, and adjusting the attribute of the target column name based on setting operation of the user on an adjusting control of the target column name; wherein the attribute comprises one or more of an arrangement sequence, a display mode and a fixed mode;
when the confirmation operation of the user on the column setting window is detected, acquiring the attribute of each column name;
and adjusting the corresponding columns of the column names in the table based on the attributes.
2. The method according to claim 1, wherein the displaying a column setting window when the trigger operation of the user on the table is detected comprises:
when detecting that a user executes right mouse click operation on a cell selected in the table, displaying a right mouse button window; the right mouse button window comprises a column setting control and a clearing control;
and displaying a column setting window when detecting that the user executes the left mouse click operation on the column setting control.
3. The method of claim 2, wherein the selected cell and the selected column name are highlighted.
4. The method of claim 2, further comprising:
and when detecting that the user executes the left mouse click operation on the clearing control, clearing the contents of the cells selected in the table.
5. The method of claim 1, wherein the position movement control is configured to perform an up-shift process, a down-shift process, a top-down process, a bottom-up process, and a reset process on a column in the table.
6. The method according to claim 1, wherein the obtaining the attribute of each column name when detecting a confirmation operation of the user on the column setting window comprises:
and when detecting the mouse left-click operation of a user on the confirmation control in the column setting window, acquiring the arrangement sequence, the display mode and the fixed mode of each column name in the column setting window.
7. The method of any one of claims 1-6, wherein the display mode control and the fixed mode control are on-off controls.
8. An apparatus for adjusting columns of a table, comprising:
the display unit is used for displaying a column setting window when the triggering operation of a user on the table is detected; the column setting window comprises all column names of the table and adjusting controls of all the column names, and the adjusting controls comprise a position moving control, a display mode control and a fixed mode control;
the setting unit is used for determining a target column name based on the selection operation of a user and adjusting the attribute of the target column name based on the setting operation of the user on the adjustment control of the target column name; wherein the attribute comprises one or more of an arrangement sequence, a display mode and a fixed mode;
the acquisition unit is used for acquiring the attribute of each column name when the confirmation operation of the user on the column setting window is detected;
and the adjusting unit is used for adjusting the corresponding columns of the column names in the table based on the attributes.
9. A computer storage medium, characterized in that it stores a plurality of instructions adapted to be loaded by a processor and to carry out the method steps according to any one of claims 1 to 7.
10. A terminal device, comprising: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the method steps of any of claims 1 to 7.
CN202110237009.4A 2021-03-03 2021-03-03 Method and device for adjusting table columns, storage medium and terminal equipment Pending CN112989776A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110237009.4A CN112989776A (en) 2021-03-03 2021-03-03 Method and device for adjusting table columns, storage medium and terminal equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110237009.4A CN112989776A (en) 2021-03-03 2021-03-03 Method and device for adjusting table columns, storage medium and terminal equipment

Publications (1)

Publication Number Publication Date
CN112989776A true CN112989776A (en) 2021-06-18

Family

ID=76352425

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110237009.4A Pending CN112989776A (en) 2021-03-03 2021-03-03 Method and device for adjusting table columns, storage medium and terminal equipment

Country Status (1)

Country Link
CN (1) CN112989776A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113625917A (en) * 2021-07-29 2021-11-09 北京达佳互联信息技术有限公司 Data display method and device, electronic equipment, storage medium and product
CN115577676A (en) * 2022-12-07 2023-01-06 苏州万店掌网络科技有限公司 Page table control method, device, equipment and storage medium
WO2023207939A1 (en) * 2022-04-29 2023-11-02 北京有竹居网络技术有限公司 Method and apparatus for adjusting interface layout, and device, storage medium and program product

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1908929A (en) * 2005-08-03 2007-02-07 国际商业机器公司 Computer-implemented method and system for hiding columns in an electronic table
US20070078881A1 (en) * 2005-10-03 2007-04-05 Sap Ag Table columns organizer
EP1909192A1 (en) * 2006-10-03 2008-04-09 Research In Motion Limited System and method for freezing columns and rows in a UI table
US20160334954A1 (en) * 2006-12-28 2016-11-17 Apple Inc. Smart tables
US20170139874A1 (en) * 2004-11-26 2017-05-18 Philip K. Chin Method of displaying data in a table with fixed header
CN111104780A (en) * 2018-10-09 2020-05-05 珠海金山办公软件有限公司 Method and terminal for screening columns in electronic table

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170139874A1 (en) * 2004-11-26 2017-05-18 Philip K. Chin Method of displaying data in a table with fixed header
CN1908929A (en) * 2005-08-03 2007-02-07 国际商业机器公司 Computer-implemented method and system for hiding columns in an electronic table
US20070078881A1 (en) * 2005-10-03 2007-04-05 Sap Ag Table columns organizer
EP1909192A1 (en) * 2006-10-03 2008-04-09 Research In Motion Limited System and method for freezing columns and rows in a UI table
US20160334954A1 (en) * 2006-12-28 2016-11-17 Apple Inc. Smart tables
CN111104780A (en) * 2018-10-09 2020-05-05 珠海金山办公软件有限公司 Method and terminal for screening columns in electronic table

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113625917A (en) * 2021-07-29 2021-11-09 北京达佳互联信息技术有限公司 Data display method and device, electronic equipment, storage medium and product
WO2023207939A1 (en) * 2022-04-29 2023-11-02 北京有竹居网络技术有限公司 Method and apparatus for adjusting interface layout, and device, storage medium and program product
CN115577676A (en) * 2022-12-07 2023-01-06 苏州万店掌网络科技有限公司 Page table control method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
CN112989776A (en) Method and device for adjusting table columns, storage medium and terminal equipment
CN102156614B (en) Device, method, and graphical user interface for manipulating tables using multi-contact gestures
US10345430B2 (en) Floor determining method and system, and related device
CN106502520A (en) For navigating and playing the user interface of content
CN108647052A (en) Application program preloads method, apparatus, storage medium and terminal
CN110297594A (en) Input equipment and user interface interaction
US11747977B2 (en) Method for displaying graphical user interface based on gesture and electronic device
CN112099686B (en) Icon display control method and device and electronic equipment
CN103563392A (en) Display device and method for remotely controlling display device
TWI428771B (en) Information acquisition device, information acquisition program product, recording medium, information acquisition method and information acquisition system
CN105227985B (en) Show equipment and its control method
KR20140058945A (en) Display apparatus and method for correcting character thereof
CN111831182A (en) Application icon control method and device and electronic equipment
KR20170042953A (en) Display apparatus and method of controling thereof
US20150213094A1 (en) Maintaining search context
CN103914466B (en) A kind of method and system of label button management
CN111984170A (en) Table output method and device and electronic equipment
WO2023030284A1 (en) Display method, display apparatus, electronic device, and storage medium
CN115238652A (en) Table data generation method and device, electronic equipment and readable storage medium
CN103353897A (en) Method and device for webpage anchor point navigation
WO2021178255A1 (en) Electronic input system
CN113467661A (en) Task synchronization method, device, equipment and readable storage medium
CN112637653A (en) Television touch remote control method and system
CN114035729B (en) Electronic voting method and device and terminal equipment
CN112449227A (en) Interaction method and device for touch screen application compatible with remote controller operation, smart television and storage medium

Legal Events

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