function formula calculation in a table with WPS text

If I said it was in WPS. The tables in the text document can be used to calculate functions, formulas, and so on, not only in the WPS text, but also in the form of the first few forms, as well as many formulas and function functions like ET. Am I in a dream? No, in fact, WPS Office has long been able to achieve this function, but most of us did not pay attention to.

The following figure, is to determine the perimeter, area and type of a table, which uses a number of functions and formulas, that is, the use of the first few moderators developed by the plugin is helpless, but only with ET to make.

However, the use of ET and then copied to the WPS word, the result will be only text, when the source data changes, the subsequent calculation will not change.

The following approach is to insert the ET form perfectly into the WPS text.

First, position the cursor where you want to insert the table, click insert → object, select new →wps Table Workbook in the Insert Object panel, and click OK.

In this case, the system calls ET and creates a new workbook called "Workbook in document 1" (if the WPS document is already saved, replace document 1 with the file name that you save). Here, you want to do a lot of complex tables, you want to use more esoteric functions. When the form is finished, set the border format (et default does not show the border), then select the range of cells to be displayed in the WPS text, and then click the "Set Display area" button floating in the document, and then close ET.

After you close ET, automatically return to the WPS text, you will find that just made the table has been shown at the cursor location, you can adjust the picture like the size of the image, edge color, fill color, wrapping style and brightness, contrast and other attributes. If you need to modify the contents of the table, simply double-click the table, and then call et again to modify it, and the display status in the WPS text will be updated immediately after the modification.

The above method is suitable to create a new table, if you need to use the existing ET table inserted into the WPS text, in the "Insert Object", select "Create by File", and the "Browse" button to choose the ET file to be inserted, the other operations and the same, do not repeat.

To be aware of, there is a "connection" option on the right side of the "Browse" button, and if selected, the ET file will not be embedded in the WPS document, and the table in the WPS document will not be edited again when the source file is mistakenly deleted, renamed, or moved. Therefore, it is recommended not to check this, so that the ET file will be embedded in the WPS text, even if you leave the ET file source, can be used normally.