CN111832270A - Method and device for displaying row number and column label of table and electronic equipment - Google Patents
Method and device for displaying row number and column label of table and electronic equipment Download PDFInfo
- Publication number
- CN111832270A CN111832270A CN201910236427.4A CN201910236427A CN111832270A CN 111832270 A CN111832270 A CN 111832270A CN 201910236427 A CN201910236427 A CN 201910236427A CN 111832270 A CN111832270 A CN 111832270A
- Authority
- CN
- China
- Prior art keywords
- column
- row
- current table
- target
- line
- 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 63
- 238000004891 communication Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 11
- 238000009877 rendering Methods 0.000 claims 2
- 238000013507 mapping Methods 0.000 claims 1
- 230000008569 process Effects 0.000 abstract description 16
- 230000006870 function Effects 0.000 description 7
- 230000001960 triggered effect Effects 0.000 description 5
- 230000009471 action Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000007423 decrease Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention provides a method and a device for displaying row numbers and column labels of a table and electronic equipment, wherein the method comprises the following steps: if the fact that the formula needs to be edited aiming at the current table is detected, the row number of the row contained in the current table, the column number of the column contained in the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each row and the horizontal coordinate value corresponding to each column are obtained; drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table; and drawing the row number corresponding to each row based on the row number of the row contained in the current table, the longitudinal coordinate value corresponding to each row and the position coordinate corresponding to the current table so as to realize the purpose that the row number and the column mark of the table are automatically displayed when a user needs to edit a formula aiming at the table in the process of using the table of office document software, thereby improving the user experience.
Description
Technical Field
The invention relates to the technical field of table processing, in particular to a method and a device for displaying row numbers and column labels of a table and electronic equipment.
Background
When a user uses a table of Office document software such as microsoft Office Word or WPS text, there may be a case where the contents of some cells in the table are operated. Currently, the office document software provides a formula insertion function, which can only provide some basic operations on the contents of cells in whole columns and/or the contents of cells in whole rows, and if the contents of cells in certain specific columns or the contents of cells in specific rows need to be operated, the user needs to manually input an operation formula for the cells in certain specific columns and/or the cells in specific rows, wherein when the user manually inputs the operation formula, the user needs to input a row number of a row where a cell referenced by the operation formula is located and a column label of the column where the cell is located, for example: the operation formula needs to reference the cells in the first column and the second row, and B2 is needed to be input, where B is the column label of the column where the cell is located, and 2 is the row number of the row where the cell is located.
However, Office document software such as microsoft Office Word or WPS text does not display the row number of the row where the cell is located and the column label of the column where the cell is located in the table at present. At this time, when the user inputs the operation formula for some cells in specific columns and/or cells in specific rows, the user needs to determine the row number of the row where the cell to be referred to is located and the column mark of the column where the cell is located by himself/herself, so that when the user uses the table, the efficiency is low and errors are prone to occur when the user inputs the operation formula for some cells in specific columns and/or cells in specific rows.
Disclosure of Invention
The embodiment of the invention aims to provide a method and a device for displaying a row number and a column label of a table and electronic equipment, so that the row number and the column label of the table can be automatically displayed when a user needs to edit a formula aiming at the table, and the user experience is improved. The specific technical scheme is as follows:
in one aspect, an embodiment of the present invention provides a method for displaying a row number and a column number of a table, where the method includes:
if the fact that a formula needs to be edited for the current table is detected, acquiring the number of rows of a row contained in the current table, the number of columns of a column contained in the current table, a position coordinate corresponding to the current table, a longitudinal coordinate value corresponding to each row and an abscissa coordinate value corresponding to each column;
drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
and drawing a line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
Optionally, the step of drawing a column mark corresponding to each column based on the number of columns of the column included in the current table, the abscissa value corresponding to each column, and the position coordinate corresponding to the current table includes:
determining a column mark of each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining a target column width of a target column, wherein the target column is one of columns included in the current table;
setting a first display width of a display area of a target column mark corresponding to the target column as the width of the target column;
setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column;
obtaining the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of the target column mark based on a longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark;
and drawing the target column marks based on the set first abscissa value, the set first ordinate value and the set first display width.
Optionally, the step of drawing, based on the number of rows of the rows included in the current table, the ordinate value corresponding to each row, and the position coordinate corresponding to the current table, the row number corresponding to each row includes:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in the current table;
setting a second display height of a display area of a target row number corresponding to the target row as the target row height;
setting a second longitudinal coordinate value of the display area of the target row number as a longitudinal coordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value in the position coordinate corresponding to the current table and the row number width;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
Optionally, after the step of drawing, based on the number of rows of the rows included in the current table, the ordinate value corresponding to each row, and the position coordinate corresponding to the current table, a row number corresponding to each row, the method further includes:
if a closing instruction for closing the formula window is detected, clearing the column mark corresponding to each drawn column and the row number corresponding to each row, wherein the formula window is as follows: and editing a window required by the formula for the current table.
Optionally, before the step of obtaining, if it is detected that a formula needs to be edited for a current table, a number of rows and a number of columns of a row included in the current table, a position coordinate corresponding to the current table, and a ordinate value and an abscissa value corresponding to each row and each column, the method further includes:
and judging whether a handle of the formula window exists or not, wherein if the handle of the formula window exists, detecting to obtain a formula which needs to be edited aiming at the current table, wherein the formula window is a window which needs to be edited aiming at the current table.
In another aspect, an embodiment of the present invention provides a display device for displaying a row number and a column number of a table, where the device includes:
the obtaining module is used for obtaining the row number of the row contained in the current table, the column number of the column contained in the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each row and the horizontal coordinate value corresponding to each column if the current table editing formula is detected to be required to be aimed at;
the first drawing module is used for drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
and the second drawing module is used for drawing the line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
Optionally, the first drawing module is specifically configured to:
determining a column mark of each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining a target column width of a target column, wherein the target column is one of columns included in the current table;
setting a first display width of a display area of a target column mark corresponding to the target column as the width of the target column;
setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column;
obtaining the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of the target column mark based on a longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark;
and drawing the target column marks based on the set first abscissa value, the set first ordinate value and the set first display width.
Optionally, the second drawing module is specifically configured to:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in the current table;
setting a second display height of a display area of a target row number corresponding to the target row as the target row height;
setting a second longitudinal coordinate value of the display area of the target row number as a longitudinal coordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value in the position coordinate corresponding to the current table and the row number width;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
Optionally, the apparatus further comprises:
a clearing module, configured to, after drawing a line number corresponding to each line based on the number of lines in the line included in the current table, a longitudinal coordinate value corresponding to each line, and a position coordinate corresponding to the current table, if a closing instruction for closing a formula window is detected, clear a column number corresponding to each drawn column and a line number corresponding to each line, where the formula window is: and editing a window required by the formula for the current table.
Optionally, the apparatus further comprises:
and the judging module is used for judging whether a handle of a formula window exists before the current table is detected to be required to edit the formula aiming at the current table, the line number of the included lines and the column number of the included columns of the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each line and the abscissa coordinate value corresponding to each column are obtained, wherein if the handle of the formula window exists, the current table is detected to be required to edit the formula aiming at the current table, and the formula window is required to edit the formula aiming at the current table.
On the other hand, the embodiment of the invention provides electronic equipment, which comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory complete mutual communication through the communication bus;
a memory for storing a computer program;
the processor is configured to implement the steps of the method for displaying the row number and the column label of the table provided in the embodiment of the present invention when executing the computer program stored in the memory.
In another aspect, an embodiment of the present invention provides a computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method for displaying a row number and a column label of a table provided in an embodiment of the present invention are implemented.
In the technical scheme provided by the embodiment of the invention, if the fact that a formula needs to be edited for a current table is detected, the row number of a row contained in the current table, the column number of a column contained in the current table, a position coordinate corresponding to the current table, a longitudinal coordinate value corresponding to each row and an abscissa coordinate value corresponding to each column are obtained; drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table; and drawing a line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
By applying the embodiment of the invention, when the formula needs to be edited aiming at the current table is detected, the column mark corresponding to each column can be drawn according to the column number of the column contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table, and the row number corresponding to each row is drawn based on the row number of the row contained in the current table, the ordinate value corresponding to each row and the position coordinate corresponding to the current table, so that the row number and the column mark of the table can be automatically displayed, the accuracy and the convenience of inputting the row number and the column mark corresponding to the cited cell can be improved when a user edits the formula, and the use experience of the user can be improved. Of course, it is not necessary for any product or method of practicing the invention to achieve all of the above-described advantages at the same time.
Drawings
In order to more clearly illustrate the embodiments of the present invention 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 invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic flowchart of a method for displaying a row number and a column number of a table according to an embodiment of the present invention;
FIG. 2 is a schematic diagram showing the row number and column number of the generated table;
fig. 3 is a schematic flowchart of a method for displaying a row number and a column number of a table according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a display device for displaying row numbers and column labels of a table according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
The embodiment of the invention provides a method and a device for displaying a row number and a column label of a table and electronic equipment, which are used for automatically displaying the row number and the column label of the table when a user needs to edit a formula aiming at the table, and improving the user experience.
As shown in fig. 1, an embodiment of the present invention provides a method for displaying a row number and a column number of a table, which may include the following steps:
s101: if the fact that the formula needs to be edited aiming at the current table is detected, the row number of the row contained in the current table, the column number of the column contained in the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each row and the horizontal coordinate value corresponding to each column are obtained;
it can be understood that the method for displaying the row number and the column label of the table provided by the embodiment of the invention can be applied to any type of electronic equipment, and the electronic equipment can be a computer, a smart phone and the like. In one case, the functional software for implementing the display flow of the row number and column number of the table may exist in the form of a special client software, or may exist in the form of a plug-in of the current client software, where the current client software may be: office document software such as Microsoft office word or WPS characters.
When the functional software for realizing the display flow of the row number and the column number of the table exists in the form of a plug-in of the current client software, the functional software can be embedded or loaded into the current client software in advance. Furthermore, when the current client software is started, the functional software is started accordingly. Correspondingly, the electronic device may monitor, in real time, whether the formula editing function of the current client software for the table is triggered through the plug-in, and if it is detected that the formula editing function of the current client software for the table is triggered, it is detected that the subsequent display process of the row number and the column number of the table is executed for the current table editing formula. The current client software has a function of creating/inserting a table.
In one case, the process of monitoring whether the formula editing function for the table of the current client software is triggered may be: in the process of using the current client software, when the formula window of the current client software for the current table is detected to be opened, the formula editing function of the current client software for the table is determined to be triggered. In one case, a formula key is displayed in a display interface corresponding to the current client software, and when the electronic device detects that the formula key is clicked through the plug-in, it is determined that a formula editing function of the current client software for the form is triggered.
For example, the current client software is office document software; in the process that a user uses office document software, when the user needs to edit a formula aiming at a form, the form can be selected firstly, then a formula window is opened aiming at the selected form, the formula is edited in the formula window, and when the electronic equipment detects that the formula window is opened aiming at the selected form, the selected form can be determined to be a current form and the formula needs to be edited aiming at the current form. The mode of selecting the table may include: and (3) suspending a cursor at any position of the area where the table is located, or clicking any position of the area where the table is located through a touch pen or a finger, and the like.
In one implementation, the local or connected storage device of the electronic device may store, in advance, the number of rows in a row included in the current table, the number of columns in a column included in the current table, the position coordinate corresponding to the current table, the ordinate value corresponding to each row, and the abscissa value corresponding to each column. The electronic device can read the number of rows of the row included in the current table, the number of columns of the column included in the current table, the position coordinate corresponding to the current table, the ordinate value corresponding to each row, and the abscissa value corresponding to each column from the corresponding storage location.
The position coordinates corresponding to the current table may be: the predetermined point may be a point at the upper left corner of the current table, a point at the lower left corner of the current table, a point at the upper right corner of the current table, a point at the center position of the current table, or the like. The current form may be a form created by Office documentation software such as microsoft Office Word or WPS text.
S102: drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
in one implementation, the electronic device may cyclically call a preset drawing command based on the number of columns, sequentially determine the column labels corresponding to each column, determine, for each column, the abscissa value of the column label corresponding to the column based on the abscissa value corresponding to the column, determine, based on the position coordinate corresponding to the current table, the ordinate value of the column label corresponding to the column, further determine, based on the abscissa value and the ordinate value of the column label corresponding to the column, the drawing position of the column label corresponding to the column, and draw, based on the determined drawing position, the column labels corresponding to the column.
When determining the column identifier of each column, the electronic device may sequentially determine the column identifier corresponding to each column based on a front-back order of each column. In this implementation manner, after each column of column marks corresponding to one column is determined, that is, based on the abscissa value corresponding to the column and the position coordinate corresponding to the current table, the drawing position of the column mark corresponding to the column may be determined, and then the column mark corresponding to the column may be drawn at the determined drawing position. The process of sequentially determining the column mark corresponding to each column may be: sequentially acquiring the column label corresponding to each column from a plurality of column labels in a pre-stored sequential ordering, wherein when the column label is represented by an English letter, the sequential ordering can be as follows: the arrangement is carried out according to the arrangement sequence of Chinese and English letters of an English alphabet. Alternatively, it may be: sequentially generating the column marks corresponding to each column based on a preset column mark arrangement sequence, wherein when the column marks are represented by English letters, the preset column mark arrangement sequence is as follows: the arrangement order of Chinese and English letters in English alphabet.
In another implementation, after obtaining the number of columns of the column included in the current table, the electronic device may first determine the number of columns based on the number of columns. Furthermore, the electronic device may determine each determined column mark as the column mark corresponding to each column in the current table in sequence according to the front-back sequence of each column in the current table. After the column labels of each column are determined, the drawing position of the column labels of each column can be determined based on the abscissa value corresponding to each column and the position coordinates corresponding to the current table, and then the column labels corresponding to each column are drawn at the determined drawing position.
The process of determining the column number of column labels based on the column number may be: the electronic equipment determines the column marks at a plurality of positions in the front row from a plurality of column marks in a pre-stored sequence ordering, wherein when the column marks are represented by English letters, the sequence ordering is as follows: and sorting the English letters in the English alphabet in the arrangement order. Or, the column number of column labels may be sequentially generated based on a preset column label arrangement order, where when the column label is represented by an english letter, the preset column label arrangement order is: the arrangement order of Chinese and English letters in English alphabet.
In one case, the farther to the left the column is located in the current table, the more forward the column is characterized. The column marks determined in the embodiment of the invention have uniqueness, the column marks can be represented by English letters or numbers, and when the column marks are represented by the English letters, the more front the column in the current table is, the more front the position of the English letter in the English alphabet is. Wherein, when determining the number of columns, the determination may be from the letter a. The determination method of the column mark corresponding to each column may refer to a determination method of a column mark in the related art, and the embodiment of the present invention does not limit the determination method of the column mark corresponding to each column.
S103: and drawing a line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
In one implementation, the electronic device may cyclically call a preset drawing command based on the number of rows, sequentially determine a row number corresponding to each row, determine, for each row, an ordinate value of the row number corresponding to the row based on an ordinate value corresponding to the row, determine, based on a position coordinate corresponding to the current table, an abscissa value of the row number corresponding to the row, further determine, based on the abscissa value and the ordinate value of the row number corresponding to the row, a drawing position of the row number of the row, and draw, based on the determined drawing position, the row number corresponding to the row.
When determining the line number of each line, the electronic device may sequentially determine the line number corresponding to each line based on a front-back order of each line. In this implementation manner, after each row number corresponding to a row is determined, that is, based on the ordinate value corresponding to the row and the position coordinate corresponding to the current table, the drawing position of the row number corresponding to the row is determined, and then the row number corresponding to the row is drawn at the determined drawing position.
In another implementation, after obtaining the number of rows of the columns included in the current table, the electronic device may first determine the number of rows based on the number of rows. Furthermore, the electronic device may determine, in sequence, each determined line number as the line number corresponding to each line in the current table according to a front-back order of each line in the current table. After the line number of each line is determined, a drawing position of the line number corresponding to each line may be determined based on the ordinate value corresponding to each line and the position coordinate corresponding to the current table, and the line number corresponding to each line may be drawn at the determined drawing position.
In one case, the higher the row is in the current table, the more forward the column is characterized. The line numbers determined in the embodiment of the invention are all unique, the line numbers can be represented by numbers or English letters, and when the line numbers are represented by the numbers, the more front lines in the current table are, the smaller the numbers are. When the number of rows is determined, the number may be determined from the number 1, for example, when the number of rows included in the current table is N, the determined row number may include an integer from 1 to N, and N may be greater than or equal to 1. The determination method of the row number corresponding to each row may refer to a column mark determination method in the related art, and the determination method of the row number corresponding to each row is not limited in the embodiment of the present invention.
In the embodiment of the present invention, the execution sequence of S102 and S103 is not limited, and S102 and S103 may be executed sequentially or in parallel, and when S102 and S103 are executed sequentially, S102 and then S103 may be executed first, or S103 and then S102 may be executed first.
By applying the embodiment of the invention, when the formula needs to be edited aiming at the current table is detected, the column mark corresponding to each column can be drawn according to the column number of the column contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table, and the row number corresponding to each row is drawn based on the row number of the row contained in the current table, the ordinate value corresponding to each row and the position coordinate corresponding to the current table, so that the row number and the column mark of the table can be automatically displayed, the accuracy and the convenience of inputting the row number and the column mark corresponding to the cited cell can be improved when a user edits the formula, and the use experience of the user can be improved.
In one implementation, in order to enable the user to better focus on the drawn column marks and row numbers, the column marks corresponding to each column may be drawn above each column, at this time, an abscissa value of the column mark corresponding to each column may be the same as an abscissa value of the column, and ordinate values of the column marks corresponding to each column may be the same, and the ordinate value of the column mark corresponding to each column is related to the position coordinate corresponding to the current table. The step of drawing the column mark corresponding to each column based on the number of columns of the column included in the current table, the abscissa value corresponding to each column, and the position coordinate corresponding to the current table may include:
determining a column mark corresponding to each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining the target column width of a target column, wherein the target column is one column in columns contained in a current table;
setting a first display width of a display area of a target column mark corresponding to a target column as a target column width;
setting a first abscissa value of a display area of the target column mark as an abscissa value corresponding to the target column;
acquiring the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of a target column mark based on a longitudinal coordinate value and a column height degree in a position coordinate corresponding to a current table;
and drawing the target column marks based on the set first abscissa value, the first ordinate value and the first display width.
In one case, the column width of each column in the current table may be different, and in order to ensure the user's experience in using, when drawing the column icon corresponding to each column, the position accuracy of the drawn column icon needs to be ensured, so that the user can clearly know which column icon corresponds to which column. In view of this, when drawing the column labels, the column label corresponding to each column may be drawn in consideration of the width of each column and the height of the column label corresponding to each column. The heights of the column marks corresponding to each column may be the same or different. In one case, in order to improve the user experience and the visual effect, the height of the column mark corresponding to each column may be set to be the same.
In this implementation, when the position coordinates of the current table are: when the position coordinate of the point at the upper left corner of the current table is determined, the electronic device may first obtain a width of a target column as a target column width when drawing the column icon, and set a first display width of a display area of the target column icon corresponding to the target column as the target column width; further setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column; acquiring the column mark height of the target column mark; setting a first longitudinal coordinate value of a display area of a target column mark based on a longitudinal coordinate value and a column height degree in the position coordinate corresponding to the current table; and then drawing a display area of the target list mark based on the set first abscissa value, the set first ordinate value and the set first display width, and further drawing the target list at the center position of the display area. The electronic device may determine the column label of each column in turn according to the front-back order of the columns included in the current table, and perform the process of drawing the column label by using the column as the target column.
The length of the display area of the target list mark is equal to the width of the target list corresponding to the target list mark, and the width of the display area of the target list mark is equal to the height of the target list mark.
In one aspect, when the abscissa value of the column included in the current table gradually increases along the abscissa direction of the coordinate system in which the current table is located, and the ordinate value of the row included in the current table gradually increases along the ordinate direction of the coordinate system in which the current table is located, the process of setting the first ordinate value of the display area of the target column icon based on the ordinate value and the column height in the position coordinate corresponding to the current table may be: and setting the first longitudinal coordinate value of the display area of the target column mark as the difference between the longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark.
In another case, when the abscissa value of the column included in the current table gradually increases along the abscissa direction of the coordinate system in which the current table is located, and the ordinate value of the row included in the current table gradually decreases along the ordinate direction of the coordinate system in which the current table is located, the step of setting the first ordinate value of the display area of the target column object based on the ordinate value and the column height in the position coordinate corresponding to the current table may be: and setting a first longitudinal coordinate value of the display area of the target column mark as the sum of the longitudinal coordinate value in the position coordinate corresponding to the current table and the column height degree.
When the ordinate value corresponding to each row refers to the ordinate value of the point at the top left corner of the row, and the abscissa value of the point at the top left corner of the row corresponds to the abscissa value of each column, the position represented by the first ordinate value and the first abscissa value may be the position of the point at the top left corner of the display area of the column icon.
In the embodiment of the invention, the display area of the column marks is determined by combining the width of each column, the height of the column marks corresponding to each column, the abscissa value of each column and the ordinate value in the position coordinate corresponding to the current table, and then the column marks are drawn at the center position of the display area of the column marks, so that the corresponding relation between the columns and the column marks can be ensured, and the attractiveness can be enhanced.
In one implementation, in order to enable the user to better focus on the drawn column marks and row numbers, the row number corresponding to each row may be drawn on the left side of each row, at this time, the ordinate value of the row number corresponding to each row is the same as the ordinate value of the row, the abscissa value of the row number corresponding to each row is the same, and the abscissa value of the row number corresponding to each row is related to the position coordinate corresponding to the current table. The step of drawing the line number corresponding to each line based on the line number of the line included in the current table, the ordinate value corresponding to each line, and the position coordinate corresponding to the current table may include:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in a current table;
setting a second display height of a display area of a target line number corresponding to the target line as a target line height;
setting a second ordinate value of the display area of the target row number as an ordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value and the row number width in the position coordinate corresponding to the current table;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
In one case, the line heights of each line in the current table may be different, and in order to ensure the user experience, when the line number corresponding to each line is drawn, the position accuracy of the drawn line number needs to be ensured, so that the user can clearly know which line number corresponds to which line. In view of this, when drawing the line number, the line number corresponding to each line may be drawn in consideration of the height of each line and the line number width of the line number corresponding to each line. The line number width of the line number corresponding to each line can be the same or different. In one case, in order to improve the user experience and the visual effect, the row number width of the row number corresponding to each row may be set to be the same.
In this implementation, when the position coordinates of the current table are: when the position coordinate of the point at the upper left corner of the current table is obtained, the electronic device may first obtain the height of the target row as the target row height when drawing the row number, and set the second display height of the display area of the target row number corresponding to the target row as the target row height; further setting a second ordinate value of the display area of the target row number as an ordinate value corresponding to the target row; obtaining the line number width of the target line number; setting a second abscissa value of the display area of the target row number based on the abscissa value and the row number width in the position coordinate corresponding to the current table; and then drawing a display area of the target row number based on the set second abscissa value, second ordinate value and second display height, and further drawing the target row number at the central position of the display area. The electronic device may determine the line number of each line in turn according to the front-back order of the line included in the current table, and perform the process of drawing the line number by using the line as a target line.
The length of the display area of the target line number is equal to the target line height of the target line corresponding to the target line number, and the width of the display area of the target line number is equal to the line number width of the target line number.
In one aspect, when the abscissa values of the columns included in the current table gradually increase along the abscissa direction of the coordinate system in which the current table is located, and the ordinate values of the rows included in the current table gradually increase along the ordinate direction of the coordinate system in which the current table is located, the process of setting the second abscissa value of the display area of the target row number based on the abscissa value and the row number width in the position coordinate corresponding to the current table may be: and setting a second abscissa value of the display area of the target row number as the difference between the abscissa value in the position coordinate corresponding to the current table and the target row number.
In another case, when the abscissa values of the columns included in the current table gradually decrease along the abscissa direction of the coordinate system in which the current table is located, and the ordinate values of the rows included in the current table gradually increase along the ordinate direction of the coordinate system in which the current table is located, the process of setting the second abscissa value of the display area of the target row number based on the abscissa value and the row number width in the position coordinate corresponding to the current table may be: and setting a second abscissa value of the display area of the target row number as the sum of the abscissa value in the position coordinate corresponding to the current table and the target row number.
When the ordinate value corresponding to each row refers to the ordinate value of the point at the top left corner of the row, and the abscissa value of the point at the top left corner of the row corresponds to the abscissa value at each column, the position represented by the second ordinate value and the second abscissa value may be the position of the point at the top left corner of the display area of the row number.
In the embodiment of the invention, the height of each line, the line number width of the line number corresponding to each line, the longitudinal coordinate value of each line and the abscissa value in the position coordinate corresponding to the current table are combined to determine the display area of the line number, and then the line number is drawn at the central position of the display area of the line number, so that the corresponding relation between the line and the line number can be ensured, and the attractiveness can be enhanced.
Fig. 2 is a schematic illustration showing a method for displaying a row number and a column label of a table according to an embodiment of the present invention, in which the row number and the column label of the generated table are drawn. As shown in fig. 2, column labels corresponding to columns are drawn above the columns included in the current table, and row numbers corresponding to rows are drawn on the left side of the rows included in the current table. The column mark corresponding to each column is represented by English letters, the position of the column in the table is closer to the right, the column mark is used for representing the English letters of the column mark corresponding to the column, and the sequence of the English letters in the English alphabet is closer to the back; the row number corresponding to each row is characterized by a number, and the lower the row is in the table, the larger the number used for characterizing the row number corresponding to the row is. As shown in fig. 2, after the user opens the formula window, the user can input the formula quickly through the row number corresponding to each row and the column mark corresponding to each column in the displayed table, so that the efficiency of using the table by the user is improved, and the probability of the user for mistaking the formula is reduced.
In an implementation manner, in order to better ensure the use experience of the user and not to interfere with the normal operation of the user, after it is determined that the user no longer needs to use the column mark and the row number of the table, the drawn column mark and row number can be automatically deleted. After the step of drawing the line number corresponding to each line based on the line number of the line included in the current table, the ordinate value corresponding to each line, and the position coordinate corresponding to the current table, the method may further include:
if a closing instruction for closing the formula window is detected, clearing the column mark corresponding to each drawn column and the row number corresponding to each row, wherein the formula window is as follows: the window required to edit the formula for the current form.
After detecting a closing instruction for closing a formula window required by the current table editing formula, the electronic device can determine that the user does not need to use the column mark and the row number of the table any more, and at this time, can directly clear the column mark corresponding to each drawn column and the row number corresponding to each drawn row.
In one implementation, as shown in fig. 3, the method may include the steps of:
s301: judging whether a handle of a formula window exists or not, wherein the formula window is a window required by a formula edited aiming at a current table; if the handle of the formula window exists, detecting that the formula needs to be edited aiming at the current table, and executing S302;
s302: acquiring the row number of the included rows, the column number of the included columns, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each row and the horizontal coordinate value corresponding to each column of the current table;
s303: drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
s304: and drawing a line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
Wherein the S302 is the same as S101 shown in fig. 1, the S303 is the same as S102 shown in fig. 1, and the S304 is the same as S103 shown in fig. 1.
In this implementation manner, the electronic device may determine whether a formula that needs to be edited for the current table is detected by determining whether a handle of a formula window that is needed for the current table editing formula exists, and if the handle of the formula window exists, the electronic device detects that the formula needs to be edited for the current table, and may further perform a subsequent display process of a row number and a column number of the table for the current table; otherwise, if the handle of the formula window is judged to exist, the fact that the formula needs to be edited aiming at the current table is not detected.
Corresponding to the above method embodiment, an embodiment of the present invention provides a display apparatus for a row number and a column number of a table, and as shown in fig. 4, the apparatus may include:
an obtaining module 410, configured to obtain, if it is detected that a formula needs to be edited for a current table, a number of rows of a row included in the current table, a number of columns of a column included in the current table, a position coordinate corresponding to the current table, a longitudinal coordinate value corresponding to each row, and an abscissa coordinate value corresponding to each column;
a first drawing module 420, configured to draw a column label corresponding to each column based on the number of columns of the column included in the current table, an abscissa value corresponding to each column, and a position coordinate corresponding to the current table;
the second drawing module 430 is configured to draw a line number corresponding to each line based on the line number of the line included in the current table, the ordinate value corresponding to each line, and the position coordinate corresponding to the current table.
By applying the embodiment of the invention, when the formula needs to be edited aiming at the current table is detected, the column mark corresponding to each column can be drawn according to the column number of the column contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table, and the row number corresponding to each row is drawn based on the row number of the row contained in the current table, the ordinate value corresponding to each row and the position coordinate corresponding to the current table, so that the row number and the column mark of the table can be automatically displayed, the accuracy and the convenience of inputting the row number and the column mark corresponding to the cited cell can be improved when a user edits the formula, and the use experience of the user can be improved.
In an implementation manner, the first drawing module 420 is specifically configured to:
determining a column mark of each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining a target column width of a target column, wherein the target column is one of columns included in the current table;
setting a first display width of a display area of a target column mark corresponding to the target column as the width of the target column;
setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column;
obtaining the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of the target column mark based on a longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark;
and drawing the target column marks based on the set first abscissa value, the set first ordinate value and the set first display width.
In an implementation manner, the second drawing module 430 is specifically configured to:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in the current table;
setting a second display height of a display area of a target row number corresponding to the target row as the target row height;
setting a second longitudinal coordinate value of the display area of the target row number as a longitudinal coordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value in the position coordinate corresponding to the current table and the row number width;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
In one implementation, the apparatus further comprises:
a clearing module, configured to, after drawing a line number corresponding to each line based on the number of lines in the line included in the current table, a longitudinal coordinate value corresponding to each line, and a position coordinate corresponding to the current table, if a closing instruction for closing a formula window is detected, clear a column number corresponding to each drawn column and a line number corresponding to each line, where the formula window is: and editing a window required by the formula for the current table.
In one implementation, the apparatus further comprises:
and the judging module is used for judging whether a handle of a formula window exists before the current table is detected to be required to edit the formula aiming at the current table, the line number of the included lines and the column number of the included columns of the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each line and the abscissa coordinate value corresponding to each column are obtained, wherein if the handle of the formula window exists, the current table is detected to be required to edit the formula aiming at the current table, and the formula window is required to edit the formula aiming at the current table.
Corresponding to the above method embodiments, the embodiment of the present invention further provides an electronic device, as shown in fig. 5, including a processor 510, a communication interface 520, a memory 530 and a communication bus 540, where the processor 510, the communication interface 520, and the memory 530 complete mutual communication through the communication bus 540,
a memory 530 for storing a computer program;
the processor 510 is configured to implement the steps of the method for displaying the row number and the column label of any one of the tables provided by the embodiments of the present invention when executing the computer program stored in the memory 530.
By applying the embodiment of the invention, when the formula needs to be edited aiming at the current table is detected, the column mark corresponding to each column can be drawn according to the column number of the column contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table, and the row number corresponding to each row is drawn based on the row number of the row contained in the current table, the ordinate value corresponding to each row and the position coordinate corresponding to the current table, so that the row number and the column mark of the table can be automatically displayed, the accuracy and the convenience of inputting the row number and the column mark corresponding to the cited cell can be improved when a user edits the formula, and the use experience of the user can be improved.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. 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 electronic equipment and other equipment.
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; but may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component.
Corresponding to the above method embodiment, an embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the method for displaying a row number and a column number of a table provided in the embodiment of the present invention is implemented.
By applying the embodiment of the invention, when the formula needs to be edited aiming at the current table is detected, the column mark corresponding to each column can be drawn according to the column number of the column contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table, and the row number corresponding to each row is drawn based on the row number of the row contained in the current table, the ordinate value corresponding to each row and the position coordinate corresponding to the current table, so that the row number and the column mark of the table can be automatically displayed, the accuracy and the convenience of inputting the row number and the column mark corresponding to the cited cell can be improved when a user edits the formula, and the use experience of the user can be improved.
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 system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (12)
1. A method for displaying a row number and a column number of a table, the method comprising:
if the fact that a formula needs to be edited for the current table is detected, acquiring the number of rows of a row contained in the current table, the number of columns of a column contained in the current table, a position coordinate corresponding to the current table, a longitudinal coordinate value corresponding to each row and an abscissa coordinate value corresponding to each column;
drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
and drawing a line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
2. The method according to claim 1, wherein the step of drawing the column index corresponding to each column based on the number of columns included in the current table, the abscissa value corresponding to each column, and the position coordinate corresponding to the current table comprises:
determining a column mark of each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining a target column width of a target column, wherein the target column is one of columns included in the current table;
setting a first display width of a display area of a target column mark corresponding to the target column as the width of the target column;
setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column;
obtaining the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of the target column mark based on a longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark;
and drawing the target column marks based on the set first abscissa value, the set first ordinate value and the set first display width.
3. The method according to claim 1, wherein the step of mapping the row number corresponding to each row based on the row number of the row included in the current table, the ordinate value corresponding to each row, and the position coordinate corresponding to the current table comprises:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in the current table;
setting a second display height of a display area of a target row number corresponding to the target row as the target row height;
setting a second longitudinal coordinate value of the display area of the target row number as a longitudinal coordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value in the position coordinate corresponding to the current table and the row number width;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
4. The method according to any one of claims 1-3, wherein after the step of plotting the row number corresponding to each row based on the number of rows contained in the current table, the ordinate value corresponding to each row, and the position coordinate corresponding to the current table, the method further comprises:
if a closing instruction for closing the formula window is detected, clearing the column mark corresponding to each drawn column and the row number corresponding to each row, wherein the formula window is as follows: and editing a window required by the formula for the current table.
5. The method according to any one of claims 1-3, wherein before the step of obtaining the number of rows and the number of columns of the current table, the position coordinates corresponding to the current table, and the ordinate value and the abscissa value corresponding to each row and each column, if it is detected that the formula needs to be edited for the current table, the method further comprises:
and judging whether a handle of the formula window exists or not, wherein if the handle of the formula window exists, detecting to obtain a formula which needs to be edited aiming at the current table, wherein the formula window is a window which needs to be edited aiming at the current table.
6. A display device for row and column designations of a table, the device comprising:
the obtaining module is used for obtaining the row number of the row contained in the current table, the column number of the column contained in the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each row and the horizontal coordinate value corresponding to each column if the current table editing formula is detected to be required to be aimed at;
the first drawing module is used for drawing a column mark corresponding to each column based on the column number of the columns contained in the current table, the abscissa value corresponding to each column and the position coordinate corresponding to the current table;
and the second drawing module is used for drawing the line number corresponding to each line based on the line number of the line contained in the current table, the longitudinal coordinate value corresponding to each line and the position coordinate corresponding to the current table.
7. The apparatus of claim 6, wherein the first rendering module is specifically configured to:
determining a column mark of each column based on the column number of the columns contained in the current table; aiming at each column, executing the following steps and drawing a column mark corresponding to the column mark;
obtaining a target column width of a target column, wherein the target column is one of columns included in the current table;
setting a first display width of a display area of a target column mark corresponding to the target column as the width of the target column;
setting a first abscissa value of the display area of the target column mark as an abscissa value corresponding to the target column;
obtaining the column mark height of the target column mark;
setting a first longitudinal coordinate value of a display area of the target column mark based on a longitudinal coordinate value in the position coordinate corresponding to the current table and the height of the column mark;
and drawing the target column marks based on the set first abscissa value, the set first ordinate value and the set first display width.
8. The apparatus of claim 6, wherein the second rendering module is specifically configured to:
determining a line number corresponding to each line based on the line number of the line contained in the current table; aiming at each row, executing the following steps to draw the corresponding row number;
obtaining a target row height of a target row, wherein the target row is one row in rows contained in the current table;
setting a second display height of a display area of a target row number corresponding to the target row as the target row height;
setting a second longitudinal coordinate value of the display area of the target row number as a longitudinal coordinate value corresponding to the target row;
obtaining the line number width of the target line number;
setting a second abscissa value of the display area of the target row number based on the abscissa value in the position coordinate corresponding to the current table and the row number width;
and drawing the target row number based on the set second abscissa value, second ordinate value and second display height.
9. The apparatus according to any one of claims 6-8, further comprising:
a clearing module, configured to, after drawing a line number corresponding to each line based on the number of lines in the line included in the current table, a longitudinal coordinate value corresponding to each line, and a position coordinate corresponding to the current table, if a closing instruction for closing a formula window is detected, clear a column number corresponding to each drawn column and a line number corresponding to each line, where the formula window is: and editing a window required by the formula for the current table.
10. The apparatus according to any one of claims 6-8, further comprising:
and the judging module is used for judging whether a handle of a formula window exists before the current table is detected to be required to edit the formula aiming at the current table, the line number of the included lines and the column number of the included columns of the current table, the position coordinate corresponding to the current table, the longitudinal coordinate value corresponding to each line and the abscissa coordinate value corresponding to each column are obtained, wherein if the handle of the formula window exists, the current table is detected to be required to edit the formula aiming at the current table, and the formula window is required to edit the formula aiming at the current table.
11. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of displaying the row number and column label of the table of any of claims 1-5 when executing the computer program stored in the memory.
12. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the method steps of displaying a row number and a column number of a table according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910236427.4A CN111832270B (en) | 2019-03-27 | 2019-03-27 | Method and device for displaying line numbers and column labels of tables in non-table document and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910236427.4A CN111832270B (en) | 2019-03-27 | 2019-03-27 | Method and device for displaying line numbers and column labels of tables in non-table document and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111832270A true CN111832270A (en) | 2020-10-27 |
| CN111832270B CN111832270B (en) | 2024-03-19 |
Family
ID=72914137
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910236427.4A Active CN111832270B (en) | 2019-03-27 | 2019-03-27 | Method and device for displaying line numbers and column labels of tables in non-table document and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111832270B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817974A (en) * | 2021-01-25 | 2021-05-18 | 杭州新中大科技股份有限公司 | Multi-layer list head control method for list control |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100146434A1 (en) * | 2008-12-09 | 2010-06-10 | Yahoo!, Inc. | Minimap Navigation for Spreadsheet |
| CN103336762A (en) * | 2013-07-12 | 2013-10-02 | 珠海金山办公软件有限公司 | Method and terminal for pointing out relative rank and column values in spreadsheet |
| US20130321282A1 (en) * | 2012-05-29 | 2013-12-05 | Microsoft Corporation | Row and column navigation |
| CN103761097A (en) * | 2014-01-23 | 2014-04-30 | 深圳联友科技有限公司 | Table structure comparing method of data tables |
| US20180129642A1 (en) * | 2016-11-04 | 2018-05-10 | Erik Rucker | Systems and methods for automatic application of formulas to tabular data cells |
-
2019
- 2019-03-27 CN CN201910236427.4A patent/CN111832270B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100146434A1 (en) * | 2008-12-09 | 2010-06-10 | Yahoo!, Inc. | Minimap Navigation for Spreadsheet |
| US20130321282A1 (en) * | 2012-05-29 | 2013-12-05 | Microsoft Corporation | Row and column navigation |
| CN103336762A (en) * | 2013-07-12 | 2013-10-02 | 珠海金山办公软件有限公司 | Method and terminal for pointing out relative rank and column values in spreadsheet |
| CN103761097A (en) * | 2014-01-23 | 2014-04-30 | 深圳联友科技有限公司 | Table structure comparing method of data tables |
| US20180129642A1 (en) * | 2016-11-04 | 2018-05-10 | Erik Rucker | Systems and methods for automatic application of formulas to tabular data cells |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817974A (en) * | 2021-01-25 | 2021-05-18 | 杭州新中大科技股份有限公司 | Multi-layer list head control method for list control |
| CN112817974B (en) * | 2021-01-25 | 2021-10-15 | 杭州新中大科技股份有限公司 | Multi-layer list head control method for list control |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111832270B (en) | 2024-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6282315B1 (en) | System for entering handwritten data into computer generated forms | |
| CN111831182B (en) | Application icon control method and device and electronic equipment | |
| US20140049499A1 (en) | Touch screen selection | |
| US20140006941A1 (en) | Method, system and computer program product for editing a displayed rendering of symbols | |
| CN105183184A (en) | Character processing method and terminal | |
| JP2015158900A (en) | Information processing device, information processing method and information processing program | |
| CN104657077A (en) | Cursor positioning method | |
| CN107861684A (en) | Writing recognition method and device, storage medium and computer equipment | |
| CN103116461A (en) | Character handling method and terminal based on touch screen | |
| CN106951168B (en) | Word processing method and mobile terminal | |
| US10254959B2 (en) | Method of inputting a character into a text string using a sliding touch gesture, and electronic device therefor | |
| CN111832270A (en) | Method and device for displaying row number and column label of table and electronic equipment | |
| CN104281560A (en) | Memory text information display method and device and terminal | |
| CN104657078B (en) | A kind of terminal | |
| US20230343125A1 (en) | Handwriting Recognition Method and Apparatus, Handwriting Recognition System and Interactive Display | |
| CN105302466B (en) | A kind of text operation method and terminal | |
| CN108572776A (en) | Rendering processing method, device and equipment based on special characters and storage medium | |
| CN113988008A (en) | Document object size adjusting method and device, electronic equipment and storage medium | |
| CN106775211A (en) | One kind positioning light target moving method and device | |
| CN111784800B (en) | Graphic object selection method and device, electronic equipment and storage medium | |
| CN107479720B (en) | Input device, input method and input system | |
| CN111090381B (en) | Display position adjusting method and device and electronic equipment | |
| CN111506185A (en) | Method and device for operating document, electronic equipment and storage medium | |
| JP6225724B2 (en) | Information sharing system, information sharing method, information processing apparatus, and information processing method | |
| CN112364156B (en) | Information display method and device and computer readable 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 |