[go: up one dir, main page]

CN112363663B - Data display method and device - Google Patents

Data display method and device Download PDF

Info

Publication number
CN112363663B
CN112363663B CN202011362034.7A CN202011362034A CN112363663B CN 112363663 B CN112363663 B CN 112363663B CN 202011362034 A CN202011362034 A CN 202011362034A CN 112363663 B CN112363663 B CN 112363663B
Authority
CN
China
Prior art keywords
cursor
sliding
boundary
boundary position
determining
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011362034.7A
Other languages
Chinese (zh)
Other versions
CN112363663A (en
Inventor
刘蓣蒙
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Jizhi Digital Technology Co Ltd
Original Assignee
Shenzhen Jizhi Digital Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Jizhi Digital Technology Co Ltd filed Critical Shenzhen Jizhi Digital Technology Co Ltd
Priority to CN202011362034.7A priority Critical patent/CN112363663B/en
Publication of CN112363663A publication Critical patent/CN112363663A/en
Application granted granted Critical
Publication of CN112363663B publication Critical patent/CN112363663B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04847Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/904Browsing; Visualisation therefor
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842Selection of displayed objects or displayed text elements

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The application provides a data display method and a data display device, which can firstly receive boundary position coordinates sent by a user, wherein the boundary position coordinates are marks of a boundary table of a second table to be displayed, namely marks of the table on the outermost side in a display range. Then, the table located outside the display range can be determined according to the boundary position coordinates, so as to determine the display range. After the display range is determined, data in the display range can be extracted from the first table, so that a second table is obtained and is displayed to the user. Then, the user can determine the boundary table coordinates according to the content to be browsed and input the boundary table coordinates into the computer. The computer can determine the content which needs to be browsed by the user according to the boundary table coordinates, and determine the display range corresponding to the content which needs to be browsed by the user, so that the data in the display range is extracted to obtain a second table which is displayed to the user. Thus, when the number of table entries is large, the data which the user wants to see can be quickly located.

Description

Data display method and device
Technical Field
The present application relates to the field of rights management, and in particular, to a data display method and apparatus.
Background
In application software, web pages, and the like, technicians often process data using tables. After filling a plurality of data into corresponding positions in the table, a technician can easily compare the differences between different data, so as to make corresponding decisions according to the comparison results. However, in an actual application scenario, the amount of data filled in the table may be large, so that the number of rows and/or columns of the table is relatively large, and the table cannot be displayed in one screen.
Therefore, most of the existing form editing software has a moving component, and technicians can drag the moving component or scroll wheels to adjust the display position of the form, so that users can browse various data in the form. However, the distance the moving component is dragged or the distance the roller rolls requires the technician to grasp himself. When the number of rows or columns of a table is too large, it is difficult for a technician to quickly locate the table to the extent that it needs to be viewed.
Disclosure of Invention
In view of this, embodiments of the present application provide a data display method and apparatus, and aim to provide a technical solution for a user to quickly locate a position to be browsed.
In a first aspect, an embodiment of the present application provides a data display method, where the method includes:
receiving boundary position coordinates sent by a user, wherein the boundary position coordinates are marks of a boundary table in a display range;
determining a display range according to the boundary position coordinates;
and extracting the data in the display range from the first table to obtain a second table, and displaying the second table to the user.
Optionally, the receiving the boundary position coordinates sent by the user includes:
displaying a cursor sliding groove and a sliding cursor to a user;
receiving a sliding cursor movement instruction sent by a user, and determining the relative position of a sliding cursor and a cursor sliding groove;
and determining the boundary position coordinate according to the relative position of the sliding cursor and the cursor sliding groove.
Optionally, the sliding cursor comprises a first sliding cursor and a second sliding cursor;
the determining the boundary position coordinates according to the relative position of the sliding cursor and the cursor sliding chute comprises:
determining a first boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding groove, wherein the first boundary position coordinate is an identifier of a left boundary table in the display range;
determining a second boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, wherein the second boundary position coordinate is an identifier of the right boundary table in the display range;
the step of extracting the data in the display range from the first table to obtain a second table comprises the following steps:
and extracting data positioned between the left boundary table and the right boundary table from the first table to obtain a second table.
Optionally, the sliding cursors further comprise a third sliding cursor and a fourth sliding cursor; the display range comprises a first table and a second table
The determining boundary position coordinates according to the sliding cursor coordinates comprises:
determining a first left boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding groove, and determining a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding groove; the first left boundary position coordinate is an identifier of the first table sub-left boundary table; the second left boundary position coordinate is an identifier of the second table sub-left boundary table;
determining a first right boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, and determining a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove; the first right boundary position coordinate is an identifier of the first sub-table right boundary table; the second right boundary position coordinate is an identifier of the second sub-table right boundary table;
the extracting the data in the display range from the first table comprises:
extracting data positioned between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table;
extracting data positioned between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table;
determining the second table according to the first sub-table and the second sub-table.
Optionally, the extracting data in the display range from the first table to obtain a second table includes:
receiving the coordinates of the frozen form items sent by the user;
acquiring a table freezing item according to the coordinate of the table freezing item;
determining the corresponding position of the table freezing item in a second table according to the coordinate of the table freezing item and the boundary position coordinate;
adding the table freeze entry to a corresponding location in the second table.
Optionally, the determining, according to the coordinates of the table freezing item and the boundary position coordinates, the corresponding position of the table freezing item in the second table includes:
comparing whether the coordinates of the table frozen items are less than the boundary position coordinates;
and if the coordinate of the table freezing item is smaller than the boundary position coordinate, determining that the corresponding position of the table freezing item in the second table is the leftmost side.
In a second aspect, an embodiment of the present application provides a data display apparatus, where the apparatus includes:
the receiving module is used for receiving boundary position coordinates sent by a user, and the boundary position coordinates are marks of a boundary table in a display range;
the range determining module is used for determining a display range according to the boundary position coordinates;
and the table generation module is used for extracting the data in the display range from the first table to obtain a second table and displaying the second table to a user.
Optionally, the receiving module includes:
the display module is used for displaying the cursor sliding groove and the sliding cursor to a user;
the command receiving module is used for receiving a sliding cursor movement command sent by a user and determining the relative position of the sliding cursor and a cursor sliding groove;
and the coordinate determination module is used for determining the boundary position coordinate according to the relative position of the sliding cursor and the cursor sliding groove.
Optionally, the sliding cursor comprises a first sliding cursor and a second sliding cursor;
the coordinate determination module is used for determining a first boundary position coordinate according to the first sliding cursor coordinate, wherein the first boundary position coordinate is an identifier of a left boundary table in the display range; determining a second boundary position coordinate according to the second sliding cursor coordinate, wherein the second boundary position coordinate is an identifier of the right boundary table in the display range;
the table generating module is configured to extract data located between the left boundary table and the right boundary table from the first table to obtain a second table.
Optionally, the sliding cursors include a first sliding cursor, a second sliding cursor, a third sliding cursor and a fourth sliding cursor.
The coordinate determination module is used for determining a first left boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding chute, and determining a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding chute; the first left boundary position coordinate is an identifier of the first table sub-left boundary table; the second left boundary position coordinate is an identifier of the second table sub-left boundary table; determining a first right boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, and determining a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove; the first right boundary position coordinate is an identifier of the first sub-table right boundary table; the second right boundary position coordinate is an identifier of the second sub-table right boundary table.
The table generating module is configured to extract data located between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table; extracting data positioned between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table; determining the second table according to the first sub-table and the second sub-table.
Optionally, the table generating module further comprises a freeze determining module.
The freezing determining module is used for receiving the coordinates of the frozen form items sent by the user; acquiring a table freezing item according to the coordinate of the table freezing item; determining the corresponding position of the table freezing item in a second table according to the coordinate of the table freezing item and the boundary position coordinate; adding the table freeze entry to a corresponding location in the second table.
Optionally, the freezing determining module is configured to compare whether the coordinates of the frozen item of the table are smaller than the boundary position coordinates; and if the coordinate of the table freezing item is smaller than the boundary position coordinate, determining that the corresponding position of the table freezing item in the second table is the leftmost side.
In a third aspect, an embodiment of the present application provides a computer-readable storage medium, where the computer-readable storage medium is used to store a computer program, and may enable the computer to execute the method for data presentation according to the foregoing first aspect.
The embodiment of the application provides a data display method and device, which can firstly receive boundary position coordinates sent by a user through the relative position of a movable sliding block and a sliding groove, wherein the boundary position coordinates are marks of a boundary table of a second table to be displayed, namely marks of tables on the outermost side in a display range. Then, the table located outside the display range can be determined according to the boundary position coordinates, so as to determine the display range. After the display range is determined, data in the display range can be extracted from the first table, so that a second table is obtained and is displayed to the user. Then, the user can determine the boundary table coordinates according to the content to be browsed and input the boundary table coordinates into the computer. The computer can determine the content which needs to be browsed by the user according to the boundary table coordinates, and determine the display range corresponding to the content which needs to be browsed by the user, so that the data in the display range is extracted to obtain a second table which is displayed to the user. Therefore, the display range can be determined according to the content which needs to be browsed by the user, and the content which needs to be browsed by the user is displayed to the user. The user can see the corresponding second table by inputting the boundary position coordinates without manually dragging the moving component. Thus, when the number of table entries is large, the data which the user wants to see can be quickly located.
Drawings
To illustrate the technical solutions in the present embodiment or the prior art more clearly, the drawings needed to be used in the description of the embodiment or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a flowchart of a method of a data presentation method according to an embodiment of the present application;
fig. 2 is a schematic diagram of a sliding cursor and a cursor sliding slot provided in the embodiment of the present application;
FIG. 3 is a schematic structural diagram of a data display device according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of a data display device according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a data display device according to an embodiment of the present disclosure.
Detailed Description
Currently, in order to process a long form, a form processing tool such as excel often has a moving component such as a scroll cursor or a slide cursor. The user can click and drag the moving components to adjust the display range through a mouse, so that the contents which the user wants to browse in the table are displayed on the screen.
Taking the example of the moving assembly including the sliding cursor and the cursor sliding slot as an example, it is assumed that there are 30 columns of data according to the general table a, and at most 10 columns of data can be displayed in one screen. Then, when the sliding cursor is located at the leftmost side of the cursor sliding chute, the computer can display the data of the first column to the tenth column of the table on the screen; when the sliding cursor is positioned at the central position of the cursor sliding chute, the computer can display the data of the eleventh column to the twentieth column of the table on the screen; when the sliding cursor is located at the rightmost side of the cursor chute, the computer may present the data of the twenty-third to thirty-third columns of the table on the screen. In this way, the user can see different contents in the table on the screen by adjusting the position of the sliding cursor in the cursor sliding chute.
However, the method of adjusting the table display range by moving the components has certain limitations. When the number of entries in the table is too large, it is difficult for the user to accurately locate the position to be browsed through the mobile component, and the position to be browsed can be located only by repeatedly adjusting the position of the mobile component, which is complex to operate.
In order to provide a technical scheme that a position which a user wants to browse can be quickly located and displayed on the basis of the prior art, the embodiment of the application provides a data display method which can extract a second form which the user wants to browse from a first form with a large number of terms and display the second form to the user. The preferred embodiment of the present application will be described below from the perspective of a computer. It should be noted that the data presentation method provided in the embodiment of the present application may be applied to a computer, a server, and a device with a data processing function, such as a terminal device. A computer is provided as a specific implementation for ease of illustration only, and is not intended to represent an entire implementation of the present application.
Referring to fig. 1, fig. 1 is a flowchart of a method of a data presentation method provided in an embodiment of the present application, including:
s101: and receiving boundary position coordinates sent by a user.
In this embodiment, the computer may first receive the boundary position coordinates sent by the user. And the boundary position coordinate is the identifier of the boundary table of the second table to be displayed. That is, when the user needs the computer to display the second table, the identifier of the boundary table of the second table may be sent to the computer, for example, the number of columns corresponding to the first column table on the left side of the boundary table, or the number of rows corresponding to the first row table of the boundary table. In one possible implementation, the computer may present the input box on a screen. The user may manually enter boundary position coordinates within the input box.
In one possible implementation, the boundary position coordinates may also be determined by the relative positions of the cursor sliding chute and the cursor sliding block. In particular, the computer may present a cursor chute and a sliding cursor on the screen. After seeing the cursor sliding groove and the sliding cursor displayed by the computer, a user can send a sliding cursor moving instruction to the computer through mouse clicking and other operations, so that the position of the sliding cursor relative to the cursor sliding groove is adjusted. The computer can move the position of the sliding cursor to the top of the relative position of the sliding cursor and the cursor sliding groove according to the sliding cursor, so that the boundary position coordinate is determined according to the relative positions of the sliding cursor and the cursor sliding groove. Alternatively, assuming that the first table comprises a one hundred column table, the computer may determine the corresponding boundary position coordinate as the first column when the sliding cursor is located at the leftmost side of the cursor chute. Therefore, the user can change the range to be displayed by changing the relative position of the sliding block and the sliding groove, and the operation of the user is facilitated.
Optionally, in order to facilitate the user to move the sliding cursor, at least one anchor point identifier may be further included on the sliding cursor, where the anchor point identifier represents a boundary position coordinate corresponding to the position. The description will be made by taking fig. 2 as an example. The cursor chute shown in fig. 2 includes 6 anchor point identifiers of "numerical point 1", "numerical point 50", "numerical point 100", "numerical point 150", "numerical point 200", and "numerical point 250". The anchor point identifier of "value point 150" indicates that when the sliding cursor is moved to the position corresponding to the anchor point identifier, the corresponding boundary position coordinate is the value point 150.
Optionally, considering that the number of rows and/or columns of the table may be relatively large, in some possible implementations, the anchor point representation may also be set by the user. Specifically, the computer may receive an anchor point identifier input by a user, fill the anchor point identifier in the cursor chute, and determine boundary position coordinates corresponding to each position of the cursor chute according to the anchor point representation input by the user.
In some possible implementations, the sliding cursor may include a first sliding cursor and a second sliding cursor, which respectively correspond to the boundary tables on both sides of the range to be displayed. For example, the first sliding cursor may correspond to the leftmost table of the to-be-displayed range, and the second sliding cursor may correspond to the rightmost table of the to-be-displayed range. Of course, the first sliding cursor may correspond to the table at the top of the range to be displayed, and the second sliding cursor may correspond to the table at the bottom of the range to be displayed. The embodiments of the present application do not limit this.
When the sliding cursor includes a first sliding cursor and a second sliding cursor, the computer may determine the first boundary position coordinate and the second boundary position coordinate according to relative positions of the first sliding cursor and the second sliding cursor with the cursor chute, respectively. Specifically, the computer may determine a first boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding chute, where the first boundary position coordinate is an identifier of a left boundary table in the presentation range, that is, an identifier of a leftmost table of the second table in the first table. The computer can also determine a second boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding chute, wherein the second boundary position coordinate is the identifier of the right boundary table in the display range, namely the identifier of the rightmost table of the second table in the first table.
It should be noted that, the first boundary position coordinate and the second boundary position coordinate respectively correspond to the left boundary and the right boundary of the display range, which is only one possible implementation manner provided in the embodiment of the present application, and in other implementation manners, the first boundary position coordinate and the second boundary position coordinate may also correspond to tables showing the upper boundary and the lower boundary of the display range or other boundaries.
In some possible implementations, the sliding cursor may include a first sliding cursor, a second sliding cursor, a third sliding cursor, and a fourth sliding cursor, which respectively correspond to the boundary tables on both sides of the first sub-table and the boundary tables on both sides of the second sub-table. The first and second sub-tables are two parts of the second table.
Then, in determining the boundary position coordinates, the computer may determine a first left boundary position coordinate based on the relative position of the first sliding cursor to the cursor slide and a first right boundary position coordinate based on the relative position of the second sliding cursor to the cursor slide. The first left boundary position coordinate is the identifier of the left boundary table of the first sub-table, namely the identifier of the leftmost table of the first sub-table in the first table; the first right boundary position coordinate is the identifier of the first sub-table right boundary table, i.e. the identifier of the rightmost table of the first sub-table in the first table.
The computer can also determine a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding groove, and determine a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove. The second left boundary position coordinate is the identifier of the left boundary table of the second sub-table, namely the identifier of the leftmost table of the second sub-table in the first table; the second right boundary position coordinate is the identification of the second sub-table right boundary table, i.e., the identification of the rightmost table of the second sub-table in the first table.
S102: and determining a display range according to the boundary position coordinates.
After determining the boundary position coordinates, the computer may determine a display range based on the boundary position coordinates. Because the boundary position coordinates are the identification of the boundary table in the display range, the computer can determine the table within the boundary position as the display range. For example, the computer may determine all tables on the right side of the boundary table corresponding to the boundary position as tables within the presentation range, or may determine all tables below the boundary table corresponding to the boundary position as tables within the presentation range.
Alternatively, when the sliding cursor includes a first sliding cursor and a second sliding cursor, and the first sliding cursor and the second sliding cursor correspond to the first boundary position coordinate and the second boundary position coordinate, respectively, the computer may determine a range located on the right side of the first boundary position coordinate (inclusive) and on the left side of the second boundary position coordinate (inclusive) as the presentation range.
Optionally, when the sliding cursor includes a first sliding cursor, a second sliding cursor, a third sliding cursor and a fourth sliding cursor, and the first sliding cursor, the second sliding cursor, the third sliding cursor and the fourth sliding cursor respectively correspond to a first left boundary position coordinate, a first right boundary position coordinate, a second left boundary position coordinate and a second right boundary position coordinate, the computer may determine a range located on the right side of the first left boundary position coordinate (inclusive) and the left side of the first right boundary position coordinate (inclusive) as a first sub-display range, determine a range located on the right side of the second left boundary position coordinate (inclusive) and the left side of the second right boundary position coordinate (inclusive) as a second sub-display range, and determine the first sub-display range and the second sub-display range as display ranges.
S103: and extracting the data in the display range from the first table to obtain a second table, and displaying the second table to the user.
After determining the scope of the presentation, the computer may extract data from the first form that is within the scope of the presentation and populate the new form with these inputs to obtain the second form. After obtaining the second form, the computer may present the second form on the computer screen, thereby presenting the second form to the user.
Optionally, when the sliding cursor includes a first sliding cursor and a second sliding cursor, and the first sliding cursor and the second sliding cursor respectively correspond to the first boundary position coordinate and the second boundary position coordinate, the computer may extract data located between the left boundary table and the right boundary table from the first table to obtain the second table.
Optionally, when the sliding cursor includes a first sliding cursor, a second sliding cursor, a third sliding cursor and a fourth sliding cursor, and the first sliding cursor, the second sliding cursor, the third sliding cursor and the fourth sliding cursor respectively correspond to the first left boundary position coordinate, the first right boundary position coordinate, the second left boundary position coordinate and the second right boundary position coordinate, the computer may extract data located between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table; and extracting data between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table, and splicing the second sub-table into a second table according to the first sub-table and the second sub-table. Therefore, when the user wants to browse the two parts of contents in the first table and the number of table items sandwiched between the two parts of contents is large, the two parts of contents which the user wants to browse can be directly spliced into one table.
The embodiment of the application provides a data display method, which can receive boundary position coordinates sent by a user, wherein the boundary position coordinates are marks of a boundary table of a second table to be displayed, namely marks of the table on the outermost side in a display range. Then, the table located outside the display range can be determined according to the boundary position coordinates, so as to determine the display range. After the display range is determined, data in the display range can be extracted from the first table, so that a second table is obtained and is displayed to the user. Then, the user can determine the boundary table coordinates according to the content to be browsed and input the boundary table coordinates into the computer. The computer can determine the content which needs to be browsed by the user according to the boundary table coordinates, and determine the display range corresponding to the content which needs to be browsed by the user, so that the data in the display range is extracted to obtain a second table which is displayed to the user. Therefore, the display range can be determined according to the content which needs to be browsed by the user, and the content which needs to be browsed by the user is displayed to the user. The user can see the corresponding second table by inputting the boundary position coordinates without manually dragging the moving component. Thus, when the number of table entries is large, the data which the user wants to see can be quickly located.
In an actual application scenario, the user may wish to freeze certain items in the table, such as the first row or column of the table, etc. For this case, the user may enter the coordinates of the frozen item of the form into the computer, which may be, for example, "first column", "second row", etc. The computer may obtain the table freezing item from the first table according to the received coordinates of the table freezing item, that is, data corresponding to the coordinates of the table freezing item. The computer may then determine the corresponding location of the table freeze in the second table based on the coordinates of the table freeze and the boundary location coordinates, thereby adding the table freeze to the corresponding location. In this way, the user can freeze any content in the first table, and the frozen content can be added to the corresponding position of the second table.
Alternatively, the computer may corner the size of the coordinates of the table frozen item and the coordinates of the boundary position when determining the corresponding position of the table frozen item in the second table. Taking the table freezing item as a column of tables and the boundary position coordinate as the identifier of the boundary table at the leftmost side of the display range as an example, the computer may compare whether the coordinate of the table freezing item is smaller than the boundary position coordinate; if the coordinates of the table freeze are less than the boundary position coordinates, indicating that in the first table the table freeze is located to the left of the table at the leftmost side of the presentation range, then the computer may determine that the corresponding position of the table freeze in the second table is to the leftmost side.
The foregoing provides some specific implementation manners of the data display method for the embodiments of the present application, and based on this, the present application also provides a corresponding apparatus. The above-mentioned device provided by the embodiments of the present application will be described in terms of functional modularity.
Referring to fig. 3, a schematic diagram of a data display device 300 is shown, which includes:
the receiving module 310 is configured to receive a boundary position coordinate sent by a user, where the boundary position coordinate is an identifier of a boundary table within a display range.
And a range determining module 320, configured to determine a display range according to the boundary position coordinates.
The table generating module 330 is configured to extract data in the display range from the first table to obtain a second table, and display the second table to a user.
Optionally, referring to fig. 4, on the basis of the apparatus shown in fig. 3, the receiving module 310 includes:
and the display module 311 is configured to display the cursor chute and the sliding cursor to the user.
The instruction receiving module 312 is configured to receive a sliding cursor movement instruction sent by a user, and determine a relative position between the sliding cursor and the cursor chute.
And the coordinate determination module 313 is configured to determine the boundary position coordinate according to the relative position of the sliding cursor and the cursor sliding chute.
The embodiment of the application provides a data display device, which can receive boundary position coordinates sent by a user, wherein the boundary position coordinates are marks of a boundary table of a second table to be displayed, namely marks of the table on the outermost side in a display range. Then, the table located outside the display range can be determined according to the boundary position coordinates, so as to determine the display range. After the display range is determined, data in the display range can be extracted from the first table, so that a second table is obtained and is displayed to the user. Then, the user can determine the boundary table coordinates according to the content to be browsed and input the boundary table coordinates into the computer. The computer can determine the content which needs to be browsed by the user according to the boundary table coordinates, and determine the display range corresponding to the content which needs to be browsed by the user, so that the data in the display range is extracted to obtain a second table which is displayed to the user. Therefore, the display range can be determined according to the content which needs to be browsed by the user, and the content which needs to be browsed by the user is displayed to the user. The user can see the corresponding second table by inputting the boundary position coordinates without manually dragging the moving component. Thus, when the number of table entries is large, the data which the user wants to see can be quickly located.
Optionally, in some possible implementations, on the basis of the apparatus shown in fig. 4, the sliding cursor includes a first sliding cursor and a second sliding cursor;
the coordinate determination module 313 is configured to determine a first boundary position coordinate according to the first sliding cursor coordinate, where the first boundary position coordinate is an identifier of a left boundary table in the display range; and determining a second boundary position coordinate according to the second sliding cursor coordinate, wherein the second boundary position coordinate is the identifier of the right boundary table in the display range.
The table generating module 330 is configured to extract data located between the left boundary table and the right boundary table from the first table to obtain a second table.
Optionally, in some possible implementations, on the basis of the apparatus shown in fig. 4, the sliding cursors include a first sliding cursor, a second sliding cursor, a third sliding cursor, and a fourth sliding cursor.
The coordinate determination module 313 is configured to determine a first left boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding chute, and determine a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding chute; the first left boundary position coordinate is an identifier of the first table sub-left boundary table; the second left boundary position coordinate is an identifier of the second table sub-left boundary table; determining a first right boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, and determining a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove; the first right boundary position coordinate is an identifier of the first sub-table right boundary table; the second right boundary position coordinate is an identifier of the second sub-table right boundary table.
The table generating module 330 is configured to extract data located between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table; extracting data positioned between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table; determining the second table according to the first sub-table and the second sub-table.
Therefore, when the user wants to browse the two parts of contents in the first table and the number of table items sandwiched between the two parts of contents is large, the two parts of contents which the user wants to browse can be directly spliced into one table.
Optionally, referring to fig. 5, on the basis of the apparatus shown in fig. 3, the table generating module 330 further includes a freeze determining module 340.
The freezing determining module 340 is configured to receive coordinates of a frozen form item sent by a user; acquiring a table freezing item according to the coordinate of the table freezing item; determining the corresponding position of the table freezing item in a second table according to the coordinate of the table freezing item and the boundary position coordinate; adding the table freeze entry to a corresponding location in the second table.
Optionally, in some possible implementations, the freeze determination module 340 is configured to compare whether the coordinates of the frozen item of the table are smaller than the boundary position coordinates; and if the coordinate of the table freezing item is smaller than the boundary position coordinate, determining that the corresponding position of the table freezing item in the second table is the leftmost side.
In addition, the embodiment of the present application further provides a computer storage medium, and when a software program stored in the computer storage medium is executed on a computer, the computer can be caused to execute the method for data presentation provided by the foregoing embodiment.
In the names of the first table, the second table and the like, the first and the second are used as name labels, and do not represent the first and the second in sequence.
As can be seen from the above description of the embodiments, those skilled in the art can clearly understand that all or part of the steps in the above embodiment methods can be implemented by software plus a general hardware platform. Based on such understanding, the technical solution of the present application may be embodied in the form of a software product, which may be stored in a storage medium, such as a read-only memory (ROM)/RAM, a magnetic disk, an optical disk, or the like, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network communication device such as a router) to execute the method according to the embodiments or some parts of the embodiments of the present application.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus embodiment, since it is substantially similar to the method embodiment, it is relatively simple to describe, and reference may be made to some descriptions of the method embodiment for relevant points. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The above description is only an exemplary embodiment of the present application, and is not intended to limit the scope of the present application.

Claims (6)

1. A method for presenting data, the method comprising:
displaying a cursor sliding groove and a sliding cursor to a user; the sliding cursors comprise a first sliding cursor, a second sliding cursor, a third sliding cursor and a fourth sliding cursor;
receiving a sliding cursor movement instruction sent by a user, and determining the relative position of a sliding cursor and a cursor sliding groove;
determining boundary position coordinates according to the relative position of the sliding cursor and the cursor sliding groove, wherein the boundary position coordinates are marks of a boundary table in a display range; the determining the boundary position coordinates according to the relative position of the sliding cursor and the cursor sliding chute comprises: determining a first left boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding groove, and determining a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding groove; the first left boundary position coordinate is an identifier of a first table sub-left boundary table; the second left boundary position coordinate is an identifier of a sub-left boundary table of a second table;
determining a first right boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, and determining a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove; the first right boundary position coordinate is an identifier of a first sub-table right boundary table; the second right boundary position coordinate is an identifier of a second sub-table right boundary table; determining a display range according to the boundary position coordinates; the display range comprises a first table and a second table;
extracting data in the display range from the first table to obtain a second table, and displaying the second table to a user; the step of extracting the data in the display range from the first table to obtain a second table comprises the following steps: extracting data positioned between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table; extracting data positioned between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table; determining the second table according to the first sub-table and the second sub-table.
2. The method of claim 1, wherein extracting the data in the presentation range from the first table to obtain a second table comprises:
receiving the coordinates of the frozen form items sent by the user;
acquiring a table freezing item according to the coordinate of the table freezing item;
determining the corresponding position of the table freezing item in a second table according to the coordinate of the table freezing item and the boundary position coordinate;
adding the table freeze entry to a corresponding location in the second table.
3. The method of claim 2, wherein determining the corresponding location of the table freeze in the second table from the coordinates of the table freeze and the boundary location coordinates comprises:
comparing whether the coordinates of the table frozen items are less than the boundary position coordinates;
and if the coordinate of the table freezing item is smaller than the boundary position coordinate, determining that the corresponding position of the table freezing item in the second table is the leftmost side.
4. A data presentation device, the device comprising:
the receiving module is used for receiving boundary position coordinates sent by a user, and the boundary position coordinates are marks of a boundary table in a display range;
the display module is used for displaying the cursor sliding groove and the sliding cursor to a user; the sliding cursors comprise a first sliding cursor, a second sliding cursor, a third sliding cursor and a fourth sliding cursor;
the command receiving module is used for receiving a sliding cursor movement command sent by a user and determining the relative position of the sliding cursor and a cursor sliding groove;
the range determining module is used for determining a display range according to the boundary position coordinates;
the coordinate determination module is used for determining the boundary position coordinate according to the relative position of the sliding cursor and the cursor sliding groove; the determining the boundary position coordinates according to the relative position of the sliding cursor and the cursor sliding chute comprises: determining a first left boundary position coordinate according to the relative position of the first sliding cursor and the cursor sliding groove, and determining a second left boundary position coordinate according to the relative position of the third sliding cursor and the cursor sliding groove; the first left boundary position coordinate is an identifier of a first table sub-left boundary table; the second left boundary position coordinate is an identifier of a sub-left boundary table of a second table;
determining a first right boundary position coordinate according to the relative position of the second sliding cursor and the cursor sliding groove, and determining a second right boundary position coordinate according to the relative position of the fourth sliding cursor and the cursor sliding groove; the first right boundary position coordinate is an identifier of a first sub-table right boundary table; the second right boundary position coordinate is an identifier of a second sub-table right boundary table;
the table generation module is used for extracting the data in the display range from the first table to obtain a second table and displaying the second table to a user; the step of extracting the data in the display range from the first table to obtain a second table comprises the following steps: extracting data positioned between the first left boundary table and the first right boundary table from the first table to obtain a first sub-table; extracting data positioned between the second left boundary table and the second right boundary table from the first table to obtain a second sub-table; determining the second table according to the first sub-table and the second sub-table.
5. An apparatus for data presentation, the apparatus comprising a memory and a processor;
the memory to store instructions;
the processor, configured to execute the instructions stored in the memory to cause the apparatus to perform the data presentation method of any one of the preceding claims 1-3.
6. A computer-readable storage medium for storing a computer program for executing the data presentation method of any one of claims 1 to 3.
CN202011362034.7A 2020-11-27 2020-11-27 Data display method and device Active CN112363663B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011362034.7A CN112363663B (en) 2020-11-27 2020-11-27 Data display method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011362034.7A CN112363663B (en) 2020-11-27 2020-11-27 Data display method and device

Publications (2)

Publication Number Publication Date
CN112363663A CN112363663A (en) 2021-02-12
CN112363663B true CN112363663B (en) 2022-04-12

Family

ID=74535444

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011362034.7A Active CN112363663B (en) 2020-11-27 2020-11-27 Data display method and device

Country Status (1)

Country Link
CN (1) CN112363663B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113268686B (en) * 2021-05-25 2022-08-26 山东卓创资讯股份有限公司 Processing method for multiple browsing modes of form in information at APP (application) end
CN113743061B (en) * 2021-09-08 2024-04-30 深圳集智数字科技有限公司 Numerical range adjustment method, device, electronic equipment and readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103713810A (en) * 2012-10-09 2014-04-09 腾讯科技(深圳)有限公司 Mobile terminal list data interactive method and device
CN111191162A (en) * 2019-11-05 2020-05-22 腾讯科技(深圳)有限公司 Data processing method and equipment
CN111339463A (en) * 2020-02-19 2020-06-26 望海康信(北京)科技股份公司 List data display method and device and electronic equipment

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7127672B1 (en) * 2003-08-22 2006-10-24 Microsoft Corporation Creating and managing structured data in an electronic spreadsheet
TW200805131A (en) * 2006-05-24 2008-01-16 Lg Electronics Inc Touch screen device and method of selecting files thereon
US20140033093A1 (en) * 2012-07-25 2014-01-30 Microsoft Corporation Manipulating tables with touch gestures
CN104238918B (en) * 2013-06-13 2019-01-08 腾讯科技(深圳)有限公司 List View component slippage display methods and device
CN103744609B (en) * 2014-01-20 2018-10-19 华为终端(东莞)有限公司 A kind of data extraction method and device
CN104020944A (en) * 2014-05-27 2014-09-03 广州视源电子科技股份有限公司 Data input method based on sliding block
CN104571862B (en) * 2014-12-30 2018-10-09 北京奇虎科技有限公司 The method and apparatus of display data in a kind of mobile terminal page
CN106569702B (en) * 2016-11-10 2020-04-24 珠海市魅族科技有限公司 List navigation method and device
CN107807764B (en) * 2017-10-27 2020-10-13 优酷网络技术(北京)有限公司 Page display method and client
CN108334486B (en) * 2018-01-19 2021-02-09 广州视源电子科技股份有限公司 Table control method, device, equipment and storage medium
CN108744514B (en) * 2018-05-18 2021-08-06 腾讯科技(深圳)有限公司 Sliding list generation method, data display device and storage medium
CN111083421A (en) * 2018-10-19 2020-04-28 珠海金山办公软件有限公司 Table document display method and device
CN111338732A (en) * 2020-02-24 2020-06-26 北京辰森世纪科技股份有限公司 Display method and device for long list page
CN111832271B (en) * 2020-07-20 2023-08-18 北京百度网讯科技有限公司 Data presentation method, device, electronic equipment and storage medium

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103713810A (en) * 2012-10-09 2014-04-09 腾讯科技(深圳)有限公司 Mobile terminal list data interactive method and device
CN111191162A (en) * 2019-11-05 2020-05-22 腾讯科技(深圳)有限公司 Data processing method and equipment
CN111339463A (en) * 2020-02-19 2020-06-26 望海康信(北京)科技股份公司 List data display method and device and electronic equipment

Also Published As

Publication number Publication date
CN112363663A (en) 2021-02-12

Similar Documents

Publication Publication Date Title
US9208216B2 (en) Transforming data into consumable content
US9009092B2 (en) Creating variations when transforming data into consumable content
US9053196B2 (en) Methods for interacting with and manipulating information and systems thereof
RU2662632C2 (en) Presenting fixed format documents in reflowed format
CN111240669B (en) Interface generation method and device, electronic equipment and computer storage medium
US12045442B2 (en) Method and apparatus for browsing table in document, and electronic device and storage medium
EP2875448A2 (en) Abstract relational model for transforming data into consumable content
CN112363663B (en) Data display method and device
CN112433650B (en) Project management method, device, equipment and storage medium
US20160335740A1 (en) Zoomable web-based wall with natural user interface
CN104461561A (en) Chatting record displaying method and device
US7908567B1 (en) Method and system for navigating in a document
JP5556461B2 (en) Information browsing terminal device, information browsing system, information browsing program, and information browsing method
US10627984B2 (en) Systems, devices, and methods for dynamic virtual data analysis
CN111680246A (en) Grouped title top setting method, device and equipment based on recycleview left-right linkage control
KR101242878B1 (en) Method and system for extracting and providing item having annotation on electronic book
CN111782309B (en) Method and device for displaying information and computer readable storage medium
US9489363B2 (en) User configurable user interface
CN110209336B (en) Content display method and device
CN105653603A (en) Method and system for displaying page functions
CN106649387B (en) Method and device for displaying information
JP6679664B2 (en) Information processing apparatus, information processing method, and program
CN119376817A (en) Data rendering method, device, electronic device and readable storage medium
CN114020576A (en) Webpage label text positioning method
CN113568535A (en) Map block selection method, map block selection device, medium, and electronic 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