CN115964989B - Information display method, device and storage medium of electronic form - Google Patents
Information display method, device and storage medium of electronic form Download PDFInfo
- Publication number
- CN115964989B CN115964989B CN202310153980.8A CN202310153980A CN115964989B CN 115964989 B CN115964989 B CN 115964989B CN 202310153980 A CN202310153980 A CN 202310153980A CN 115964989 B CN115964989 B CN 115964989B
- Authority
- CN
- China
- Prior art keywords
- content
- invisible
- descriptive text
- cell
- converting
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 230000004048 modification Effects 0.000 claims description 21
- 238000012986 modification Methods 0.000 claims description 21
- 238000006243 chemical reaction Methods 0.000 claims description 12
- 238000010586 diagram Methods 0.000 description 12
- 230000003287 optical effect Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Landscapes
- Document Processing Apparatus (AREA)
Abstract
The embodiment of the invention discloses an information display method, an information display device and a storage medium of an electronic form, wherein the method comprises the following steps: receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation; reading the content of an invisible form when the invisible form exists; converting the content of the invisible form and the corresponding header content into descriptive text; and displaying the descriptive text on the electronic form display page. The user can visually see the content in the invisible form. The user can view the contents in the invisible form by clicking on the corresponding cell. Compared with the traditional mode, the operation steps are greatly reduced, and the efficiency of viewing the invisible table contents is improved.
Description
Technical Field
The present invention relates to the field of electronic forms, and in particular, to an information display method and apparatus for an electronic form, and a storage medium.
Background
A Spreadsheet (spread sheet), also known as a Spreadsheet, is a type of computer program that simulates a computational table on paper. It will display a grid of a series of rows and columns. The cells may hold values, calculations, or text.
In the process of realizing the invention, the inventor finds the following technical problems: because of the large amount of data in some electronic forms, some rows/columns of data are less focused in editing and browsing, but these rows/columns are located in the middle of other rows/columns, so that in order to display more rows/columns with high focus in the current page, the user can achieve the goal by hiding the rows/columns with low focus. At this time, if the user wants to view the contents of the hidden rows/columns, the user can only cancel the hidden rows/columns first, and if there are a plurality of hidden rows/columns, the user needs to operate on the plurality of hidden rows/columns to view the hidden contents. In addition, due to limitations of the display device, some of the row/column information in the spreadsheet may not be displayed at the open interface, and the user may need to move down or right by using the scroll bar to view the complete spreadsheet information. Therefore, at present, for the form information hidden or outside the display interface, after various operations are needed, the complete electronic form information can be seen, the operation is complicated, and the viewing efficiency of the electronic form data is affected.
Disclosure of Invention
The embodiment of the invention provides an information display method, an information display device, a network disk device and a storage medium for an electronic form, which are used for solving the technical problems of complicated information viewing of the electronic form hidden in the electronic form or outside a display interface and low efficiency in the prior art.
In a first aspect, an embodiment of the present invention provides an information display method of an electronic form, including:
receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation;
reading the content of an invisible form when the invisible form exists;
converting the content of the invisible form and the corresponding header content into descriptive text;
and displaying the descriptive text on the electronic form display page.
In a second aspect, an embodiment of the present invention further provides an information display apparatus of a spreadsheet, including:
the receiving module is used for receiving the operation of selecting the cell, and judging whether an invisible table exists in the row or the column where the cell is located according to the operation;
the reading module is used for reading the content of the invisible form when the invisible form exists;
the conversion module is used for converting the content of the invisible table and the corresponding table head content into descriptive text;
and the display module is used for displaying the page on the electronic form and displaying the descriptive text.
In a third aspect, embodiments of the present invention also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are for performing the information display method of the electronic form as provided in the above embodiments.
According to the information display method, the information display device and the storage medium of the electronic form, through receiving operation of selecting the cells, whether invisible forms exist in the rows or the columns where the cells are located or not is judged according to the operation; reading the content of an invisible form when the invisible form exists; converting the content of the invisible form and the corresponding header content into descriptive text; and displaying the descriptive text on the electronic form display page. When a user selects to view information of a certain row or column in the electronic table, information in a cell which is hidden or can not be displayed on the current interface is read, and descriptive text is generated according to corresponding header information. And presenting the descriptive text. The descriptive text can correspondingly display the header and the hidden information, so that a user can visually see the contents in the invisible table. The user can view the contents in the invisible form by clicking on the corresponding cell. Compared with the traditional mode, the operation steps are greatly reduced, and the efficiency of viewing the invisible table contents is improved.
Drawings
Other features, objects and advantages of the present invention will become more apparent upon reading of the detailed description of non-limiting embodiments, made with reference to the accompanying drawings in which:
FIG. 1 is a flowchart of a method for displaying information of a spreadsheet according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a spreadsheet according to a method for displaying information of a spreadsheet according to an embodiment of the present invention;
FIG. 3 is a schematic diagram showing a descriptive text of the contents of an invisible form in a method for displaying information of an electronic form according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a descriptive text and a switching state of electronic form display in an information display method of an electronic form according to an embodiment of the present invention;
fig. 5 is a flowchart of a method for displaying information of a spreadsheet according to a second embodiment of the present invention;
fig. 6 is a schematic diagram showing a descriptive text in an information display method of a spreadsheet according to a second embodiment of the present invention;
fig. 7 is a flowchart of an information display method of a spreadsheet according to a third embodiment of the present invention;
fig. 8 is a schematic display diagram of a descriptive text constructed based on a template in the information display method of a spreadsheet according to the third embodiment of the present invention;
FIG. 9 is a flowchart of a method for displaying information of a spreadsheet according to a fourth embodiment of the present invention;
fig. 10 is a schematic structural diagram of an information display device of a spreadsheet according to a fifth embodiment of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Example 1
Fig. 1 is a flowchart of an information display method of a spreadsheet provided in an embodiment of the present invention, where the embodiment is applicable to a case of quickly viewing details of an invisible form in a spreadsheet file, the method may be performed by an information display device of the spreadsheet and may be integrated in a terminal capable of running the spreadsheet or a server supporting a multi-person collaborative spreadsheet online document, and specifically includes the following steps:
step 110, receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation.
In this embodiment, the user may click on the information of the invisible form in the same row/column as the selected cell by selecting the cell in the spreadsheet file. Optionally, the invisible table may include: hidden cells and cells that cannot be displayed on the current page. The hidden cells may be cells that are hidden for ease of viewing data of other rows or columns, particularly cells of a row or column. The cells that cannot be displayed on the current page may be cells that cannot be displayed on the current interface due to the large number of rows/columns of the electronic form and can only be viewed by sliding the scroll bar.
For example, the presence of the invisible table may be determined by checking whether cells having hidden properties exist in the corresponding row or column, or determining the number of rows and columns of the display based on the currently set resolution, when the number of cells included in the checked row or column is greater than the number of rows and columns of the display.
And step 120, when the invisible table exists, reading the content of the invisible table.
According to the steps, an invisible table is determined, and optionally, the invisible table is taken as a unit of a cell. The contents of each invisible form are read.
And step 130, converting the content of the invisible table and the corresponding header content into descriptive text.
The converting the content of the invisible form and the corresponding header content into descriptive text may include: converting the header into a character string key; converting the corresponding invisible table contents into key values; and establishing a corresponding relation between the character string keys and the key values to form an array.
In this embodiment, the descriptive text may be in XML, JSON, or MD format text. The corresponding structural description information can be constructed by using the descriptive text, and the contents in the invisible table can be completely described. In particular, the descriptive text may be stored and displayed in an array of keys and key values. Thus, a header, which is the beginning of a table, may be used first to categorize the nature of some problems. Also known as a title bar. Typically the content of the top row/column cell. And reading and converting the content in the header corresponding to each invisible table into a corresponding character string, taking the character string as a key, and taking the content read in the corresponding invisible table as a key value to form a corresponding array. For example: the header is the name, the invisible cell content is Li-IV, and the corresponding descriptive text is { name: li IV).
Further, the contents of the invisible table and the corresponding header contents can be converted into descriptive text, and the descriptive text is specifically optimized: the contents of the visible form, the corresponding header content, the contents of the invisible form, and the corresponding header content are converted into descriptive text. Since only the contents of the invisible form are displayed, the user is not facilitated to acquire the complete contents, and thus the contents of the corresponding full row or full column can be completely converted into descriptive text.
And 140, displaying the descriptive text on the electronic form display page.
Fig. 2 is a schematic diagram of a spreadsheet according to an embodiment of the present invention, wherein columns B-E are hidden columns. Fig. 3 is a schematic diagram showing a descriptive text of the contents of an invisible form in the method for displaying information of a spreadsheet according to the first embodiment of the present invention. And corresponding to fig. 2, it can be seen from fig. 3 that in the electronic form display page currently browsed by the user, the descriptive text may be sequentially displayed according to the arrangement order of the invisible forms. Alternatively, to avoid obscuring other information, the user may define the size and display location of a frame, which may be popped up and the descriptive text displayed in the frame when the user selects a cell. And the size of the descriptive text font can be adjusted according to the set window. And the user can conveniently check the related information. In addition, according to the description of the steps, the contents of the corresponding whole rows or columns in the selected electronic form can be displayed and converted into descriptive text contents.
According to the embodiment of the invention, through receiving the operation of selecting the cell, judging whether an invisible table exists in the row or column where the cell is located according to the operation; reading the content of an invisible form when the invisible form exists; converting the content of the invisible form and the corresponding header content into descriptive text; and displaying the descriptive text on the electronic form display page. When a user selects to view information of a certain row or column in the electronic table, information in a cell which is hidden or can not be displayed on the current interface is read, and descriptive text is generated according to corresponding header information. And presenting the descriptive text. The descriptive text can correspondingly display the header and the hidden information, so that a user can visually see the contents in the invisible table. The user can view the contents in the invisible form by clicking on the corresponding cell. Compared with the traditional mode, the operation steps are greatly reduced, and the efficiency of viewing the invisible table contents is improved.
In a preferred implementation of this embodiment, the method may further comprise the steps of: and receiving clicking operation of the descriptive text, closing display of the descriptive text according to the clicking operation, and returning to the display state of the electronic table. The user may close the display of the descriptive text by clicking on the display form of the descriptive text. And restoring to the display state of the original electronic form, so that the user can conveniently perform subsequent operations. Fig. 4 is a schematic diagram of a descriptive text and a spreadsheet display switching state in a method for displaying information of a spreadsheet according to an embodiment of the present invention. As can be seen from fig. 4, the descriptive text and the electronic form can be switched in display state according to user operations.
Example two
Fig. 5 is a flowchart of an information display method of a spreadsheet according to a second embodiment of the present invention. The present embodiment is optimized based on the foregoing embodiment, and in this embodiment, the operation of receiving and selecting the cells is specifically optimized as follows: receiving an operation of selecting a plurality of cells; correspondingly, the contents of the invisible table and the corresponding header contents are converted into descriptive text, and the descriptive text is specifically optimized as follows: creating a title of a descriptive text according to the name of the electronic form; creating a corresponding node for each selected cell; converting the content of the invisible table and the corresponding header content into an array; the array is written into the node information.
Correspondingly, the information display method of the electronic form provided by the embodiment specifically includes:
step 210, receiving an operation of selecting a plurality of cells, and judging whether an invisible table exists in a row or a column where the cells are located according to the operation.
The user can select a plurality of cells, particularly a plurality of cells in the same row or column in a multi-selection manner.
Step 220, when there is an invisible form, reading the content of the invisible form.
Step 230, creating a title of the descriptive text according to the name of the electronic form.
In the present embodiment, since a plurality of cells are selected. Thus, when establishing descriptive text, at least the juxtaposition between each cell should be indicated. Thus, the structure of the describable text can be considered. For example, the spreadsheet name may be the name of the overall architecture that may describe the text.
Step 240 creates a corresponding node for each selected cell.
Because the data corresponding to each selected cell does not belong to a membership, it is necessary to perform a relationship separation. Based on the framework, a corresponding node may be created for each selected cell, respectively.
Step 250, converting the content of the invisible form and the corresponding header content into an array.
The contents of the invisible table and the corresponding header contents may be converted into an array in the manner provided by the above embodiments.
Furthermore, since there may be merging cells in the header content, for example: among the contact ways, there may be various contact ways such as a fixed telephone, a mobile phone, a mailbox, etc., and the above information is generally referred to as a contact way. And specific modes are set forth below. In this case, it is necessary to determine whether the header is a merge table, and if so, acquire whether the table corresponding to the next row of the header is a merge table; and when the table is not merged, acquiring the content of the cell corresponding to the next row, and converting the content of each cell into a character string key. And obtaining the corresponding header content in a step-by-step judging mode.
Step 260, writing the array into node information.
The array is written into the corresponding node information so as to avoid reading difficulty caused by mixing various information together.
And step 270, displaying the descriptive text on the electronic form display page.
Fig. 6 is a schematic diagram showing a descriptive text in an information display method of a spreadsheet according to a second embodiment of the present invention. As can be seen from fig. 6, for a plurality of selected cells, a different array may be generated for display according to each cell, and the information of each selected cell is displayed in parallel.
The operation of receiving and selecting the cell is specifically optimized as follows: receiving an operation of selecting a plurality of cells; correspondingly, the contents of the invisible table and the corresponding header contents are converted into descriptive text, and the descriptive text is specifically optimized as follows: creating a title of a descriptive text according to the name of the electronic form; creating a corresponding node for each selected cell; converting the content of the invisible table and the corresponding header content into an array; the array is written into the node information. The method can be used for establishing a corresponding architecture for the descriptive text aiming at the condition of selecting a plurality of cells, so that the disorder of the relation among the displayed data is avoided, and the accuracy of information acquisition is influenced.
Example III
Fig. 7 is a flowchart of an information display method of a spreadsheet according to a third embodiment of the present invention. The present embodiment is optimized based on the above embodiment, in this embodiment, after the content of the visible table, the corresponding header content, the content of the invisible table, and the corresponding header content are converted into the descriptive text, the method may further include the following steps: acquiring a template corresponding to the electronic form; reading each character string key from the template in turn, and determining a key value filling position corresponding to each character string key; and searching a corresponding key value from the descriptive text according to the corresponding character string key, and filling the key value in a key value filling position in the template.
Correspondingly, the information display method of the electronic form provided by the embodiment specifically includes:
step 310, receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation.
Step 320, when there is an invisible form, reading the content of the invisible form.
And 330, acquiring a template corresponding to the electronic form.
Some electronic forms can be correspondingly provided with corresponding templates so as to realize that the electronic form information can be displayed in a more visual and user habit-conforming mode. For example: for personal information, the personal information can be displayed in a resume mode and the like. The user can preset corresponding templates according to the table characteristics, and the template files can define the positions and the overall layout of various display contents. So as to more conform to the reading habit of the user.
And 340, reading each character string key from the template in turn, and determining a key value filling position corresponding to each character string key.
Fig. 8 is a schematic diagram of displaying a descriptive text constructed based on a template in the information display method of a spreadsheet according to the third embodiment of the present invention. As can be seen from fig. 8, the positions and sizes of the respective parts can be defined in the template, and the corresponding character string keys can be preset, and each character string key can be read from the template file. And filling positions of contents corresponding to the character string keys defined in the template.
And 350, searching a corresponding key value from the descriptive text according to the corresponding character string key, and filling the key value in a key value filling position in the template.
An array constructed by character string keys and key values is arranged in the descriptive text, the array is traversed, the corresponding character string keys are read, the corresponding key values in the array are obtained, and the key values are written into filling positions determined in the steps. A complete template-created descriptive text is formed.
Step 360, allocating a corresponding directory window for each recommended folder, and displaying the recommended folder file directory corresponding to the directory window.
At step 370, the descriptive text created based on the template is displayed on the spreadsheet display page.
In this embodiment, after the contents of the visible table, the corresponding header contents, the contents of the invisible table and the corresponding header contents are converted into the descriptive text, the method may further include the following steps: acquiring a template corresponding to the electronic form; reading each character string key from the template in turn, and determining a key value filling position corresponding to each character string key; and searching a corresponding key value from the descriptive text according to the corresponding character string key, and filling the key value in a key value filling position in the template. And the efficiency of sharing the network disk file is improved. Descriptive text which is more suitable for the reading habit of the user can be created by using the template, so that the reading habit of the user is more suitable, and the experience of the user in using the electronic form is further improved.
Example IV
Fig. 9 is a flowchart of an information display method of a spreadsheet according to a fourth embodiment of the present invention. The present embodiment is optimized based on the above embodiment, and in this embodiment, the method may further include the following steps: judging whether the invisible form has a newly added collaborative editing form or not; when a new collaborative editing table exists, receiving a modification operation of the descriptive text; judging whether the modified content corresponding to the modification operation accords with the attribute of the cell setting or not; and accepting the modified content when the attribute is met.
Correspondingly, the information display method of the electronic form provided by the embodiment specifically includes:
step 410, receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation.
Step 420, when there is an invisible form, reading the content of the invisible form.
Step 430, converting the content of the invisible form and the corresponding header content into descriptive text.
And step 440, displaying the descriptive text on the electronic form display page.
Step 450, judging whether the invisible form has a new collaborative editing form, and receiving the modification operation of the descriptive text when the new collaborative editing form exists.
Collaborative editing forms are a special type of electronic form that allows multiple people with rights to the electronic form file to edit together. Therefore, other users may be hidden by other users after being newly added or modified, or newly added contents in the last row or column may not be displayed by the current interface. Although the method provided by the embodiment can be used for quick display, in the case that the user needs to edit the content, the user needs to remove the corresponding hidden attribute or slide the scroll bar to find the corresponding cell, so as to modify the cell. The operation is more complicated. Therefore, in this embodiment, it may be determined that the newly added collaborative editing table may be a cell in which a modification or a new addition exists in the collaborative editing table. If there is a new collaborative editing form, the user is allowed to directly make an operation of modifying or writing new content directly on the descriptive text.
Step 460, determining whether the modification content corresponding to the modification operation accords with the attribute set by the cell, and accepting the modification content when the modification content accords with the attribute.
Since cells may have certain formatting requirements for the filled data, for example, a certain cell may only allow for filling in dates, or be numbers. If the filled content is character, it is not satisfactory and can not be filled. Therefore, it is necessary to first determine the cell corresponding to the modified content corresponding to the modification operation, and find the attribute set by the cell, and accept the modified content when the attribute requirement is satisfied.
Correspondingly, a character string key corresponding to the modified content can be obtained, and a corresponding column is determined according to the character string key; and determining a modified cell according to the column, and covering the original content of the modified cell with the modified content. Direct modification of the spreadsheet file is achieved.
The embodiment adds the following steps: judging whether the invisible form has a newly added collaborative editing form or not; when a new collaborative editing table exists, receiving a modification operation of the descriptive text; judging whether the modified content corresponding to the modification operation accords with the attribute of the cell setting or not; and accepting the modified content when the attribute is met. The method can provide a shortcut modification mode for the user to cooperatively edit the invisible forms in the document, the user can directly modify the contents in the descriptive text, the modification operation of the invisible forms is simplified, and the modification efficiency of the invisible forms of the electronic forms is improved.
Example five
Fig. 10 is a schematic structural diagram of an information display device of a spreadsheet according to a fifth embodiment of the present invention, as shown in fig. 10, the device includes:
a receiving module 510, configured to receive an operation of selecting a cell, and determine whether an invisible table exists in a row or a column where the cell is located according to the operation;
a reading module 520, configured to read the content of the invisible form when the invisible form exists;
a conversion module 530, configured to convert the content of the invisible form and the corresponding header content into descriptive text;
and the display module 540 is used for displaying the descriptive text on the electronic form display page.
According to the information display device of the electronic form, through receiving operation of selecting the cell, whether an invisible form exists in a row or a column where the cell is located is judged according to the operation; reading the content of an invisible form when the invisible form exists; converting the content of the invisible form and the corresponding header content into descriptive text; and displaying the descriptive text on the electronic form display page. When a user selects to view information of a certain row or column in the electronic table, information in a cell which is hidden or can not be displayed on the current interface is read, and descriptive text is generated according to corresponding header information. And presenting the descriptive text. The descriptive text can correspondingly display the header and the hidden information, so that a user can visually see the contents in the invisible table. The user can view the contents in the invisible form by clicking on the corresponding cell. Compared with the traditional mode, the operation steps are greatly reduced, and the efficiency of viewing the invisible table contents is improved.
On the basis of the above embodiments, the invisible table includes:
hidden cells and cells that cannot be displayed on the current page.
On the basis of the above embodiments, the device further includes:
and the return module is used for receiving the clicking operation of the descriptive text, closing the display of the descriptive text according to the clicking operation, and returning to the display state of the electronic table.
On the basis of the above embodiments, the device further includes:
the new adding judging module is used for judging whether the invisible form has a new adding collaborative editing form or not;
the modification operation receiving module is used for receiving modification operation on the descriptive text when a new collaborative editing table exists;
the coincidence judging module is used for judging whether the modification content corresponding to the modification operation accords with the attribute of the cell setting;
and the modified content receiving module is used for receiving the modified content when the attribute is met.
On the basis of the above embodiments, the device further includes:
the character string key acquisition module is used for acquiring the character string key corresponding to the modified content;
a column determining module, configured to determine a corresponding column according to the character string key;
and the covering module is used for determining the modified cell according to the column and covering the original content of the modified cell with the modified content.
On the basis of the above embodiments, the conversion module includes:
and the first conversion unit is used for converting the contents of the visible table, the corresponding header contents, the contents of the invisible table and the corresponding header contents into descriptive texts.
On the basis of the above embodiments, the receiving module includes:
a receiving unit configured to receive an operation of selecting a plurality of cells;
correspondingly, the conversion module comprises:
a title creation unit for creating a title of a descriptive text according to the name of the electronic form;
a node creation unit for creating a corresponding node for each selected cell;
the conversion unit is used for converting the content of the invisible table and the corresponding header content into an array;
and the writing unit is used for writing the array into the node information.
On the basis of the above embodiments, the conversion unit includes:
a determining subunit, configured to determine whether the header is a merging table, and when the header is the merging table, determine whether a table corresponding to a next row of the header is the merging table;
and the acquisition subunit is used for acquiring the content of the cell corresponding to the next row when the table is not merged, and converting the content of each cell into a character string key.
On the basis of the above embodiments, the device further includes:
the template acquisition module is used for acquiring a template corresponding to the electronic form;
the position determining module is used for sequentially reading each character string key from the template and determining a key value filling position corresponding to each character string key;
and the searching module is used for searching the corresponding key value from the descriptive text according to the corresponding character string key and filling the key value in the key value filling position in the template.
The information display device of the electronic form provided by the embodiment of the invention can execute the information display method of the electronic form provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Example six
A sixth embodiment of the present invention also provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform the information display method of the electronic form according to any one of the above embodiments.
The computer storage media of embodiments of the invention may take the form of any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (9)
1. An information display method of a spreadsheet, comprising:
receiving an operation of selecting a cell, and judging whether an invisible table exists in a row or a column where the cell is located according to the operation;
reading the content of an invisible form when the invisible form exists;
converting the content of the invisible form and the corresponding header content into descriptive text;
displaying the descriptive text on the electronic form display page;
the converting the content of the invisible form and the corresponding header content into descriptive text includes:
converting the header into a character string key;
converting the corresponding invisible table contents into key values;
establishing a corresponding relation between the character string keys and the key values to form an array;
the converting the content of the invisible form and the corresponding header content into descriptive text includes:
converting the contents of the visible form, the corresponding header contents, the contents of the invisible form and the corresponding header contents into descriptive text;
after converting the content of the visible form, the corresponding header content, the content of the invisible form, and the corresponding header content into descriptive text, the method further comprises:
acquiring a template corresponding to the electronic form;
reading each character string key from the template in turn, and determining a key value filling position corresponding to each character string key;
and searching a corresponding key value from the descriptive text according to the corresponding character string key, and filling the key value in a key value filling position in the template.
2. The method of claim 1, wherein the invisible form comprises:
hidden cells and cells that cannot be displayed on the current page.
3. The method according to claim 1, wherein the method further comprises:
and receiving clicking operation of the descriptive text, closing display of the descriptive text according to the clicking operation, and returning to the display state of the electronic table.
4. The method according to claim 1, wherein the method further comprises:
judging whether the invisible form has a newly added collaborative editing form or not;
when a new collaborative editing table exists, receiving a modification operation of the descriptive text;
judging whether the modified content corresponding to the modification operation accords with the attribute of the cell setting or not;
and accepting the modified content when the attribute is met.
5. The method according to claim 4, wherein the method further comprises:
acquiring a character string key corresponding to the modified content;
determining a corresponding column according to the character string key;
and determining a modified cell according to the column, and covering the original content of the modified cell with the modified content.
6. The method of claim 1, wherein the receiving operation of selecting a cell comprises:
receiving an operation of selecting a plurality of cells;
correspondingly, the converting the content of the invisible form and the corresponding header content into descriptive text includes:
creating a title of a descriptive text according to the name of the electronic form;
creating a corresponding node for each selected cell;
converting the content of the invisible table and the corresponding header content into an array;
the array is written into the node information.
7. The method of claim 1, wherein converting the content of the invisible form and the corresponding header content into an array comprises:
judging whether the header is a merging table, and if so, determining whether a table corresponding to the next row of the header is a merging table;
and when the table is not merged, acquiring the content of the cell corresponding to the next row, and converting the content of each cell into a character string key.
8. An information display apparatus of a spreadsheet, comprising:
the receiving module is used for receiving the operation of selecting the cell, and judging whether an invisible table exists in the row or the column where the cell is located according to the operation;
the reading module is used for reading the content of the invisible form when the invisible form exists;
the conversion module is used for converting the content of the invisible table and the corresponding table head content into descriptive text;
the display module is used for displaying the page on the electronic form and displaying the descriptive text;
the conversion module comprises:
the first conversion unit is used for converting the contents of the visible table, the corresponding header contents, the contents of the invisible table and the corresponding header contents into descriptive texts;
a character string key conversion unit for converting the header into a character string key;
a key value conversion unit for converting the corresponding invisible table contents into key values;
the forming unit is used for establishing the corresponding relation between the character string keys and the key values to form an array;
the apparatus further comprises:
the template acquisition module is used for acquiring a template corresponding to the electronic form;
the position determining module is used for sequentially reading each character string key from the template and determining a key value filling position corresponding to each character string key;
and the searching module is used for searching the corresponding key value from the descriptive text according to the corresponding character string key and filling the key value in the key value filling position in the template.
9. A storage medium containing computer executable instructions which, when executed by a computer processor, are for implementing the method of information display of a spreadsheet as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310153980.8A CN115964989B (en) | 2023-02-23 | 2023-02-23 | Information display method, device and storage medium of electronic form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310153980.8A CN115964989B (en) | 2023-02-23 | 2023-02-23 | Information display method, device and storage medium of electronic form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115964989A CN115964989A (en) | 2023-04-14 |
| CN115964989B true CN115964989B (en) | 2023-09-08 |
Family
ID=87354922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310153980.8A Active CN115964989B (en) | 2023-02-23 | 2023-02-23 | Information display method, device and storage medium of electronic form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115964989B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818000A (en) * | 2016-08-31 | 2018-03-20 | 北京国双科技有限公司 | The operating method and device of a kind of page tabular |
| CN109344831A (en) * | 2018-08-22 | 2019-02-15 | 中国平安人寿保险股份有限公司 | A kind of tables of data recognition methods, device and terminal device |
| CN111241796A (en) * | 2020-01-19 | 2020-06-05 | 北京字节跳动网络技术有限公司 | Table information display method, device, equipment and storage medium |
| CN114707472A (en) * | 2022-03-11 | 2022-07-05 | 北京字跳网络技术有限公司 | Method and device for field merging and electronic equipment |
-
2023
- 2023-02-23 CN CN202310153980.8A patent/CN115964989B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818000A (en) * | 2016-08-31 | 2018-03-20 | 北京国双科技有限公司 | The operating method and device of a kind of page tabular |
| CN109344831A (en) * | 2018-08-22 | 2019-02-15 | 中国平安人寿保险股份有限公司 | A kind of tables of data recognition methods, device and terminal device |
| CN111241796A (en) * | 2020-01-19 | 2020-06-05 | 北京字节跳动网络技术有限公司 | Table information display method, device, equipment and storage medium |
| CN114707472A (en) * | 2022-03-11 | 2022-07-05 | 北京字跳网络技术有限公司 | Method and device for field merging and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115964989A (en) | 2023-04-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110520859B (en) | More intelligent copy/paste | |
| US10372801B2 (en) | Narrative-based media organizing system for transforming and merging graphical representations of digital media within a work area | |
| Edhlund | Nvivo 9 essentials | |
| US8966361B2 (en) | Providing summary view of documents | |
| CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| US8213719B2 (en) | Editing 2D structures using natural input | |
| US20130212463A1 (en) | Smart document processing with associated online data and action streams | |
| US20090313537A1 (en) | Micro browser spreadsheet viewer | |
| US20140164900A1 (en) | Appending content with annotation | |
| KR102570255B1 (en) | Table browsing method in document, device, electronic device and storage medium | |
| CN110442553A (en) | File management method, device, computer equipment and storage medium | |
| KR20100074155A (en) | Auto-generation and syndication of tables as forms | |
| US20150058711A1 (en) | Presenting fixed format documents in reflowed format | |
| US20190377779A1 (en) | Device, System and Method for Displaying Sectioned Documents | |
| US8139872B2 (en) | Splitting file types within partitioned images | |
| CN113515928B (en) | Electronic text generation method, device, equipment and medium | |
| JP2009140467A (en) | Method and system for providing and using editable personal dictionary | |
| US8756520B2 (en) | Individual information element access for unopened objects | |
| WO2021072333A1 (en) | Computer based unitary workspace leveraging multiple filetype toggling for dynamic content creation | |
| CN115964989B (en) | Information display method, device and storage medium of electronic form | |
| US20220318494A1 (en) | Apparatus and method for writing electronic document by interactive type and document type, method for providing interactive type electronic document | |
| CN111522939B (en) | Method and device for processing notes, computer storage medium and terminal | |
| Kim et al. | Social navigation and annotation for electronic books | |
| US20230305673A1 (en) | Computer based unitary workspace leveraging multiple file-type toggling for dynamic content creation | |
| CN115408985B (en) | Online spreadsheet worksheet name display method, device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |