Shulou(Shulou.com)06/01 Report--

This article analyzes "how to easily handle a large piece of text in the report in big data". The content is detailed and easy to understand. Friends who are interested in "how to easily handle a large section of text in the report in big data" can follow the editor's train of thought to read it slowly and deeply. I hope it will be helpful to everyone after reading. Let's follow the editor to learn more about "how to easily handle a large piece of text in a report in big data".

Now report tools are widely used in various industries to achieve web-side data display, in which many industries will involve the data presentation form of documents, and there will be large sections of text in most documents, such as insurance policies of insurance companies, drug testing certificates in the medical industry and so on. In the report, the basic unit of data display is the cell, if the content of a field is a large piece of text, the content is very much, how to wrap and expand the grid height according to the content? When there is too much content to fit on one page, how to set it up to automatically divide the undisplayed content to the next page?

Below I will give a specific description of the large text requirements that appear in common document reports.

Automatic line wrapping display when the content exceeds the grid width

By default, the size of the report cell is the same as the design size, when there is a lot of content, because the size of the grid is fixed, the content can only be displayed as wide as the grid.

In order to see the effect more obvious, I set a border for A1, here is the preview effect.

Set A1 grid automatic line wrapping, its inch adjustment will automatically be expanded according to the contents of the cell, so that the text content will be displayed in multiple lines.

The preview effect is as follows:

The content is more than one page intercepted and displayed.

Set the expansion mode of the cell to expand according to the contents of the cell, automatically wrap lines, when there is more text, so that a page has not been displayed, the default will display at the end of the content, "the text is too long, the excess part is not displayed."... " .

In addition to this automatic capture method in the screenshot, you can also intercept through the dry string capture function and cooperate with the prompt function to show part of the content in the grid and point the mouse to show the whole content.

Paging display of large text content

If you want the rest of the content to be displayed on the next page, you need to make the following settings:

(1) you can add one line under the current line

(2) and merge the new lines with the original lines of large text.

(3) and split the cells on the parallel setting.

The effect of the page will be fully displayed on the next page.

Adjust the distance between a large piece of text and the footer when paging

When a large piece of text is divided into multiple pages, the report has a footer. If the distance between the large text and the footer in the body is large, you can control it in the following two ways:

(1) add multiple rows to merge and set cell split

When the content is certain, merge by adding multiple rows, such as the following report, add row merge, and then preview, and finally add almost 100 rows after adjusting the report.

(2) dynamically expand the cell size according to the content.

Roughly calculate the number of lines needed to show the large text according to the number of characters, after the large text cell, use to (1jinlen (the cell where the large text is located) / the maximum number of characters per line), and then dynamically expand the corresponding number of lines, stretch the row height of the cell where the large text is located, and the width of the auxiliary column is 0.

It should be noted that the cell height of the content should be appropriate, such as the height of the A236 cell in the image above, because the more content, the more rows, because the row height needs to be integer pixels, the greater the error.

About big data how to easily deal with a large part of the text in the report is shared here, I hope that the above content can improve everyone. If you want to learn more knowledge, please pay more attention to the editor's updates. Thank you for following the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.