A method and apparatus for interacting with a tabularized aircraft weight tree hierarchy

By using a hierarchical tree structure for aircraft weight data in a list format, the problem of balancing the convenience of interactive operations and data modification in Excel spreadsheets is solved, thereby improving the efficiency and accuracy of data preprocessing.

CN119690283BActive Publication Date: 2026-01-09XIAN AIRCRAFT DESIGN INST OF AVIATION IND OF CHINA
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202411873342.4
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-12-18
Publication Date
2026-01-09
Estimated Expiration
2044-12-18

AI Technical Summary

Technical Problem

In existing technologies, aircraft weight characteristic data exported from 3D design software cannot be directly interactively manipulated in a tree structure, and convenience and structured management cannot be simultaneously achieved when modifying data in an Excel spreadsheet.

Method used

This paper provides an interactive method for a hierarchical tree structure of aircraft weights in a list format. By obtaining tabular data, the method responds to the selected tree nodes for interactive operations, supporting operations such as undo, formatting, hierarchical elevation/reduction, tree node movement, creation, and deletion.

Benefits of technology

It enables seamless interaction of aircraft weight characteristic data in a tree-like hierarchical structure within an Excel spreadsheet, improving the efficiency and accuracy of data preprocessing.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119690283B_ABST
    Figure CN119690283B_ABST
Patent Text Reader

Abstract

The application provides a tabularized aircraft weight tree structure interaction method and device, and belongs to the field of aircraft weight characteristic data processing. The aircraft weight tree structure interaction method comprises the following steps: S10, acquiring a tabularized aircraft weight tree structure; S20, in response to a selected tree node selection range in the tree structure that is intended to participate in an interactive operation, judging the cells in the selection range to obtain a tree node to be subjected to an interactive operation; and S30, in response to a selected operation instruction, performing a corresponding interactive operation on the tree node to be subjected to an interactive operation. The application can interactively operate aircraft weight characteristic data in the tree structure as smoothly as operating a tree structure. The efficiency of data preprocessing is significantly improved compared with conventional methods, and the accuracy of data preprocessing is greatly improved compared with conventional artificial methods.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The application belongs to the field of aircraft weight data processing, and particularly relates to a list-based aircraft weight tree structure interaction method and device. BACKGROUND

[0002] In the overall design process of an aircraft, the weight characteristic data of the aircraft is often exported from different three-dimensional design software and summarized to a weight professional, and the tree structure of the data has been tabulated, so that the data cannot be directly interacted like a tree structure. Considering that the weight characteristic data set in the pre-processing stage still has many errors, the errors need to be modified in an Excel table, and the convenience of editing the data in Excel cannot be lost, so the data cannot be managed in a mainstream structured software. The convenience of interactive operation and the convenience of data modification and editing cannot be considered.

[0003] Therefore, the field of overall design of an aircraft needs a method and tool which can interact with the aircraft weight characteristic data set in a table like a tree structure, and cannot affect the convenience of modifying and editing the data set in an Excel table. SUMMARY

[0004] The application aims to provide a list-based aircraft weight tree structure interaction method to solve or alleviate at least one problem in the background art.

[0005] The technical solution of the application is a list-based aircraft weight tree structure interaction method, comprising:

[0006] S10, acquiring a tabulated aircraft weight tree structure;

[0007] S20, in response to a selected tree node selection range in the tree structure which is intended to participate in interactive operation, judging the cells in the selection range to obtain a tree node which is intended to participate in interactive operation;

[0008] S30, in response to a selected operation instruction, performing corresponding interactive operation processing on the tree node which is intended to participate in interactive operation.

[0009] Preferably, the tree structure is an Excel table file.

[0010] Preferably, in step S20, in response to the selected tree node selection range in the tree structure which is intended to participate in interactive operation, the selection range is judged to obtain the tree node which is intended to participate in interactive operation, and the process comprises:

[0011] S21: acquiring the selection range in the tree structure, and extracting the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selection range.

[0012] S22: judging whether the selected cell is in a single row by LimR01 = LimR02, if yes, executing step S23, if not, executing step S24;

[0013] S23: judging whether the selected cell is in a single column by LimC01 = LimC02, if yes, executing step S27, if not, executing step S24;

[0014] S24: judging whether the selected cell meets the requirement by LimC01-LimC02>N, if yes, executing step S25, if not, executing step S26, wherein N is a natural number;

[0015] S25: selecting all the tree nodes and their child nodes in the selected range;

[0016] S26: selecting all the tree nodes in the selected range;

[0017] S27: selecting all the tree nodes in the tree structure.

[0018] Preferably, the operation instruction includes a cancel instruction, a formatter instruction, a level upgrade instruction, a tree node moving instruction, a tree node deleting instruction, and a tree node creating instruction;

[0019] The cancel instruction is used to restore the data and format in the tree structure.

[0020] The formatter instruction is used to clear all the aircraft weight characteristic data and format in the tree structure.

[0021] The level upgrade instruction is used to upgrade or downgrade the node level of the selected tree node by one level.

[0022] The tree node moving instruction is used to move the selected tree node up or down after disassembling and reassembling the selected tree node in the tree structure.

[0023] The tree node deleting instruction is used to delete the selected tree node level in the tree structure, so as to no longer participate in the calculation and interactive operation in the tree structure.

[0024] The tree node creating instruction is used to set the selected cell as the tree node of the corresponding level, wherein the tree node creating instruction has 1-M levels, thereby realizing the creation of M-level tree nodes, the level identifier of each tree node creating instruction is set as the identifier of the corresponding level of the tree node, and the level identifier of the selected cell is set as the level identifier corresponding to the tree node creating instruction in response to the selected cell and the tree node creating instruction button in the tree structure, and M>1.

[0025] Preferably, the process of disassembling and recombining selected tree nodes in a tree-like hierarchical structure and then moving the tree nodes up and down includes:

[0026] S31: Select the tree node to be decomposed in the tree hierarchy. If it is necessary to decompose the child tree nodes together, select at least Q columns, where Q>1.

[0027] S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds Q, proceed to step S33. If it does not exceed Q, proceed to step S34.

[0028] S33: Determine the child tree nodes of each tree node within the selected range;

[0029] S34: Respond to the tree node move command to disassemble the selected tree node;

[0030] S35: Select the location to reorganize the tree node in the tree hierarchy and paste the disassembled tree node into that location;

[0031] S36: Responding to the level adjustment command button will adjust the level of the reorganized tree node to the target level.

[0032] On the other hand, this application provides an interactive device for a hierarchical tree structure of aircraft weights in a list format, including:

[0033] The data import module is used to obtain the tabulated tree-like hierarchical structure of aircraft weight;

[0034] The tree node selection module is used to respond to the selected range of tree nodes in the tree hierarchy that are intended to participate in interactive operations, and to determine the tree nodes to be interactively operated on by judging the cells within the selected range.

[0035] The interaction processing module is used to respond to the selected operation command and perform corresponding interaction operations on the tree node to be interacted with.

[0036] Preferably, the tree-like hierarchical structure is an Excel spreadsheet file.

[0037] Preferably, in response to selecting a range of tree nodes to participate in the interactive operation within the tree hierarchy, the selected range is judged to obtain the tree nodes to be interactively operated, the process including:

[0038] S21: Get the selection range within the tree hierarchy, and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells within the selection range;

[0039] S22: judging whether the selected cell is in a single row by LimR01=LimR02, if yes, executing step S23, if not, executing step S24;

[0040] S23: judging whether the selected cell is in a single column by LimC01=LimC02, if yes, executing step S27, if not, executing step S24;

[0041] S24: judging whether the selected cell meets the requirements by LimC01-LimC02>N, if yes, executing step S25, if not, executing step S26, wherein N is a natural number;

[0042] S25: selecting all tree nodes and their child tree nodes in the selected range;

[0043] S26: selecting all tree nodes in the selected range;

[0044] S27: selecting all tree nodes in the tree structure.

[0045] Preferably, the operation instruction includes a cancel instruction, a formatter instruction, a level upgrade instruction, a tree node moving instruction, a tree node deleting instruction, and a tree node creating instruction;

[0046] The cancel instruction is used to restore the data and format in the tree structure.

[0047] The formatter instruction is used to clear all aircraft weight characteristic data and format in the tree structure.

[0048] The level upgrade instruction is used to upgrade or downgrade the node level of the selected tree node by one level.

[0049] The tree node moving instruction is used to move the selected tree node up or down after disassembling and reassembling the selected tree node in the tree structure.

[0050] The tree node deleting instruction is used to delete the selected tree node level identifier in the tree structure, so as to no longer participate in the calculation and interactive operation in the tree structure.

[0051] The tree node creating instruction is used to set the selected cell as a tree node corresponding to the level, wherein the tree node creating instruction has 1-M levels, thereby realizing the creation of M-level tree nodes, and the level identifier of each tree node creating instruction is set as the identifier of the tree node corresponding to the level, and the level identifier of the selected cell is set as the level identifier corresponding to the tree node creating instruction in response to the selected cell and the tree node creating instruction button in the tree structure, and M>1.

[0052] Preferably, the process of moving the tree nodes up and down after the selected tree nodes are disassembled and reassembled in the tree hierarchy includes:

[0053] S31: selecting the tree nodes to be disassembled in the tree hierarchy, and selecting no less than Q columns if the tree nodes of the sub-level are needed to be disassembled, Q>1;

[0054] S32: judging the number of columns of the selected tree nodes, and executing step S33 if the number of columns exceeds Q, and executing step S34 if the number of columns does not exceed Q;

[0055] S33: determining the sub-level tree nodes of each tree node in the selected range;

[0056] S34: disassembling the selected tree nodes in response to the tree node moving instruction;

[0057] S35: selecting the position of the reassembled tree nodes in the tree hierarchy, and pasting the disassembled tree nodes to the position;

[0058] S36: adjusting the level of the reassembled tree nodes to the target level in response to the level up and down instruction button.

[0059] In a third aspect, the present application provides an electronic device, comprising:

[0060] one or more processors;

[0061] a memory;

[0062] one or more application programs stored in the memory and configured to be executed by the one or more processors, the one or more application programs being configured for implementing the list-based aircraft weight tree hierarchy interaction method according to any one of the above.

[0063] In a last aspect, the present application provides a computer storage medium storing at least one instruction, at least one program, a code set or an instruction set, which are loaded and executed by a processor to implement the list-based aircraft weight tree hierarchy interaction method according to any one of the above.

[0064] The list-based aircraft weight tree hierarchy interaction method and device of the present application can interact and operate the aircraft weight characteristic data in the tree hierarchy (Excel table) as smoothly as operating the tree structure, the efficiency of data preprocessing is significantly improved compared with the conventional method, and the accuracy of data preprocessing is greatly improved compared with the conventional manual method. BRIEF DESCRIPTION OF DRAWINGS

[0065] In order to more clearly illustrate the technical solutions provided by the present application, the following will briefly introduce the drawings. Obviously, the drawings described below are only some embodiments of the present application.

[0066] Figure 1 The figure is a schematic diagram of the list-based aircraft weight tree structure interaction method of the present application.

[0067] Figure 2 The figure is a schematic diagram of the processing flow of the selected range tree node in the present application.

[0068] Figure 3 The figure is a schematic diagram of the operation instruction panel in the present application.

[0069] Figure 4 The figure is a schematic diagram of the list-based aircraft weight tree structure interaction device of the present application.

[0070] Figure 5 The figure is a schematic diagram of the electronic device of an embodiment of the present application. DETAILED DESCRIPTION

[0071] In order to make the purpose, technical solutions and advantages of the present application clearer, the following will describe the technical solutions of the embodiments of the present application in more detail in combination with the drawings of the embodiments of the present application.

[0072] The present application provides a list-based aircraft weight tree structure interaction operation method and device, which provides a data processing method in the aircraft weight tree structure table for the common interactive operations such as creation, deletion, disassembly and reorganization in the aircraft weight tree structure data, and ensures that the listed aircraft weight characteristic data tree structure can be interacted in an orderly manner.

[0073] As shown in Figure 1 The list-based weight tree structure interaction operation method provided by the present application includes:

[0074] S10, obtaining a tabulated aircraft weight tree structure table;

[0075] As shown in Table 1, the tabulated aircraft weight tree structure provided in this embodiment of the present application is an Excel table file. In the present application, different colors or different background patterns are used to identify the data levels, and the main basis for the data levels is the assembly level number.

[0076] Table 1 Tabulated aircraft weight tree structure table

[0077]

[0078] S20: In response to the selected tree nodes in the tree structure that are to participate in the interactive operation, the selected range is selected, and the cells in the selected range are judged to obtain the tree nodes to be interactively operated.

[0079] As shown in Figure 2 The rule flow of the application for processing the tree nodes in the selected range in the tree structure is shown, and the specific steps are as follows:

[0080] S21: Obtain the selected range in the tree structure (i.e. the Excel table), and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selected range;

[0081] S22: Determine whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if yes, execute step S23, if not, execute step S24;

[0082] S23: Determine whether the cells in the selected range are selected in a single column by the condition LimC01=LimC02, if yes, execute S27, if not, execute step S24;

[0083] S24: Determine whether the cells in the selected range meet the requirements by the condition LimC01-LimC02>N, if yes, execute step S25, if not, execute step S26, N is a natural number;

[0084] S25: Select all the tree nodes and their child tree nodes in the selected range;

[0085] S26: Select all the tree nodes in the selected range;

[0086] S27: Select all the tree nodes in the tree structure.

[0087] In some embodiments of the application, N is 10, i.e. the process of selecting the tree nodes in the above tree structure can be represented as:

[0088] Selecting 1 cell is considered as selecting all the tree nodes, selecting single-row and multiple-column cells but less than 10 columns is considered as selecting the tree nodes corresponding to the row, selecting single-row and more than 10 columns is considered as selecting the tree nodes corresponding to the row and all their child tree nodes, selecting multiple rows but less than 10 columns in each row is considered as selecting the selected tree nodes themselves, and selecting multiple rows but not less than 10 columns in each row is considered as selecting the selected tree nodes themselves and all their child tree nodes.

[0089] S30, in response to the selected operation instruction, the corresponding interactive operation processing is performed on the tree nodes to be interactively operated.

[0090] As shown in Figure 3The operation instruction panel in the present application is shown in the figure. The operation instructions include:

[0091] 1) Undo instruction: record the data and format before operation, and restore the data and format in the tree hierarchy (i.e. Excel table) after clicking the undo instruction button;

[0092] 2) Formatter instruction: click the formatter instruction button to clear all the aircraft weight characteristic data and format in the tree hierarchy;

[0093] 3) Level up and down (▲▼) instruction: click the upward arrow (▲) to promote the selected tree node level by one, and click the downward arrow (▼) to lower the tree node level by one;

[0094] 4) Tree node moving (↑↓) instruction: click the tree node moving instruction button to move the selected tree node up and down after disassembling and recombining the tree node in the tree hierarchy;

[0095] The flow of the tree node in the tree hierarchy in the present application includes the following steps:

[0096] S31: select the tree node to be disassembled in the tree hierarchy, and select no less than Q columns if the sub-level tree nodes need to be disassembled together, Q>1;

[0097] S32: determine the number of columns selected, if the number of columns selected exceeds Q columns, execute step S33, if it does not exceed Q columns, execute step S34;

[0098] S33: determine the sub-level tree nodes of each tree node in the selected range;

[0099] S34: disassemble the selected tree node in response to the tree node moving instruction;

[0100] S35: select the position of the recombined tree node in the tree hierarchy, and paste the disassembled tree node to the position;

[0101] S36: adjust the level of the recombined tree node to the target level in response to the level up and down instruction button.

[0102] 5) Tree node deletion instruction: click the tree node deletion instruction button to delete the selected tree node level identifier (e.g. use different colors to identify) in the tree hierarchy, which no longer participates in the calculation and interactive operation in the tree hierarchy; if the number of columns selected is less than M rows, only remove the level identifier of the selected row, otherwise remove the level identifier of the selected row and the rows where the sub-level tree nodes of the selected row are located.

[0103] 6) tree node creation instruction: clicking the tree node creation instruction button can set the selected cell as the tree node of the corresponding level, wherein the tree node creation instruction has 1-M levels, thereby realizing the creation of M-level tree nodes. The level identifier (i.e. color) of each tree node creation instruction is set as the level identifier (color) of the tree node. In response to the selected cell in the tree structure and the tree node creation instruction button, the level identifier (color) of the selected cell can be set as the level identifier (color) of the tree node creation instruction, achieving the equivalent effect of tree node creation.

[0104] The list-based aircraft weight tree structure interaction method of the present application can interactively operate aircraft weight characteristic data in the tree structure (Excel table) as smoothly as operating the tree structure, the efficiency of data preprocessing is significantly improved compared with the conventional method, and the accuracy of data preprocessing is greatly improved compared with the conventional manual method.

[0105] As shown in Figure 4 The present application also provides a list-based aircraft weight tree structure interaction device, which comprises:

[0106] A data import module 101 is configured to acquire the tabular aircraft weight tree structure;

[0107] A tree node selection module 102 is configured to respond to the selected tree node selection range in the tree structure to be involved in interactive operation, and judge the cells in the selection range to obtain the tree nodes to be interactively operated;

[0108] An interaction processing module 103 is configured to respond to the selected operation instruction and perform corresponding interactive operation processing on the tree nodes to be interactively operated.

[0109] The processing process of the aircraft weight tree structure interaction device of the present application can refer to the content of the aircraft weight tree structure interaction method.

[0110] As shown in Figure 5 The electronic device 200 according to the embodiment of the present application comprises a processing device 201, which can perform various appropriate actions and processes according to the program stored in the ROM (Read Only Memory) 202 or the program loaded from the storage device 208 to the RAM (Random Access Memory) 203. The processing device 201 may, for example, comprise a general-purpose microprocessor (such as a CPU), an instruction set processor, and / or a related chipset, and / or a special-purpose microprocessor (such as an Application-Specific Integrated Circuit (ASIC)), etc. The processing device 201 can also comprise an on-board memory for caching purposes. The processing device 201 can comprise a single processing unit or multiple processing units for performing different actions of the method processes according to the embodiments of the present disclosure.

[0111] In the RAM 203, various programs and data required for the operation of the electronic device 200 are stored. The processing apparatus 201, the ROM 202, and the RAM 203 are connected to each other via the bus 204. The processing apparatus 201 performs various operations of the method and the procedure according to the embodiments of the present application by executing the programs in the ROM 202 and / or the RAM 203. It is to be noted that the programs can also be stored in one or more memories other than the ROM 202 and the RAM 203. The processing apparatus 201 can also perform various operations of the method or the procedure according to the embodiments of the present application by executing the programs stored in the one or more memories.

[0112] According to the embodiments of the present application, the electronic device 200 can further include an I / O interface 205 (input / output interface) which is also connected to the bus 204. The electronic device 200 can further include one or more of the following components connected to the I / O interface 205: an input apparatus 206 including a keyboard, a mouse, and the like; an output apparatus 207 including a display such as a cathode ray tube (CRT), a liquid crystal display (LCD), and the like, and a speaker, and the like; a storage apparatus 208 including a hard disk, and the like; and a communication apparatus 209 including a network interface card such as a LAN card, a modem, and the like. The communication apparatus 209 performs communication processing via a network such as the Internet. A drive is also connected to the I / O interface 205 as necessary. A removable medium such as a magnetic disk, a magneto-optical disk, a semiconductor memory, and the like is attached to the drive as necessary, so that a computer program read out therefrom is installed in the storage apparatus 208 as necessary.

[0113] The present application also provides a computer readable storage medium, which can be included in the device / apparatus / system described in the above embodiments, or exist separately without being assembled into the device / apparatus / system. The above computer readable storage medium carries one or more programs, which when executed, implement various operations of the above method or procedure according to the embodiments of the present application.

[0114] The above describes only the specific implementation of the present application, but the protection scope of the present application is not limited to this. Any changes or replacements easily thought of by those skilled in the art within the technical range disclosed in the present application should be covered within the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. A tabularized aircraft weight tree hierarchy interaction method, characterized by, The method comprises the following steps: S10, obtaining a tabulated aircraft weight tree structure; S20, in response to a selected range of tree nodes in the tree structure that are to participate in interactive operation, judging the cells in the selected range to obtain the tree nodes to be interactively operated, comprising: S21, obtaining the selected range in the tree structure, and extracting the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selected range; S22, judging whether the cells in the selected range are in a single row through the LimR01=LimR02 condition, if yes, executing step S23, and if no, executing step S24; S23, judging whether the cells in the selected range only select one column through the LimC01=LimC02 condition, if yes, executing S27, and if no, executing step S24; S24, judging whether the cells in the selected range meet the requirements through the LimC01-LimC02>N condition, if yes, executing step S25, and if no, executing step S26, wherein N is a natural number; S25, selecting all the tree nodes and child tree nodes in the selected range; S26, selecting all the tree nodes in the selected range; S27, selecting all the tree nodes in the tree structure; S30, in response to a selected operation instruction, performing corresponding interactive operation processing on the tree nodes to be interactively operated.

2. The tabulated aircraft weight tree hierarchy interaction method of claim 1, wherein, The tree structure is an Excel table file.

3. The tabulated aircraft weight tree hierarchy interaction method of claim 2, wherein, The operation instruction comprises a cancel instruction, a formatter instruction, a level upgrade instruction, a tree node moving instruction, a tree node deleting instruction, and a tree node creating instruction; The cancel instruction is used to restore the data and format in the tree structure; The formatter instruction is used to clear all the aircraft weight characteristic data and format in the tree structure; The level upgrade instruction is used to promote or demote the node level of the selected tree node by one level; The tree node moving instruction is used to move the selected tree node up and down after disassembling and recombining the selected tree node in the tree structure; The tree node deleting instruction is used to delete the selected tree node level identifier in the tree structure, so that the tree node no longer participates in the calculation and interactive operation in the tree structure; The tree node creating instruction is used to set the selected cell as a tree node of a corresponding level, wherein the tree node creating instruction has 1 to M levels, thereby achieving the creation of M levels of tree nodes, the level identifier of each tree node creating instruction is set as the identifier of the corresponding level of the tree node, and in response to the selected cell in the tree structure and the tree node creating instruction button, the level identifier of the selected cell is set as the level identifier corresponding to the tree node creating instruction, and M>1.

4. The tabulated aircraft weight tree hierarchy interaction method of claim 3, wherein, The process of moving the selected tree node up and down after disassembling and recombining the selected tree node in the tree structure comprises: S31, selecting a tree node to be disassembled in the tree structure, and if the child tree nodes need to be disassembled together, selecting no less than Q columns, Q>1; S32, judging the number of selected rows and columns, if the number of selected columns exceeds Q columns, executing step S33, and if the number of selected columns does not exceed Q columns, executing step S34; S33: determine the child tree nodes of each tree node in the selected range; S34: respond to the tree node moving instruction to disassemble the selected tree node; S35: select the position of the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the position; S36: respond to the level up and down instruction button to adjust the level of the reorganized tree node to the target level.

5. A tabularized aircraft weight tree hierarchy interaction device, characterized by, Comprise: a data import module for obtaining a tabular aircraft weight tree hierarchy; a tree node selection module for selecting a range of tree nodes in the tree hierarchy that are to participate in interactive operation in response to the selected range, judging the cells in the selected range to obtain the tree nodes to be interactively operated, the process comprising: S21: obtain the selected range in the tree hierarchy, and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selected range; S22: determine whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if yes, execute step S23, if not, execute step S24; S23: determine whether the cells in the selected range are selected from only one column by the condition LimC01=LimC02, if yes, execute S27, if not, execute step S24; S24: determine whether the cells in the selected range meet the requirements by the condition LimC01-LimC02>N, if yes, execute step S25, if not, execute step S26, wherein N is a natural number; S25: select all tree nodes and their child tree nodes in the selected range; S26: select all tree nodes in the selected range; S27: select all tree nodes in the tree hierarchy; an interactive processing module for performing corresponding interactive operation processing on the tree nodes to be interactively operated in response to the selected operation instruction.

6. The listed aircraft weight tree hierarchy interaction apparatus of claim 5, wherein, The tree hierarchy is an Excel table file.

7. The listed aircraft weight tree hierarchy interaction apparatus of claim 6, wherein, The operation instruction includes a cancel instruction, a formatter instruction, a level upgrade instruction, a tree node moving instruction, a tree node deletion instruction, and a tree node creation instruction; The cancel instruction is used to restore the data and format in the tree hierarchy; The formatter instruction is used to clear all aircraft weight characteristic data and format in the tree hierarchy; The level upgrade instruction is used to promote or demote the node level of the selected tree node by one level; The tree node moving instruction is used to disassemble and reorganize the selected tree node in the tree hierarchy and move the tree node up and down; The tree node deletion instruction is used to delete the selected tree node level identifier in the tree hierarchy, which no longer participates in the calculation and interactive operation in the tree hierarchy; The tree node creation instruction is used to set the selected cell as a tree node of the corresponding level, wherein the tree node creation instruction has 1-M levels, thereby realizing the creation of M-level tree nodes, the level identifier of each tree node creation instruction is set as the identifier of the corresponding level of the tree node, and the level identifier of the selected cell is set as the level identifier corresponding to the tree node creation instruction in response to the selected cell in the tree hierarchy and the tree node creation instruction button, M>1.

8. The listed aircraft weight tree hierarchy interaction apparatus of claim 7, wherein, The process of moving the selected tree node up and down in the tree hierarchy after disassembling and reassembling the selected tree node includes: S31: selecting the tree node to be disassembled in the tree hierarchy, and selecting no less than Q columns if the sub-level tree node needs to be disassembled, Q>1; S32: judging the number of columns of the selected tree node, if the number of columns exceeds Q, executing step S33, if not, executing step S34; S33: determining the sub-level tree node of each tree node in the selected range; S34: disassembling the selected tree node in response to the tree node moving instruction; S35: selecting the position of the reassembled tree node in the tree hierarchy, and pasting the disassembled tree node to the position; S36: adjusting the level of the reassembled tree node to the target level in response to the level up and down instruction button.

9. An electronic device, comprising: Comprise: One or more processors; Memory; One or more application programs stored in the memory and configured to be executed by the one or more processors, the one or more application programs being configured for implementing the list-based aircraft weight tree hierarchy interaction method according to any one of claims 1-4.

10. A computer storage medium, characterized in that, The computer storage medium stores at least one instruction, at least one program, a code set or an instruction set, which is loaded and executed by the processor to implement the list-based aircraft weight tree hierarchy interaction method according to any one of claims 1-4.

Citation Information

Patent Citations

  • Table processing method and device, equipment, storage medium and product

    CN114281823A