CN112784560A - Data display method and device - Google Patents
Data display method and device Download PDFInfo
- Publication number
- CN112784560A CN112784560A CN202010456042.1A CN202010456042A CN112784560A CN 112784560 A CN112784560 A CN 112784560A CN 202010456042 A CN202010456042 A CN 202010456042A CN 112784560 A CN112784560 A CN 112784560A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- cell
- format
- data structure
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000006243 chemical reaction Methods 0.000 claims abstract description 48
- 238000013479 data entry Methods 0.000 abstract description 6
- 238000004891 communication Methods 0.000 description 14
- 238000004590 computer program Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application provides a data display method and a device, wherein the method comprises the following steps: identifying target data input into a first cell of the spreadsheet by a user, identifying a first data structure of the target data; when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; and when the second data formats of the data in the target cells are the same and the first data structure is the same as the second data structure, displaying the target data. Therefore, when the second data formats of the data in the target cell are the same and the first data structure is the same as the second data structure, the display form of the target data input in the first cell expected by the user is determined to follow the display form of the data in the target cell, and the target data is directly displayed, so that the situation that the data displayed according to the preset conversion rule does not meet the user expectation and needs the user to re-record the data is avoided, and the data entry efficiency is improved.
Description
Technical Field
The present application relates to the field of office software technologies, and in particular, to a data display method and apparatus.
Background
In the prior art, a data format of a cell is preset in spreadsheet software, and when data is input into the cell and a data structure of the data conforms to a preset conversion rule corresponding to the data format, the data is converted into the data conforming to the data format. The data format refers to the arrangement format of data stored in spreadsheet software, and the data structure refers to the composition form of the data. For example, the input data is "11-15", the spreadsheet software displays the data as "11 months and 15 days", the data format of the data is a date format, and the data structure of the data is a short bar type.
However, when the user only wants to input the data and does not want to convert the data into data conforming to the data format, the spreadsheet software still performs data format conversion on the data. For example, if the user enters data "11-15" and wishes to display the data as "11-15" but the data structure of the data conforms to the predetermined conversion rules corresponding to the date format, the spreadsheet software will display the data as 11/15. And at this time, the user cannot restore the cell by adjusting the data format of the cell, and only deletes the data, sets the cell format and re-inputs the data, so that the data input work is more complicated, and the repeated workload is increased.
Disclosure of Invention
An object of the embodiments of the present application is to provide a data display method and apparatus, so as to save extra workload of a user for entering data, and improve data entry efficiency. The specific technical scheme is as follows:
in a first aspect, a data display method is provided, the method comprising:
target data input by a user into a first cell of the spreadsheet is identified, and a first data structure of the target data is identified.
When the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; the target unit cell is a front preset column unit cell or a front preset row unit cell of the first unit cell.
And when the second data formats of the data in the target cells are the same and the first data structure is the same as the second data structure, displaying the target data.
Optionally, after determining the second data format and the second data structure of the data in the target cell, the method further includes:
and when one or more conditions that the second data format of the data in the target cell is different and the first data structure is different from the second data structure are met, converting the target data into the data meeting the first data format.
The converted data is displayed in the first cell.
Optionally, after identifying the target data input into the first cell of the spreadsheet by the user and identifying the first data structure of the target data, the method further includes:
and when the first data structure does not accord with the preset conversion rule corresponding to the first data format of the first cell, displaying the target data.
Optionally, the first data format includes: a numerical format or a date format.
Optionally, before displaying the target data, the method further includes: the first data format of the first cell is set to the second data format.
In a second aspect, there is provided a data display device, the device comprising:
the identification module is used for identifying target data input into a first cell of the electronic form by a user and identifying a first data structure of the target data.
The determining module is used for determining a second data format and a second data structure of the data in the target cell when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell; the target unit cell is a front preset column unit cell or a front preset row unit cell of the first unit cell.
And the first display module is used for displaying the target data when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same.
Optionally, the data display device further includes:
and the conversion module is used for converting the target data into the data meeting the first data format when one or more conditions of different second data formats of the data in the target unit cell and different first data structures and second data structures are met after the second data formats and the second data structures of the data in the target unit cell are determined.
And the second display module is used for displaying the converted data in the first cell.
Optionally, the data display device further includes:
and the third display module is used for displaying the target data when the first data structure does not accord with the preset conversion rule corresponding to the first data format of the first cell after identifying the target data input into the first cell of the electronic form by the user and identifying the first data structure of the target data.
Optionally, the data format includes: a numerical format or a date format.
Optionally, the data display device further includes:
and the setting module is used for setting the first data format of the first cell as the second data format before the target data is displayed.
In a third aspect, an electronic device is provided, which includes a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory complete communication with each other through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any of the first aspect when executing a program stored in the memory.
In a fourth aspect, a computer-readable storage medium is provided, having stored thereon a computer program which, when being executed by a processor, carries out the method steps of any of the first aspects.
In a fifth aspect, there is provided a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of any of the first aspects above.
In an embodiment of the application, spreadsheet software may identify target data input into a first cell of a spreadsheet by a user and identify a first data structure of the target data; when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; the target cell is a front preset column cell or a front preset row cell of the first cell; and when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same, displaying the target data. Therefore, when the second data formats of the data in the target cell are the same and the first data structure is the same as the second data structure, the display form of the target data input in the first cell expected by the user can be determined to follow the display form of the data in the target cell, and the target data can be directly displayed, so that the situation that the data displayed according to the preset conversion rule does not meet the user expectation and the user needs to re-record the data is avoided. The data format that the user expects to display the input data is determined according to the second data structure and the second data format of the data of the pre-preset row cells or the pre-preset column cells, extra workload of data input by the user is reduced, and data input efficiency is improved.
Of course, not all advantages described above need to be achieved at the same time in the practice of any one product or method of the present application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a method of displaying data according to an embodiment of the present disclosure;
FIG. 2 is a flow chart of another method for displaying data according to an embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of a data display device according to an embodiment of the present disclosure;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The embodiment of the present application provides a data display method, which may be applied to spreadsheet software, and the following detailed description will be made in conjunction with a specific implementation manner, where as shown in fig. 1, the specific steps are as follows:
For example, when the user enters the target data 12.20 in the first cell, the electronic device may determine that the first data structure of the target data is two decimal places. When the user inputs the target data 31-10, the electronic device may determine that the first data structure of the target data is a dashed line type.
Specifically, when the first data structure conforms to the preset conversion rule corresponding to the first data format of the first cell, the cell in the preset row before the column of the first cell or the preset column before the row of the first cell is the target cell, and then the electronic device may determine the second data format and the second data structure of the data in the target cell.
For example, the user's first cell inputs the target data as 11-15, and the first data structure of the target data is a short bar type. In the preset conversion rule, when the data structure of the data is in a short horizontal line type and the data can be converted into the date, the spreadsheet software displays the data according to the date format, and at the moment, the first data structure of the target data conforms to the corresponding data structure of the date format in the preset conversion rule. The electronic device may then determine a second data format and a second data structure for the data in the first 4 rows of cells in the column of the first cell, or determine a second data format and a second data structure for the data in the first 4 columns of cells in the row of the first cell.
And 103, displaying the target data when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same.
In this embodiment, the first data structure and the second data structure are the same and include: the second data structure of the data in the target cell is the same and is the same as the first data structure of the first cell. And the second data formats in the target cells are the same, and when the data structure of the data input by the user in the row is the second data structure, the data format of the data expected to be displayed by the user is indicated to be the second data format. At this time, when the second data structure of the target cell is identical to the first data structure of the first cell, it indicates that the target data format of the target data that the user desires to display in the first cell is identical to the data format of the target cell.
For example, the user inputs the target data 11-15 in the first cell, and the first data structure of the target data is a short horizontal line type. In the preset conversion rule, when the data structure of the data is in a short horizontal line type and the data can be converted into the date, the spreadsheet software displays the data according to the date format, and at the moment, the first data structure of the target data conforms to the data structure corresponding to the date format in the preset conversion rule. At this time, when the data in the first 3 rows of cells (i.e., the target cells) in the column of the first cell are 31-11, 13-14, and 15-1 in sequence, it can be determined that the second data formats of the target cells are all numerical formats, and the second data structures are all short horizontal lines. In this case, the target data format indicating the target data that the user desires to display is a numeric format, rather than a date format corresponding to the preset conversion rule, so that the spreadsheet software does not convert the target data according to the preset conversion rule but directly displays the target data input by the user.
In an embodiment of the application, spreadsheet software may identify target data input into a first cell of a spreadsheet by a user and identify a first data structure of the target data; when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; the target cell is a front preset column cell or a front preset row cell of the first cell; and when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same, displaying the target data. Therefore, when the second data formats of the data in the target cell are the same and the first data structure is the same as the second data structure, the display form of the target data input in the first cell expected by the user can be determined to follow the display form of the data in the target cell, and the target data can be directly displayed, so that the situation that the data displayed according to the preset conversion rule does not meet the user expectation and the user needs to re-record the data is avoided. The data format that the user expects to display the input data is determined according to the second data structure and the second data format of the data of the pre-preset row cells or the pre-preset column cells, extra workload of data input by the user is reduced, and data input efficiency is improved.
Specifically, the first data format includes: a numerical format or a date format.
The first data format in the embodiments of the present application may include a numerical value format or a date format. The second data format may also include a numerical format or a date format. The first and second data formats may also include a time format, a currency format, a percentage format, a text format, and the like.
For example, the target data input by the user is short horizontal line type data of 11 to 15, and when the data structure of the data is short horizontal line type and the data can be converted into date in the preset conversion rule, the spreadsheet software displays the data according to the date format, and the data format of the target data conforms to the data structure corresponding to the date format in the preset conversion rule; when the target data input by the user is 015 and the data structure of the data is 015 and the data can be converted into a numerical value, the spreadsheet software displays the data according to a numerical value format, and the data structure of the target data is a data structure corresponding to the numerical value format in the preset conversion rule.
Optionally, after determining the second data format and the second data structure of the data in the target cell, the data display method further includes:
and when one or more conditions that the second data format of the data in the target cell is different and the first data structure is different from the second data structure are met, converting the target data into the data meeting the first data format.
The converted data is displayed in the first cell.
In the embodiment of the application, if the second data formats in the target cells are different, it indicates that the data input by the user in the row or the column has no fixed corresponding data format; at this time, the target data does not have a fixed corresponding data format within the first cell, regardless of whether the first data structure of the first cell is the same as the target cell second data structure. Therefore, the first cell displays the target data converted according to the preset conversion rule.
When the second data formats of the target cells are the same and the second data structure of the target cell is different from the first data structure of the target data input in the first cell, it indicates that the corresponding data format of the target data that the user desires to display in the first cell is different from the data format of the target cell, i.e., the user does not desire to follow the data format of the first cell with the data format of the target cell. Therefore, the first cell displays the target data converted according to the preset conversion rule. Therefore, after the target data input by the user is determined to have no fixed corresponding data format, the target data is converted according to the preset conversion rule, the accuracy of displaying the data by the electronic equipment after the data is input by the user is improved, data entry errors caused by mistakenly converting the data format of the target data are avoided, and the data entry efficiency is improved.
For example, the target data input by the user in the first cell is 11-11, and the first data structure of the target data is a short horizontal line type. In the preset conversion rule, when the data format of the data is a short horizontal line type and the data can be converted into the date, the spreadsheet software displays the data according to the date format, and at the moment, the first data structure of the target data conforms to the data structure corresponding to the date format in the preset conversion rule. Since the data in the first 4 rows of the first cell in the column is 31-1 and 15 in sequence: 34. 12: 11. 13-4, determining a value format, a time format and a value format of the second data format in sequence, wherein the second data structure is a short line type. And if the second data format of the first 4 rows of cells in the column of the first cell is different, the data input by the user in the column is not in the data format expected to be displayed. The data in the first 4 rows of cells in the row of the first cell are sequentially data 1.1, 1.2, 1.3, and 1.4, the second data formats that can be determined are all numerical formats, the second data structures are all one-bit decimal types, the second data formats of the first 4 columns of cells in the row of the first cell are the same, but the second data structure of the target cell is different from the first data structure of the first cell, which indicates that the data input by the user in the row has no data format that the data input by the user in the column is not expected to be displayed if the target data format of the data input by the user in the row is different from the second data format of the target cell. Therefore, the first cell displays the target data converted according to the preset conversion rule, namely, the target data is displayed as 11 th month 11.
The target data input by the user in the first cell is 11-12, and the first data structure of the target data is a short horizontal line type. In the preset conversion rule, when the data format of the data is a short horizontal line type and the data can be converted into the date, the spreadsheet software displays the data according to the date format, and at the moment, the first data structure of the target data conforms to the data structure corresponding to the date format in the preset conversion rule. Since the data in the first 2 rows of cells in the column of the first cell are 31.10 and 15 in this order: 34, the value format and the time format of the second data format can be determined in sequence, and the second data structure is two decimal numbers. If the second data format of the target cell is different, indicating that the data input by the user in the column is not in the data format expected to be displayed; the data in the first 2 columns of cells in the row of the first cell are 12: 11 and 13.40, a second data format can be determined, wherein the second data format comprises a time format and a numerical value format, and the second data structure comprises two decimal numbers. The second data format of the target cell is different, indicating that the data entered by the user in the row is not in the data format desired to be displayed. And at this time, the data structure of the target data of the first cell is different from the second data structure of the target cell, so that it can be determined that the data format corresponding to the target data is different from the second data format of the target cell. Therefore, the first cell displays the target data converted according to the preset conversion rule, namely, the target data is displayed as 11/month/12.
Optionally, after identifying the target data input into the first cell of the spreadsheet by the user and identifying the first data structure of the target data, the data display method further includes:
and when the first data structure does not accord with the preset conversion rule corresponding to the first data format of the first cell, displaying the target data.
In the embodiment of the application, when the first data format of the target data does not conform to the preset conversion rule corresponding to the first data format of the first cell, the first data format of the first cell is set to be the data format capable of displaying the data structure, and the target data is displayed according to the data structure of the target data input by the user. The accuracy of the data entry work of the user is improved, and the data entry efficiency is improved.
Optionally, before displaying the target data, the data displaying method further includes: the first data format of the first cell is set to the second data format.
In the embodiment of the application, the first data format of the first cell is set as the second data format, so that the data format of the first cell is adjusted to the data format capable of displaying the current data structure, the data format is prevented from being changed again in the subsequent input work, and the data input efficiency is improved.
Fig. 2 is a flowchart of another data display method according to an embodiment of the present disclosure.
As shown in the figure, the specific steps are as follows:
step S201: identifying target data input into a first cell of the spreadsheet by a user and identifying a first data structure of the target data;
step S202: judging whether the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell; if yes, go to step S203; if not, go to step S205;
step S203: determining a second data format and a second data structure of the data in the target cell; the target cell is a front preset column cell or a front preset row cell of the first cell;
step S204: judging whether the second data formats of the data in the target cells are the same and whether the first data structure and the second data structure are the same; if yes, go to step S205; if not, go to step S207;
step S205: setting the first data format of the first cell as a second data format;
step S206: displaying the target data;
step S206: and displaying the target data converted according to the preset conversion rule.
In the embodiment of the application, the condition that the target data is converted into the data format which is not needed by the user is avoided. The data format that the user expects to display the input data is determined according to the second data structure and the second data format of the data of the pre-preset row cells or the pre-preset column cells, extra workload of data input by the user is reduced, and data input efficiency is improved.
Based on the same technical concept, an embodiment of the present application further provides a data display apparatus, as shown in fig. 3, which is applied to an electronic device of spreadsheet software, and includes:
the identifying module 301 is configured to identify target data input into a first cell of the spreadsheet by a user and identify a first data structure of the target data.
A determining module 302, configured to determine a second data format and a second data structure of data in a target cell when the first data structure meets a preset conversion rule corresponding to the first data format of the first cell; the target unit cell is a front preset column unit cell or a front preset row unit cell of the first unit cell.
The first display module 303 is configured to display the target data when the second data formats of the data in the target cells are the same and the first data structure is the same as the second data structure.
In an embodiment of the application, spreadsheet software may identify target data input into a first cell of a spreadsheet by a user and identify a first data structure of the target data; when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; the target cell is a front preset column cell or a front preset row cell of the first cell; and when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same, displaying the target data. Therefore, when the second data formats of the data in the target cell are the same and the first data structure is the same as the second data structure, the display form of the target data input in the first cell expected by the user can be determined to follow the display form of the data in the target cell, and the target data can be directly displayed, so that the situation that the data displayed according to the preset conversion rule does not meet the user expectation and the user needs to re-record the data is avoided. The data format that the user expects to display the input data is determined according to the second data structure and the second data format of the data of the pre-preset row cells or the pre-preset column cells, extra workload of data input by the user is reduced, and data input efficiency is improved.
Optionally, the data display device further includes:
and the conversion module is used for converting the target data into the data meeting the first data format when one or more conditions of different second data formats of the data in the target unit cell and different first data structures and second data structures are met after the second data formats and the second data structures of the data in the target unit cell are determined.
And the second display module is used for displaying the converted data in the first cell.
Optionally, the data display device further includes:
and the third display module is used for displaying the target data when the first data structure does not accord with the preset conversion rule corresponding to the first data format of the first cell after identifying the target data input into the first cell of the electronic form by the user and identifying the first data structure of the target data.
Specifically, the first data format includes: a numerical format or a date format.
Optionally, the data display device further includes:
and the setting module is used for setting the first data format of the first cell as the second data format before the target data is displayed.
The embodiment of the present application further provides a schematic structural diagram of an electronic device, as shown in fig. 4, including a processor 401, a communication interface 402, a memory 403, and a communication bus 404, where the processor 401, the communication interface 402, and the memory 403 complete mutual communication through the communication bus 404,
a memory 403 for storing a computer program;
the processor 401 is configured to implement any method step in the method embodiments of the data display method when executing the program stored in the memory 403.
The communication bus mentioned in the network device may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the network device and other devices.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; the Integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA), or other Programmable logic devices, discrete Gate or transistor logic devices, or discrete hardware components.
Based on the same technical concept, embodiments of the present application further provide a computer-readable storage medium, in which a computer program is stored, and the computer program, when executed by a processor, implements any method step in the method embodiments of the data display method.
Based on the same technical concept, embodiments of the present application further provide a computer program product containing instructions, which when run on a computer, causes the computer to perform any one of the method steps in the method embodiments of the data display method described above.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus, the electronic device, the computer-readable storage medium, and the computer program product embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and in relation to them, reference may be made to the partial description of the method embodiments.
The above description is only for the preferred embodiment of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims (10)
1. A method of displaying data, the method comprising:
identifying target data input into a first cell of a spreadsheet by a user and identifying a first data structure of the target data;
when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell, determining a second data format and a second data structure of the data in the target cell; the target unit cell is a front preset column unit cell or a front preset row unit cell of the first unit cell;
and when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same, displaying the target data.
2. The method of claim 1, further comprising, after the determining the second data format and the second data structure for the data in the target cell:
converting the target data into data satisfying the first data format when one or more conditions of a second data format of the data in the target cell being different and the first data structure being different from the second data structure are satisfied;
and displaying the converted data in the first cell.
3. The method of claim 1, further comprising, after the identifying target data entered by a user into a first cell of a spreadsheet and identifying a first data structure of the target data:
and when the first data structure does not accord with the preset conversion rule corresponding to the first data format of the first cell, displaying the target data.
4. The method of claim 1, wherein the first data format comprises: a numerical format or a date format.
5. The method of claim 1, prior to said displaying said target data, further comprising:
setting the first data format of the first cell as the second data format.
6. A data display device, the device comprising:
the identification module is used for identifying target data input into a first cell of the electronic form by a user and identifying a first data structure of the target data;
the determining module is used for determining a second data format and a second data structure of the data in the target cell when the first data structure accords with a preset conversion rule corresponding to the first data format of the first cell; the target unit cell is a front preset column unit cell or a front preset row unit cell of the first unit cell;
and the first display module is used for displaying the target data when the second data formats of the data in the target cells are the same and the first data structure and the second data structure are the same.
7. The apparatus of claim 6, further comprising:
a conversion module, configured to, after the determining of the second data format and the second data structure of the data in the target cell, convert the target data into data satisfying the first data format when one or more conditions of the second data format of the data in the target cell being different and the first data structure being different from the second data structure are satisfied;
and the second display module is used for displaying the converted data in the first cell.
8. The apparatus of claim 6, further comprising:
and the third display module is used for displaying the target data when the first data structure does not accord with a preset conversion rule corresponding to the first data format of the first cell after the target data input into the first cell of the electronic form by the user is identified and the first data structure of the target data is identified.
9. The apparatus of claim 6, wherein the data format comprises: a numerical format or a date format.
10. The apparatus of claim 6, further comprising:
a setting module, configured to set the first data format of the first cell to the second data format before the target data is displayed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010456042.1A CN112784560B (en) | 2020-05-26 | 2020-05-26 | Data display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010456042.1A CN112784560B (en) | 2020-05-26 | 2020-05-26 | Data display method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112784560A true CN112784560A (en) | 2021-05-11 |
| CN112784560B CN112784560B (en) | 2024-07-23 |
Family
ID=75749118
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010456042.1A Active CN112784560B (en) | 2020-05-26 | 2020-05-26 | Data display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112784560B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113515918A (en) * | 2021-06-30 | 2021-10-19 | 珠海金山办公软件有限公司 | Data specification method and device of electronic document, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030110174A1 (en) * | 1998-11-18 | 2003-06-12 | Tadao Matsuzuki | Intelligent data structure, processing apparatus, and medium using network |
| CN102609403A (en) * | 2011-01-26 | 2012-07-25 | 微软公司 | Formatting data by example |
| US20130055059A1 (en) * | 2011-08-22 | 2013-02-28 | Can Do Gmbh | Spread Sheet Application Having Multidimensional Cells |
| CN108363732A (en) * | 2018-01-15 | 2018-08-03 | 阿里巴巴集团控股有限公司 | A kind of form processing method of multi-user collaborative, device and equipment |
| CN110287459A (en) * | 2019-05-30 | 2019-09-27 | 平安科技（深圳）有限公司 | Table batch processing method, system, device and can storage medium |
-
2020
- 2020-05-26 CN CN202010456042.1A patent/CN112784560B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030110174A1 (en) * | 1998-11-18 | 2003-06-12 | Tadao Matsuzuki | Intelligent data structure, processing apparatus, and medium using network |
| CN102609403A (en) * | 2011-01-26 | 2012-07-25 | 微软公司 | Formatting data by example |
| US20130055059A1 (en) * | 2011-08-22 | 2013-02-28 | Can Do Gmbh | Spread Sheet Application Having Multidimensional Cells |
| CN108363732A (en) * | 2018-01-15 | 2018-08-03 | 阿里巴巴集团控股有限公司 | A kind of form processing method of multi-user collaborative, device and equipment |
| CN110287459A (en) * | 2019-05-30 | 2019-09-27 | 平安科技（深圳）有限公司 | Table batch processing method, system, device and can storage medium |
Non-Patent Citations (1)
| Title |
|---|
| WEIXIN_30244681: "通过VBA，当在EXCEL单元格中输入任意的日期格式时，都能自动转换为指定的标准格式的 日期值...", pages 1 - 4, Retrieved from the Internet <URL:https://blog.csdn.net/weixin_30244681/article/details/97552656?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522170372897016800215030573%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=170372897016800215030573&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-5-97552656-null-null.142^v99^pc_search_result_base5&utm_term=%E5%8D%95%E5%85%83%E6%A0%BC%20%E6%A0%BC%E5%BC%8F%20%E6%97%A5%E6%9C%9F%20%E8%87%AA%E5%8A%A8%20%E8%BD%AC%E6%8D%A2&spm=1018.2226.3001.4187> * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113515918A (en) * | 2021-06-30 | 2021-10-19 | 珠海金山办公软件有限公司 | Data specification method and device of electronic document, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112784560B (en) | 2024-07-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111126045A (en) | Text error correction method and device | |
| CN109213978B (en) | Method and device for merging cells, electronic equipment and readable storage medium | |
| CN113052676A (en) | Intelligent wind control decision method, device, equipment and readable storage medium | |
| CN111949550B (en) | Method, device, equipment and storage medium for automatically generating test data | |
| CN111476017B (en) | Webpage form editing method and device and electronic equipment | |
| CN112784560B (en) | Data display method and device | |
| CN113515703A (en) | Information recommendation method and device, electronic equipment and readable storage medium | |
| CN112052647B (en) | Document editing method and device, electronic equipment and readable storage medium | |
| CN112784552B (en) | Table editing method and apparatus | |
| CN111782629B (en) | Feature processing script generation method and device | |
| CN115034189A (en) | Table data processing method and device, computer equipment and storage medium | |
| CN113537631A (en) | Method and device for predicting medicine demand, electronic equipment and storage medium | |
| CN112784564B (en) | Document generation method and device | |
| CN111598704A (en) | Correlation processing method, device and equipment for combined investment of air drop mechanism | |
| CN112231316B (en) | Graph display method and device and electronic equipment | |
| CN110209690B (en) | Data acquisition method and device and electronic equipment | |
| CN112232046A (en) | Method and device for displaying repeated items of table | |
| CN110049374A (en) | A kind of focus frame determines method and device | |
| CN118673893B (en) | Method, device and equipment for generating document and computer readable storage medium | |
| CN112784550B (en) | Information input method and device | |
| CN111832267B (en) | Cell pasting method and device | |
| CN113766333B (en) | Method and device for determining video heat value, electronic equipment and storage medium | |
| CN110928470B (en) | Signature box display method and device, electronic equipment and storage medium | |
| CN112632929B (en) | Method and device for intelligently recommending chart based on table data and electronic equipment | |
| CN112181240A (en) | Information display method and device |
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 |