CN110968987B - Table display method and device, storage medium and electronic device - Google Patents
Table display method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN110968987B CN110968987B CN201811161935.2A CN201811161935A CN110968987B CN 110968987 B CN110968987 B CN 110968987B CN 201811161935 A CN201811161935 A CN 201811161935A CN 110968987 B CN110968987 B CN 110968987B
- Authority
- CN
- China
- Prior art keywords
- window
- cell object
- display
- freezing
- frozen
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Abstract
The invention discloses a table display method and device, a storage medium and an electronic device. Wherein, the method comprises the following steps: acquiring a region freezing instruction generated by executing operation on a target region to be frozen in a table; under the condition that the display range of the target area is larger than or equal to the display range of a freezing window configured in advance in the visual window, controlling the cell object contained in the target area in the freezing window to display, wherein the display range of the freezing window is smaller than or equal to the display range of the visual window; acquiring an adjusting instruction generated by executing adjusting operation on a cell object displayed in a freezing window; responding to an adjusting instruction, and adjusting the cell object displayed in the freezing window into a target cell object in the target area; and displaying the adjusted target cell object in the freezing window. The invention solves the technical problem that the display is easy to be jammed when the display area of the freezing area exceeds the display area of the visual window.
Description
Technical Field
The invention relates to the field of computers, in particular to a table display method and device, a storage medium and an electronic device.
Background
In order to facilitate a user to visually check a table displayed in a visual window, many editing software is configured with a region freezing function for the table. For example, freezing part of the row cells or column cells in the table, so that in the process of editing the table, the row cells or column cells in the frozen region can be fixedly rendered and displayed, and the cells in the non-frozen region can be dynamically rendered and displayed, so that the cells in the frozen region and the cells in the non-frozen region can be contrastingly displayed.
However, since the display area of the visual window is limited, when the display area of the frozen region fixed within the visual window is gradually enlarged, the display area of the corresponding editable non-frozen region is gradually reduced. When the display area of the frozen area exceeds the display area of the visual window, not only the cells in the non-frozen area cannot be normally displayed, but also the problem of display blockage can easily occur in the process of rendering and displaying the cells in the visual window.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a table display method and device, a storage medium and an electronic device, which are used for at least solving the technical problem that display jamming is easy to occur when a display area of a freezing area exceeds a display area of a visual window.
According to an aspect of an embodiment of the present invention, there is provided a table display method including: acquiring a region freezing instruction generated by executing operation on a target region to be frozen in a table; when the display range of the target area is larger than or equal to the display range of a frozen window which is configured in advance in a visual window, controlling the cell object contained in the target area to be displayed in the frozen window, wherein the display range of the frozen window is smaller than or equal to the display range of the visual window; acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window; responding to the adjusting instruction, and adjusting the cell object displayed in the freezing window into a target cell object in the target area; and displaying the adjusted target cell object in the freezing window.
According to another aspect of the embodiments of the present invention, there is also provided a table display apparatus including: the first acquisition unit is used for acquiring a region freezing instruction generated by executing operation on a target region to be frozen in the table; a control unit configured to control a cell object included in the target region to be displayed in a frozen window when a display range of the target region is equal to or larger than a display range of the frozen window previously arranged in a visible window, wherein the display range of the frozen window is equal to or smaller than the display range of the visible window; a second obtaining unit, configured to obtain an adjustment instruction generated by performing an adjustment operation on the cell object displayed in the frozen window; an adjusting unit, configured to adjust the cell object displayed in the frozen window to a target cell object in the target area in response to the adjustment instruction; and a display unit for displaying the adjusted target cell object in the freezing window.
In the embodiment of the invention, after a region freezing instruction generated by operating a target region to be frozen in a table is acquired, under the condition that the display range of the target region is greater than or equal to the display range of a freezing window configured in advance in a visual window, a cell object contained in the target region is controlled in the freezing window to be displayed, wherein the display range of the freezing window is less than or equal to the display range of the visual window; acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window; adjusting the cell object displayed in the freezing window into a target cell object in the target area according to the adjusting instruction; and displaying the adjusted target cell object in the freezing window, thereby flexibly controlling the cell object in the frozen target area to be dynamically displayed in the freezing window without display jamming, and further solving the technical problem that the display jamming is easy to occur when the display area of the freezing area exceeds the display area of the visual window.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a diagram of an application environment of a table display method according to an embodiment of the present invention;
FIG. 2 is a flow chart diagram of an alternative table display method according to an embodiment of the invention;
FIG. 3 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 5 is a diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 9 is a schematic diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 10 is a diagram of an alternative table display method according to an embodiment of the present invention;
FIG. 11 is a schematic diagram of an alternative table display method in accordance with an embodiment of the present invention (eight);
FIG. 12 is a schematic diagram of an alternative table display apparatus according to an embodiment of the present invention;
FIG. 13 is a block diagram of a table display apparatus according to yet another alternative embodiment of the present invention;
FIG. 14 is a block diagram of a table display apparatus according to yet another alternative embodiment of the present invention;
FIG. 15 is a block diagram of a table display apparatus according to yet another alternative embodiment of the present invention;
FIG. 16 is a block diagram of a table display apparatus according to yet another alternative embodiment of the present invention;
fig. 17 is a schematic structural diagram of an alternative electronic device according to an embodiment of the invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, 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 obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
According to an aspect of an embodiment of the present invention, there is provided a table display method. Alternatively, the above table display method can be applied, but not limited, to the Web online table application environment as shown in fig. 1, wherein the Web online table can use a freezing function, that is, the Web online table can be divided into a frozen area and a non-frozen area.
The following describes terms involved in the Web presence table.
Freezing, partial row and column areas can be fixed in the form, and at the moment, a user can only change the non-frozen area by rolling the form, so that people can conveniently read form information.
Dom: the general name of each element in the Web page is that a Web page is composed of a plurality of Dom nodes.
A Canvas: a special Dom node, also called Canvas, can call the bottom layer drawing interface of the browser, and can perform efficient image drawing based on Canvas.
Viewport: viewport, visual area. Images drawn in Canvas, whose position coordinates are to be based on the current viewable area (viewport). When the element is at coordinates outside the visible region, it is not visible.
Optionally, in this embodiment, as an optional implementation manner, as shown in fig. 2, the table display method may include:
s202, acquiring a region freezing instruction generated by executing operation on a target region to be frozen in the table;
the region freeze instruction is used to instruct the freezing process to be performed on the cells in the target region. The cells may be real cells in which data is already recorded, or empty cells in which data is not recorded. This is not limited in this embodiment.
S204, under the condition that the display range of the target area is larger than or equal to the display range of a freezing window configured in advance in the visual window, controlling the cell object contained in the target area to be displayed in the freezing window, wherein the display range of the freezing window is smaller than or equal to the display range of the visual window;
the display range of the frozen window is equal to or smaller than the display range of the visible window.
S206, acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window;
s208, responding to the adjusting instruction, and adjusting the cell object displayed in the freezing window into a target cell object in the target area;
and S210, displaying the adjusted target cell object in the freezing window.
Alternatively, the target area may be an area to be frozen, for example, in fig. 1, column AB is a frozen area, and a column behind column AB is a non-frozen area. The above is merely an example, and this is not limited in this embodiment.
Optionally, in this embodiment, in a case that the display range of the target area is smaller than or equal to the display range of a frozen window configured in advance in the visual window, the cells in the target area may be normally displayed.
Optionally, in this embodiment, the frozen window may be, but is not limited to, identified by a virtual Viewport, where the virtual Viewport is used to control the cells in the target area to be limited in the frozen window for display. The above is merely an example, and this is not limited in this embodiment.
Optionally, in this embodiment, the manner of controlling the cells in the target area to be displayed in the freeze window includes, but is not limited to:
determining an original cell object located in a display range of the freezing window from the target area in a first mode; and displaying the original cell object in the freezing window.
Moving the target area, and then determining the target cell object which is adjusted and located in the display range of the freezing window from the moved target area; and displaying the target cell object in the freezing window.
The above is only an example, and this is not limited in this embodiment.
Optionally, in this embodiment, the displaying the adjusted target cell object in the freeze window includes, but is not limited to:
in a first mode, the adjusted target cell object is rendered and displayed based on Canvas in a display area corresponding to the frozen window, and a characteristic cell object is rendered and displayed in a display area except the frozen window in the visual window, wherein the characteristic cell object is a cell acquired from a non-target area except the target area in a page to be displayed.
And secondly, rendering and displaying the adjusted target cell object in a display area corresponding to the frozen window based on non-Canvas, and rendering and displaying a characteristic cell object in a display area except the frozen window in the visual window, wherein the characteristic cell object is a cell acquired from a non-target area except the target area in a page to be displayed.
The above is merely an example, and this is not limited in this embodiment.
Through the steps S202 to S210, after the region freezing instruction generated by performing the operation on the target region to be frozen in the table is acquired, in the case that the display range of the target region is greater than or equal to the display range of the freezing window configured in advance in the visual window, the cell object included in the target region is controlled in the freezing window to be displayed, wherein the display range of the freezing window is less than or equal to the display range of the visual window; acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window; adjusting the cell object displayed in the freezing window into a target cell object in the target area according to the adjusting instruction; and displaying the adjusted target cell object in the freezing window, thereby flexibly controlling the cell object in the frozen target area to be dynamically displayed in the freezing window without display jamming, and further solving the technical problem that the display jamming is easy to occur when the display area of the freezing area exceeds the display area of the visual window.
The present embodiment will be described below with reference to specific examples.
In the Web online form provided by the related art, after the freezing function is used, only the non-frozen region can be scrolled, so that when the frozen region is too large, the range of the user which can be operated actually becomes small, and when the frozen region is too small to a trigger limit, more rows and columns cannot be frozen and the non-frozen rows and columns cannot be operated. In this embodiment, not only the freezing area is fixed, but also a maximum value is given to the freezing area, for example, half of the size of the viewport, and then the range of the other half of the viewport can be displayed when the non-freezing area is minimum. When the real size of the frozen area exceeds the maximum value, a scroll bar appears, and at this time, the user can perform operations such as sliding on the frozen area to obtain feedback (as shown in fig. 3).
In this case, it is not only avoided that the size of the frozen region is too large to cause the page to be falsely dead, but also the user can conveniently compare the content of the frozen region with that of the non-frozen region, and the performance on the mobile terminal is particularly obvious.
In an optional embodiment, the controlling and displaying the cell object included in the target region in the freeze window includes the following steps:
step S11, determining the original cell object in the target area within the display range of the freezing window;
step S12, the original cell object is displayed in the freeze window.
For example, assuming that table 1 includes 5 columns, A, B, C, D, E respectively, where the target area (i.e., the area to be frozen) is four columns of A, B, C, D, the preconfigured freeze window (i.e., the virtual Viewport) is a window that includes three columns of A, B, C, then the original cell object is a cell object that includes three columns of A, B, C, and the three columns of cell objects are displayed A, B, C in the freeze window.
For another example, assume that table 1 includes 5 columns, A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D, the preconfigured freeze window (i.e., the virtual Viewport) is a window including A, B, C, D, and then the original cell object is a cell object including A, B, C, D, and A, B, C, D is displayed in the freeze window.
Alternatively, in the present embodiment, a part of the cell objects in the target region adapted to the freeze window may be acquired through the above steps S11 to S12 and displayed.
Optionally, the adjusting, in response to the adjustment instruction, the cell object displayed in the frozen window to be the target cell object in the target area includes the following steps:
step S21, responding to the adjusting instruction, adjusting the original cell object displayed in the freezing window;
in step S22, the target cell object in the target area after adjustment is located within the display range of the freeze window is determined.
Optionally, in this embodiment, the steps S21 to S22 correspond to relative movement between the freezing window and the target area, and the cell object located in the freezing window after each adjustment is obtained and displayed.
For example, assuming that table 1 includes 5 columns, A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D, and the preconfigured freeze window (i.e., the virtual Viewport) is a window including A, B, C, the target cell object is a cell object including A, B, C, and the three columns of cell objects are displayed A, B, C in the freeze window, and after receiving the adjustment instruction, the cell object displayed in the freeze window is adjusted, and B, C, D columns of cell objects located in the freeze window are displayed.
For another example, if table 1 includes 5 columns, which are A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D four columns, and the pre-configured freezing window (i.e., the virtual Viewport) is a window including A, B four columns, the target cell object is a cell object including A, B two columns, and A, B two columns of cell objects are displayed in the freezing window, and after receiving the adjustment instruction, the cell object displayed in the freezing window is adjusted, and C, D columns of cell objects located in the freezing window are displayed.
In an optional embodiment, the obtaining of the adjustment instruction generated by performing the adjustment operation on the cell object displayed in the frozen window includes at least one of:
acquiring the adjusting instruction generated by executing sliding operation on the scroll bar contained in the freezing window;
acquiring the adjusting instruction generated by executing touch screen operation on a display screen where the freezing window is located;
and acquiring the adjusting instruction generated by executing the motion sensing operation on the three-dimensional space corresponding to the freezing window.
Optionally, in this embodiment, a manner of obtaining the adjustment instruction generated by performing the operation on the freeze window includes, but is not limited to: sliding scroll bars, gestures (somatosensory), touch screen dragging and sliding, and the like.
Through the method, the adjusting instruction generated by executing the operation on the frozen window is obtained, and the technical problem that the display is easy to jam when the display area of the frozen area exceeds the display area of the visual window can be further solved.
Optionally, the displaying the adjusted target cell object in the freeze window includes the following steps:
step S31, render and display the adjusted target cell object in the display area corresponding to the frozen window, and render and display the characteristic cell object in the display area except for the frozen window in the visual window, where the characteristic cell object is a cell object obtained from a non-target area except for the target area in the page to be displayed.
Optionally, in this embodiment, for the operation of the frozen region and the non-frozen region, a part a may be rendered first, and the part a is cleared of the out-of-bounds cell object; and rendering the part B, wherein the part B cross-border cell object is displayed under (covered by) the part A data in a mode of 'source data priority', thereby realizing dynamic control on different areas and ensuring normal display. The above is merely an example, and this is not limited in this embodiment.
Through the step S31, a visual window is rendered, which includes the cell object in the frozen window and the cell object in the non-frozen window, thereby implementing dynamic control on different areas and ensuring normal display.
In an optional embodiment, the rendering and displaying the adjusted target cell object in the display area corresponding to the frozen window, and the rendering and displaying the characteristic cell object in the display area other than the frozen window in the visual window includes:
step S41, obtaining the cell object in the target area from the first cache for storing the target area, and drawing the cell object in the target area in the visual window;
it should be noted that the first cache may be a virtual Viewport that freezes a portion.
Step S42, emptying the first cache;
step S43, obtaining the cell object in the non-target region from the second cache for storing the non-target region, and drawing the cell object in the non-target region in the visual window, wherein the display priority of the cell object stored in the first cache is higher than the display priority of the cell object stored in the second cache in the display region corresponding to the frozen window.
It should be noted that the second cache may be a virtual Viewport of a non-frozen portion.
Optionally, the rendering and displaying the adjusted target cell object in the display area corresponding to the frozen window, and the rendering and displaying the characteristic cell object in the display area except for the frozen window in the visual window includes the following steps:
step S51, obtaining the cell object in the non-target area from the third cache for storing the non-target area, and drawing the cell object in the non-target area in the visual window;
it should be noted that the third cache may be a virtual Viewport of a non-frozen portion.
Step S52, emptying the third buffer;
step S53, obtaining the cell object in the target area from the fourth cache for storing the target area, and drawing the cell object in the target area within the visual window, wherein the display priority of the cell object stored in the third cache is higher than the display priority of the cell object stored in the fourth cache in the display area except the frozen window within the visual window.
It should be noted that the third cache may be a virtual Viewport that freezes a portion.
The present embodiment will be described below with reference to specific examples.
Assuming that the entire table is operational before freezing, it can be understood that only one region on a viewport is a non-frozen region. At this time, the position coordinates of the table elements are all based on viewport, that is, it is understood that the rendering of any cell only needs to consider the viewport coordinates. The viewport coordinates of C6 grid in fig. 4 are (226, 235).
When the user freezes the first four columns, if the mode of only fixing the frozen region is adopted, the elements in the table only need to consider the viewport coordinates, and only need to control the rendering sequence to cover the frozen region with the non-frozen region (as shown in fig. 5).
The proposal of the example introduces a virtual viewport, and one virtual viewport is added for maintenance whether the area is frozen or not. The real viewport of C3 case in FIG. 6 is (189, 91), the virtual viewport is (0, 91)
Whether the virtual viewport is really visible on the screen or not is also determined by the virtual viewport coordinate, and the x coordinate under the virtual viewport of the C column in FIG. 7 exceeds the maximum value of the virtual viewport of the freezing area, so that the virtual viewport is invisible. For such a schema, the process maintenance of the entire table cell object needs to be changed, not just paying attention to the non-frozen regions.
One key left is how to render the virtual viewport. In other schemes, because only the frozen region is fixed and then is completely displayed, the rendering pipelines of the other schemes render the non-frozen region first and then render the frozen region. The frozen region is the highest level and thus naturally covers the out-of-range of the non-frozen region due to scrolling.
The virtual viewport introduced in this example has a problem that the frozen region may also be out of bounds (as shown in fig. 8), and when both are out of bounds, no matter whether the frozen region is above or not, the rendered region will render out of bounds part, which produces an erroneous effect.
Therefore, at this time, the rendering with the limited range is needed, the non-frozen region is rendered first, the boundary crossing phenomenon already exists, when the frozen region is rendered again, the range of the frozen region is limited first, and only the size of the virtual viewport is rendered, so that the boundary crossing phenomenon does not occur in the frozen region, and the boundary crossing content of the non-frozen region is covered after normal rendering, as shown in fig. 9.
An API for limiting the rendering range of Canvas in the Web is clip, and the following is found after actual use: due to the performance bottleneck of the Web, calling the clip brings unacceptable performance overhead, and causes the display to be dull. Under iOS, a large clip would cause significant chunking (fig. 10). Therefore, a frequent and small-range clip (fig. 11) is adopted in the replacement concept, and in the scheme, the iOS is not blocked, but part of android is blocked, and if the clip is continuously used, only a subsystem can process the clip, but great code development and maintenance cost is brought.
Finally, the invention adopts the self to realize clip, firstly, the rendering and stacking mode is switched to the priority of the source image, namely, the element drawn later is under the element drawn first, and the element is not covered but covered. The whole pipeline drawing process is that a non-freezing area is drawn firstly, at the moment, an out-of-range phenomenon exists, then before the freezing area is drawn, a viewport of the freezing area is emptied, the non-freezing area does not have the out-of-range phenomenon, the freezing area is drawn next, the out-of-range phenomenon of the freezing area is changed into source image priority due to a rendering mode, and the source image priority cannot occur, so that the purposes of the people are achieved.
The advantage of this example is that the user does not have to be limited by the screen size when freezing the form, and there is also an excellent use experience on the mobile end, which is a small-screen device compared to a PC.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
According to another aspect of the embodiments of the present invention, there is also provided a form display apparatus in a scenario for implementing the form display method, and optionally, the embodiments of the present invention may be applied to an application environment as shown in fig. 1, where the Web online form shown in fig. 1 may use a freezing function, that is, the Web online form may be divided into a frozen area and a non-frozen area.
The following describes terms involved in the Web presence table.
Freezing, partial row and column areas can be fixed in the form, and at the moment, a user can only change the non-frozen area by rolling the form, so that people can conveniently read form information.
Dom: the general name of each element in the Web page is that a Web page is composed of a plurality of Dom nodes.
A Canvas: a special Dom node, also called Canvas, can call the bottom layer drawing interface of the browser, and can perform efficient image drawing based on Canvas.
Viewport: viewport, visual area. Images drawn in Canvas, whose position coordinates are to be based on the current viewable area (viewport). When the element is outside the visible region, it is invisible.
According to an aspect of an embodiment of the present invention, as shown in fig. 12, the above table display apparatus includes:
1) a first obtaining unit 122, configured to obtain a region freezing instruction generated by performing an operation on a target region to be frozen in a table;
the region freeze instruction is used to instruct the freezing process to be performed on the cells in the target region. The cells may be real cells in which data is already recorded, or empty cells in which data is not recorded. This is not limited in this embodiment.
2) A control unit 124, configured to control the cell object included in the target region to be displayed in the frozen window when a display range of the target region is greater than or equal to a display range of a frozen window preconfigured in the visual window, where the display range of the frozen window is less than or equal to the display range of the visual window;
the display range of the frozen window is equal to or smaller than the display range of the visible window.
3) A second obtaining unit 126, configured to obtain an adjustment instruction generated by performing an adjustment operation on the cell object displayed in the frozen window;
3) an adjusting unit 128 for adjusting the cell object displayed in the frozen window to a target cell object in the target area in response to an adjustment instruction;
4) and a display unit 130 for displaying the adjusted target cell object in the frozen window.
Alternatively, the target area may be an area to be frozen, for example, in fig. 1, column AB is a frozen area, and a column following the column AB is a non-frozen area. The above is only an example, and this is not limited in this embodiment.
Optionally, in this embodiment, in a case that the display range of the target area is smaller than or equal to the display range of a frozen window configured in advance in the visual window, the cells in the target area may be normally displayed.
Optionally, in this embodiment, the frozen window may be, but is not limited to, identified by a virtual Viewport, where the virtual Viewport is used to control the cells in the target area to be limited in the frozen window for display. The above is merely an example, and this is not limited in this embodiment.
Optionally, in this embodiment, the manner of controlling the cells in the target area to be displayed in the freeze window includes, but is not limited to:
determining an original cell object located in a display range of the freezing window from the target area in a first mode; and displaying the original cell object in the freezing window.
Moving the target area, and then determining the target cell object which is adjusted and located in the display range of the freezing window from the moved target area; and displaying the target cell object in the freezing window.
The above is merely an example, and this is not limited in this embodiment.
Optionally, in this embodiment, the displaying the adjusted target cell object in the freeze window includes, but is not limited to:
in a first mode, the adjusted target cell object is rendered and displayed based on Canvas in a display area corresponding to the frozen window, and a characteristic cell object is rendered and displayed in a display area except the frozen window in the visual window, wherein the characteristic cell object is a cell acquired from a non-target area except the target area in a page to be displayed.
And secondly, rendering and displaying the adjusted target cell object in a display area corresponding to the frozen window based on non-Canvas, and rendering and displaying a characteristic cell object in a display area except the frozen window in the visual window, wherein the characteristic cell object is a cell acquired from a non-target area except the target area in a page to be displayed.
The above is merely an example, and this is not limited in this embodiment.
By the apparatus shown in fig. 12, after an area freeze instruction generated by performing an operation on a target area to be frozen in a table is acquired, in a case that a display range of the target area is greater than or equal to a display range of a freeze window pre-configured in a visual window, a cell object included in the target area is controlled in the freeze window to be displayed, where the display range of the freeze window is less than or equal to the display range of the visual window; acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window; adjusting the cell object displayed in the freezing window into a target cell object in the target area according to the adjusting instruction; and displaying the adjusted target cell object in the freezing window, thereby flexibly controlling the cell object in the frozen target area to be dynamically displayed in the freezing window without display jamming, and further solving the technical problem that the display jamming is easy to occur when the display area of the freezing area exceeds the display area of the visual window.
The present embodiment will be described below with reference to specific examples.
In the Web online form provided by the related art, after the freezing function is used, only the non-frozen region can be scrolled, so that when the frozen region is too large, the range of the user which can be operated actually becomes small, and when the frozen region is too small to a trigger limit, more rows and columns cannot be frozen and the non-frozen rows and columns cannot be operated. In this embodiment, not only the freezing area is fixed, but also a maximum value is given to the freezing area, for example, half of the size of the viewport, and then the range of the other half of the viewport can be displayed when the non-freezing area is minimum. When the real size of the frozen area exceeds the maximum value, a scroll bar appears, and at this time, the user can perform operations such as sliding on the frozen area to obtain feedback (as shown in fig. 3).
In this case, not only is the page falsely death caused by the large frozen area avoided, but also the content comparison between the frozen area and the non-frozen area is facilitated for the user, and the performance on the mobile terminal is particularly obvious.
In an alternative implementation manner, fig. 13 is a block diagram (a) of a table display apparatus according to another alternative embodiment of the present invention, and as shown in fig. 13, the control unit 124 includes:
1) a first determining module 132, configured to determine an original cell object located in a display range of the frozen window in the target region;
2) a first display module 134 for displaying the original cell object in the frozen window.
For example, assuming that table 1 includes 5 columns, A, B, C, D, E respectively, where the target area (i.e., the area to be frozen) is four columns of A, B, C, D, the preconfigured freeze window (i.e., the virtual Viewport) is a window that includes three columns of A, B, C, then the original cell object is a cell object that includes three columns of A, B, C, and the three columns of cell objects are displayed A, B, C in the freeze window.
For another example, assume that table 1 includes 5 columns, A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D, the preconfigured freeze window (i.e., the virtual Viewport) is a window including A, B, C, D, and then the original cell object is a cell object including A, B, C, D, and A, B, C, D is displayed in the freeze window.
Alternatively, in this embodiment, part of the cell objects in the target region adapted to the freeze window may be acquired through fig. 13 and displayed.
In an alternative implementation manner, fig. 14 is a structural block diagram (ii) of a table display apparatus according to another alternative embodiment of the present invention, and as shown in fig. 14, the adjusting unit 128 includes:
1) an adjusting module 142, configured to adjust the original cell object displayed in the frozen window in response to the adjusting instruction;
2) and a second determining module 144, configured to determine the adjusted target cell object located in the display range of the freezing window in the target area.
Optionally, in this embodiment, the steps S21 to S22 correspond to relative movement between the freezing window and the target area, and the cell object located in the freezing window after each adjustment is obtained and displayed.
For example, assuming that table 1 includes 5 columns, A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D, and the preconfigured freeze window (i.e., the virtual Viewport) is a window including A, B, C, the target cell object is a cell object including A, B, C, and the three columns of cell objects are displayed A, B, C in the freeze window, and after receiving the adjustment instruction, the cell object displayed in the freeze window is adjusted, and B, C, D columns of cell objects located in the freeze window are displayed.
For another example, if table 1 includes 5 columns, which are A, B, C, D and E respectively, where the target area (i.e., the area to be frozen) is A, B, C, D four columns, and the pre-configured freezing window (i.e., the virtual Viewport) is a window including A, B four columns, the target cell object is a cell object including A, B two columns, and A, B two columns of cell objects are displayed in the freezing window, and after receiving the adjustment instruction, the cell object displayed in the freezing window is adjusted, and C, D columns of cell objects located in the freezing window are displayed.
In an optional embodiment, the obtaining of the adjustment instruction generated by performing the adjustment operation on the cell object displayed in the frozen window includes at least one of:
acquiring the adjusting instruction generated by executing sliding operation on the scroll bar contained in the freezing window;
acquiring the adjusting instruction generated by executing touch screen operation on a display screen where the freezing window is located;
and acquiring the adjusting instruction generated by executing the motion sensing operation on the three-dimensional space corresponding to the freezing window.
Optionally, in this embodiment, a manner of obtaining the adjustment instruction generated by performing the operation on the freeze window includes, but is not limited to: sliding a scroll bar, gestures (somatosensory), touch screen drag-and-slide, etc.
By the method, the adjusting instruction generated by executing the operation on the frozen window is obtained, and the technical problem that display blockage is easy to occur when the display area of the frozen area exceeds the display area of the visual window can be further solved.
By the method, the adjusting instruction generated by executing the operation on the frozen window is obtained, and the technical problem that display blockage is easy to occur when the display area of the frozen area exceeds the display area of the visual window can be further solved.
Optionally, the display unit 130 is further configured to render and display the adjusted target cell object in a display area corresponding to the frozen window, and render and display a feature cell object in a display area in the visual window except the frozen window, where the feature cell object is a cell object obtained from a non-target area in the page to be displayed except the target area.
Optionally, in this embodiment, for the operation of the frozen region and the non-frozen region, a part a may be rendered first, and the part a is cleared of the out-of-bounds cell object; and rendering the part B, wherein the part B cross-border cell object is displayed under (covered by) the part A data in a mode of 'source data priority', thereby realizing dynamic control on different areas and ensuring normal display. The above is merely an example, and this is not limited in this embodiment.
Through the step S31, a visual window is rendered, which includes the cell object in the frozen window and the cell object in the non-frozen window, thereby implementing dynamic control on different areas and ensuring normal display.
In an alternative implementation manner, fig. 15 is a structural block diagram (three) of a table display apparatus according to another alternative embodiment of the present invention, and as shown in fig. 15, the display unit 130 includes:
1) a first obtaining module 152, configured to obtain a cell object in a target area from a first cache for storing the target area, and draw the cell object in the target area within a visual window;
it should be noted that the first cache may be a virtual Viewport that freezes a portion.
2) A first flush module 154, configured to flush the first cache;
3) a second obtaining module 156, configured to obtain a cell object in the non-target region from a second cache for storing the non-target region, and draw the cell object in the non-target region in the visual window, where, in a display region corresponding to the freeze window, a display priority of the cell object stored in the first cache is higher than a display priority of the cell object stored in the second cache.
It should be noted that the second cache may be a virtual Viewport of a non-frozen portion.
In an alternative implementation, fig. 16 is a block diagram (iv) of a table display apparatus according to another alternative embodiment of the present invention, and as shown in fig. 16, the display unit 130 includes:
1) a third obtaining module 162, configured to obtain a cell object in the non-target region from a third cache for storing the non-target region, and draw the cell object in the non-target region in the visual window;
it should be noted that the third cache may be a virtual Viewport of a non-frozen portion.
2) A second emptying module 164, configured to empty the third cache;
3) a fourth obtaining module 166, configured to obtain the cell object in the target area from a fourth cache for storing the target area, and draw the cell object in the target area within the visible window, where in a display area within the visible window except for the frozen window, a display priority of the cell object stored in the third cache is higher than a display priority of the cell object stored in the fourth cache.
It should be noted that the third cache may be a virtual Viewport that freezes a portion.
The present embodiment will be described below with reference to specific examples.
Assuming that the entire table is operational before freezing, it can be understood that only one region on a viewport is a non-frozen region. At this time, the position coordinates of the table elements are all based on viewport, that is, it is understood that the rendering of any cell only needs to consider the viewport coordinates. The viewport coordinates of C6 pane in fig. 4 are (226, 235).
When the user freezes the first four columns, if the mode of only fixing the frozen region is adopted, the elements in the table only need to consider the viewport coordinates, and only need to control the rendering sequence to cover the frozen region with the non-frozen region (as shown in fig. 5).
The proposal of the example introduces a virtual viewport, and one virtual viewport is added for maintenance whether the area is frozen or not. The real viewport of C3 lattice in FIG. 6 is (189, 91), the virtual viewport is (0, 91)
Whether the virtual viewport is really visible on the screen or not is also determined by the virtual viewport coordinate, and the x coordinate under the virtual viewport of the C column in FIG. 7 exceeds the maximum value of the virtual viewport of the freezing area, so that the virtual viewport is invisible. For such a schema, the process maintenance of the entire table cell object needs to be changed, not just paying attention to the non-frozen regions.
One key left is how to render the virtual viewport presentation. In other schemes, because only the frozen region is fixed and then is completely displayed, the rendering pipelines of the other schemes render the non-frozen region first and then render the frozen region. The frozen region is the highest level and thus naturally covers the out-of-range of the non-frozen region due to scrolling.
The virtual viewport introduced in this example has a problem that the frozen region may also be out of bounds (as shown in fig. 8), and when both are out of bounds, no matter whether the frozen region is above or not, the rendered region will render out of bounds part, which produces an erroneous effect.
Therefore, at this time, the rendering with the limited range is needed, the non-frozen region is rendered first, the boundary crossing phenomenon already exists, when the frozen region is rendered again, the range of the frozen region is limited first, and only the size of the virtual viewport is rendered, so that the boundary crossing phenomenon does not occur in the frozen region, and the boundary crossing content of the non-frozen region is covered after normal rendering, as shown in fig. 9.
An API for limiting the rendering range of Canvas in the Web is clip, and the following is found after actual use: due to the performance bottleneck of the Web, calling the clip brings unacceptable performance overhead, and causes the display to be dull. Under iOS, a large clip would cause significant chunking (fig. 10). Therefore, a frequent and small-range clip (fig. 11) is adopted in the replacement concept, and in the scheme, the iOS is not blocked, but part of android is blocked, and if the clip is continuously used, only a subsystem can process the clip, but great code development and maintenance cost is brought.
Finally, the invention adopts the self to realize clip, firstly, the rendering and stacking mode is switched to the priority of the source image, namely, the element drawn later is under the element drawn first, and the element is not covered but covered. The whole pipeline drawing process is that a non-freezing area is drawn firstly, at the moment, an out-of-range phenomenon exists, then before the freezing area is drawn, a viewport of the freezing area is emptied, the non-freezing area does not have the out-of-range phenomenon, the freezing area is drawn next, the out-of-range phenomenon of the freezing area is changed into source image priority due to a rendering mode, and the source image priority cannot occur, so that the purposes of the people are achieved.
The advantage of this example is that the user does not have to be limited by the screen size when freezing the form, and there is also an excellent use experience on the mobile end, which is a small-screen device compared to a PC.
According to a further aspect of an embodiment of the present invention, there is also provided a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps in any of the method embodiments described above when executed.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, acquiring a region freezing instruction generated by executing operation on a target region to be frozen in the table;
s2, when the display range of the target area is larger than or equal to the display range of a freezing window configured in advance in the visual window, controlling the cell object contained in the target area to be displayed in the freezing window, wherein the display range of the freezing window is smaller than or equal to the display range of the visual window;
s3, acquiring an adjusting instruction generated by adjusting the cell object displayed in the freezing window;
s4, responding to the adjusting instruction, adjusting the cell object displayed in the freezing window into the target cell object in the target area;
s5, the adjusted target cell object is displayed in the freeze window.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, determining the original cell object in the target area within the display range of the freezing window;
s2, the original cell object is displayed in the freeze window.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, responding to the adjusting instruction, adjusting the original cell object displayed in the freezing window;
and S2, determining the target cell object which is positioned in the display range of the freezing window in the target area after adjustment.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, acquiring an adjusting instruction generated by executing sliding operation on the scroll bar contained in the freezing window;
s2, acquiring an adjusting instruction generated by executing touch screen operation on a display screen where the freezing window is located;
s3, an adjustment command generated by performing a motion sensing operation on the three-dimensional space corresponding to the frozen window is acquired.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
and S1, rendering and displaying the adjusted target cell object in the display area corresponding to the frozen window, and rendering and displaying the characteristic cell object in the display area except the frozen window in the visual window, wherein the characteristic cell object is the cell object obtained from the non-target area except the target area in the page to be displayed.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, obtaining the cell object in the target area from the first cache for storing the target area, and drawing the cell object in the target area in the visual window;
s2, emptying the first cache;
and S3, obtaining the cell object in the non-target area from the second cache for storing the non-target area, and drawing the cell object in the non-target area in the visual window, wherein the display priority of the cell object stored in the first cache is higher than that of the cell object stored in the second cache in the display area corresponding to the freezing window.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, obtaining the cell object in the non-target area from the third cache for storing the non-target area, and drawing the cell object in the non-target area in the visual window;
s2, emptying the third cache;
and S3, obtaining the cell object in the target area from a fourth cache for storing the target area, and drawing the cell object in the target area in the visual window, wherein the display priority of the cell object stored in the third cache is higher than that of the cell object stored in the fourth cache in the display area except the frozen window in the visual window.
Alternatively, in this embodiment, a person skilled in the art may understand that all or part of the steps in the methods of the foregoing embodiments may be implemented by a program instructing hardware associated with the terminal device, where the program may be stored in a computer-readable storage medium, and the storage medium may include: flash disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
According to another aspect of the embodiment of the present invention, there is also provided an electronic apparatus for implementing the table display method, as shown in fig. 17, the electronic apparatus includes a memory 1702 and a processor 1704, the memory 1702 stores a computer program, and the processor 1704 is configured to execute the steps in any one of the method embodiments through the computer program.
Optionally, in this embodiment, the electronic apparatus may be located in at least one network device of a plurality of network devices of a computer network.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, acquiring a region freezing instruction generated by executing operation on a target region to be frozen in the table;
s2, when the display range of the target area is larger than or equal to the display range of a frozen window configured in advance in a visual window, controlling the cell object contained in the target area to be displayed in the frozen window, wherein the display range of the frozen window is smaller than or equal to the display range of the visual window;
s3, acquiring an adjusting instruction generated by adjusting the cell object displayed in the freezing window;
s4, responding to the adjusting instruction, adjusting the cell object displayed in the freezing window into the target cell object in the target area;
s5, displaying the adjusted target cell object in the freezing window.
Alternatively, in this embodiment, the processor may be configured to store a computer program for executing the following steps:
s1, determining an original cell object located in the display range of the freezing window in the target area;
s2, displaying the original cell object in the freezing window.
Alternatively, in this embodiment, the processor may be configured to store a computer program for executing the following steps:
s1, responding to the adjusting instruction, adjusting the original cell object displayed in the freezing window;
and S2, determining the target cell object which is positioned in the display range of the freezing window in the target area after adjustment.
Alternatively, in this embodiment, the processor may be configured to store a computer program for executing the following steps:
and S1, rendering and displaying the adjusted target cell object in the display area corresponding to the frozen window, and rendering and displaying the characteristic cell object in the display area except the frozen window in the visual window, wherein the characteristic cell object is a cell object obtained from a non-target area except the target area in the page to be displayed.
Alternatively, it can be understood by those skilled in the art that the structure shown in fig. 17 is only an illustration, and the electronic device may also be a terminal device such as a smart phone (e.g., an Android phone, an iOS phone, etc.), a tablet computer, a palmtop computer, and a Mobile Internet Device (MID), a PAD, and the like. Fig. 17 is a diagram illustrating the structure of the electronic device. For example, the electronic device may also include more or fewer components (e.g., network interfaces, display devices, etc.) than shown in FIG. 17, or have a different configuration than shown in FIG. 17.
The memory 1702 may be configured to store software programs and modules, such as program instructions/modules corresponding to the table display method and apparatus in the embodiments of the present invention, and the processor 1702 executes various functional applications and data processing by running the software programs and modules stored in the memory 1702, so as to implement the table display method. The memory 1702 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 1702 may further include memory located remotely from the processor 1702, which may be connected to the terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof. The memory 1702 may be specifically, but not limited to, used for storing information such as table display procedures. As an example, as shown in fig. 17, the memory 1702 may include, but is not limited to, the first obtaining unit 122, the control unit 124, the second obtaining unit 126, the adjusting unit 128, and the display unit 130 in the table display device. In addition, the present invention may further include, but is not limited to, other module units in the table display apparatus, which are not described in detail in this example.
Optionally, the above-mentioned transmission device 1710 is used for receiving or sending data via a network. Examples of the network may include a wired network and a wireless network. In one example, the transmission device 1710 includes a Network adapter (NIC) that can be connected to a router via a Network cable and other Network devices to communicate with the internet or a local area Network. In one example, the transmission 1710 is a Radio Frequency (RF) module, which is used to communicate with the internet in a wireless manner.
In addition, the electronic device further includes: a display 1708 for displaying the results of the table display; and a connection bus 1710 for connecting the respective module parts in the above-described electronic apparatus.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
The integrated unit in the above embodiments, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing one or more computer devices (which may be personal computers, servers, network devices, etc.) to execute all or part of the steps of the method according to the embodiments of the present invention.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (9)
1. A table display method, comprising:
acquiring a region freezing instruction generated by executing operation on a target region to be frozen in a table;
under the condition that the display range of the target area is larger than or equal to the display range of a frozen window which is configured in advance in a visual window, controlling the cell object contained in the target area to be displayed in the frozen window, wherein the display range of the frozen window is smaller than or equal to the display range of the visual window;
acquiring an adjusting instruction generated by executing adjusting operation on the cell object displayed in the freezing window;
responding to the adjusting instruction, and adjusting the cell object displayed in the freezing window into a target cell object in the target area;
obtaining cell objects in a non-target area from a first cache used for storing the non-target area except the target area, and drawing the cell objects in the non-target area in the visual window;
emptying a visible area viewport of the target area;
and obtaining the cell object in the target area from a second cache for storing the target area, and drawing the cell object in the target area in the visual window, wherein the display priority of the cell object stored in the first cache is higher than that of the cell object stored in the second cache in the display area except the frozen window in the visual window.
2. The method of claim 1, wherein controlling the cell objects contained in the target region to be displayed in the freeze window comprises:
determining an original cell object in the target area and positioned in the display range of the freezing window;
displaying the original cell object in the freeze window.
3. The method of claim 2, wherein the adjusting the displayed cell object in the frozen window to the target cell object in the target area in response to the adjustment instruction comprises:
responding to the adjusting instruction, and adjusting the original cell object displayed in the freezing window;
and determining the target cell object which is positioned in the display range of the freezing window in the target area after adjustment.
4. The method of claim 1, wherein obtaining adjustment instructions generated by performing adjustment operations on cell objects displayed in the frozen window comprises at least one of:
acquiring the adjusting instruction generated by executing sliding operation on the scroll bar contained in the freezing window;
acquiring the adjusting instruction generated by executing touch screen operation on the display screen where the freezing window is located;
and acquiring the adjusting instruction generated by executing the somatosensory operation on the three-dimensional space corresponding to the freezing window.
5. A table display apparatus, comprising:
the first acquisition unit is used for acquiring a region freezing instruction generated by executing operation on a target region to be frozen in the table;
the control unit is used for controlling the cell object contained in the target area to be displayed in the freezing window when the display range of the target area is larger than or equal to the display range of the freezing window configured in advance in the visual window, wherein the display range of the freezing window is smaller than or equal to the display range of the visual window;
a second obtaining unit, configured to obtain an adjustment instruction generated by performing an adjustment operation on the cell object displayed in the frozen window;
the adjusting unit is used for responding to the adjusting instruction and adjusting the cell object displayed in the freezing window into a target cell object in the target area;
a display unit, configured to display the adjusted target cell object in the freeze window;
the display unit is further configured to render and display the adjusted target cell object in a display area corresponding to the frozen window, and render and display a feature cell object in a display area of the visible window except the frozen window, where the feature cell object is a cell object obtained from a non-target area of a page to be displayed except the target area;
the display unit further includes:
a first obtaining module, configured to obtain a cell object in the non-target region from a first cache for storing the non-target region, and draw the cell object in the non-target region within the viewable window;
a first emptying module, configured to empty a viewable area viewport of the target area;
and a second obtaining module, configured to obtain a cell object in the target area from a second cache that is used for storing the target area, and draw the cell object in the target area in the visual window, where in a display area within the visual window except for the frozen window, a display priority of the cell object stored in the first cache is higher than a display priority of the cell object stored in the second cache.
6. The apparatus of claim 5, wherein the control unit comprises:
the first determining module is used for determining an original cell object which is positioned in the display range of the freezing window in the target area;
a first display module for displaying the original cell object in the frozen window.
7. The apparatus of claim 6, wherein the adjusting unit comprises:
the adjusting module is used for responding to the adjusting instruction and adjusting the original cell object displayed in the freezing window;
and the second determination module is used for determining the target cell object which is positioned in the display range of the freezing window in the target area after adjustment.
8. A storage medium, in which a computer program is stored, wherein the computer program is arranged to perform the method of any of claims 1 to 4 when executed.
9. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 4 by means of the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811161935.2A CN110968987B (en) | 2018-09-30 | 2018-09-30 | Table display method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811161935.2A CN110968987B (en) | 2018-09-30 | 2018-09-30 | Table display method and device, storage medium and electronic device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110968987A CN110968987A (en) | 2020-04-07 |
| CN110968987B true CN110968987B (en) | 2022-05-20 |
Family
ID=70029329
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811161935.2A Active CN110968987B (en) | 2018-09-30 | 2018-09-30 | Table display method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110968987B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111309798B (en) * | 2020-02-11 | 2023-05-12 | 北京字节跳动网络技术有限公司 | Processing method, device, equipment and storage medium of table |
| CN111563214B (en) * | 2020-04-29 | 2023-05-16 | 北京字节跳动网络技术有限公司 | Reference line processing method and device |
| CN112286603A (en) * | 2020-09-28 | 2021-01-29 | 长沙市到家悠享网络科技有限公司 | Table display method and device, electronic equipment and storage medium |
| CN113625917A (en) * | 2021-07-29 | 2021-11-09 | 北京达佳互联信息技术有限公司 | Data display method and device, electronic equipment, storage medium and product |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815478A (en) * | 2006-03-06 | 2006-08-09 | 阿里巴巴公司 | Method and system for realizing form local rolling-display in web-page |
| CN105022558A (en) * | 2014-04-16 | 2015-11-04 | 珠海金山办公软件有限公司 | Method and system for adjusting frozen region in spreadsheet |
| CN105302787A (en) * | 2015-11-10 | 2016-02-03 | 浪潮软件股份有限公司 | Method and device for table data editing |
| CN105677624A (en) * | 2014-11-20 | 2016-06-15 | 珠海金山办公软件有限公司 | Adjusting method and device for adjusting frozen region of electronic table |
| CN106886511A (en) * | 2016-06-21 | 2017-06-23 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of network form |
| CN108595097A (en) * | 2018-05-10 | 2018-09-28 | 聚好看科技股份有限公司 | Page scroll control method and device and playback terminal |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7454695B1 (en) * | 2000-05-19 | 2008-11-18 | Renderx, Inc. | Methods for rendering tables |
| US11461077B2 (en) * | 2004-11-26 | 2022-10-04 | Philip K. Chin | Method of displaying data in a table with fixed header |
| US7930323B2 (en) * | 2004-12-30 | 2011-04-19 | Sap Ag | Method for reallocating table formats in real-time |
| US9195780B2 (en) * | 2011-09-30 | 2015-11-24 | Oracle International Corporation | Computer user interface including a data grid with a persistent display portion |
| CN104516867A (en) * | 2013-09-30 | 2015-04-15 | 北大方正集团有限公司 | Table reordering method and table reordering system |
| US9760271B2 (en) * | 2014-07-28 | 2017-09-12 | International Business Machines Corporation | Client-side dynamic control of visualization of frozen region in a data table |
-
2018
- 2018-09-30 CN CN201811161935.2A patent/CN110968987B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815478A (en) * | 2006-03-06 | 2006-08-09 | 阿里巴巴公司 | Method and system for realizing form local rolling-display in web-page |
| CN105022558A (en) * | 2014-04-16 | 2015-11-04 | 珠海金山办公软件有限公司 | Method and system for adjusting frozen region in spreadsheet |
| CN105677624A (en) * | 2014-11-20 | 2016-06-15 | 珠海金山办公软件有限公司 | Adjusting method and device for adjusting frozen region of electronic table |
| CN105302787A (en) * | 2015-11-10 | 2016-02-03 | 浪潮软件股份有限公司 | Method and device for table data editing |
| CN106886511A (en) * | 2016-06-21 | 2017-06-23 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of network form |
| CN108595097A (en) * | 2018-05-10 | 2018-09-28 | 聚好看科技股份有限公司 | Page scroll control method and device and playback terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110968987A (en) | 2020-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110968987B (en) | Table display method and device, storage medium and electronic device | |
| US11836327B2 (en) | Application window divider control for window layout management | |
| US20200353355A1 (en) | Information object display method and apparatus in virtual scene, and storage medium | |
| US6720981B1 (en) | Method, system and program product for animated web page construction and display | |
| US20180007417A1 (en) | Method and system for improving application sharing by dynamic partitioning | |
| KR20030016313A (en) | Providing A Scrolling Function For A Multiple Frame Web Page | |
| US9921797B2 (en) | Displaying user activity in real-time collaborative editing systems | |
| WO2016094286A1 (en) | Intelligent browser-based display tiling | |
| CN104350495A (en) | Managing objects in panorama display to navigate spreadsheet | |
| KR102317013B1 (en) | Object management and visualization using computing devices | |
| CN112114928A (en) | Display page processing method and device | |
| CN111625167A (en) | Page switching method and device and computer equipment | |
| CN105549936A (en) | Data table display method and apparatus | |
| CN106201237A (en) | A kind of information collection method and device | |
| CN103677524A (en) | Control method and device of presenting mode of navigation bar | |
| CN111724226A (en) | Information display method and system, electronic equipment and storage medium | |
| CN105302590A (en) | Information processing method and apparatus | |
| CN111222302A (en) | Webpage rendering control method, control device and computer readable medium | |
| CN115222840A (en) | Table rendering method, computer-readable storage medium, and electronic device | |
| CN110968241B (en) | Processing method and device of electronic form, computer readable storage medium and computer equipment | |
| CN109032476B (en) | Method for displaying big data set in graphical user interface | |
| CN109960562B (en) | Information display method and device and computer readable storage medium | |
| CN114117274A (en) | Data rendering method and device, computer equipment and storage medium | |
| CN106484233A (en) | Interface control method and system based on slide | |
| CN111158566A (en) | Event processing method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 40021555 Country of ref document: HK |
|
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |