Table style processing method, processing device and computer readable storage medium
By identifying and adjusting the fill and border colors of the table's designated areas, including the header and body areas, the problem of poor adjustment results caused by the inability to identify table areas in existing technologies has been solved, achieving better table style adjustment effects.
Patent Information
- Application Number
- CN202111130455.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-26
- Publication Date
- 2025-11-25
- Estimated Expiration
- 2041-09-26
AI Technical Summary
Existing technology cannot recognize table areas, resulting in poor table adjustment effects, inability to distinguish different structural styles, and insufficient coverage of built-in preset styles, failing to recognize horizontal reading issues.
By identifying the predefined areas of the table, including the header area and the body area, and in response to selection operations on the interface, style information is determined, and the styles of different areas of the table are adjusted according to the predefined areas and style information, such as fill color, border color, and alternation method.
It enables targeted adjustments to different areas of the table, improving the effectiveness of table adjustments and resolving the issue of poor adjustment results caused by the inability to recognize table areas.
Smart Images

Figure CN113869015B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the field of data processing, in particular, to a table style processing method and device, a computer readable storage medium and a processor. BACKGROUND
[0002] In the process of using table documents, there are often scenarios that need to adjust the table, for example: 1) when the document has many rows and columns, the information is relatively dense, there is no fill color and no border line, the closely packed text makes it difficult to read the information, and the readability is poor; 2) when printing a table document, since no table style is set, the printed table has no border line, and the readability is poor; 3) the user's individual needs require fill color and border line and other styles to provide better display effects for the table and highlight structural features; 4) certain specific application scenarios require the use of specific styles, for example, tables cited in academic materials require the use of "three-line table" style.
[0003] The preset table style can be selected to adjust the table, and the preset table adjustment style in the table can be used as follows: a, the user selects the cell to be adjusted, clicks the "table style" in the table, can select the preset table adjustment style, determines the adjustment area (which can be re-selected), selects the number of header rows (the default is 1 row), and clicks "Confirm" to apply the table adjustment style, b, first select the preset table adjustment style, and then select "Convert to table" in the confirmation area dialog box, which completes the "table" conversion and style application at the same time, c, customizing the preset style, the preset style of the table can be customized by selecting the fill color, border style and alternating row style of "title" and "table body".
[0004] However, the preset table adjustment style in the table does not recognize the table area, and the style effect is single: it cannot distinguish different structure style applications (for example, it cannot distinguish between titles and supplementary information), the default style of the title row depends on manual selection, and the default is one row, which is easy to cause application errors, the use scenarios covered by the preset table adjustment style in the table are not wide enough, and the problem of horizontal reading is not considered, and there is no style related to the list header and row alternation, as shown in Figure 1 When the table is converted into other formats of files, the merged cells are canceled, which leads to poor overall application effect. This way cannot recognize the table area, so the adjustment effect of the table is poor.
[0005] Therefore, there is an urgent need for a method that can recognize the table area and adjust different areas of the table.
[0006] The above information disclosed in the Background section is only for enhancing the understanding of the background of the technology described herein and therefore can contain information that does not form the prior art that is already known in this country to those of ordinary skill in the art. SUMMARY
[0007] The main purpose of the present application is to provide a table style processing method, processing device, computer readable storage medium and processor, so as to solve the problem of poor adjustment effect of table due to the inability to identify the table area in the prior art.
[0008] According to an aspect of an embodiment of the present application, a table style processing method is provided, comprising: determining a to-be-adjusted area of a target table; identifying a predetermined area in the to-be-adjusted area, the identified predetermined area comprising at least a header area and a body area; determining style information in response to selection operations on a plurality of identifiers on a display interface, the style information being information of a preset style of the to-be-adjusted area, the plurality of identifiers comprising a theme color identifier, an alternating manner identifier, and a table style identifier, the theme color identifier being an identifier representing a target fill color of the to-be-adjusted area, the alternating manner identifier being an identifier representing an alternating manner of fill color, and the table style identifier being an identifier representing a style of the to-be-adjusted area; and adjusting the style in the to-be-adjusted area of the target table to the preset style according to at least the predetermined area and the style information.
[0009] Optionally, the style information comprises theme color information and alternating style information, and adjusting the style in the to-be-adjusted area of the target table to the preset style according to at least the predetermined area and the style information comprises: determining a target fill color of the to-be-adjusted area according to the theme color information; determining an alternating style of the to-be-adjusted area according to the alternating style information, the alternating style being an alternating manner of fill color; and adjusting fill colors of the header area and the body area of the to-be-adjusted area of the target table according to the target fill color of the to-be-adjusted area and the alternating style.
[0010] Optionally, the target fill color of the to-be-adjusted region has multiple, and the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, comprising: in the case that the alternating pattern is a row alternating pattern, determining a horizontal alternating granularity; in the case that the horizontal alternating granularity is a merged row, traversing the table header region and the table body region by the merged row as a unit, and alternately filling multiple target fill colors, the cells of the merged row being formed by multiple minimum cells in the column direction; in the case that the horizontal alternating granularity is not the merged row, traversing the table header region and the table body region by a single row as a unit, and alternately filling multiple target fill colors, the cells of the single row being the minimum cells.
[0011] Optionally, the target fill color of the to-be-adjusted region has multiple, and the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, comprising: in the case that the alternating pattern is a row alternating pattern, determining a horizontal alternating granularity; in the case that the horizontal alternating granularity is a merged row, traversing the table header region and the table body region by the merged row as a unit, and alternately filling multiple target fill colors, the cells of the merged row being formed by multiple minimum cells in the column direction; in the case that the horizontal alternating granularity is not the merged row, traversing the table header region and the table body region by a single row as a unit, and alternately filling multiple target fill colors, the cells of the single row being the minimum cells.
[0012] Optionally, after the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, the style of the to-be-adjusted region of the target table is adjusted to the preset style according to at least the predetermined region and the style information, further comprising: determining the target color of the text in each predetermined region, the outer border target color and the inner border target color of the to-be-adjusted region according to the theme color information; adjusting the color of the text in each predetermined region to the target color of the corresponding text; adjusting the outer border color and the inner border color of the to-be-adjusted region to the outer border target color and the inner border target color of the to-be-adjusted region.
[0013] Optionally, adjusting the outer border color and the inner border color of the to-be-adjusted region to the outer border target color and the inner border target color of the to-be-adjusted region comprises: sequentially setting two border colors of each row in a first predetermined direction, and in the process of setting, the color of the first border of a later set row replaces the color of the second border of an earlier set row, wherein the color of the first border of each row is the inner border target color, and the color of the second border of each row is the outer border target color, and the direction from the first border to the second border of a row is the first predetermined direction; and / or sequentially setting two border colors of each column in a second predetermined direction, and in the process of setting, the color of the first border of a later set column replaces the color of the second border of an earlier set column, wherein the direction from the first border to the second border of a column is the second predetermined direction.
[0014] Optionally, after sequentially setting two border colors of each row in a first predetermined direction, and / or sequentially setting two border colors of each column in a second predetermined direction, adjusting the outer border color and the inner border color of the to-be-adjusted region to the outer border target color and the inner border target color of the to-be-adjusted region further comprises: adjusting the color of a target border to the outer border target color, wherein the target border is an outer border of the to-be-adjusted region whose color is not the outer border target color.
[0015] Optionally, before adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating pattern, adjusting the pattern in the to-be-adjusted region of the target table to the preset pattern according to the predetermined region and the pattern information comprises: in the case that the identified predetermined region comprises a title region and a supplementary information region, determining, according to the theme color information, a target color of text in the title region, a target color of the text in the supplementary information region, a target fill color of the title region, a target border color of the title region, a target fill color of the supplementary information region, and a target border color of the supplementary information region; adjusting the color of the text in the title region and the color of the text in the supplementary information region to the corresponding target color of the text, respectively; adjusting the border color of the title region and the border color of the supplementary information region to the corresponding target border color, respectively; and adjusting the fill color of the title region and the fill color of the supplementary information region to the corresponding target fill color, respectively.
[0016] Optionally, after adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating style, the adjusting the style in the to-be-adjusted region of the target table into the preset style according to at least the predetermined region and the style information comprises: determining the target color of the text in the table header region, the target fill color of the table header region and the target color of the border of the table header region according to the theme color information; adjusting the color of the text in the table header region into the corresponding target color of the text; adjusting the border color of the table header region into the corresponding target color of the border; and adjusting the fill color of the table header region into the corresponding target fill color.
[0017] Optionally, after adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating style, the adjusting the style in the to-be-adjusted region of the target table into the preset style according to at least the predetermined region and the style information comprises: determining whether to ignore the table header setting; in a case where it is determined not to ignore the table header setting, determining the target color of the text in the table header region, the target fill color of the table header region and the target color of the border of the table header region according to the theme color information; adjusting the color of the text in the table header region into the corresponding target color of the text; adjusting the border color of the table header region into the corresponding target color of the border; and adjusting the fill color of the table header region into the corresponding target fill color.
[0018] Optionally, after adjusting the fill color of the table header region into the corresponding target fill color, the adjusting the style in the to-be-adjusted region of the target table into the preset style according to at least the predetermined region and the style information comprises: in a case where the identified predetermined region comprises a first column region, determining the target color of the text in the first column region, the target fill color of the first column region and the target color of the border of the first column region according to the theme color information; adjusting the color of the text in the first column region into the corresponding target color of the text; adjusting the border color of the first column region into the corresponding target color of the border of the first column region, wherein the target color of the outer border of the first column region is the target color of the outer border of the to-be-adjusted region; and adjusting the fill color of the first column region into the corresponding target fill color.
[0019] Optionally, the determining the to-be-adjusted region of the target table comprises: receiving a first selection operation acting on a region of the target table in the display interface; and determining the to-be-adjusted region in response to the first selection operation.
[0020] Optionally, in response to the selection operation on the plurality of identifiers on the display interface, the style information is determined by: receiving a second selection operation on a first region of the display interface, the first region including a plurality of the theme color identifiers; receiving a third selection operation on a second region of the display interface, the second region including a plurality of the table style identifiers; receiving a fourth selection operation on a third region of the display interface, the third region including a plurality of the alternating manner identifiers; and generating the style information in response to the second selection operation, the third selection operation and the fourth selection operation.
[0021] Optionally, the style of the region to be adjusted includes at least one of a three-line table style, a vertical alternating style and a horizontal alternating style.
[0022] Optionally, after the style information is determined, before the style of the region to be adjusted of the target table is adjusted to the preset style according to the predetermined region and the style information, the method further includes: receiving a predetermined operation on a preview identifier on the display interface; and in response to the predetermined operation, generating a preview table according to the style information and the predetermined region and displaying the preview table on the display interface.
[0023] According to another aspect of the embodiments of the present application, a table style processing apparatus is further provided, which includes: a first determining unit configured to determine a region to be adjusted of a target table; an identifying unit configured to identify a predetermined region in the region to be adjusted, the identified predetermined region including at least a table header region and a table body region; a second determining unit configured to determine, in response to selection operations on a plurality of identifiers on a display interface, style information, the style information being information of a preset style of the region to be adjusted, the plurality of identifiers including a theme color identifier, an alternating manner identifier and a table style identifier, the theme color identifier being an identifier representing a target fill color of the region to be adjusted, the alternating manner identifier being an identifier representing an alternating manner of fill colors, and the table style identifier being an identifier representing a style of the region to be adjusted; and an adjusting unit configured to adjust, according to at least the predetermined region and the style information, the style of the region to be adjusted of the target table to the preset style.
[0024] According to still another aspect of the embodiments of the present application, a computer readable storage medium is further provided, which includes a stored program, wherein the program performs any of the processing methods.
[0025] According to a further aspect of the embodiments of the present application, a processor is provided for running a program, wherein the program performs any of the processing methods when running.
[0026] In the embodiments of the present application, the region to be adjusted of the target table is determined first, then the predetermined region in the region to be adjusted is identified, the predetermined region obtained by the identification includes at least the header region and the body region, then the style information is determined in response to the selection operation on the multiple marks on the display interface, the style information is the information of the preset style of the region to be adjusted, finally the style in the region to be adjusted of the target table is adjusted to the preset style according to the predetermined region and the style information. In the above scheme, the styles of different predetermined regions of the table are adjusted to the preset style by identifying the predetermined region of the table and adjusting the region to be adjusted according to the identified predetermined region and the style information, that is, the different predetermined regions of the table are adjusted respectively and pertinently, so that the adjustment effect is better, and the problem that the table adjustment effect is poor due to the failure to identify the table region is solved. BRIEF DESCRIPTION OF DRAWINGS
[0027] The accompanying drawings, which form a part of the present application, are intended to provide further understanding of the present application, and are used to interpret the present application together with its description. In the drawings:
[0028] Figure 1 A schematic diagram of adjusting the style of a preset table after converting a table in the prior art is shown;
[0029] Figure 2 A flowchart of a table style processing method according to an embodiment of the present application is shown;
[0030] Figure 3 A schematic diagram of traversing the predetermined region in a merged action unit and alternately filling the target fill color is shown;
[0031] Figure 4 A schematic diagram of traversing the predetermined region in a single row unit and alternately filling the target fill color is shown;
[0032] Figure 5 A schematic diagram of sequentially setting the border color is shown;
[0033] Figure 6 A schematic diagram of the border color of the first column being the outer border target color is shown;
[0034] Figure 7 A schematic diagram of a title region is shown;
[0035] Figure 8A schematic view showing the table header region after being reset is shown;
[0036] Figure 9 A schematic view showing the first column region is shown;
[0037] Figure 10 A schematic view showing the display interface is shown;
[0038] Figure 11 A schematic view showing the three-line table style is shown;
[0039] Figure 12 A schematic view showing the vertical alternating style is shown;
[0040] Figure 13 A schematic view showing the horizontal alternating style is shown;
[0041] Figure 14 A schematic view showing the generated preview table and displayed on the display interface is shown;
[0042] Figure 15 A style sheet showing the theme color information is shown;
[0043] Figure 16 A table style schematic view showing the target fill color, alternating style and predetermined region is shown;
[0044] Figure 17 A table style schematic view showing another target fill color, alternating style and predetermined region is shown;
[0045] Figure 18 A structural schematic view of a table style processing apparatus according to an embodiment of the present application is shown.
[0046] Wherein, the above figures include the following reference signs:
[0047] 101, table header region; 102, table body region; 103, title region; 104, supplementary information region; 105, first column region; 106, theme color identifier; 107, table style identifier; 108, alternating manner identifier; 109, preview table. DETAILED DESCRIPTION
[0048] It should be noted that the embodiments in the present application and the features in the embodiments can be combined with each other without conflict. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.
[0049] In the following, the technical solutions in the embodiments of the present application will be described clearly and completely in conjunction with the drawings in the embodiments of the present application, so that those skilled in the art can better understand the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work should be within the scope of protection of the present application.
[0050] It should be noted that the terms "first", "second", and the like in the description of the specification and claims of the present application and the above-described drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or a chronological sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device including a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to the process, method, product or device.
[0051] It should be understood that when an element (such as a layer, film, region, or substrate) is described as "on" another element, it can be directly on the other element, or there can be an intermediate element. Also, in the specification and claims, when an element is described as "connected" to another element, it can be "directly connected" to the other element, or "connected" to the other element through a third element.
[0052] As mentioned in the background, due to the inability to identify the table area in the prior art, the adjustment effect of the table is poor. In order to solve the above problems, in a typical embodiment of the present application, a table style processing method, processing device, computer readable storage medium and processor are provided.
[0053] According to the embodiments of the present application, a table style processing method is provided. Figure 2 is a flowchart of the table style processing method according to the embodiments of the present application. As shown in Figure 2 , the method comprises the following steps:
[0054] Step S101, determining the to-be-adjusted area of the target table;
[0055] Step S102, identifying a predetermined area in the to-be-adjusted area, and the identified predetermined area at least includes a table header area and a table body area;
[0056] In step S103, in response to selection operations respectively performed on a plurality of identifiers on the display interface, style information is determined, the style information being information of a preset style of the to-be-adjusted region, the plurality of identifiers including a theme color identifier, an alternating manner identifier, and a table style identifier, the theme color identifier being an identifier representing a target fill color of the to-be-adjusted region, the alternating manner identifier being an identifier representing an alternating manner of fill colors, and the table style identifier being an identifier representing a style of the to-be-adjusted region.
[0057] In step S104, at least according to the predetermined region and the style information, the style in the to-be-adjusted region of the target table is adjusted to the preset style.
[0058] In the method, first, the to-be-adjusted region of the target table is determined, then, a predetermined region in the to-be-adjusted region is identified, the identified predetermined region at least including a header region and a body region, then, in response to selection operations respectively performed on a plurality of identifiers on the display interface, style information is determined, the style information being information of a preset style of the to-be-adjusted region, and finally, at least according to the predetermined region and the style information, the style in the to-be-adjusted region of the target table is adjusted to the preset style. In the scheme, by identifying a predetermined region of a table and then adjusting a to-be-adjusted region according to the identified predetermined region and style information, different styles of different predetermined regions of the table can be adjusted to preset styles, that is, different predetermined regions of the table are adjusted respectively and specifically, so that the adjustment effect is better, thereby solving the problem that the table adjustment effect is poor due to failure to identify table regions.
[0059] It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described herein can be executed in an order different from that shown.
[0060] It should be noted that in the prior art, table style adjustment is performed by manually selecting a table style, and the table style is a fixed template. However, in the scheme, the table style is adjusted according to actual conditions, rather than by using a fixed template. There are multiple styles of table styles, and a color can be selected after a style is selected. The table style itself is a category, and the table style in the scheme has multiple different categories.
[0061] In an embodiment of the present application, the style information includes theme color information and alternating style information, and adjusting the style in the to-be-adjusted region of the target table to the preset style according to the predetermined region and the style information includes: determining a target fill color of the to-be-adjusted region according to the theme color information; determining an alternating style of the to-be-adjusted region according to the alternating style information, the alternating style being an alternating mode of fill color; and adjusting the fill color of the header region and the body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating style. In this embodiment, the color matching scheme of the to-be-adjusted region can be determined, the theme color of the to-be-adjusted region can be determined, and the target fill color of the to-be-adjusted region can be determined, the color matching scheme is unified, color errors are avoided, there can be a scheme of "no horizontal header" in the style, therefore, in order to make the same adjustment, configuration errors are avoided, the header region and the body region are adjusted as a whole, the fill color of the header region and the body region can be more accurately determined in this embodiment, and the effect of the adjustment is further ensured to be good.
[0062] It should be noted that the alternating style information can be information of an alternating mode of the preset fill color of the to-be-adjusted region of the table, and when the predetermined region of the table includes at least the header region and the body region, the alternating style information is information of an alternating mode of the preset fill color of the header region and the body region.
[0063] In another embodiment of the present application, the target fill color of the to-be-adjusted region has multiple target fill colors, and adjusting the fill color of the header region and the body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating style includes: when the alternating style is a row alternating style, determining a horizontal alternating granularity; when the horizontal alternating granularity is a merged row, traversing the header region and the body region by the unit of the merged row, and alternatingly filling the multiple target fill colors, the cell of the merged row being a cell formed by merging multiple minimum cells in the column direction; and when the horizontal alternating granularity is not the merged row, traversing the header region and the body region by the unit of a single row, and alternatingly filling the multiple target fill colors, the cell of the single row being the minimum cell. In this embodiment, the target fill color can be alternately filled in the manner of a single row or a merged row, and the adjustment effect of the predetermined region is further ensured to be good.
[0064] Specifically, as shown in Figure 3 and Figure 4 , Figure 3As shown in FIG. 1, the adjustment effect of alternately filling the plurality of target fill colors is shown by traversing the table header region 101 and the table body region 102 in the above-mentioned unit of merged cells. Figure 4 As shown in FIG. 1, the adjustment effect of alternately filling the plurality of target fill colors is shown by traversing the table header region 101 and the table body region 102 in the above-mentioned unit of merged cells. Figure 4 As shown in FIG. 1, the adjustment effect of alternately filling the plurality of target fill colors is shown by traversing the table header region 101 and the table body region 102 in the above-mentioned unit of merged cells.
[0065] In another embodiment of the present application, the target fill color of the to-be-adjusted region has a plurality of target fill colors, and the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, comprising: in the case that the alternating pattern is a column-alternating pattern, determining a column-alternating granularity; in the case that the column-alternating granularity is a merged column, traversing the table header region and the table body region in the above-mentioned unit of merged columns, and alternately filling the plurality of target fill colors, the cells of the merged column being a plurality of minimum cells merged in the row direction; in the case that the column-alternating granularity is not the merged column, traversing the table header region and the table body region in the unit of single column, and alternately filling the plurality of target fill colors, the cells of the single column being the minimum cells. In this embodiment, the target fill color can be alternately filled in the unit of single column or merged column, further ensuring that the adjustment effect of the predetermined region is good.
[0066] In particular, in one embodiment, the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, and further comprising: in the case that the alternating pattern is a non-alternating pattern, determining that the table header region and the table body region are not filled with the fill color.
[0067] In another embodiment of the present application, after the fill colors of the table header region and the table body region of the to-be-adjusted region of the target table are adjusted according to the target fill color of the to-be-adjusted region and the alternating pattern, the style in the to-be-adjusted region of the target table is adjusted to the preset style according to the predetermined region and the style information, and further comprising: determining the target color of the text in each predetermined region, the outer border target color and the inner border target color of the to-be-adjusted region according to the theme color information; adjusting the color of the text in each predetermined region to the corresponding target color of the text; and adjusting the outer border color and the inner border color of the to-be-adjusted region to the outer border target color and the inner border target color of the to-be-adjusted region. In this embodiment, the color of the text, the outer border color and the inner border color can be adjusted, further ensuring that the adjustment effect of the table is good.
[0068] In a specific embodiment of the present application, the outer border color and the inner border color of the to-be-adjusted region are adjusted to the outer border target color and the inner border target color of the to-be-adjusted region, including: setting two border colors of each row in turn according to a first predetermined direction, and in the setting process, the color of the first border of a later set row replaces the color of the second border of a previously set row, wherein the color of the first border of each row is the inner border target color, and the color of the second border of each row is the outer border target color, and the direction from the first border to the second border of a row is the first predetermined direction; and / or setting two border colors of each column in turn according to a second predetermined direction, and in the setting process, the color of the first border of a later set column replaces the color of the second border of a previously set column, wherein the direction from the first border to the second border of a column is the second predetermined direction. In this embodiment, the outer border color and the inner border color can be further adapted, and when the alternating pattern is set, the border color of the next row or column will cover the border color of the previous row or column, so that the color of the first border in the first predetermined direction and / or the second predetermined direction of the to-be-adjusted region is the inner border target color, and the color of the second border of the last set row or column is the outer border target color, further ensuring that the adjustment effect of the table is good.
[0069] Specifically, in the process of setting the border color according to the first predetermined direction, the color of the first border of a certain row is first set to the inner border target color, and the color of the second border is set to the outer border target color, and then the border color of the next row is set, the color of the first border of the next row is set to the inner border target color, and the color of the first border of the next row replaces the color of the second border set before the previous row, that is, the color of the second border of the last row is the outer border target color, and the color of the first border and the color of the second border of other rows are the inner border target color, as shown in Figure 5 The color of the first border is the inner border target color, and the color of the second border is the outer border target color.
[0070] In order to set the color of the outer border of the table to the outer border target color, in an embodiment of the present application, after setting two border colors of each row in turn according to the first predetermined direction, and / or setting two border colors of each column in turn according to the second predetermined direction, the outer border color and the inner border color of the to-be-adjusted region are adjusted to the outer border target color and the inner border target color of the to-be-adjusted region, and further including: adjusting the color of the target border to the outer border target color, wherein the target border is the outer border of the to-be-adjusted region whose color is not the outer border target color.
[0071] Specifically, as shown in Figure 6As shown, the color of the first border of the first column in the figure is adjusted to the outer border target color.
[0072] In another embodiment of the present application, before adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating pattern, at least according to the predetermined region and the pattern information, the pattern in the to-be-adjusted region of the target table is adjusted to the preset pattern, including: in the case that the identified predetermined region includes a title region and a supplementary information region, according to the theme color information, determining the target color of the text in the title region, the target color of the text in the supplementary information region, the target fill color of the title region, the border target color of the title region, the target fill color of the supplementary information region, and the border target color of the supplementary information region; adjusting the color of the text in the title region and the color of the text in the supplementary information region to the target color of the corresponding text, respectively; adjusting the border color of the title region and the border color of the supplementary information region to the corresponding border target color, respectively; adjusting the fill color of the title region and the fill color of the supplementary information region to the corresponding target fill color, respectively. In this embodiment, the pattern of the title region and the supplementary information region is set before the pattern of the table header region and the table body region is set, so that when there is no supplementary information region, the lower border line of the title region will not cover the upper border line of the table body region. This embodiment can set the pattern of the title region and the supplementary information region of the table, so as to further ensure that different predetermined regions of the table can be adjusted respectively, further ensure that the adjustment effect of the table is good, and further solve the problem that the adjustment effect of the table is poor due to the failure to identify the table region.
[0073] Specifically, the title region 103 is set to highlight the title of the table, so as to meet the user's demand for emphasizing the title, such as Figure 7 As shown, the part framed in the figure is the title region 103.
[0074] In yet another embodiment of the present application, after adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating pattern, and according to the predetermined region and the pattern information, the pattern of the to-be-adjusted region of the target table is adjusted to the preset pattern, including: determining the target color of the text in the table header region, the target fill color of the table header region, and the target color of the border of the table header region according to the theme color information; adjusting the color of the text in the table header region to the target color of the corresponding text; adjusting the border color of the table header region to the target color of the corresponding border; and adjusting the fill color of the table header region to the target fill color of the corresponding table header region. In this embodiment, the previously set fill color makes the color of the alternating row and the table header region close, and the table header region and the table body region are not easy to distinguish, so the pattern of the table header region is reset, and the reset pattern of the table header region covers the previously set alternating pattern, which further ensures that different predetermined regions of the table can be adjusted respectively, further improves the adjustment effect, and further solves the problem of poor adjustment effect of the table due to the inability to identify the table region.
[0075] Specifically, as shown in FIG. 10, Figure 8 Figure 8 An effect diagram after resetting the table header region 101 is shown, and the pattern of the lower border line of the table header region 101 can be the pattern of the dividable region. Specifically, the lower border color can be adjusted to the target color of the corresponding border, which is to separate the table header region 101 and the table body region 102, and to distinguish the table header region 101 and the table body region 102 more easily, thereby avoiding the adverse effect that the content of the table header region 101 and the table body region 102 are connected together and are difficult to distinguish.
[0076] In another embodiment of this application, after adjusting the fill colors of the header area and body area of the target table according to the target fill color and the alternating style of the area to be adjusted, the style of the target table in the area to be adjusted is adjusted to the preset style, at least according to the predetermined area and the style information. This includes: determining whether to ignore the header settings; if it is determined that the header settings are not ignored, determining the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area according to the theme color information; adjusting the color of the text in the header area to the corresponding target color of the text; adjusting the border color of the header area to the corresponding target border color; and adjusting the fill color of the header area to the corresponding target fill color. In this embodiment, if it is determined that the header settings are ignored, it is not necessary to reset the style of the header area; only if it is determined that the header settings are not ignored is it necessary to reset the style of the header area. This embodiment can set the style of the header area more efficiently.
[0077] In one specific embodiment of this application, after adjusting the fill color of the header area to the corresponding target fill color, the style of the area to be adjusted in the target table is adjusted to the preset style, at least according to the predetermined area and the style information. This includes: when the predetermined area includes the first column area, determining the target color of the text in the first column area, the target fill color of the first column area, and the target border color of the first column area according to the theme color information; adjusting the color of the text in the first column area to the corresponding target color of the text; adjusting the border color of the first column area to the corresponding target border color of the first column area, wherein the target border color of the outer border of the first column area is the target border color of the area to be adjusted; and adjusting the fill color of the first column area to the corresponding target fill color. In this embodiment, the first column area 105 is the first column of the header area and the body area, such as... Figure 9 As shown in the figure, the area outlined in the box is the first column area 105. Setting the style of the first column area 105 will override the styles of the previously set header and body areas. This ensures that the border color of the first column area 105 is the target color of the outer border of the area to be adjusted. This further ensures that different predetermined areas of the table can be adjusted separately, resulting in better adjustment effects. This further solves the problem of poor table adjustment effects due to the inability to recognize table areas.
[0078] The predetermined areas of the table are distributed according to a predetermined direction, and the upper border line of a next area affects the lower border line of a previous area, so the setting needs to be performed according to the title area and the supplementary information area, the table header area and the table body area, and the table header area and the first column area, the color of each area is uniformly filled according to different areas to avoid color errors caused by separate color filling, the style of a predetermined area set later covers the style of a predetermined area set earlier, so the border of each area is set in sequence, and the border style of the current area covers or avoids the border style of the previously set area when the border style of the current area is set.
[0079] In another embodiment of the present application, the area to be adjusted of the target table is determined by receiving a first selection operation on the target table of the display interface, and determining the area to be adjusted in response to the first selection operation. In this embodiment, the selected area can be more accurately determined as the area to be adjusted.
[0080] In another embodiment of the present application, the style information is determined in response to a selection operation on a plurality of identifiers on the display interface, including receiving a second selection operation on a first area of the display interface, the first area including a plurality of theme color identifiers, receiving a third selection operation on a second area of the display interface, the second area including a plurality of table style identifiers, receiving a fourth selection operation on a third area of the display interface, the third area including a plurality of alternating mode identifiers, and generating the style information in response to the second selection operation, the third selection operation and the fourth selection operation. In this embodiment, the style information can be more accurately generated according to the second selection operation, the third selection operation and the fourth selection operation.
[0081] Specifically, as shown in FIG. 6, the style information is determined in response to a selection operation on a plurality of identifiers on the display interface, including receiving a second selection operation on a first area of the display interface, the first area including a plurality of theme color identifiers, receiving a third selection operation on a second area of the display interface, the second area including a plurality of table style identifiers, receiving a fourth selection operation on a third area of the display interface, the third area including a plurality of alternating mode identifiers, and generating the style information in response to the second selection operation, the third selection operation and the fourth selection operation. In this embodiment, the style information can be more accurately generated according to the second selection operation, the third selection operation and the fourth selection operation. Figure 10 Figure 10 The area in the figure showing the "theme color" is the first area, and the plurality of square solid frames in the figure are theme color identifiers 106. The theme color identifiers 106 are a plurality of identifiers corresponding to different theme colors. The area in the figure showing the "table style" is the second area, and the plurality of rectangular frames under the "table style" in the figure are table style identifiers 107. The table style identifiers 107 are a plurality of identifiers corresponding to different table styles. The table style corresponding to the table style identifier 107 with "none" written in the figure is the first table style. The table style corresponding to the table style identifier 107 to the right of the table style identifier 107 with "none" written in the figure is the second table style. The table style corresponding to the table style identifier 107 below the table style identifier 107 with "none" written in the figure is the third table style. The table style corresponding to the other table style identifier 107 is the fourth table style. The area in the figure showing the "alternating mode" is the third area, and the three alternating mode identifiers 108 in the figure are "none", "row alternation", and "column alternation", respectively.
[0082] In another embodiment of the present application, the style of the to-be-adjusted area includes at least one of the following: a three-line table style, a vertical alternating style, and a horizontal alternating style.
[0083] As shown in the figure, Figure 11 a schematic diagram of the three-line table style is shown, Figure 12 a schematic diagram of the vertical alternating style is shown, Figure 13 a schematic diagram of the horizontal alternating style is shown.
[0084] In a specific embodiment of the present application, after determining the style information, before adjusting the style in the to-be-adjusted area of the target table to the preset style according to the predetermined area and the style information, the method further includes: receiving a predetermined operation on a preview identifier on the display interface; and in response to the predetermined operation, generating a preview table according to the style information and the predetermined area and displaying the preview table on the display interface. In this embodiment, the table style can be previewed and displayed before the table style is adjusted, so that the user can preview the style in the to-be-adjusted area.
[0085] As shown in the figure, Figure 14 a preview effect is shown in the figure. The part of the table displayed in the middle of the figure is the preview table 109.
[0086] In this scheme, the theme color is designed in advance. The style table of the specific theme color information is as shown in Figure 15 , Figure 15 a plurality of theme color information is shown. The letters are color application codes of the style table. In the case where the predetermined area includes the title area 103, the supplementary information area 104, the table header area 101, and the table body area 102, as Figure 16As shown in the figure, the figure shows the theme color information, the alternate style information and the table adjusted according to the above two information, in the case of including the title area 103, the supplementary information area 104, the first column area and the table body area 102 in the predetermined area, as Figure 17 As shown in the figure, the figure shows the theme color information, the alternate style information and the table adjusted according to the above two information, Figure 16 In the above, "none" means that the wireframe has no color, Figure 16 and 17 In the above, "as is" means that the style of the last step is retained, that is, the style of the predetermined area set last time is retained, for example, Figure 16 In the above, there is no first column area, and the "as is" of the first column area is the style of the table header area 101 and the table body area 102 set last time, and the style of the table header area 101 and the table body area 102 is retained unchanged, Figure 17 In the above, there is no table header area 101, and the "as is" of the table header area 101 is the style of the supplementary information area 104 set last time, and the style of the supplementary information area 104 is retained unchanged, and "row alternate-odd" and "row alternate-even" in the figure represent the style of each single row from top to bottom, and "column alternate-odd" and "column alternate-even" in the figure represent the style of each single column from left to right, and the letter is the application code of the preset color, which is obtained by using Figure 15 the theme color information in the above.
[0087] The process of user interaction in the present scheme is as follows: first, the user selects the unit, then starts the function, the user selects the range to be adjusted, determines the to-be-adjusted area of the target table, the user selects the theme color, the user selects the preset table style, the user selects the alternate way, determines the style information according to the user's selection, generates a preview table and displays it on the display interface, and the user selects to confirm the application, that is, the style of the table is adjusted.
[0088] The present application also provides a table style processing device, and it should be noted that the table style processing device of the present application can be used to execute the table style processing method provided by the present application. The table style processing device provided by the present application is introduced as follows.
[0089] Figure 18 is a schematic diagram of the table style processing device according to the present application. As Figure 18 shown, the device comprises:
[0090] The first determination unit 10 is configured to determine the to-be-adjusted area of the target table.
[0091] The recognition unit 20 is configured to recognize the predetermined area in the to-be-adjusted area, and the recognized predetermined area at least includes the table header area and the table body area.
[0092] The second determining unit 30 is configured to determine style information in response to selection operations respectively performed on a plurality of identifiers on the display interface, the style information being information of a preset style of the to-be-adjusted region, the plurality of identifiers including a theme color identifier, an alternating manner identifier, and a table style identifier, the theme color identifier being an identifier representing a target fill color of the to-be-adjusted region, the alternating manner identifier being an identifier representing an alternating manner of fill colors, and the table style identifier being an identifier representing a style of the to-be-adjusted region.
[0093] The adjusting unit 40 is configured to adjust the style in the to-be-adjusted region of the target table to the preset style according to at least the predetermined region and the style information.
[0094] In the device, the first determining unit determines the to-be-adjusted region of the target table, the recognizing unit recognizes the predetermined region in the to-be-adjusted region, the recognized predetermined region includes at least a header region and a body region, the second determining unit determines style information in response to selection operations respectively performed on a plurality of identifiers on the display interface, the style information being information of a preset style of the to-be-adjusted region, and the adjusting unit adjusts the style in the to-be-adjusted region of the target table to the preset style according to at least the predetermined region and the style information. In the scheme, the styles of different predetermined regions of a table are adjusted to preset styles by recognizing the predetermined regions of the table and adjusting the to-be-adjusted region according to the recognized predetermined regions and style information, so that the different predetermined regions of the table are adjusted respectively and specifically, the adjustment effect is better, and the problem that the table cannot be adjusted well due to failure to recognize the table region is solved.
[0095] It should be noted that the prior art adjusts the table style by manually selecting a table style, and the table style is a fixed template. However, the scheme adjusts the table style according to actual conditions, rather than using a fixed template, the table style has a plurality of styles, and a color can be selected after a style is selected. The table style itself is a category, and the table style in the scheme has a plurality of different categories.
[0096] In an embodiment of the present application, the style information includes theme color information and alternating style information, the adjusting unit includes a first determining module, a second determining module and a first adjusting module, the first determining module is configured to determine a target fill color of the to-be-adjusted region according to the theme color information; the second determining module is configured to determine an alternating style of the to-be-adjusted region according to the alternating style information, the alternating style being an alternating manner of fill color; and the first adjusting module is configured to adjust fill colors of the header region and the body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating style. In this embodiment, the color matching scheme of the to-be-adjusted region can be determined, the theme color of the to-be-adjusted region can be determined, and the target fill color of the to-be-adjusted region can be determined, thereby unifying the color matching scheme, avoiding color errors, and avoiding configuration errors in the style. In the style, there can be a scheme of "no horizontal header", and therefore, in order to make the same adjustment, the header region and the body region are first adjusted as a whole, the fill colors of the header region and the body region can be more accurately determined in this embodiment, and the different predetermined regions can be further adjusted respectively and pertinently, thereby further ensuring that the adjustment effect is good.
[0097] It should be noted that the alternating style information can be information of an alternating manner of a preset fill color of the to-be-adjusted region of the table, and when the predetermined region of the table includes at least the header region and the body region, the alternating style information is information of an alternating manner of a preset fill color of the header region and the body region.
[0098] In another embodiment of the present application, the target fill color of the to-be-adjusted region has multiple target fill colors, the first adjusting module includes a first determining submodule, a first adjusting submodule and a second adjusting submodule, the first determining submodule is configured to determine a horizontal alternating granularity when the alternating style is a row alternating style; the first adjusting submodule is configured to traverse the header region and the body region by a unit of the merged row when the horizontal alternating granularity is the merged row, and alternately fill the multiple target fill colors, the cell of the merged row being a cell formed by merging multiple minimum cells in the column direction; and the second adjusting submodule is configured to traverse the header region and the body region by a unit of a single row when the horizontal alternating granularity is not the merged row, and alternately fill the multiple target fill colors, the cell of the single row being the minimum cell. In this embodiment, the target fill color can be alternately filled in the manner of a single row or a merged row, thereby further ensuring that the adjustment effect of the predetermined region is good.
[0099] Specifically, as shown in Figure 3 and Figure 4 , the target fill color of the to-be-adjusted region is alternately filled in the manner of a single row or a merged row, thereby further ensuring that the adjustment effect of the predetermined region is good. Figure 3The adjustment effect of alternately filling the plurality of target fill colors is shown in the above table header region 101 and the above table body region 102 in the above unit of merged behavior. Figure 4 As shown in the above table header region 101 and the above table body region 102 in the above unit of merged behavior. Figure 4 The adjustment effect of alternately filling the plurality of target fill colors is shown in the above table header region 101 and the above table body region 102 in the above unit of merged behavior.
[0100] In another embodiment of the present application, the target fill color of the to-be-adjusted region has a plurality of target fill colors, and the first adjustment module includes a second determination submodule, a third adjustment submodule, and a fourth adjustment submodule. The second determination submodule is configured to determine a column alternation granularity when the alternation pattern is a column alternation pattern. The third adjustment submodule is configured to traverse the table header region and the table body region in the above unit of merged columns when the column alternation granularity is a merged column, and alternately fill the plurality of target fill colors. The cells of the merged column are a plurality of minimum cells merged in the row direction. The fourth adjustment submodule is configured to traverse the table header region and the table body region in the unit of a single column when the column alternation granularity is not the merged column, and alternately fill the plurality of target fill colors. The cells of the single column are the minimum cells. In this embodiment, the target fill color can be alternately filled in the unit of a single column or a merged column, further ensuring that the adjustment effect of the predetermined region is good.
[0101] In a specific embodiment, the first adjustment module is further configured to determine not to fill the fill color of the table header region and the table body region when the alternation pattern is a no-alternation pattern.
[0102] In another embodiment of the present application, the adjustment unit includes a third determination module, a second adjustment module, and a third adjustment module. The third determination module is configured to determine the target color of the text in each predetermined region, the outer border target color, and the inner border target color of the to-be-adjusted region according to the theme color information after adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternation pattern. The second adjustment module is configured to adjust the color of the text in each predetermined region to the corresponding target color of the text. The third adjustment module is configured to adjust the outer border color and the inner border color of the to-be-adjusted region to the outer border target color and the inner border target color of the to-be-adjusted region. In this embodiment, the color of the text, the outer border color, and the inner border color can be adjusted, further ensuring that the adjustment effect of the table is good.
[0103] In a specific embodiment of the present application, the third adjustment module comprises a fifth adjustment submodule and a sixth adjustment submodule. The fifth adjustment submodule is configured to set the two border colors of each row in the first predetermined direction in sequence, and in the setting process, the color of the first border of a later-set row replaces the color of the second border of an earlier-set row, wherein the color of the first border of each row is the inner border target color, and the color of the second border of each row is the outer border target color, and the direction from the first border to the second border of each row is the first predetermined direction; and / or the sixth adjustment submodule is configured to set the two border colors of each column in the second predetermined direction in sequence, and in the setting process, the color of the first border of a later-set column replaces the color of the second border of an earlier-set column, wherein the direction from the first border to the second border of each column is the second predetermined direction. In this embodiment, the outer border color and the inner border color can be further adapted, and in the setting of the alternating style, the border color of the next row or column covers the border color of the previous row or column, so that the color of the first border in the first predetermined direction and / or the second predetermined direction of the to-be-adjusted region is the inner border target color, and the color of the second border of the last-set row or column is the outer border target color, thereby further ensuring that the adjustment effect of the table is good.
[0104] Specifically, in the process of setting the border color in the first predetermined direction, the color of the first border of a certain row is first set to the inner border target color, and the color of the second border is set to the outer border target color, and then the border color of the next row is set, the color of the first border of the next row is set to the inner border target color, and the color of the first border of the next row replaces the color of the second border set before the previous row, that is, the color of the second border of the last row is the outer border target color, and the colors of the first border and the second border of other rows are the inner border target color, as shown in FIG. 8. Figure 5
[0105] In order to set the color of the outer border of the table to the outer border target color, in an embodiment of the present application, the third adjustment module comprises a seventh adjustment submodule, which is configured to, after setting the two border colors of each row in the first predetermined direction in sequence and / or setting the two border colors of each column in the second predetermined direction in sequence, adjust the color of the target border to the outer border target color, wherein the target border is the outer border of the to-be-adjusted region whose color is not the outer border target color.
[0106] Specifically, as shown in FIG. 9, the color of the first border of the first column is adjusted to the outer border target color. Figure 6
[0107] In still another embodiment of the present application, the adjusting unit comprises a fourth determining module, a fourth adjusting module, a fifth adjusting module and a sixth adjusting module. The fourth determining module is configured to, before adjusting the fill color of the table header region and the table body region of the to-be-adjusted region of the target table according to the target fill color of the to-be-adjusted region and the alternating pattern, determine, in the case that the identified predetermined region comprises a title region and a supplementary information region, the target color of the text in the title region, the target color of the text in the supplementary information region, the target fill color of the title region, the target border color of the title region, the target fill color of the supplementary information region and the target border color of the supplementary information region according to the theme color information. The fourth adjusting module is configured to adjust the color of the text in the title region and the color of the text in the supplementary information region to the target color of the corresponding text respectively. The fifth adjusting module is configured to adjust the border color of the title region and the border color of the supplementary information region to the target border color of the corresponding border respectively. The sixth adjusting module is configured to adjust the fill color of the title region and the fill color of the supplementary information region to the target fill color of the corresponding region respectively. In this embodiment, the pattern of the title region and the supplementary information region is set before the pattern of the table header region and the table body region is set. Thus, when there is no supplementary information region, the lower border line of the title region will not cover the upper border line of the table body region. This embodiment can set the pattern of the title region and the supplementary information region of the table, thus further ensuring that different predetermined regions of the table can be adjusted respectively, further ensuring that the adjustment effect of the table is good, and further solving the problem that the adjustment effect of the table is poor due to the failure to identify the table region.
[0108] Specifically, the title region 103 is configured to highlight the title of the table, thus satisfying the requirement of the user to emphasize the title, such as Figure 7 As shown in the figure, the boxed part is the title region 103.
[0109] In another embodiment of this application, the adjustment unit includes a fifth determining module, a seventh adjusting module, an eighth adjusting module, and a ninth adjusting module. The fifth determining module is used to adjust the fill color of the header area and the body area of the target table according to the target fill color and the alternation style of the area to be adjusted, and then determine the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area according to the theme color information. The seventh adjusting module is used to adjust the color of the text in the header area to the corresponding target color of the text. The eighth adjusting module is used to adjust the border color of the header area to the corresponding target border color. The ninth adjusting module is used to adjust the fill color of the header area to the corresponding target fill color. In this embodiment, since the previously set fill color makes the colors of the alternating rows and the header area too similar, the header area and the body area are not easily distinguishable. Therefore, the style of the header area is reset. This reset style of the header area will cover the previously set alternating style, which further ensures that different predetermined areas of the table can be adjusted separately, further improving the adjustment effect and further solving the problem of poor table adjustment effect due to the inability to recognize table areas.
[0110] Specifically, such as Figure 8 As shown, Figure 8 The image shows the effect after resetting the header area 101. The style of the bottom border of the header area 101 can be a divisible style. Specifically, the bottom border color can be adjusted to the corresponding border target color. This is to separate the header area 101 and the body area 102, making it easier to distinguish between them and avoiding the disadvantage of the contents of the header area 101 and the body area 102 being connected and difficult to distinguish.
[0111] In another embodiment of the present application, the adjusting unit comprises a sixth determining module, a seventh determining module, a tenth adjusting module, an eleventh adjusting module and a twelfth adjusting module. The sixth determining module is configured to determine whether to ignore the header setting after adjusting the fill color of the header region and the body region in the to-be-adjusted region according to the target fill color of the to-be-adjusted region and the alternating pattern. The seventh determining module is configured to determine the target color of the text in the header region, the target fill color of the header region and the target color of the border of the header region according to the theme color information in the case of determining not to ignore the header setting. The tenth adjusting module is configured to adjust the color of the text in the header region to the target color of the corresponding text. The eleventh adjusting module is configured to adjust the border color of the header region to the target color of the corresponding border. The twelfth adjusting module is configured to adjust the fill color of the header region to the target fill color. In this embodiment, the case of determining to ignore the header setting does not need to reset the pattern of the header region, and the case of determining not to ignore the header setting needs to reset the pattern of the header region. This embodiment can more efficiently set the pattern of the header region.
[0112] In a specific embodiment of the present application, the adjusting unit comprises an eighth determining module, a thirteenth adjusting module, a fourteenth adjusting module and a fifteenth adjusting module. The eighth determining module is configured to determine the target color of the text in the first column region, the target fill color of the first column region and the target color of the border of the first column region according to the theme color information in the case of identifying that the predetermined region comprises the first column region after adjusting the fill color of the header region to the target fill color. The thirteenth adjusting module is configured to adjust the color of the text in the first column region to the target color of the corresponding text. The fourteenth adjusting module is configured to adjust the border color of the first column region to the target color of the corresponding border of the first column region, wherein the target color of the outer border of the first column region is the target color of the outer border of the to-be-adjusted region. The fifteenth adjusting module is configured to adjust the fill color of the first column region to the target fill color. In this embodiment, the first column region 105 is the first column of the header region and the body region, as shown in the part framed in the figure. The pattern of the first column region 105 covers the previously set pattern of the header region and the body region, so that the border color of the first column region 105 is the target color of the outer border of the to-be-adjusted region, which further ensures that different predetermined regions of the table can be adjusted respectively, further improves the adjustment effect, and further solves the problem of poor adjustment effect of the table due to the failure to identify the table region. Figure 9
[0113] The predetermined areas of the table are distributed according to a predetermined direction, and the upper border line of a next area affects the lower border line of a previous area, so the setting needs to be performed according to the title area and the supplementary information area, the table header area and the table body area, and the table header area and the first column area, the color is uniformly filled according to different areas to avoid color errors caused by separate color filling, the style of a predetermined area set later covers the style of a predetermined area set earlier, so the border of each area is set in sequence, the border style of a previously set area is considered when the border style of a current area is set, and the border style of the previously set area is covered or avoided.
[0114] In another embodiment of the present application, the first determining unit includes a first receiving module and a ninth determining module, the first receiving module is configured to receive a first selection operation on a region of the target table of the display interface, and the ninth determining module is configured to determine the region to be adjusted in response to the first selection operation. In this embodiment, the selected region can be more accurately determined as the region to be adjusted.
[0115] In another embodiment of the present application, the second determining unit includes a second receiving module, a third receiving module, a fourth receiving module and a generating module, the second receiving module is configured to receive a second selection operation on a first region of the display interface, the first region includes a plurality of theme color identifiers, the third receiving module is configured to receive a third selection operation on a second region of the display interface, the second region includes a plurality of table style identifiers, the fourth receiving module is configured to receive a fourth selection operation on a third region of the display interface, the third region includes a plurality of alternating mode identifiers, and the generating module is configured to generate the style information in response to the second selection operation, the third selection operation and the fourth selection operation. In this embodiment, the style information can be more accurately generated according to the second selection operation, the third selection operation and the fourth selection operation.
[0116] Specifically, as shown in FIG. 6, the first receiving module 601 is configured to receive a first selection operation on a region of the target table of the display interface, and the ninth determining module 602 is configured to determine the region to be adjusted in response to the first selection operation. Figure 10 Figure 10 The area in the figure showing the "theme color" is the first area, the plurality of square solid frames in the figure are theme color identifiers 106, the theme color identifiers 106 are a plurality of identifiers corresponding to different theme colors, the area in the figure showing the "table style" is the second area, the plurality of rectangular frames under the "table style" in the figure are table style identifiers 107, the table style identifiers 107 are a plurality of identifiers corresponding to different table styles, the table style corresponding to the table style identifier 107 with "none" written in the figure is the first table style, the table style corresponding to the table style identifier 107 to the right of the table style identifier 107 with "none" written in the figure is the second table style, the table style corresponding to the table style identifier 107 below the table style identifier 107 with "none" written in the figure is the third table style, and the table style corresponding to the other table style identifier 107 is the fourth table style. The area in the figure showing the "alternating mode" is the third area, and the three alternating mode identifiers 108 are shown in the figure, which are "none", "row alternation", and "column alternation".
[0117] In another embodiment of the present application, the style of the to-be-adjusted area includes at least one of the following: a three-line table style, a vertical alternating style, and a horizontal alternating style.
[0118] As shown in the figure, Figure 11 a schematic diagram of the three-line table style is shown, Figure 12 a schematic diagram of the vertical alternating style is shown, Figure 13 a schematic diagram of the horizontal alternating style is shown.
[0119] In a specific embodiment of the present application, the device further includes a receiving unit and a display unit. The receiving unit is configured to, after determining the style information, receive a predetermined operation on a preview identifier on the display interface before adjusting the style in the to-be-adjusted area of the target table to the preset style according to the predetermined area and the style information. The display unit is configured to, in response to the predetermined operation, generate a preview table according to the style information and the predetermined area and display the preview table on the display interface. In this embodiment, the table style can be previewed before being adjusted, so that the table style can be previewed and displayed before being adjusted, and the user can preview the style in the to-be-adjusted area.
[0120] As shown in the figure, Figure 14 The preview effect is shown in the figure, and the part in the middle of the figure showing the table is the displayed preview table 109.
[0121] In this scheme, the theme color is designed in advance, and the style table of specific theme color information is as shown in Figure 15 , Figure 15A plurality of theme color information is shown, and the letters are the color application codes of the style sheet. In the case where predetermined areas include a title area 103, a supplementary information area 104, a table header area 101, and a table body area 102, as shown in Figure 16 , the figure shows theme color information, alternating style information, and a table adjusted according to the above two information, in the case where predetermined areas include a title area 103, a supplementary information area 104, a first column area, and a table body area 102, as shown in Figure 17 , the figure shows theme color information, alternating style information, and a table adjusted according to the above two information, Figure 16 , “none” in the middle means that the wireframe has no color, Figure 16 , and 17 , “as is” in the middle means that the style of the last step is retained, i.e., the style of the predetermined area set last time is retained, for example, Figure 16 , there is no first column area in the middle, “as is” of the first column area is the style of the table header area 101 and the table body area 102 set last time, and the style of the table header area 101 and the table body area 102 is retained unchanged, Figure 17 , there is no table header area 101 in the middle, “as is” of the table header area 101 is the style of the supplementary information area 104 set last time, and the style of the supplementary information area 104 is retained unchanged, “row alternating-odd” and “row alternating-even” in the figure represent the style of each single row from top to bottom, “column alternating-odd” and “column alternating-even” in the figure represent the style of each single column from left to right, and the letters are the application codes of the preset colors, which are obtained by using the theme color information in Figure 15 .
[0122] The table style processing apparatus described above includes a processor and a memory, and the determination unit, the identification unit, the acquisition unit, and the adjustment unit are all stored in the memory as program units, and the corresponding functions are realized by the processor executing the program units stored in the memory.
[0123] The processor includes a core, and the core calls the corresponding program units from the memory. The core can be one or more, and the core parameters are adjusted to identify the table area and adjust different areas of the table, so that the adjustment effect of the table is better.
[0124] The memory can include a non-permanent memory in a computer readable medium, a random access memory (RAM), and / or a non-volatile memory such as a read-only memory (ROM) or a flash memory (flash RAM), and the memory includes at least one memory chip.
[0125] The embodiment of the present application provides a computer readable storage medium, which stores a program, and the program is executed by a processor to realize the table style processing method.
[0126] The embodiment of the present application provides a processor for running a program, wherein the processor is used for executing the table style processing method when the program is running.
[0127] The embodiment of the present application provides a device, the device comprising a processor, a memory and a program stored on the memory and capable of running on the processor, wherein the processor implements at least the following steps when the program is running:
[0128] Step S101, determining a to-be-adjusted region of a target table;
[0129] Step S102, identifying a predetermined region in the to-be-adjusted region, wherein the identified predetermined region comprises at least a table header region and a table body region;
[0130] Step S103, determining style information in response to selection operations on a plurality of identifiers on a display interface, wherein the style information is information of a preset style of the to-be-adjusted region, the plurality of identifiers comprise a theme color identifier, an alternating mode identifier and a table style identifier, the theme color identifier is an identifier representing a target fill color of the to-be-adjusted region, the alternating mode identifier is an identifier representing an alternating mode of fill colors, and the table style identifier is an identifier representing a style of the to-be-adjusted region;
[0131] Step S104, adjusting a style in the to-be-adjusted region of the target table to the preset style according to at least the predetermined region and the style information.
[0132] The device herein can be a server, a PC, a PAD, a mobile phone or the like.
[0133] The present application also provides a computer program product, which, when executed on a data processing device, is adapted to execute a program that is initialized with at least the following method steps:
[0134] Step S101, determining a to-be-adjusted region of a target table;
[0135] Step S102, identifying a predetermined region in the to-be-adjusted region, wherein the identified predetermined region comprises at least a table header region and a table body region;
[0136] Step S103, determining style information in response to selection operations on a plurality of identifiers on a display interface, wherein the style information is information of a preset style of the to-be-adjusted region, the plurality of identifiers comprise a theme color identifier, an alternating mode identifier and a table style identifier, the theme color identifier is an identifier representing a target fill color of the to-be-adjusted region, the alternating mode identifier is an identifier representing an alternating mode of fill colors, and the table style identifier is an identifier representing a style of the to-be-adjusted region;
[0137] In step S104, the style in the to-be-adjusted region of the target table is adjusted to the preset style according to the predetermined region and the style information.
[0138] In order for those skilled in the art to more clearly understand the technical solutions of the present application, the technical solutions and technical effects of the present application will be described below in conjunction with specific embodiments.
[0139] Embodiments
[0140] The predetermined region of the table includes a title region, a supplementary information region, a table header region, a table body region, and a first column region, and the style of the table is adjusted in the following order:
[0141] Firstly, the styles of the title region 103 and the supplementary information region are adjusted, as shown in FIG. 1, the boxed part is the title region 103, the title region 103 and the supplementary information region are adjusted to the preset style, the title region 103 and the supplementary information region need to be adjusted as the first step, if they are adjusted after the table body region, the style of the lower border line of the title region 103 will replace the style of the upper border line of the table body region, and when there is no supplementary information region, the style of the lower border line of the title region 103 will replace the style of the upper border line of the table body region; Figure 7
[0142] Secondly, the alternating style is set, and the alternating manner of the fill color of the table header region and the table body region is adjusted, the preset style includes the style of “no horizontal table header”, in order to unify the process, the table header region and the table body region are taken as a whole to adjust the alternating manner;
[0143] Thirdly, the style of the table header region 101 is re-adjusted, the re-adjusted style of the table header region 101 will replace the style of the table header region 101 set in the previous step, as shown in FIG. 2, the table header region 101 in the figure has been re-set, the style of the table header region 101 is different from the style of the table body region 102, and they can be easily distinguished; Figure 8
[0144] Fourthly, the style of the first column region 105 is adjusted, the first column region 105 is adjusted to the preset style, the first column region 105 is the first column of the table header region and the table body region, the adjusted style of the first column region 105 will replace the styles of the table header region and the table body region set in the previous two steps, as shown in FIG. 3, the boxed part in the figure is the first column region 105, and the preset style has multiple types; Figure 9
[0145] Fifthly, the color, the fill color, the outer border color, and the inner border color of the text in the predetermined region are adjusted.
[0146] Specifically, the style table is as shown in Table 1. Figure 15 As shown, the style sheet shows multiple theme color information, and the letters are color application codes of the style sheet, which is a pre-designed style sheet;
[0147] In this solution, adaptive processing is also needed:
[0148] First, the to-be-adjusted areas of the table are vertically distributed from top to bottom. The style of the top border line of the next area will affect the style of the bottom border line of the previous area. According to the above sequence, the mutually affected border styles can be adjusted to the required preset styles, and the final effect is the required effect.
[0149] Second, when the alternating mode is set, the style of the table header area re-adjusted in the third step will replace the previously set alternating style. Sometimes, the fill color of the table header area will blend with the alternating style color of the table body area. If the colors are similar, the styles of the re-adjusted table header area and the previously adjusted table header area cannot be distinguished. It is necessary to emphasize the division of the table header area. The bottom border line of the table header area is the style of the dividable area, which separates the two areas to prevent the table header area and the content of the table header area from being connected together.
[0150] Third, when the alternating style is set, the column alternating implementation mode is as follows: the style of each column is set from left to right. The color of the left border is light, and the color of the right border is dark. In the process of setting from left to right, the color of the left border of the next column replaces the color of the right border of the previous column, so as to achieve the purpose of making the entire table have light vertical inner borders. Until the last column is set, the color of the right border of the last column is dark, and the color of the left border of the table is light, as shown in Figure 5 for the next step.
[0151] Fourth, when the predetermined area includes the first column area, the style of the first column area will replace the style of the first column. When the predetermined area does not include the first column area, the color of the left border of the first column is adjusted to dark, as shown in Figure 6 After the style of the first column is finally adjusted, the color of the left border of the first column is dark.
[0152] The alternating style includes row alternating style, column alternating style, and no alternating style,
[0153] In the case of row alternating style, the table header area 101 and the table body area 102 are obtained, and the horizontal alternating granularity is determined. In the case of merged rows, as shown in Figure 3 the merged rows are used to traverse the table header area 101 and the table body area 102. The styles of odd rows and even rows are obtained according to the style sheet, and the target fill color of the odd rows and the even rows is alternately filled. In the case of single row, as shown inFigure 4 As shown, the target fill color is filled alternately in odd rows and even rows by traversing the table header region 101 and the table body region 102 in a single row;
[0154] In the case where the alternating style is the column-alternating style, the table header region and the table body region are acquired, the column-alternating granularity is determined, in the case where the column-alternating granularity is the merged column, the table header region and the table body region are traversed in the merged column, the styles of the odd columns and the even columns are obtained according to the style table, and the target fill color is filled alternately in the odd columns and the even columns, in the case where the column-alternating granularity is the single column, the table header region and the table body region are traversed in the single column, and the target fill color is filled alternately in the odd columns and the even columns;
[0155] In the case where the alternating style is the no-alternating style, the table header region and the table body region are acquired, the preset style of the no-alternating style is obtained according to the style table, and the fill color of the table header region and the table body region is not filled;
[0156] After the style of the table header region and the table body region is adjusted, it is determined whether to ignore the table header setting, in the case where it is determined not to ignore the table header setting, the style of the table header region is adjusted, and in the case where it is determined to ignore the table header setting, it is determined not to set the style of the table header region;
[0157] Specifically, the style of the region to be adjusted includes a three-line table style, a vertical-alternating style, and a horizontal-alternating style, Figure 11 a display effect diagram of the three-line table style is shown, Figure 12 a display effect diagram of the vertical-alternating style is shown, Figure 13 a display effect diagram of the horizontal-alternating style is shown;
[0158] The embodiment further includes: receiving a predetermined operation on a preview identifier on the display interface, in response to the predetermined operation, generating a preview table according to the style information and the predetermined region and displaying the preview table on the display interface, and the display interface is as shown in Figure 10 The preview effect is as shown in Figure 14 .
[0159] In the above embodiments of the present application, the description of each embodiment has its own focus, and the parts not described in detail in a certain embodiment can be referred to the related description of other embodiments.
[0160] In several embodiments provided in the present application, it should be understood that the disclosed technical content can be implemented by other manners. Among them, the above-described device embodiments are only illustrative, for example, the division of the above-mentioned units can be a logical function division, and actual implementation can have another division manner, for example, a plurality of units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the coupling or direct coupling or communication connection between the units or modules shown or discussed can be indirect coupling or communication connection between the units or modules through some interfaces, and can be electrical or other forms.
[0161] The units described above as separate components can or can not be physically separate, and the components shown as units can or can not be physical units, that is, they can be located in one place, or they can be distributed to multiple units. Part or all of the units can be selected according to actual needs to achieve the purpose of the embodiment.
[0162] In addition, each functional unit in each embodiment of the present application can be integrated in one processing unit, or each unit can exist physically, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware or in the form of a software functional unit.
[0163] The integrated unit, if realized in the form of a software functional unit and sold or used as an independent product, can be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application essentially or the part of the prior art that makes a contribution or the whole or part of the technical solutions can be embodied in the form of a software product. The computer software product is stored in a storage medium, including a plurality of instructions for causing a computer device (which can be a personal computer, a server or a network device, etc.) to execute all or part of the steps of the above-mentioned method of each embodiment of the present application. The foregoing storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and various program code storage media.
[0164] From the above description, it can be seen that the above-described embodiments of the present application achieve the following technical effects:
[0165] 1)、The table style processing method of the present application first determines the to-be-adjusted area of the target table, then identifies a predetermined area in the to-be-adjusted area, the identified predetermined area at least includes a table header area and a table body area, then determines style information in response to selection operations on a plurality of marks on the display interface, the style information is the information of the preset style of the to-be-adjusted area, and finally adjusts the style in the to-be-adjusted area of the target table to the preset style according to at least the predetermined area and the style information. In the above scheme, the styles of different predetermined areas of the table are adjusted to the preset style by identifying the predetermined area of the table and adjusting the to-be-adjusted area according to the identified predetermined area and the style information, that is, the different predetermined areas of the table are adjusted respectively and pertinently, so that the adjustment effect is better, and the problem that the table adjustment effect is poor due to the inability to identify the table area is solved.
[0166] 2)、The table style processing device of the present application, the first determination unit determines the to-be-adjusted area of the target table, the identification unit identifies a predetermined area in the to-be-adjusted area, the identified predetermined area at least includes a table header area and a table body area, the second determination unit determines style information in response to selection operations on a plurality of marks on the display interface, the style information is the information of the preset style of the to-be-adjusted area, and the adjustment unit adjusts the style in the to-be-adjusted area of the target table to the preset style according to at least the predetermined area and the style information. In the above scheme, the styles of different predetermined areas of the table are adjusted to the preset style by identifying the predetermined area of the table and adjusting the to-be-adjusted area according to the identified predetermined area and the style information, that is, the different predetermined areas of the table are adjusted respectively and pertinently, so that the adjustment effect is better, and the problem that the table adjustment effect is poor due to the inability to identify the table area is solved.
[0167] The above is only a preferred embodiment of the present application and is not used to limit the present application. Those skilled in the art can make various changes and modifications to the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims
1. A method for processing table styles, characterized in that, include: Identify the area in the target table that needs adjustment; Identify a predetermined area within the area to be adjusted, wherein the identified predetermined area includes at least a header area and a body area; In response to selection operations applied to multiple icons on the display interface, style information is determined. The style information is information about the preset style of the area to be adjusted, including theme color information and alternation style information. The multiple icons include theme color icons, alternation mode icons, and table style icons. The theme color icon represents the target fill color of the area to be adjusted, the alternation mode icon represents the alternation mode of the fill color, and the table style icon represents the style of the area to be adjusted. Based at least on the predetermined area and the style information, the header area and the body area are first styled as a whole, then the style of the header area is reset, and the reset style of the header area overrides the previously set style, including: First, adjust the style of the area to be adjusted in the target table to the preset style, including: determining the target fill color of the area to be adjusted according to the theme color information; determining the alternating style of the area to be adjusted according to the alternating style information, wherein the alternating style is the alternation method of fill color; and adjusting the fill color of the header area and the body area of the area to be adjusted in the target table according to the target fill color and the alternating style. Then, based on the theme color information, determine the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area; adjust the color of the text in the header area to the corresponding target color of the text; adjust the border color of the header area to the corresponding target border color; and adjust the fill color of the header area to the corresponding target fill color.
2. The processing method according to claim 1, characterized in that, There are multiple target fill colors for the area to be adjusted. Based on the target fill color and the alternation style, the fill colors of the header and body areas of the target table's area to be adjusted are adjusted, including: When the alternation pattern is a row alternation pattern, determine the horizontal alternation granularity; When the horizontal alternation granularity is a merged row, the header area and the body area are traversed in units of the merged row, and multiple target fill colors are alternately filled. The cells of the merged row are formed by merging multiple smallest cells in the column direction. If the horizontal alternation granularity is not the merged row, the header area and the body area are traversed in units of single rows, and multiple target fill colors are alternately filled, with the single row cell being the smallest cell.
3. The processing method according to claim 1, characterized in that, There are multiple target fill colors for the area to be adjusted. Based on the target fill color and the alternation style, the fill colors of the header and body areas of the target table's area to be adjusted are adjusted, including: When the alternation pattern is a column alternation pattern, determine the column alternation granularity; When the column granularity is a merged column, the header area and the body area are traversed in units of the merged column, and multiple target fill colors are alternately filled. The cells of the merged column are formed by merging multiple smallest cells in the row direction. When the column alternation granularity is not the merged column, the header area and the body area are traversed in units of a single column, and multiple target fill colors are alternately filled, wherein the cell of the single column is the smallest cell.
4. The processing method according to claim 1, characterized in that, After adjusting the fill colors of the header and body areas of the target table's area to be adjusted according to the target fill color and the alternating style, the style in the target table's area to be adjusted is adjusted to the preset style, at least according to the predetermined area and the style information, further comprising: Based on the theme color information, determine the target color of the text in each of the predetermined areas, the target color of the outer border of the area to be adjusted, and the target color of the inner border. Adjust the color of the text within each of the predetermined areas to the target color of the corresponding text; Adjust the outer border color and inner border color of the area to be adjusted to the target outer border color and inner border color of the area to be adjusted.
5. The processing method according to claim 4, characterized in that, Adjusting the outer and inner border colors of the area to be adjusted to the target colors of the outer and inner borders of the area to be adjusted includes: Following a first predetermined direction, the two border colors of each row are set sequentially. During the setting process, the color of the first border of the later-set row replaces the color of the second border of the previously set row. The color of the first border of each row is the target color for the inner border, and the color of the second border of each row is the target color for the outer border. The direction from the first border to the second border of a row is the first predetermined direction; and / or... According to the second predetermined direction, the two border colors of each column are set sequentially, and during the setting process, the color of the first border of the later set column replaces the color of the second border of the previously set column, wherein the direction from the first border to the second border of a column is the second predetermined direction.
6. The processing method according to claim 5, characterized in that, After setting the two border colors of each row sequentially according to a first predetermined direction, and / or after setting the two border colors of each column sequentially according to a second predetermined direction, adjusting the outer border color and inner border color of the area to be adjusted to the target outer border color and inner border color of the area to be adjusted, further comprising: Adjust the color of the target border to the target color of the outer border, wherein the target border is the outer border of the area to be adjusted whose color is not the target color of the outer border.
7. The processing method according to claim 1, characterized in that, Before adjusting the fill color of the header area and the body area of the target table's area to be adjusted according to the target fill color and the alternating style, the style in the target table's area to be adjusted is adjusted to the preset style at least according to the predetermined area and the style information, including: If the identified predetermined area includes a title area and a supplementary information area, the target color of the text in the title area, the target color of the text in the supplementary information area, the target fill color of the title area, the target border color of the title area, the target fill color of the supplementary information area, and the target border color of the supplementary information area are determined according to the theme color information. Adjust the color of the text in the title area and the color of the text in the supplementary information area to the target color of the corresponding text. Adjust the border color of the title area and the border color of the supplementary information area to the corresponding target border colors; Adjust the fill color of the title area and the fill color of the supplementary information area to the corresponding target fill color.
8. The processing method according to claim 1, characterized in that, After adjusting the fill colors of the header and body areas of the target table's area to be adjusted according to the target fill color and the alternating style, the style in the target table's area to be adjusted is then adjusted to the preset style, at least according to the predetermined area and the style information, including: Based on the theme color information, determine the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area; Adjust the color of the text in the header area to the target color of the corresponding text; Adjust the border color of the header area to the corresponding target border color; Adjust the fill color of the header area to the corresponding target fill color.
9. The processing method according to claim 8, characterized in that, After adjusting the fill colors of the header and body areas of the target table's area to be adjusted according to the target fill color and the alternating style, the style in the target table's area to be adjusted is then adjusted to the preset style, at least according to the predetermined area and the style information, including: Determine whether to ignore header settings; Without ignoring the header settings, the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area are determined based on the theme color information. Adjust the color of the text in the header area to the target color of the corresponding text; Adjust the border color of the header area to the corresponding target border color; Adjust the fill color of the header area to the corresponding target fill color.
10. The processing method according to claim 8, characterized in that, After adjusting the fill color of the header area to the corresponding target fill color, the style of the area to be adjusted in the target table is adjusted to the preset style, at least according to the predetermined area and the style information, including: If the identified predetermined area includes the first column area, the target color of the text in the first column area, the target fill color of the first column area, and the target border color of the first column area are determined according to the theme color information. Adjust the color of the text in the first column area to the target color of the corresponding text; Adjust the border color of the first column area to the corresponding target border color of the first column area, wherein the target border color of the outer border of the first column area is the target border color of the outer border of the area to be adjusted; Adjust the fill color of the first column area to the corresponding target fill color.
11. The processing method according to any one of claims 1 to 10, characterized in that, Identify the areas of the target table that need adjustment, including: Receive a first selection operation applied to the area of the target table on the display interface; In response to the first selection operation, the area to be adjusted is determined.
12. The processing method according to any one of claims 1 to 10, characterized in that, In response to selection operations on multiple icons on the display interface, determine style information, including: Receive a second selection operation applied to a first area of the display interface, the first area including a plurality of the theme color indicators; Receive a third selection operation applied to a second area of the display interface, the second area including a plurality of the table style identifiers; Receive a fourth selection operation applied to a third area of the display interface, the third area including a plurality of the alternation mode identifiers; The style information is generated in response to the second selection operation, the third selection operation, and the fourth selection operation.
13. The processing method according to any one of claims 1 to 10, characterized in that, The style of the area to be adjusted includes at least one of the following: three-line table style, vertical alternation style, and horizontal alternation style.
14. The processing method according to any one of claims 1 to 10, characterized in that, After determining the style information, and before adjusting the style in the area to be adjusted of the target table to the preset style based at least on the predetermined area and the style information, the method further includes: Receive a pre-defined operation applied to the preview icon on the display interface; In response to the predetermined operation, a preview table is generated based on the style information and the predetermined area and displayed on the display interface.
15. A table-style processing device, characterized in that, include: The first determining unit is used to determine the area to be adjusted in the target table; The identification unit is used to identify a predetermined area in the area to be adjusted, wherein the identified predetermined area includes at least a header area and a body area. The second determining unit is configured to determine style information in response to selection operations performed on multiple icons on the display interface. The style information is information about a preset style of the area to be adjusted, including theme color information and alternation style information. The multiple icons include theme color icons, alternation mode icons, and table style icons. The theme color icon represents the target fill color of the area to be adjusted, the alternation mode icon represents the alternation mode of the fill color, and the table style icon represents the style of the area to be adjusted. An adjustment unit is configured to, based at least on the predetermined area and the style information, first adjust the style of the header area and the body area as a whole, then reset the style of the header area, and override the previously set style with the reset style of the header area, including: First, adjust the style of the area to be adjusted in the target table to the preset style, including: determining the target fill color of the area to be adjusted according to the theme color information; determining the alternating style of the area to be adjusted according to the alternating style information, wherein the alternating style is the alternation method of fill color; and adjusting the fill color of the header area and the body area of the area to be adjusted in the target table according to the target fill color and the alternating style. Then, based on the theme color information, determine the target color of the text in the header area, the target fill color of the header area, and the target border color of the header area; adjust the color of the text in the header area to the corresponding target color of the text; adjust the border color of the header area to the corresponding target border color; and adjust the fill color of the header area to the corresponding target fill color.
16. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored program, wherein the program performs the processing method according to any one of claims 1 to 14.
17. A processor, characterized in that, The processor is used to run a program, wherein the program executes the processing method according to any one of claims 1 to 14 when it runs.
Citation Information
Patent Citations
Customizable spreadsheet table styles
US20070050699A1