Listed aircraft weight tree hierarchical structure interaction method and device
Through the list-based aircraft weight tree hierarchical structure interaction method, the problem that aircraft weight data cannot interact directly in the tree structure is solved, and the interactive operation and data editing of aircraft weight characteristic data is realized efficiently and accurately processed in Excel tables.
Patent Information
- Application Number
- CN202411873342.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-18
- Publication Date
- 2025-03-25
- Estimated Expiration
- 2044-12-18
AI Technical Summary
During the overall aircraft design process, after the aircraft weight characteristic data is exported from the three-dimensional design software, the tree structure cannot be directly interoperated, and when modifying the wrong data in the Excel table, it is difficult to take into account the convenience of interaction and the convenience of data editing.
A list-based interaction method for tree-like hierarchical structure is provided. By obtaining the tabular tree-like hierarchical structure, it realizes the interactive operation processing of tree nodes in response to tree node selection range and operation instructions.
Interoperate aircraft weight characteristic data smoothly in the tree hierarchy like operating a tree structure, improving the efficiency and accuracy of data preprocessing, taking into account the convenience of interactive operation and data editing.
Smart Images

Figure CN119690283A_ABST
Abstract
Description
Technical Field
[0001] The present application belongs to the field of aircraft weight data processing, and in particular relates to a method and device for interacting with a tree-like hierarchical structure of listed aircraft weights. Background Art
[0002] During the overall design of an aircraft, the weight characteristic data of the aircraft is often exported from different 3D design software. When the data is summarized in the weight specialty, the tree structure of the data has been tabulated, and it is not possible to directly interact with it like a tree structure. Considering that there are still many errors in the weight characteristic data set in the pre-processing stage, the errors need to be modified in the Excel table, and the convenience of editing data in Excel cannot be lost, so structured management cannot be performed in mainstream structured software. The convenience of interactive operation and the convenience of data modification and editing cannot be taken into account at the same time.
[0003] Therefore, the field of aircraft overall design requires a method and tool that can interactively operate the aircraft weight characteristic data set in a table like a tree structure without affecting the convenience of modifying and editing the data set in an Excel table. Summary of the invention
[0004] The purpose of the present application is to provide a method for interacting with a tree-like hierarchical structure of listed aircraft weights to solve or alleviate at least one problem in the background technology.
[0005] The technical solution of the present application is: a method for interactively listing the tree-like hierarchical structure of aircraft weight, comprising:
[0006] S10, obtaining a tabular tree hierarchy structure of aircraft weight;
[0007] S20, in response to a selection range of tree nodes to be involved in an interactive operation selected in the tree hierarchy, determining cells within the selection range to obtain a tree node to be interactively operated;
[0008] S30, in response to the selected operation instruction, performing corresponding interactive operation processing on the tree node to be interactively operated.
[0009] Preferably, the tree-like hierarchical structure is an Excel spreadsheet file.
[0010] Preferably, in step S20, in response to checking a selection range of tree nodes to be involved in an interactive operation in the tree hierarchy, the selection range is judged to obtain a tree node to be interactively operated, and the process includes:
[0011] S21: Get the selection range in the tree hierarchy structure, and extract 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 cells in the selected range are in a single row by the condition LimR01=LimR02, if so, executing step S23, if not, executing step S24;
[0013] S23: judging whether only one column is selected in the selected range of cells by the condition of LimC01=LimC02, if yes, executing S27, if no, executing step S24;
[0014] S24: judging whether the number of cells in the selected range is not less than M by the condition LimC02-LimC01>N, if yes, executing step S25, if no, executing step S26, wherein N and M are natural numbers;
[0015] S25: Select all tree nodes and their child tree nodes within the selection range;
[0016] S26: Select all tree nodes within the selection range;
[0017] S27: Select all tree nodes in the tree hierarchy.
[0018] Preferably, the operation instructions include undo instructions, format program instructions, level upgrade instructions, tree node move instructions, tree node delete instructions, and tree node create instructions;
[0019] Wherein, the undo instruction is used to restore the data and format in the tree-like hierarchical structure;
[0020] The formatter instruction is used to clear all aircraft weight characteristic data and formats in the tree hierarchy;
[0021] The level up / down instruction is used to raise or lower the node level of the selected tree node by one level;
[0022] The tree node movement is used to disassemble and reorganize the selected tree nodes in the tree hierarchy and then move the tree nodes up and down;
[0023] The tree node deletion instruction is used to delete the selected tree node level identifier in the tree hierarchy structure, and no longer participate in the calculation and interaction operations in the tree hierarchy structure;
[0024] The tree node creation instruction is used to set the selected cell as a tree node of the corresponding level, where the tree node creation instructions have 1-M levels, thereby realizing the creation of a total of M levels of tree nodes. The level identifier of each tree node creation instruction is set to the identifier of the corresponding level of the tree node. In response to the selected cell in the tree hierarchy structure and the tree node creation instruction button, the level identifier of the selected cell is set to the level identifier corresponding to the tree node creation instruction.
[0025] Preferably, the process of disassembling and reassembling the selected tree nodes in the tree hierarchy and then moving the tree nodes up and down comprises:
[0026] S31: Select the tree node to be disassembled in the tree hierarchy structure. If it is necessary to disassemble the tree node with its child nodes, select no less than M columns.
[0027] S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds M columns, execute step S33; if it does not exceed M columns, execute step S34;
[0028] S33: Determine the child tree nodes of each tree node in the selected range;
[0029] S34: responding to the tree node move instruction to disassemble the selected tree node;
[0030] S35: Select a location for the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the location;
[0031] S36: Respond to the level up / down command button to adjust the level of the reorganized tree node to the target level.
[0032] On the other hand, the present application provides a device for interacting with a tree-like hierarchical structure of aircraft weight after listing, comprising:
[0033] Data import module, used to obtain the tabulated tree hierarchy of aircraft weight;
[0034] A tree node selection module, for responding to a selected range of tree nodes to be interactively operated in the tree hierarchy, and determining cells within the selected range to obtain a tree node to be interactively operated;
[0035] The interaction processing module is used to perform corresponding interaction operation processing on the tree node to be interactively operated in response to the selected operation instruction.
[0036] Preferably, the tree-like hierarchical structure is an Excel spreadsheet file.
[0037] Preferably, in response to checking a selection range of tree nodes to be involved in an interactive operation in the tree hierarchy, the selection range is judged to obtain the tree nodes to be interactively operated, and the process includes:
[0038] S21: Get the selection range in the tree hierarchy structure, and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selection range;
[0039] S22: judging whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if so, executing step S23, if not, executing step S24;
[0040] S23: judging whether only one column is selected in the selected range of cells by the condition of LimC01=LimC02, if yes, executing S27, if no, executing step S24;
[0041] S24: judging whether the number of cells in the selected range is not less than M by the condition LimC02-LimC01>N, if yes, executing step S25, if no, executing step S26, wherein N and M are natural numbers;
[0042] S25: Select all tree nodes and their child tree nodes within the selection range;
[0043] S26: Select all tree nodes within the selection range;
[0044] S27: Select all tree nodes in the tree hierarchy.
[0045] Preferably, the operation instructions include undo instructions, format program instructions, level upgrade instructions, tree node move instructions, tree node delete instructions, and tree node create instructions;
[0046] Wherein, the undo instruction is used to restore the data and format in the tree-like hierarchical structure;
[0047] The formatter instruction is used to clear all aircraft weight characteristic data and formats in the tree hierarchy;
[0048] The level up / down instruction is used to raise or lower the node level of the selected tree node by one level;
[0049] The tree node movement is used to disassemble and reorganize the selected tree nodes in the tree hierarchy and then move the tree nodes up and down;
[0050] The tree node deletion instruction is used to delete the selected tree node level identifier in the tree hierarchy structure, and no longer participate in the calculation and interaction operations in the tree hierarchy structure;
[0051] The tree node creation instruction is used to set the selected cell as a tree node of the corresponding level, where the tree node creation instructions have 1-M levels, thereby realizing the creation of a total of M levels of tree nodes. The level identifier of each tree node creation instruction is set to the identifier of the corresponding level of the tree node. In response to the selected cell in the tree hierarchy structure and the tree node creation instruction button, the level identifier of the selected cell is set to the level identifier corresponding to the tree node creation instruction.
[0052] Preferably, the process of disassembling and reassembling the selected tree nodes in the tree hierarchy and then moving the tree nodes up and down comprises:
[0053] S31: Select the tree node to be disassembled in the tree hierarchy structure. If it is necessary to disassemble the tree node with its child nodes, select no less than M columns.
[0054] S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds M columns, execute step S33; if it does not exceed M columns, execute step S34;
[0055] S33: Determine the child tree nodes of each tree node in the selected range;
[0056] S34: responding to the tree node move instruction to disassemble the selected tree node;
[0057] S35: Select a location for the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the location;
[0058] S36: Respond to the level up / down command button to adjust the level of the reorganized tree node to the target level.
[0059] In a third aspect, the present application provides an electronic device, including:
[0060] one or more processors;
[0061] Memory;
[0062] One or more applications, the one or more applications are stored in the memory and are configured to be executed by the one or more processors, the one or more applications are configured to implement the listed aircraft weight tree hierarchy interaction method as described in any one of the above items.
[0063] In a final 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, wherein the at least one instruction, the at least one program, the code set or the instruction set is loaded and executed by a processor to implement the listed aircraft weight tree hierarchy interaction method as described in any of the above items.
[0064] The aircraft weight tree hierarchy interaction method and device listed in the present application can interactively operate aircraft weight characteristic data in the tree hierarchy (Excel table) as smoothly as operating a tree structure. The efficiency of data pre-processing is significantly improved compared with conventional methods, and the accuracy of data pre-processing is greatly improved compared with conventional manual methods. BRIEF DESCRIPTION OF THE DRAWINGS
[0065] In order to more clearly illustrate the technical solution provided by the present application, the following is a brief introduction to the accompanying drawings. Obviously, the accompanying drawings described below are only some embodiments of the present application.
[0066] Figure 1Schematic diagram of the interactive method of the tree hierarchy structure of aircraft weight after the list of this application.
[0067] Figure 2 This is a schematic diagram of the process of processing tree nodes in the selected range in this application.
[0068] Figure 3 This is a schematic diagram of the operation instruction panel in this application.
[0069] Figure 4 Schematic diagram of the interactive device for the tree hierarchy structure of aircraft weight after the list of this application.
[0070] Figure 5 A schematic diagram of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION
[0071] In order to make the purpose, technical solutions and advantages of the implementation of this application clearer, the technical solutions in the embodiments of this application will be described in more detail below in conjunction with the drawings in the embodiments of this application.
[0072] The present application provides a method and device for interactive operation of a tree-like hierarchical structure of aircraft weight after being tabulated. For interactive operations such as creation, deletion, disassembly and reorganization commonly used in the tree-like hierarchical structure data of aircraft weight, a data processing method in the tree-like hierarchical structure table of aircraft weight is provided to ensure that the tree-like hierarchical structure of aircraft weight characteristic data after being tabulated can be interactively operated in an orderly manner.
[0073] like Figure 1 As shown, the weight tree hierarchy interaction operation method after the list provided by this application includes:
[0074] S10, obtaining a tabular tree-like hierarchical structure table of aircraft weight;
[0075] Table 1 shows an example of a tabulated tree hierarchy structure of aircraft weight provided in this embodiment of the present application, and the tree hierarchy structure is an Excel spreadsheet file. In the present application, data levels are identified by different colors or different background patterns, and the main basis of data levels is the assembly level number.
[0076] Table 1 Tabulated tree hierarchy of aircraft weight
[0077]
[0078] S20: In response to a selection range of tree nodes to be involved in an interactive operation selected in the tree hierarchy, cells within the selection range are judged to obtain tree nodes to be interactively operated.
[0079] like Figure 2The following is a rule flow of processing the tree nodes of the selected range in the tree hierarchy of this application, and the specific steps are as follows:
[0080] S21: Obtain the selection range in the tree hierarchy (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 selection range;
[0081] S22: judging whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if so, executing step S23, if not, executing step S24;
[0082] S23: judging whether only one column is selected in the selected range of cells by the condition of LimC01=LimC02, if yes, executing S27, if no, executing step S24;
[0083] S24: judging whether the number of cells in the selected range is not less than M by the condition LimC02-LimC01>N, if yes, executing step S25, if no, executing step S26, N and M are natural numbers;
[0084] S25: Select all tree nodes and their child tree nodes within the selection range;
[0085] S26: Select all tree nodes within the selection range;
[0086] S27: Select all tree nodes in the tree hierarchy.
[0087] In some embodiments of the present application, the value of M is 10, that is, the process of selecting a tree node in the above tree hierarchy can be expressed as:
[0088] When one cell is selected, all tree nodes are considered to be selected; when multiple but less than 10 cells in a single row are selected, the tree node corresponding to the row is considered to be selected; when a single row is selected and no less than 10 cells are selected, the tree node corresponding to the row and all its child tree nodes are considered to be selected; when multiple rows are selected but less than 10 cells in each row are selected, the selected tree node itself is considered to be selected; when multiple rows are selected but no less than 10 cells in each row are selected, the selected tree node itself and all its child tree nodes are considered to be selected.
[0089] S30, in response to the selected operation instruction, performing corresponding interactive operation processing on the tree node to be interactively operated.
[0090] like Figure 3 The following is a schematic diagram of the operation instruction panel in this application. The operation instructions include:
[0091] 1) Undo command: record the data and format before the operation in advance, and restore the data and format in the tree hierarchy (i.e. Excel table) after clicking the Undo command button;
[0092] 2) Formatter command: Click the Formatter command button to clear all aircraft weight characteristic data and formats in the tree hierarchy;
[0093] 3) Level Up / Down (▲▼) Commands: Click the upward arrow (▲) to increase the level of the selected tree node by one level, and click the downward arrow (▼) to decrease the level of the selected tree node by one level;
[0094] 4) Tree node move (↑↓) command: Click the tree node move command button to disassemble and reorganize the selected tree node in the tree hierarchy and then move the tree node up and down;
[0095] See Figure 4 The specific steps of the process of the tree node in the tree hierarchy in this application are as follows:
[0096] S31: Select the tree node to be disassembled in the tree hierarchy structure. If it is necessary to disassemble the tree node with its child nodes, select no less than M columns.
[0097] S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds M columns, execute step S33; if it does not exceed M columns, execute step S34;
[0098] S33: Determine the child tree nodes of each tree node in the selected range;
[0099] S34: responding to the tree node move instruction to disassemble the selected tree node;
[0100] S35: Select a location for the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the location;
[0101] S36: Respond to the level up / down command button to adjust the level of the reorganized tree node to the target level.
[0102] 5) Tree node deletion command: Clicking the tree node deletion command button can delete the level identification of the selected tree node in the tree hierarchy (for example, it can be identified by different colors), and it will no longer participate in the calculation and interactive operations in the tree hierarchy; among them, if the number of columns in the selected range is less than M rows, only the level identification of the selected row is removed, otherwise the level identification of the selected row and the row where the child tree nodes of the selected row are located are removed.
[0103] 6) Tree node creation instruction: Clicking the tree node creation instruction button can set the selected cell to a tree node of the corresponding level, where the tree node creation instructions have 1-M levels, thereby achieving the creation of a total of M levels of tree nodes. The level identifier (i.e., color) of each tree node creation instruction is set to the level identifier (color) corresponding to the tree node. In response to the selected cell in the tree hierarchy and the tree node creation instruction button, the level identifier (color) of the selected cell can be set to the level identifier (color) corresponding to the tree node creation instruction, achieving the equivalent effect of tree node creation.
[0104] The aircraft weight tree hierarchy interaction method after the list of the present application can interactively operate the aircraft weight characteristic data in the tree hierarchy (Excel table) as smoothly as operating a tree structure. The efficiency of data pre-processing is significantly improved compared with conventional methods, and the accuracy of data pre-processing is greatly improved compared with conventional manual methods.
[0105] like Figure 4 As shown, the present application also provides a device for interacting with a tree-like hierarchical structure of aircraft weight after tabulation, and the device 100 includes:
[0106] The data import module 101 is used to obtain the tabulated tree structure of aircraft weight;
[0107] The tree node selection module 102 is used to respond to the selected tree node selection range to be involved in the interactive operation in the tree hierarchy structure, and to judge the cells in the selection range to obtain the tree node to be interactively operated;
[0108] The interaction processing module 103 is used to perform corresponding interaction operation processing on the tree node to be interactively operated in response to the selected operation instruction.
[0109] For the processing process of the aircraft weight tree hierarchy structure interaction device of the present application, reference may be made to the content of the aircraft weight tree hierarchy structure interaction method.
[0110] like Figure 5 As shown, an embodiment of the present application also provides an electronic device 200, which includes a processing device 201, which can perform various appropriate actions and processes according to a program stored in a ROM (read-only memory) 202 or a program loaded from a storage device 208 to a RAM (random access memory) 203. The processing device 201 may include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (for example, an application-specific integrated circuit (ASIC)), etc. The processing device 201 may also include an onboard memory for caching purposes. The processing device 201 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.
[0111] In RAM 203, various programs and data required for the operation of electronic device 200 are stored. Processing device 201, ROM 202 and RAM 203 are connected to each other via bus 204. Processing device 201 performs various operations of the method flow according to the embodiment of the present application by executing the program in ROM 202 and / or RAM 203. It should be noted that the program can also be stored in one or more memories other than ROM 202 and RAM 203. Processing device 201 can also perform various operations of the method or flow according to the embodiment of the application by executing the program stored in the one or more memories.
[0112] According to an embodiment of the present application, the electronic device 200 may further include an I / O interface 205 (input / output interface), which is also connected to the bus 204. The electronic device 200 may further include one or more of the following components connected to the I / O interface 205: an input device 206 including a keyboard, a mouse, etc.; an output device 207 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage device 208 including a hard disk, etc.; and a communication device 209 including a network interface card such as a LAN card, a modem, etc. The communication device 209 performs communication processing via a network such as the Internet. A drive is also connected to the I / O interface 205 as needed. Removable media, such as magnetic disks, optical disks, magneto-optical disks, semiconductor memories, etc., are installed on the drive as needed so that the computer program read therefrom is installed into the storage device 208 as needed.
[0113] The present application also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, various operations of the above methods or processes according to the embodiments of the present application are implemented.
[0114] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed in the present application should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.
Claims
1. A method for interactively calculating a tree-like hierarchical structure of aircraft weight after tabulation, characterized in that: include: S10, obtaining a tabular tree hierarchy structure of aircraft weight; S20, in response to a selection range of tree nodes to be involved in an interactive operation selected in the tree hierarchy, determining cells within the selection range to obtain a tree node to be interactively operated; S30, in response to the selected operation instruction, performing corresponding interactive operation processing on the tree node to be interactively operated.
2. The method for interactively viewing the tree-like hierarchical structure of aircraft weights after tabulation as claimed in claim 1, characterized in that: The tree-like hierarchical structure is an Excel table file.
3. The method for interactively viewing the tree-like hierarchical structure of aircraft weights after tabulation as claimed in claim 1, characterized in that: In step S20, in response to checking the selection range of tree nodes to be involved in the interactive operation in the tree hierarchy, the selection range is judged to obtain the tree nodes to be interactively operated, and the process includes: S21: Get the selection range in the tree hierarchy structure, and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selection range; S22: judging whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if yes, executing step S23, if no, executing step S24; S23: judging whether only one column is selected in the selected range of cells by the condition of LimC01=LimC02, if yes, executing S27, if no, executing step S24; S24: judging whether the number of cells in the selected range is not less than M by the condition LimC02-LimC01>N, if yes, executing step S25, if no, executing step S26, wherein N and M are natural numbers; S25: Select all tree nodes and their child tree nodes within the selection range; S26: Select all tree nodes within the selection range; S27: Select all tree nodes in the tree hierarchy.
4. The method for interactively viewing the tree-like hierarchical structure of aircraft weights after tabulation as claimed in claim 3, characterized in that: The operation instructions include undo instructions, format program instructions, level upgrade instructions, tree node move instructions, tree node delete instructions, and tree node create instructions; Wherein, the undo instruction is used to restore the data and format in the tree-like hierarchical structure; The formatter instruction is used to clear all aircraft weight characteristic data and formats in the tree hierarchy; The level up / down instruction is used to raise or lower the node level of the selected tree node by one level; The tree node movement is used to disassemble and reorganize the selected tree nodes in the tree hierarchy and then move the tree nodes up and down; The tree node deletion instruction is used to delete the selected tree node level identifier in the tree hierarchy structure, and no longer participate in the calculation and interaction operations in the tree hierarchy structure; The tree node creation instruction is used to set the selected cell as a tree node of the corresponding level, where the tree node creation instructions have 1-M levels, thereby realizing the creation of a total of M levels of tree nodes. The level identifier of each tree node creation instruction is set to the identifier of the corresponding level of the tree node. In response to the selected cell in the tree hierarchy structure and the tree node creation instruction button, the level identifier of the selected cell is set to the level identifier corresponding to the tree node creation instruction.
5. The method for interactively viewing the tree-like hierarchical structure of aircraft weight after tabulation as claimed in claim 4, characterized in that: The process of disassembling and reassembling the selected tree nodes and moving the tree nodes up and down in the tree hierarchy includes: S31: Select the tree node to be disassembled in the tree hierarchy structure. If it is necessary to disassemble the tree node with its child nodes, select no less than M columns. S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds M columns, execute step S33; if it does not exceed M columns, execute step S34; S33: Determine the child tree nodes of each tree node in the selected range; S34: responding to the tree node move instruction to disassemble the selected tree node; S35: Select a location for the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the location; S36: Respond to the level up / down command button to adjust the level of the reorganized tree node to the target level.
6. A tree-like hierarchical structure interactive device for aircraft weight after tabulation, characterized in that: include: Data import module, used to obtain the tabulated tree hierarchy of aircraft weight; A tree node selection module, for responding to a selected range of tree nodes to be interactively operated in the tree hierarchy, and determining cells within the selected range to obtain a tree node to be interactively operated; The interaction processing module is used to perform corresponding interaction operation processing on the tree node to be interactively operated in response to the selected operation instruction.
7. The interactive device for the tree-like hierarchical structure of the listed aircraft weight according to claim 6, characterized in that: The tree-like hierarchical structure is an Excel table file.
8. The interactive device for the tree-like hierarchical structure of listed aircraft weights according to claim 1, characterized in that: In response to checking a selection range of tree nodes to be involved in an interactive operation in a tree hierarchy, determining the selection range to obtain a tree node to be interactively operated, the process includes: S21: Get the selection range in the tree hierarchy structure, and extract the maximum and minimum row numbers LimR01, LimR02 and column numbers LimC01, LimC02 of the cells in the selection range; S22: judging whether the cells in the selected range are in a single row by the condition LimR01=LimR02, if yes, executing step S23, if no, executing step S24; S23: judging whether only one column is selected in the selected range of cells by the condition of LimC01=LimC02, if yes, executing S27, if no, executing step S24; S24: judging whether the number of cells in the selected range is not less than M by the condition LimC02-LimC01>N, if yes, executing step S25, if no, executing step S26, wherein N and M are natural numbers; S25: Select all tree nodes and their child tree nodes within the selection range; S26: Select all tree nodes within the selection range; S27: Select all tree nodes in the tree hierarchy.
9. The interactive device for the tree-like hierarchical structure of the listed aircraft weight according to claim 8, characterized in that: The operation instructions include undo instructions, format program instructions, level upgrade instructions, tree node move instructions, tree node delete instructions, and tree node create instructions; Wherein, the undo instruction is used to restore the data and format in the tree-like hierarchical structure; The formatter instruction is used to clear all aircraft weight characteristic data and formats in the tree hierarchy; The level up / down instruction is used to raise or lower the node level of the selected tree node by one level; The tree node movement is used to disassemble and reorganize the selected tree nodes in the tree hierarchy and then move the tree nodes up and down; The tree node deletion instruction is used to delete the selected tree node level identifier in the tree hierarchy structure, and no longer participate in the calculation and interaction operations in the tree hierarchy structure; The tree node creation instruction is used to set the selected cell as a tree node of the corresponding level, where the tree node creation instructions have 1-M levels, thereby realizing the creation of a total of M levels of tree nodes. The level identifier of each tree node creation instruction is set to the identifier of the corresponding level of the tree node. In response to the selected cell in the tree hierarchy structure and the tree node creation instruction button, the level identifier of the selected cell is set to the level identifier corresponding to the tree node creation instruction.
10. The interactive device for the tree-like hierarchical structure of the listed aircraft weight according to claim 9, characterized in that: The process of disassembling and reassembling the selected tree nodes and moving the tree nodes up and down in the tree hierarchy includes: S31: Select the tree node to be disassembled in the tree hierarchy structure. If it is necessary to disassemble the tree node with its child nodes, select no less than M columns. S32: Determine the number of rows and columns of the selected tree node. If the number of selected columns exceeds M columns, execute step S33; if it does not exceed M columns, execute step S34; S33: Determine the child tree nodes of each tree node in the selected range; S34: responding to the tree node move instruction to disassemble the selected tree node; S35: Select a location for the reorganized tree node in the tree hierarchy, and paste the disassembled tree node to the location; S36: Respond to the level up / down command button to adjust the level of the reorganized tree node to the target level.
11. An electronic device, characterized in that: include: one or more processors; Memory; One or more applications, the one or more applications are stored in the memory and configured to be executed by the one or more processors, the one or more applications are configured to implement the listed aircraft weight tree hierarchy interaction method according to any one of claims 1 to 5.
12. 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, and the at least one instruction, the at least one program, the code set or the instruction set are loaded and executed by the processor to implement the listed aircraft weight tree hierarchy interaction method as described in any one of claims 1 to 5.
Citation Information
Patent Citations
Tree-based equipment selection method and system and related equipment
CN113055235A
Table processing method and device, equipment, storage medium and product
CN114281823A
Data processing method and device, electronic equipment and computer readable storage medium
CN114282069A
System and method for standardized processing of webpage table
CN114385948A
System and method for viewing selected descendant nodes in a tree hierarchy displayed in tabular form
US20140059488A1