Spreadsheet publishing line height adjustment method, electronic equipment and storage medium

Abstract

The invention provides a spreadsheet publishing row height adjustment method, electronic equipment and a storage medium. The method comprises the following steps: screening out cells with automatic line feed format attributes to form a to-be-optimized target cell set; in the target cell set, all cell contents of the current target cell are copied and applied to the measurement and calculation cell object; setting the column width attribute value of the measurement and calculation cell object as a simulation column width, and calling an automatic row height adjustment function to obtain a reference row height value of the measurement and calculation cell object; extracting a font size value from the font attribute of the current target cell, calculating a single-line font height, and adding the single-line font height value and the reference line height value to obtain a theoretical publication line height of the current target cell; under the condition that the theoretical publication row height meets the preset condition, the final execution row height of each row is generated through row-level aggregation and inter-row coordination calculation based on the final publication row height, and the corresponding row object is given, so that the typesetting efficiency and specialty are greatly improved.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method for adjusting the output height of an electronic spreadsheet, an electronic device, and a storage medium. Background Technology

[0002] In the typesetting and publication preparation of spreadsheets (such as Microsoft Excel and WPS Spreadsheets), ensuring that the content is clear, aesthetically pleasing, and conforms to printing standards is a crucial but tedious task. However, current methods for adjusting row height typically rely on manual experience. Operators must individually determine if content is truncated and manually drag the row boundaries to adjust. This process is not only time-consuming, but also lacks objective standards for row height settings, resulting in inefficient and inaccurate adjustments, making it difficult to guarantee consistency and professionalism in typesetting. This problem is particularly pronounced for large tables.

[0003] In addition, the current traditional methods of adjusting line height manually and by visual estimation lack the step of modeling printing accuracy during the adjustment stage. Due to the difference between the screen display and the final printed output, a table that is perfectly adjusted on the screen may have unexpected text wrapping or truncation when printed or exported to publishing formats such as PDF, resulting in a messy table layout. Summary of the Invention

[0004] This invention provides a method for adjusting the row height of a spreadsheet, an electronic device, and a storage medium to solve the problems existing in related technologies. The technical solution is as follows: In a first aspect, embodiments of the present invention provide a method for adjusting the row height of a spreadsheet, including: In response to the adjustment command, it iterates through all cells within the valid data area of ​​the spreadsheet worksheet object and filters out cells with automatic line wrapping to form the target cell set to be optimized; For each target cell in the target cell set, copy all cell contents of the current target cell and apply them to the measure cell object; where the measure cell object is the cell selected outside the boundary of the valid data area; Set the column width attribute value of the measured cell object to the simulated column width after adjusting the preset printing conversion factor, and call the automatic row height adjustment function to obtain the baseline row height value of the measured cell object after adapting to the content; Extract the font size value from the font attribute of the current target cell and calculate its corresponding single-line font height. Add the single-line font height value to the baseline row height value to obtain the theoretical row height of the current target cell. If the theoretical publication line height meets the preset conditions, the theoretical publication line height is determined as the final publication line height. Based on the final publication line height, the final execution line height of each line is calculated and generated through line-level aggregation and cross-line coordination. The final execution line height is then assigned to the corresponding line object to complete the line height adjustment.

[0005] In one implementation, the simulated column width is determined based on the structural state of the current target cell, using a reference column width, and is calculated based on the reference column width and a preset printing conversion factor.

[0006] In one implementation, determining the reference column width based on the current structural state of the target cell includes: When the current target cell is a merged cell, calculate the sum of the widths of all columns spanned by the merged area, and use this sum as the reference column width for the current target cell; When the current target cell is a non-merged cell, the width of its column is used as the reference column width for the current target cell.

[0007] In one implementation, when the theoretical published line height is less than or equal to a preset maximum allowed line height threshold, it is determined that the preset condition is met.

[0008] In one implementation, it further includes: When the theoretical publication line height is greater than the preset maximum allowed line height threshold, it is determined that the preset condition is not met. The font size attribute value of the current target cell and the font size attribute value of the measured cell object are reduced by a specified level, and a new baseline line height value is recalculated based on the current font size to determine the new theoretical publication line height, until the new theoretical publication line height is less than or equal to the preset maximum allowed line height threshold.

[0009] In one implementation, row-level aggregation includes: For each row, extract the maximum value from the final published row height of all its non-merged cells and use it as the content requirement row height for that row. Then, read the original row height attribute value of that row and determine the larger value between the content requirement row height and the original row height attribute value as the initial adjusted row height for that row.

[0010] In one implementation, cross-row coordination computation includes: Iterate through all merged cells. For each merged cell, compare its final published row height with the sum of the initial adjusted row heights of the rows it spans. If the final published line height is greater than the sum of the initial adjusted line heights, the difference between the two is used as the new line height and evenly distributed to each line it spans; the initial adjusted line height obtained for each line is added to the distributed new line height to generate the final executed line height for that line.

[0011] In one implementation, assigning the final row height to the corresponding row object is done by writing the value of the final row height into the row height attribute of the corresponding row object in the spreadsheet worksheet object.

[0012] Secondly, embodiments of the present invention provide an electronic device comprising a memory and a processor. The memory and the processor communicate with each other via an internal connection path. The memory stores instructions, and the processor executes the instructions stored in the memory. When the processor executes the instructions stored in the memory, it causes the processor to perform the method described in any of the above embodiments.

[0013] Thirdly, embodiments of the present invention provide a computer-readable storage medium that stores a computer program, wherein when the computer program is run on a computer, the methods in any of the above-described embodiments are executed.

[0014] The advantages or beneficial effects of the above technical solutions include at least the following: This invention completely replaces the inefficient and inaccurate manual visual adjustment, greatly improving typesetting efficiency and professionalism. In particular, by creating an independent measurement cell object, all cell contents of the current target cell to be optimized are copied and applied to the measurement cell object, which avoids directly adjusting the original table and affecting the original data layout and format, while eliminating the interference of adjacent cells on row height measurement.

[0015] Adjusting the column width of the measured cell object to the simulated column width adjusted by the preset printing conversion factor automatically calculates the theoretical row height of each cell that meets the publishing aesthetic standards (including reasonable line spacing), making the row height calculation benchmark closer to the actual printing conditions and avoiding layout errors caused by differences in output media from the source.

[0016] By generating the final execution row height for each row through row-level aggregation calculation and cross-row collaborative adjustment calculation, it can automatically take the maximum value required by each cell in the same row, which solves the fundamental contradiction that a single row height cannot meet the differentiated needs of multiple cells in the same row. It also intelligently allocates the required height of the merged cell to the multiple rows it spans, ensuring the reasonable layout and visual consistency of complex table structures.

[0017] The above overview is for illustrative purposes only and is not intended to be limiting in any way. In addition to the illustrative aspects, embodiments, and features described above, further aspects, embodiments, and features of the invention will become readily apparent from the accompanying drawings and the following detailed description. Attached Figure Description

[0018] In the accompanying drawings, unless otherwise specified, the same reference numerals throughout the various drawings denote the same or similar parts or elements. These drawings are not necessarily drawn to scale. It should be understood that these drawings depict only some embodiments disclosed in the invention and should not be construed as limiting the scope of the invention.

[0019] Figure 1 This is a flowchart illustrating the spreadsheet publishing height adjustment method of the present invention; Figure 2 This is a structural block diagram of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0020] In the following description, only certain exemplary embodiments are briefly described. As those skilled in the art will recognize, the described embodiments can be modified in various ways without departing from the spirit or scope of the invention. Therefore, the drawings and description are considered to be exemplary in nature and not restrictive.

[0021] In the typesetting and publication preparation of spreadsheets (such as Microsoft Excel and WPS Spreadsheets), ensuring that the table content is clear, aesthetically pleasing, and conforms to printing standards is a crucial but tedious task. Current techniques typically rely on manual experience or basic software functions for row height adjustment, which has a series of inherent drawbacks: 1. Row height adjustment relies on manual operation and visual inspection, which is inefficient and inaccurate: the operator must check whether the content is truncated one by one and manually drag the row boundaries to adjust. This process is not only time-consuming, but also lacks objective standards for row height settings, making it difficult to ensure consistency and professionalism in layout. This problem is particularly prominent for large tables.

[0022] 2. The "Auto-adjust row height" function performs poorly in complex scenarios: Although spreadsheet software provides the "Auto-adjust row height" function, its mechanism is simple, calculating the minimum display height only based on the current column width, without considering the visual spacing (line spacing) required for publishing. More importantly, this function cannot handle the different height requirements of multiple cells in the same row, nor can it intelligently coordinate row height conflicts between merged cells and ordinary cells, often leading to content overlap or layout chaos.

[0023] 3. Lack of pre-simulation of printing physical characteristics: There are differences between screen display and final printed output (such as pixel-to-dot conversion). Existing methods lack a step to model printing accuracy during the adjustment stage, which may result in unexpected text wrapping or truncation when printing or exporting to publication formats such as PDF, even if the table is perfectly adjusted on the screen.

[0024] 4. Insufficient global coordination capabilities: Existing tools or methods often adjust individual cells or rows in isolation, lacking the ability to perform systematic and collaborative optimization at the entire table level. Especially when dealing with merged cells spanning multiple rows, existing technologies lack effective automated solutions for allocating the required height to the rows while maintaining a uniform layout.

[0025] To address the aforementioned issues, this embodiment provides a method for adjusting the line height of spreadsheets. This method enables automated, precise, and systematic calculation and application of line height, and can automatically adapt to spreadsheets with complex table structures (such as merged cells). It completely replaces inefficient and inaccurate manual visual adjustments, greatly improving typesetting efficiency and professionalism.

[0026] like Figure 1 As shown, the method for adjusting the row height of a spreadsheet in this embodiment specifically includes: Step S1: In response to the adjustment command, traverse all cells within the valid data area of ​​the spreadsheet worksheet object and filter out cells with automatic line wrapping attributes to form the target cell set to be optimized.

[0027] When a user initiates an adjustment command, in response to the command, an independent measurement cell object is instantiated at a coordinate position outside the boundary of the valid data area within the memory space of the spreadsheet worksheet object. The measurement cell object is marked as Cellm and used as a sandbox environment for simulation calculation. This avoids directly adjusting the original table and affecting the original data layout and format, while also eliminating interference from adjacent cells on row height measurement.

[0028] Iterate through all cell objects within the valid data area of ​​the worksheet object, filter out cells whose "Wrap text" flag is True in the format properties, denote these cells as Celli, and combine all cells with automatic wrapping Celli into a target cell set to be optimized, thereby avoiding unnecessary calculations for cells without automatic wrapping.

[0029] Step S2: For each target cell in the target cell set, copy all the cell contents of the current target cell and apply them to the measurement cell object.

[0030] This embodiment performs a deep copy operation, copying all cell content of the current target cell, including text content, font attributes, alignment, borders, background color, and all formatting attributes, to the measurement cell object. If the target cell is a merged cell, all content within the merged area is extracted and integrated into a single data container within the measurement cell object. By completely reproducing the visual content and formatting attributes of the target cell in the measurement cell object, the representativeness of the measurement environment is ensured.

[0031] Step S3: Set the column width attribute value of the measured cell object to the simulated column width after adjusting the preset printing conversion factor, and call the automatic row height adjustment function to obtain the baseline row height value of the measured cell object after adapting to the content.

[0032] In this embodiment, the simulated column width is determined based on the structural state of the current target cell and its reference column width. It is calculated based on the reference column width and the preset printing conversion coefficient. The column width attribute value of the measured cell object is set as the simulated column width. By simulating the column width change caused by the adjustment of printing precision in the real publishing environment, the row height requirement that is more in line with the actual printing effect is obtained.

[0033] The printing conversion factor can be 1.11, or it can be set according to the actual situation.

[0034] It should be noted that the current target cell's structural state includes merged cells and non-merged cells. When the current target cell's structural state is a merged cell, the sum of the widths of all columns spanned by its merged area is calculated as the reference column width of the current target cell. When the current target cell's structural state is a non-merged cell, the width of its own column is taken as the reference column width of the current target cell.

[0035] Subsequently, the automatic row height function is called and the return value is obtained. That is, the "Auto Adjust Row Height" method is called on the cell object to be measured. This method calculates and returns the minimum pixel height required to accommodate all the content based on the current column width and cell content, and converts it into a row height unit value, which is recorded as the baseline row height value. This baseline row height value is the minimum row height value required to accommodate all the content under the current column width.

[0036] Step S4: Extract the font size value from the font attribute of the current target cell and calculate its corresponding single-line font height. Add the single-line font height value to the baseline line height value to obtain the theoretical line height of the current target cell. This provides the necessary visual spacing between lines of text, directly producing a professional-grade typesetting effect and ensuring the harmony of visual rhythm.

[0037] Step S5: Determine whether the theoretical publication height meets the preset conditions.

[0038] In this embodiment, the theoretical row height is compared with the corresponding maximum allowed row height threshold based on the current structural state of the target cell.

[0039] The maximum allowed row height threshold for non-merged cells can be set to 340 points, while the maximum allowed row height threshold for merged cells is 400 points.

[0040] When the theoretical line height is less than or equal to the preset maximum allowed line height threshold, it is determined that the preset condition is met, and step S6 continues; if the theoretical line height is greater than the preset maximum allowed line height threshold, it is determined that the preset condition is not met, and the font size attribute value of the current target cell and the font size attribute value of the measured cell object are reduced by a specified level. This embodiment adapts the content to the line height limit by reducing the font size, ensuring overall layout harmony.

[0041] In this embodiment, reducing a specified level can be done by simultaneously reducing one level. Based on the current font size after reducing the level, the process returns to step S3. The simulated column width of the measured cell object is re-determined according to the current font size and the preset printing conversion coefficient. The new baseline row height value of the measured cell is determined by calling the automatic row height function. Then, the calculation of the new theoretical publishing row height in step S4 is performed. The new theoretical publishing row height is then compared with the maximum allowed row height threshold. The above loop judgment logic is executed until the new theoretical publishing row height is less than or equal to the preset maximum allowed row height threshold, or the font size attribute value of the current target cell and the font size attribute value of the measured cell object reach the preset minimum font size limit.

[0042] When the preset conditions are met, the theoretical publication line height or the new theoretical publication line height obtained during the cyclic judgment process is determined as the final publication line height.

[0043] This embodiment calculates the final publication line height of each target cell by performing a loop judgment logic. By independently calculating and optimizing the final publication line height for each target cell, this embodiment provides accurate, reliable, and publication-compliant basic data for subsequent row-level aggregation and cross-row coordination, thereby ensuring the accuracy, adaptability, and robustness of the entire automatic adjustment method.

[0044] Step S6: Based on the final published row height of each target cell, determine the initial adjusted row height within the row through row-level aggregation and merging with the original row height data.

[0045] Specifically, the final published row height values ​​are grouped and aggregated by row index; for each row, the maximum value is extracted from the final published row height of all its non-merged cells as the content requirement row height for that row; for each row, the original row height attribute value of that row is read, and the content requirement row height of that row is compared with the original row height attribute value of that row, and the larger of the two values ​​is determined as the initial adjusted row height for that row.

[0046] This embodiment ensures that the row height is sufficient to accommodate the cell with the highest demand by taking the maximum final row height of all non-merged cells in the row. This prevents content truncation or overlap in any non-merged cells due to insufficient row height.

[0047] Furthermore, during the automated adjustment process, by comparing the calculated content requirement line height with the original line height and taking the larger value, the original design choices of the user can be preserved while ensuring the readability of the content, thus avoiding excessive adjustments.

[0048] Step S7: Generate the final execution row height for each row through cross-row coordination calculation, and assign the final execution row height to the corresponding row object to complete the row height adjustment.

[0049] The method for handling the coordinated adjustment of merged cells across rows is as follows: Traverse all merged cells. For each merged cell, obtain its final published row height as its required total row height. Identify each row spanned by the merged cell and sum the preliminary adjusted row heights determined in step S6 to obtain the current allocated row height sum. Compare the required total row height with the current allocated row height sum. If the required total row height is greater, calculate the difference and apply the difference allocation algorithm to distribute the difference as an additional row height evenly to each row it spans. Add the preliminary adjusted row height determined in step S6 to the allocated additional row height for each row to obtain the final executed row height for that row, and update the row height attribute value of that row accordingly.

[0050] The final row height is assigned to the corresponding row object by writing the value of the final row height into the row height property of the corresponding row object in the spreadsheet worksheet object.

[0051] The advantage of this cross-row coordination calculation is that it automatically detects and resolves height conflicts between merged cells and multiple rows. Through a difference allocation algorithm, the extra height requirement of merged cells is evenly distributed across the rows, ensuring complete content display while maintaining a uniform layout. This avoids sudden increases in row height or layout errors that may occur in traditional methods, achieving fully automatic adjustment of complex structures, guaranteeing a uniform and aesthetically pleasing layout. Furthermore, the adjustment takes effect through attribute writing, thereby improving the completeness, practicality, and automation of the solution.

[0052] In another embodiment, an electronic device is also provided. Figure 2 A structural block diagram of an electronic device according to an embodiment of the present invention is shown. Figure 2 As shown, the electronic device includes a memory 100 and a processor 200. The memory 100 stores a computer program that can run on the processor 200. When the processor 200 executes the computer program, it implements the spreadsheet row height adjustment method described in the above embodiments. The number of memories 100 and processors 200 can be one or more.

[0053] The electronic device also includes: The communication interface 300 is used to communicate with external devices and perform data exchange and transmission.

[0054] If the memory 100, processor 200, and communication interface 300 are implemented independently, they can be interconnected via a bus to communicate with each other. This bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. This bus can be divided into address bus, data bus, control bus, etc.

[0055] Optionally, in a specific implementation, if the memory 100, processor 200, and communication interface 300 are integrated on a single chip, then the memory 100, processor 200, and communication interface 300 can communicate with each other through an internal interface.

[0056] This invention provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the method provided in this invention.

[0057] This invention also provides a chip, which includes a processor for calling and executing instructions stored in a memory, causing a communication device on which the chip is installed to perform the method provided in this invention.

[0058] This invention also provides a chip, including: an input interface, an output interface, a processor, and a memory. The input interface, output interface, processor, and memory are connected through an internal connection path. The processor is used to execute code in the memory. When the code is executed, the processor is used to execute the method provided in this invention.

[0059] It should be understood that the aforementioned processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. General-purpose processors can be microprocessors or any conventional processor. It is worth noting that the processor can be a processor supporting the Advanced Reduced Instruction Set Computing (RISC) machine (ARM) architecture.

[0060] Further, optionally, the aforementioned memory may include read-only memory and random access memory, and may also include non-volatile random access memory. The memory may be volatile or non-volatile, or may include both. Non-volatile memory may include read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory may include random access memory (RAM), which serves as an external cache. Many forms of RAM are available by way of example, but not limitation. Examples include static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous linked dynamic random access memory (SLDRAM), and direct rambus RAM (DR RAM).

[0061] In the above embodiments, implementation can be achieved, in whole or in part, by software, hardware, firmware, or any combination thereof. When implemented in software, it can be implemented, in whole or in part, as a computer program product. A computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, all or part of the flow or function according to the present invention is generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium or transferred from one computer-readable storage medium to another.

[0062] In the description of this specification, references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of those different embodiments or examples.

[0063] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this invention, "a plurality of" means two or more, unless otherwise explicitly specified.

[0064] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any person skilled in the art can easily conceive of various variations or substitutions within the technical scope disclosed in the present invention, and these should all be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A method for adjusting the line height of an electronic spreadsheet, characterized in that, include: In response to the adjustment command, it iterates through all cells within the valid data area of ​​the spreadsheet worksheet object and filters out cells with automatic line wrapping to form the target cell set to be optimized; For each target cell in the target cell set, the entire content of the current target cell is copied and applied to the measurement cell object; wherein, the measurement cell object is a cell selected outside the boundary of the valid data area; Set the column width attribute value of the measured cell object to the simulated column width after adjusting the preset printing conversion coefficient, and call the automatic row height adjustment function to obtain the baseline row height value of the measured cell object after adapting to the content; Extract the font size value from the font attribute of the current target cell and calculate its corresponding single-line font height. Add the single-line font height value to the baseline line height value to obtain the theoretical line height of the current target cell. If the theoretical publication line height meets the preset conditions, the theoretical publication line height is determined as the final publication line height. Based on the final publication line height, the final execution line height of each line is generated through row-level aggregation and cross-row coordination calculation. The final execution line height is then assigned to the corresponding line object to complete the line height adjustment.

2. The method for adjusting the row height of an electronic spreadsheet according to claim 1, characterized in that, The simulated column width is determined based on the structural state of the current target cell, using a reference column width, and is calculated based on the reference column width and a preset printing conversion coefficient.

3. The method for adjusting the row height of an electronic spreadsheet according to claim 2, characterized in that, Determining the reference column width based on the current target cell's structural state includes: When the current target cell is a merged cell, calculate the sum of the widths of all columns spanned by its merged area, and use this sum as the reference column width of the current target cell; When the current target cell is a non-merged cell, the width of its column is taken as the reference column width of the current target cell.

4. The method for adjusting the row height of an electronic spreadsheet according to claim 1, characterized in that, When the theoretical published line height is less than or equal to the preset maximum allowed line height threshold, it is determined that the preset condition is met.

5. The method for adjusting the row height of an electronic spreadsheet according to claim 4, characterized in that, Also includes: When the theoretical publication line height is greater than the preset maximum allowed line height threshold, it is determined that the preset condition is not met. The font size attribute value of the current target cell and the font size attribute value of the measured cell object are reduced by a specified level in sync. A new baseline line height value is recalculated based on the current font size to determine the new theoretical publication line height, until the new theoretical publication line height is less than or equal to the preset maximum allowed line height threshold.

6. The method for adjusting the row height of an electronic spreadsheet according to claim 1, characterized in that, The row-level aggregation includes: For each row, extract the maximum value from the final published row height of all its non-merged cells as the content requirement row height for that row, and read the original row height attribute value of that row. The larger value between the content requirement row height and the original row height attribute value is determined as the initial adjusted row height for that row.

7. The method for adjusting the row height of an electronic spreadsheet according to claim 6, characterized in that, The cross-line coordination calculation includes: Iterate through all merged cells. For each merged cell, compare its final published row height with the sum of the initial adjusted row heights of the rows it spans. If the final published line height is greater than the sum of the initial adjusted line heights, the difference between the two is used as the new line height and evenly distributed to each line it spans; the initial adjusted line height obtained for each line is added to the distributed new line height to generate the final executed line height for that line.

8. The method for adjusting the row height of an electronic spreadsheet according to claim 7, characterized in that, Assigning the final executed row height to the corresponding row object is done by writing the value of the final executed row height into the row height attribute of the corresponding row object in the spreadsheet worksheet object.

9. An electronic device, characterized in that, include: A processor and a memory, wherein instructions are stored in the memory and loaded and executed by the processor to implement the spreadsheet publishing height adjustment method as described in any one of claims 1 to 8.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the spreadsheet row height adjustment method as described in any one of claims 1 to 8.

Images