Method for generating multi-modal spreadsheet

Abstract

Disclosed in the present invention is a method for generating a multi-modal spreadsheet. The method comprises: by means of establishing a human-machine interaction interface, recording types and entries, which are input into a sheet by a terminal user, into a computer memory and a local style sheet file; by means of human-machine interaction, performing operations, such as addition, deletion and modification, on the sheet types and entries input by the user, and storing same in the local style sheet file; on the basis of the local style sheet file and by means of human-machine interaction, responding to a request of the user to create a sheet of a user-defined style, and creating a blank content sheet file; and in response to the request of the user, performing operations, such as addition, deletion and the modification of rows and columns, on content of a content sheet by means of human-machine interaction.

Description

A Polymorphic Electronic Form Generation Method Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method for generating a polymorphic electronic form and the use of a multi-level storage format of a file structure, an organizational form, and a processing method necessary for implementing the method. Background Art

[0002] As a commonly used way to organize and express information in daily work and life, tables mainly function to organize and summarize information to facilitate reading.

[0003] In the existing technology, the mainstream technology is table text editing technology represented by Excel. Its original design intention was mainly to unify the text box input structure, which is not conducive to the daily life's demand for polymorphic functions such as single selection, multiple selection, and picture recording. Technical issues

[0004] In traditional technologies such as Excel, the title and content of a table are integrated into a universal input unit. When editing a fixed template, a blank template file with a title is generally saved as a file, and then the actual files are edited and stored separately. There is no substantial distinction between the title and content, nor is there any substantial connection between the same template files. Although this improves the flexibility of table editing, for scenarios where a large number of different contents are repeatedly entered using the same template, when the title information of a fixed template needs to be changed for expansion, all generated files need to be separated one by one, which has certain inconveniences. At the same time, this universal input unit cannot meet the diverse nature of input requirements such as multiple selection, single selection, and picture units. Technical Solutions

[0005] In the present invention, the title and content of the table are first substantially edited and stored separately. The title is edited through a style table file, and the content is edited through a content table file. Only after the style table file is created is it allowed to create a corresponding content table file and place the title bar above the table.

[0006] The present invention allows users to choose to associate the new table of contents with a source style sheet or not when creating a blank table of contents. When establishing an association, preset information such as the table of contents title bar needs to be completed by modifying the source style sheet. When there are multiple table of contents from the same source style file, modifications to the source style file can modify the title information of all associated table of contents to improve its initial convenience. In this case, editing of the title and other formats is not allowed in the table of contents. When choosing not to establish an association, the table of contents and the source style sheet can be regarded as two independent file units. Modifications to information such as the title bar in the table of contents are performed by modifying the style information copied to the header of the table of contents file. After the modification, the information is no longer the same as the source style sheet file information. When the user has actual needs, the new style information can also be exported from the table of contents to form a new style sheet file.

[0007] As of the date of this application, 13 types of table cell formats have been added to the style information, including "field", "short text", "long text", "extra long text", "value", "formula", "date year-month-day", "date hour and minute", "date year-month-day hour and minute", "single choice", "multiple choice one", "multiple choice multiple", and "picture". These formats are required to be selected and set together when the user creates or edits a style table file to preset a title for the table; after the user selects the corresponding format, when the user creates a new blank content table file based on the style table file, in the table of the content table file, text editing controls or button controls are used to draw table cells and combine them into a table according to different format types; when the format type is a text editing control, it mainly triggers the detection of text length and format (mainly used in formulas); when the format type is a button, it mainly triggers the editing, setting and operation of the corresponding format editor, such as year selector, month selector, day selector, hour selector, minute selector, single choice selector, multiple choice selector, and picture selector.

[0008] The purpose of the present application method is to provide a polymorphic table editing method, so that people can conveniently record information items such as dates, single-choice, multiple-choice, pictures, etc. that need to be repeatedly input in the same format and are difficult to handle during editing in daily life.

[0009] On the one hand, this application provides a pre-editing function for tables, which requires users to clarify the style of the table they want to create before creating a formal table, and record the style requirement information such as title name (item), serial number, expression form (type), etc. in the form of a style table file in the storage medium.

[0010] A human-computer interaction interface is designed in the system and a method program is embedded to summarize the table type information required by the user into the local memory through the human-computer interaction combination interface.

[0011] After obtaining the table type requirement information of the user in the human-computer interaction interface, the table type information in the memory is stored in the system local storage medium in the form of a style sheet file after the user confirms it by key response.

[0012] The end user can operate and edit the stored style sheet files through an independent window.

[0013] The background processing of user editing operations such as adding, deleting, and modifying style sheet files is different.

[0014] Users can use the style sheet merging function to add a single item type to a style sheet by specifying the merge object as the source file of a basic style sheet. Users can also add multiple style sheet items at once by specifying the merge object as an edited style sheet file.

[0015] Users can delete items in the style sheet by pressing the Delete button.

[0016] Users can adjust the order of style sheet items by pressing the up and down buttons.

[0017] Users can modify the names of each item in the style sheet by clicking the Modify Item Name button, that is, modify the table title name of the future content table.

[0018] Users can establish specified calculation relationships with other numerical items by modifying the content of the formula item.

[0019] The user can change the preset values ​​of single-select and multiple-select selectors by modifying them, that is, setting the corresponding parameter values ​​of single-select selectors and multiple-select selectors in the future content table.

[0020] Users can change the name of a style sheet file by modifying the name of the style sheet.

[0021] The user can perform more operations on the temporary files of the style sheet through the callback or forward button or the temporary file group operation interface.

[0022] As of the date of this application, the item types of the style sheet are divided into 13 items: field, short text, long text, extra-long text, value, formula, date year-month-day, date hour-minute, date year-month-day hour-minute, single choice, multiple choice one, multiple choice multiple and picture; it should be understood that through the variable-length file format construction method, the item types of the style sheet shown in this application can still be freely added and updated in the later stage without affecting the use of the old version.

[0023] On the other hand, users can add a new blank table of contents file operation through the Create New Blank Table of Contents function in the Style Table Operation window.

[0024] Empty Table The title and format of the table of contents are defined according to the format of the style sheet file used when it was created.

[0025] The system will copy the complete information of the source style sheet file to the file header of the blank content sheet to ensure that the content sheet can still be used normally if the original style sheet file is lost.

[0026] Changes to the title and formatting of a table of contents after it is created are independent of the source style sheet file used to create it.

[0027] In the content table, the table cells of fields, short texts, values, and formulas are implemented in the form of short text edit boxes; long texts and super long texts are implemented in the form of long text edit boxes; date year-month-day, date hour-minute, date year-month-day hour-minute, single selection, multiple selection one, multiple selection multiple, and pictures appear in the form of function buttons.

[0028] Among the function buttons, the date year-month-day, date hour-minute, and date year-month-day-hour-minute respond to the user's selection in the form of a year selector, month selector, day selector, hour selector, and minute selector; single selection responds to the user in the form of a single selection selector; multiple selection one and multiple selection multiple respond to the user in the form of a multiple selection selector; and picture responds to the user in the form of a picture selector.

[0029] For specific devices such as mobile terminals equipped with camera functions, the picture selector provides three methods: importing pictures from the device's built-in album, entering local pictures from the application, and entering the camera function.

[0030] In the edit box of the content table, a function key group for editing the rows and columns of the content table is set up.

[0031] In the function button group, the row add button can be used to add blank content to a specified row in the content table.

[0032] The row delete button can delete the specified row in the content table.

[0033] The row movement buttons can be used to move the specified row of the content table up or down.

[0034] Other operations, such as editing the table of contents title, that is, changing the table of contents style format, are completed by operating the built-in style table information in the header of the table of contents file.

[0035] The operations of adding header items and columns can be used to add columns to the content table.

[0036] The column deletion operation can delete the columns of the content table.

[0037] The column move up operation can be used to move up the columns of the content table.

[0038] The column move down operation can be used to move down the columns of the content table.

[0039] You can also edit the formulas in the formula column.

[0040] You can edit the preset contents of single-select and multi-select columns to change the parameter values ​​in the corresponding selectors.

[0041] The method of the present application provides the implementation of callback and forward functions for temporary files of each individual content table file, with the maximum number not exceeding a specified number.

[0042] The formulas in the design method of this application are expressed using the expression method represented by "#*", and negative numbers are represented by (-*); for example, "#1" represents a numerical column ranked as 1, "(-1)" represents a negative number, and so on.

[0043] During the formula entry stage, whether the formula is entered or modified in the sample table file, or the formula of the title in the content table file is modified, the method of this application strictly verifies the input format of the formula and declares that it only supports the calculation of limited character expressions including "+", "-", "*", " / ", ".", "()", ")"; the output result of the output formula unit is represented by "0" or "err" for the part that is entered incorrectly or exceeds the calculation capacity. Beneficial effects

[0044] The first benefit of the present invention is that it solves the problem of the traditional single-entry input method in spreadsheets such as Excel. It improves and supplements some functions that are not easy to implement in Excel, such as date, single selection, multiple selection, or drawing, which are relatively repetitive operations in daily life.

[0045] The advantages and improvements of the present application method lie in its polymorphism and its closer expression of table information in daily life. The more diverse input methods can meet different types of needs. At the same time, it can also better meet the creation problems of complex tables such as questionnaires and test papers. It is a functional improvement and extension of traditional table editing.

[0046] The second benefit of this method primarily stems from clarifying the file structures of style (title and format) and content, thereby opening up various possibilities for a two-tiered structure that links style and content table files. In certain scenarios, such as the creation of payroll tables in enterprise personnel management, since payrolls include a collection of multiple data items, such as base salary and performance-based salary, a single form can only record the specific information of one person at a time. Therefore, multiple forms with the same structure but different designated objects are required to represent the salary information of different individuals. In this case, a single style sheet file can quickly create multiple forms with the same structure but different designated objects, achieving a transition from a two-dimensional to a three-dimensional relational data model while reducing the time required to create forms with the same format, thereby improving productivity. Furthermore, if a linkage method is configured for tables within this three-dimensional relationship, changes to the format of any one table can automatically be applied to all forms with the same structure, significantly reducing the time and labor required to maintain the overall form structure and improving work efficiency.

[0047] The gain effect 3 of the present application method is mainly reflected in that the present application method provides personalized and customized services to users while reducing redundant data items for its own storage medium, thereby improving the space utilization efficiency of the storage medium. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] Figure 1 is a flowchart of the generation of a polymorphic electronic form provided by the present application method;

[0049] FIG2 is a schematic diagram of the structure of a sample table file provided by an example of the present application method;

[0050] FIG3 is a main diagram showing the structure of a table of contents file provided by an example of the present application method;

[0051] FIG4 is a diagram showing a table of contents file structure provided by an example of the present application method;

[0052] FIG5 is a schematic diagram of creating a sample table file provided by an example of the present application method;

[0053] FIG6 is a schematic diagram of a single-select selector button response provided by an example of the present application method;

[0054] FIG7 is a schematic diagram of a single-select content modification interface provided by an example of the present application method;

[0055] FIG8 is a schematic diagram of the structure of the basic unit of the style sheet (.fom) file;

[0056] Figure 9 is a schematic diagram of the structure of the basic unit of the table of contents (.xuc) file;

[0057] FIG10 is a flowchart of a specific implementation method of entering data in the second embodiment;

[0058] FIG11 is a flowchart for creating a form for entering data using a format list;

[0059] Figure 12 shows the SQL statement corresponding to the .fom file and employee name;

[0060] FIG13 is a schematic diagram of the results of three character string segmentation;

[0061] Figure 14 shows the processing of .dtt files;

[0062] Figure 15 is a schematic diagram of the content arrangement of .dtt;

[0063] Figure 16 shows the content of .dtt when it contains three sets of data;

[0064] [Corrected 28.02.2024 according to Rule 91] Figure 17 shows an example of repeated content in the createtable statement; [0064.1][Corrected 28.02.2024 according to Rule 91] Figure 18 shows the format of the .dtt file content. Best Mode for Carrying Out the Invention

[0065] This section describes a method for generating a polymorphic spreadsheet using the mobile terminal iPhone as an example. Because this method primarily involves a data structure for a two-level linked file structure and a diverse response method for polymorphic processing of specific items within a single table, its application should include all modern electronic devices with screen display output, central data processing, media storage, text box input, and user request event response capabilities.

[0066] Figure 1 is a schematic diagram of the process flow of the present application method. This diagram omits the process and steps of the method for constructing a human-computer interaction interface on different hardware and operating system platforms. It is assumed that professionals in this field have the ability to independently construct the relevant human-computer interaction interface. Therefore, the demonstration of this implementation method only provides a detailed explanation of the core file structure of the method.

[0067] The data structure used in this method primarily utilizes a key-value storage approach. Taking the iPhone's iOS platform as an example, data is stored using NSMutableDictionary and NSMutableArray in Objective-C. The built-in writetoFile functions of NSMutableDictionary and NSMutableArray allow data to be written to local files. Furthermore, the nested nature of NSMutableDictionary greatly enhances data storage flexibility.

[0068] NSMutableDictionary is ultimately stored in a file in XML format.

[0069] When reading the file contents, you only need to use the built-in reading function in NSMutableDictionary to automatically restore the data to the form of NSMutableDictionary.

[0070] Therefore, in a sense, the editing operation of the file content is simplified to the separate editing, adding, deleting and modifying operations on NSMutableDictionary.

[0071] In the program shown in this method, a style file is named .fom and a content file is named .xuc. However, no matter how they are named, they are essentially XML files.

[0072] The following is a brief introduction to the design specifications of the two files.

[0073] The characteristic of the pattern file (.fom) is that it is implemented in the form of NSMutableDictionary nested within a layer of NSArray.

[0074] As shown in Figure 2, the basic feature of a pattern file is that it is stored in a format where one key corresponds to one NSArray value. When reading data, the entire sequence is read by traversing from the key starting at 0 to the data size, and the .fom file is read into an entire NSMutableDictionary.

[0075] For a single NSAry, due to the different types of data, it is designed to be divided into 0-5 segments, which respectively represent character data, numerical and formula data, date data, single-select data, multiple-select data and picture data.

[0076] The basic settings of specific sample table file parameters are shown in Figure 8.

[0077] It should be noted that due to the extensibility of NSArray itself, as long as the setting of one key corresponding to one NSArray value in NSMutableDictionary remains unchanged, the value and length of NSArray can be flexible and changeable.

[0078] That is to say, as shown in the table above, each type can customize its own separate NSArray internal combination specifications. When reading NSArray, it is only necessary to read its accompanying identifier, such as the array[0] and array[2] component type identifiers used in the program shown in this application method. That is, different types of NSArray data can be read separately according to different types.

[0079] For example, if there is a need to extend the functionality of an edited type specification, by expanding the subscript of the additional length of NSArray, the data group can be expanded according to the needs of the program itself in any case while ensuring certain writing standards and readability.

[0080] Similar to the style sheet (.fom) file, the content sheet (.xuc) file uses a relatively more complex nested combination of NSMutalbeDictionary to store data.

[0081] As shown in Figure 3, for each key less than 100, key=0 stores the style table dictionary in the form of NSMutableDictionary, and key=1 to key=99 store the configuration information of the content table. Here, the Dictionary with key=0 is the dataset of the copied source style table file.

[0082] For example, if key=3 is used, it stores the number of entries in the content table. Each time a row is added, the number of entries is incremented by one; each time a row is deleted, the number of entries is decremented by one.

[0083] For each NSMutableDictionary that records row information, the NSArray structure of the current column information is stored, as shown in Figure 4. Its format is similar to that of a style (.fom) file.

[0084] The specific design is shown in Figure 9.

[0085] In this table, the numerical part such as '0-0' represents the type of data in the style sheet, 'value' represents the value displayed in the table cell by the text box or button at that time or the corresponding mapping information, and 'UITextField', 'UITextView', and 'Symbolbtn (UIButton)' represent the UIKit types of cells that constitute the table format.

[0086] When the information of each table cell at a corresponding position is obtained, the type information of the table cell, the value information of the table cell, and the classification information of the UI control used by the table cell can be obtained respectively according to the above information.

[0087] The generation of a polymorphic electronic form is to set the type of each independent unit of the form as a text input box or a button according to the classification of the information of the above UI controls, and then piece them together to form a complete form.

[0088] The generation of polymorphic electronic forms also sets up corresponding event responders of different types for independent cells of the form based on the information of UI controls, such as date selectors, single-select selectors, multiple-select selectors, and image selectors to achieve its diverse input methods.

[0089] The above is a detailed introduction to the optimal method for generating a polymorphic electronic form in the method of the present application. Modes for Carrying Out the Invention

[0090] Another embodiment of the present invention is to construct the structure of the template file and the content file by using an autonomous programming method. This embodiment needs to be demonstrated by taking the salary table problem of the enterprise human resources management system as an example.

[0091] Creating and entering information forms for an enterprise's human resources management system requires completing three steps, as shown in Figure 10. Step 1: The user creates and defines a .fom file; Step 2: The user customizes the format of the prepared .fom file to create a specific blank form; Step 3: The user fills in and edits data within the blank form.

[0092] For example, using SQL to create forms and enter data, we need to create three forms for Li Ming, Zhang San, and Wang Wu using a fixed format. This means we need to use three crate table statements, each with the same and repetitive format.

[0093] The difference between the data format list mentioned in this invention and create table in the database system is that create table is divided into two parts in this invention.

[0094] Take creating a corporate payroll table as an example:

[0095] Name January 2023 Salary February 2023 Salary March 2023 Salary Li Ming 12000 13000 14000 Zhang San 9000 10000 11000 Wang Wu 15000 14000 13000

[0096] If you simply want to record the salaries of three employees, Li Ming, Zhang San, and Wang Wu, from January to March 2023, then a table can describe it. Such a table can be directly implemented using Excel.

[0097] In practice, payroll records, such as actual wages, consist of multiple items, including base salary, performance-based salary, commuting bonus, fines, and social security deductions. Therefore, a single table like the one above is insufficient to meet the needs of an enterprise.

[0098] To operate the database, you need to design a separate salary table for each employee. For example, the SQL statement is as follows (Figure 17):

[0099] CREATE TABLE Li Ming_salary table(id INT(11), riqi DATETIME(8), base_gongzi (INT 11), jixiao_gongzi INT(11), tongqin_gongzi INT(11), fakuan INT(11), shebao INT(11));

[0100] CREATE TABLE Zhang San_salary table(id INT(11), riqi DATETIME(8), base_gongzi (INT 11), jixiao_gongzi INT(11), tongqin_gongzi INT(11), fakuan INT(11), shebao INT(11));

[0101] CREATE TABLE Wangwu_salarytable(id INT(11), riqi DATETIME(8),base_gongzi (INT 11), jixiao_gongzi INT(11), tongqin_gongzi INT(11), fakuan INT(11), shebao INT(11));

[0102] After creating three independent payroll tables, we then enter the corresponding data for each employee by month, as shown in Figure 17. This is the basic process implemented using SQL.

[0103] As shown in Figure 11, the data structure used by .fom is essentially the repeated parts defined in create table, stored in the .fom file. Later, simply provide the employee's name to create a corresponding empty table.

[0104] Therefore, in fact, what the .fom file records are the name of each item in create table and the length of the actual data (in the best implementation scheme, because the definition of the table element type is added, the user-defined length is deleted and changed to 13 fixed-length types, so the format and content of the stored data items are different from this example).

[0105] In the following example, all salary components are simplified into one item: salary payment amount, for easier reading and testing.

[0106] Therefore, users can define the following formats: Date (40 bytes), Salary (8 bytes). In this way, at least one file with a custom suffix of .fom format needs to be generated in the system background. The main parameters of this .fom file include:

[0107] Format name Content 1 Content 1 length Content 2 Content 2 length Individual salary list format Payment date 40 bytes Salary payment number 8 bytes

[0108] Figure 12 can more vividly show the location of the .fom file in the database creation process in this system.

[0109] If you use Objective-C or C or C++ to write to disk, you can organize the above information into:

[0110] File name: Personal salary list format.fom File content: Personal salary list format: payment date, 40; salary payment amount, 8

[0111] Using the string extraction function in NSString, the text of the file can be read and split. The text content is split into strings using a triple loop of ":", ";", and "," respectively. The data in the text can be classified and parsed into corresponding string arrays.

[0112] The first use of the string split function to extract the result with ":" is:

[0113] Array name subscript 0 subscript 1 array 1 individual salary list format payment date, 40; salary payment amount, 8

[0114] Use ";" to split the string again on the content with subscript 1, and you can get the array as follows:

[0115] Array name subscript 0 subscript 1 array 2 payment date, 40 salary payment number, 8

[0116] If we use "," to split the contents of array 2 into strings for the third time, we can get the following array:

[0117] Array name subscript 0 subscript 1 array 3 payment date 40 array 4 salary payment amount 8

[0118] The specific segmentation method is shown in Figure 13.

[0119] This allows the contents of all .fom files to be parsed into corresponding string arrays in the form of string arrays. The specific functional meaning represented by the data in the corresponding loop layer can be determined based on its subscript position in the array.

[0120] After the user defines the list format, the user can use the list format to generate a database file to store specific data. In this system, the file name is uniformly named with the fixed format suffix .dtt.

[0121] The specific implementation method is as shown in FIG14 . The user needs to select a format list from the existing format list in the graphical interface, and then generate an empty form according to the format of the format list, and then add content to the empty form one by one.

[0122] It's important to note that, using the database create table command as an example, a table containing at least one row of data is only created after the .dtt file is generated and populated with data. In this example, a blank form is created first and then the data is populated. A single format list can support multiple different tables. For example, Zhang San has his own historical salary table, and Wang Wu can also have his own historical salary table. In this case, the format of their salary tables is the same.

[0123] Constructing a .dtt file differs from constructing a .fom file. Because the length of each data item is already specified in the .fom file, it's more appropriate to construct a .dtt file using a header + body format. (In this example, the .fom file information is not added to the .dtt file header. In this case, each opening and reading of the .dtt file requires the corresponding .fom file.)

[0124] The specific naming method of the .dtt file in this example is "person name + employee number + '-' + relative path of the list format file.dtt". When there is duplication, use add (1) or (1)(1)... to achieve it.

[0125] For example, when Li Ming 001 is used for the first time to create the employee individual salary format .fom, the corresponding file name is "Li Ming 001-employee individual salary format.fom.dtt". The file name when used for the second time is "Li Ming 001-employee individual salary format.fom (1).dtt". I will follow the same principle.

[0126] For another example, if you need to enter Li Ming's salary of 12,000 yuan in January 2023 and Li Ming's salary of 13,000 yuan in February 2023, and Li Ming's employee number is 001, the simplest format for entering information should be as shown in Figure 18.

[0127] FIG15 is a schematic diagram showing the internal structure of a .dtt file when a format list is selected with a header file length of 50 bytes and each section of the format list having a length of (40+8) bytes.

[0128] The 50-byte file header length is determined by the programmer. Additional information and verification information can also be added to the file header based on the specific format. For example, in this example, the additional information, totaling n=2, is added to the file header, and the body references the corresponding format information file, "Employee Personal Data Format.fom," after it.

[0129] The main body of the file is entered in a regular loop, with each section consisting of 40 bytes + 8 bytes, without any separators. The number n in the file header is automatically increased by 1 each time a section of information is added.

[0130] When searching for a specific date, you only need to read the first 40 bytes of information at a time using the formula 50+48*i (where i is a value in the range of 0 to n-1). To search for salary information, you only need to read 8 bytes of information at a time using the formula 50+48*i+40 at the specified location.

[0131] If you subsequently add information about a salary of 16,000 yuan for March 2023 as shown in Figure 16, using the end-add method, you only need to add "March 2023" and "16000" (a total of 48 bytes) to the end of the file. At this time, n needs to be automatically increased by 1.

[0132] If you want to perform an insert operation at a specified position, you need to first save all the information of the subsequent file at the address of the specified position 50+48*(p-1) (p is a value from 0 to n-1), then add 48 bytes of content at that position, and then enter the saved content into the file in sequence. At this time, n should automatically increase by 1.

[0133] If you want to delete the specified position p, you need to reassemble the file into a new file based on the content of the first half of position p and the content of position p+1 as the second half. At this time, n should be automatically reduced by 1.

[0134] This data structure is a variable-length sequential storage structure that saves disk space when storing large amounts of information compared to linked list-based storage structures. Its disadvantage is that inserting or deleting data in the middle of a segment is relatively time-consuming, but it is not negatively impacted when appending to the end of a segment or updating intermediate data.

[0135] Taking into account that in the operation of enterprise human resources management systems, such as salary information, is generally entered into the system one by one and in chronological order, most operations are added at the end, and the probability of inserting or deleting existing information items is relatively small. This variable-length array structure is considered to be a more suitable data storage structure than the chain storage structure in this system.

[0136] The above is the main content achieved through autonomous programming. Industrial Applicability

[0137] The industrial applicability of the invention is mainly reflected in two aspects:

[0138] As exemplified in the best embodiment of this specification, this method can be well used on mobile devices, providing users with a more convenient polymorphic table editing experience on mobile terminals that is different from traditional desktop computers and notebooks.

[0139] Second, as exemplified in the general implementation manner of this specification, this method can also be used to improve the problems existing when creating tables using SQL, and this method can be applied to the construction of a lightweight visual database.

Claims

1. A polymorphic method for generating a spreadsheet, characterized in that, The method includes: Recording the types and entries of the form entered by the end user into the computer memory and the local style sheet file through setting up a human-computer interaction interface; Performing operations such as adding, deleting, and modifying the types and entries of the form entered by the user through human-computer interaction and storing them in the local style sheet file; According to the local style sheet file, responding to the user's request to create a custom-style form through human-computer interaction and creating a blank content form file; Performing operations such as adding, deleting, and modifying rows and columns of the content of the content form in response to the user's request through human-computer interaction.

2. The polymorphic spreadsheet generation method according to claim 1, wherein Summarizing the requirements of the user for the types and entries of the form entered through the human-computer interaction interface and storing them in a local file in the format of a style sheet, the content of which is a collection of styles mapping text boxes or button features such as recorded text, numbers (including formulas), dates, radio buttons, check boxes, pictures, etc.

3. The polymorphic spreadsheet generation method according to claim 1, characterized in that After creating the style sheet file, the end user needs to create a new blank content form file according to the input information in the style sheet file and generate a form title bar, and the substantial editing of the content column of the form is carried out in the content form file.

4. The polymorphic spreadsheet generation method according to claim 1, characterized in that Independent windows and editing areas are set up for the style sheet file and the content form file respectively for separate editing and separate storage.

5. The polymorphic spreadsheet generation method according to claim 1, characterized in that The pre-editing of formulas, radio buttons, and check boxes is carried out during the editing of the style sheet file.

6. The polymorphic spreadsheet generation method according to claim 1, wherein After creating the blank content form, the system copies the source style sheet file to the head of the content form file. After creating the new blank form, the reading, running, changing, and editing of the new form no longer depend on the source style sheet file.

7. The polymorphic spreadsheet generation method according to claim 1, wherein When editing the content form, the generation of the content of the table cell of the formula is completed by the system automatically filling according to the preset formula calculation relationship, and the input of the table cells of dates, radio buttons, check boxes, and pictures is carried out through a date selector, a radio selector, a check box selector, and a picture selector.

8. The polymorphic spreadsheet generation method according to claim 1, characterized in that The system sets up groups of temporary files with a maximum number not exceeding a certain number for the editing of the style sheet file and the content form file respectively to meet the user's needs for calling back or advancing past operations.

9. The polymorphic spreadsheet generation method according to claim 1, characterized in that When editing the columns of the style involving the title bar editing of the content form, only the style sheet information built into the content form is modified, and the built-in style sheet information can be exported as a new style sheet format file.

10. According to the polymorphic electronic form generation method shown in claim 1, a function of merging styles is added to the editing areas of the style sheet and the content form respectively; and a basic style source file representing the existing single function features listed in the style sheet is set up to perform a quick addition operation on the style sheet and the content form.

11. According to the polymorphic spreadsheet generation method shown in claim 1, the format of the style sheet and the content sheet file is a nestable file structure format with adjustable length, which mainly includes but is not limited to a variable-length file format storage method implemented through XML format or through independent programming; the main purpose of the variable-length file format storage method is to be selected for the purpose of meeting future expansion of the style format or content format, and its scope of application includes but is not limited to computers, laptops, and all intelligent terminals, mobile devices, and numerical control devices with display, computing functions, and input and control response capabilities.

Images