Cập nhật nội dung chi tiết về Functions And Formulas That You Can Use In A Word Document mới nhất trên website Beiqthatgioi.com. Hy vọng thông tin trong bài viết sẽ đáp ứng được nhu cầu ngoài mong đợi của bạn, chúng tôi sẽ làm việc thường xuyên để cập nhật nội dung mới nhằm giúp bạn nhận được thông tin nhanh chóng và chính xác nhất.
You can use simple formulas in Microsoft Word, such as addition (+), subtraction (-), multiplication (*), or division (/). Also, you can calculate a power of (^):
See How to reference a cell of a Word table for more details.
All functions you can see in the Paste function drop-down list of the Formula dialog box:
ABS ()
Calculates the absolute value of the value inside the parentheses.
AVERAGE ()
Calculates the average of the elements identified inside the parentheses.
COUNT ()
Calculates the number of elements identified inside the parentheses.
DEFINED ()
Evaluates whether the argument inside parentheses is defined. Returns 1 if the argument has been defined and evaluates without error, 0 if the argument has not been defined or returns an error.
IF ()
Evaluates the first argument. Returns the second argument if the first argument is true; returns the third argument if the first argument is false.
INT ()
Rounds the value inside the parentheses down to the nearest integer.
MAX ()
Returns the maximum value of the items identified inside the parentheses.
MIN ()
Returns the minimum value of the items identified inside the parentheses.
MOD ()
Takes two arguments (must be numbers or evaluate to numbers). Returns the remainder after the second argument is divided by the first. If the remainder is 0 (zero), returns 0.0.
NOT
Evaluates whether the argument is true. Returns 0 if the argument is true, 1 if the argument is false. Mostly used inside an IF formula.
OR ()
Takes two arguments. If both are false, returns 0, else returns 1. Mostly used inside an IF formula.
PRODUCT ()
Calculates the product of items identified inside the parentheses.
ROUND ()
Rounds the first argument to the number of digits specified by the second argument. If the second argument is greater than zero ( 0), first argument is rounded down to the specified number of digits. If second argument is zero ( 0), first argument is rounded down to the nearest integer. If second argument is negative, first argument is rounded down to the left of the decimal.
SIGN ()
Takes one argument that must either be a number or evaluate to a number. Evaluates whether the item identified inside the parentheses if greater than, equal to, or less than zero ( 0). Returns 1 if greater than zero, 0 if zero, -1 if less than zero.
SUM ()
Calculates the sum of items identified inside the parentheses.
The arguments can be:
See also this tip in French: Fonctions et formules dans Word.
Parse Word Document Using Apache Poi Example
In this article we will be discussing about ways and techniques to read word documents in Java using Apache POI library. The word document may contain images, tables or plain text. Apart from this a standard word file has header and footers too. Here in the following examples we will be parsing a word document by reading its different paragraph, runs, images, tables along with headers and footers. We will also take a look into identifying different styles associated with the paragraphs such as font-size, font-family, font-color etc.
Maven Dependencies
Following is the poi maven depedency required to read word documents. For latest artifacts visit here
chúng tôi
<dependencies> <dependency> <groupId>org.apache.poi
</groupId> <artifactId>poi-ooxml
</artifactId> <version>3.16
</version> </dependency> </dependencies>Reading Complete Text from Word Document
The class XWPFDocument has many methods defined to read and extract .docx file contents. getText() can be used to read all the texts in a .docx word document. Following is an example.
TextReader.java
public class
TextReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); XWPFWordExtractor extractor =new
XWPFWordExtractor(xdoc); System.out
.println(extractor.getText()); }catch
(Exception ex) { ex.printStackTrace(); } } }Reading Headers and Foooters of Word Document
HeaderFooter.java
public class
HeaderFooterReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); XWPFHeaderFooterPolicy policy =new
XWPFHeaderFooterPolicy(xdoc); XWPFHeader header = policy.getDefaultHeader();if
(header !=null
) { System.out
.println(header.getText()); } XWPFFooter footer = policy.getDefaultFooter();if
(footer !=null
) { System.out
.println(footer.getText()); } }catch
(Exception ex) { ex.printStackTrace(); } } }Output
This is Header
This is footer
Read Each Paragraph of a Word Document
Among the many methods defined in XWPFDocument class, we can use getParagraphs() to read a .docx word document paragraph chúng tôi method returns a list of all the paragraphs(XWPFParagraph) of a word document. Again the XWPFParagraph has many utils method defined to extract information related to any paragraph such as text alignment, style associated with the paragrpahs.
To have more control over the text reading of a word document,each paragraph is again divided into multiple runs. Run defines a region of text with a common set of properties.Following is an example to read paragraphs from a .docx word document.
ParagraphReader.java
public class
ParagraphReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); List paragraphList = xdoc.getParagraphs();for
(XWPFParagraph paragraph : paragraphList) { System.out
.println(paragraph.getText()); System.out
.println(paragraph.getAlignment()); System.out
.print(paragraph.getRuns().size()); System.out
.println(paragraph.getStyle());// Returns numbering format for this paragraph, eg bullet or lowerLetter.
System.out
.println(paragraph.getNumFmt()); System.out
.println(paragraph.getAlignment()); System.out
.println(paragraph.isWordWrapped()); System.out
.println("********************************************************************"
); } }catch
(Exception ex) { ex.printStackTrace(); } } }Reading Tables from Word Document
Following is an example to read tables present in a word document. It will print all the text rows wise.
TableReader.java
public class
TableReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); Iterator bodyElementIterator = xdoc.getBodyElementsIterator();while
(bodyElementIterator.hasNext()) { IBodyElement element = bodyElementIterator.next();if
("TABLE"
.equalsIgnoreCase(element.getElementType().name())) { List tableList = element.getBody().getTables();for
(XWPFTable table : tableList) { System.out
.println("Total Number of Rows of Table:"
+ table.getNumberOfRows());for
(int
i = 0; i for (int
j = 0; j out.println(table.getRow(i).getCell(j).getText()); } } } } } }catch
(Exception ex) { ex.printStackTrace(); } } }Reading Styles from Word Document
Styles are associated with runs of a paragraph. There are many methods available in the XWPFRun class to identify the styles associated with the text.There are methods to identify boldness, highlighted words, capitalized words etc.
StyleReader.java
public class
StyleReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); List paragraphList = xdoc.getParagraphs();for
(XWPFParagraph paragraph : paragraphList) {for
(XWPFRun rn : paragraph.getRuns()) { System.out
.println(rn.isBold()); System.out
.println(rn.isHighlighted()); System.out
.println(rn.isCapitalized()); System.out
.println(rn.getFontSize()); } System.out
.println("********************************************************************"
); } }catch
(Exception ex) { ex.printStackTrace(); } } }Reading Image from Word Document
Following is an example to read image files from a word document.
public class
ImageReader {public static void
main(String[] args) {try
{ FileInputStream fis =new
FileInputStream("test.docx"
); XWPFDocument xdoc =new
XWPFDocument(OPCPackage.open(fis)); List pic = xdoc.getAllPictures();if
(!pic.isEmpty()) { System.out
.print(pic.get(0).getPictureType()); System.out
.print(pic.get(0).getData()); } }catch
(Exception ex) { ex.printStackTrace(); } } }Conclusion
Download source
How Can You Turn A Word Task Pane On And Off?
Multiple task panes are available in Microsoft Word. Most only appear when needed for a specific tool or feature, others are available to turn on and off as needed. Task panes, such as the Navigation pane, the Reviewing pane, the Selection pane, and the Thesaurus Pane might not be straightforward to find when you need them or turn off when you don’t. Learn how to turn on or off a task pane in Word.
How to Enable and Disable the Navigation Task Pane in Word
The Navigation pane simplifies moving through a Word document without scrolling. Open and close it as needed.
Open the Word document in which you want to open the Navigation pane.
In the Show group, select the Navigation Pane check box. The Navigation task pane opens to the left of the document.
To use a keyboard shortcut to open the Navigation pane, press Ctrl+ F.
Use the Navigation pane to search the document, browse headings, browse pages, rearrange content, and more.
How to Enable and Disable the Reviewing Task Pane in Word
If you track changes made to a document, the Reviewing pane shows any revisions made.
Open the Word document in which you want to open the Reviewing pane.
In the Tracking group, select Reviewing Pane. The Reviewing pane opens to the left of the document, by default.
Select the Reviewing Pane drop-down arrow and choose Reviewing Pane Horizontal to open the Reviewing pane below the document.
How to Enable and Disable the Selection Task Pane in Word
The Selection pane allows you to find and edit objects in a Word document.
Open the Word document in which you want to open the Selection pane.
Select the Layout or Page Layout tab.
In the Arrange group, choose Selection Pane. The task pane opens to the right of the document.
How to Enable and Disable the Thesaurus Task Pane in Word
The Thesaurus Pane makes it easy to find alternative words to use in documents.
Open the Word document in which you want to open the Thesaurus pane.
In the Proofing group, select Thesaurus. The Thesaurus pane opens to the right of the document.
To open the Thesaurus pane with a keyboard shortcut, press Shift+ F7.
Thanks for letting us know!
Other Not enough details Hard to understand
How To Use The Excel Counta Function
Random list of names
At the core, this formula uses the INDEX function to retrieve 10 random names from a named range called “names” which contains 100 names. For example, to retrieve the fifth name from the list, we use INDEX like this…
Add row numbers and skip blanks
In the example shown, the goal is to add row numbers in column B only when there is a value in column C. The formula in B5 is:
=IF(ISBLANK(C5),””,COUNTA($C$5:C5))
The IF function first checks if cell C5 has…
Cell contains all of many things
The key is this snippet:
ISNUMBER(SEARCH(things,B5)
This is based on another formula (explained in detail here) that simply checks a cell for a single substring. If the cell contains the substring, the formula…
Count cells that are blank
The COUNTBLANK function counts the number of cells in the range that don’t contain any value and returns this number as the result. Cells that contain text, numbers, dates, errors, etc. are not counted. COUNTBLANK is…
Last row in mixed data with no blanks
This formula uses the COUNTA function to count values in a range. COUNTA counts both numbers and text to so works well with mixed data.
The range B4:B8 contains 5 values, so COUNTA returns 5. The number 5 corresponds…
Count unique values
This example uses the UNIQUE function to extract unique values. When UNIQUE is provided with the range B5:B16, which contains 12 values, it returns the 7 unique values seen in D5:D11. These are returned directly to the…
Dynamic named range with OFFSET
This formula uses the OFFSET function to generate a range that expands and contracts by adjusting height and width based on a count of non-empty cells.
The first argument in OFFSET represents the first cell in the…
Running count group by n size
The core of this formula is the COUNTA function, configured with an expanding range like this:
COUNTA($B$5:B5)
As the formula is copied down the column, the range starting with B5 expands to include each new row, and…
Count cells not equal to many things
First, a little context. Normally, if you have just a couple things you don’t want to count, you can use COUNTIFS like this:
But this doesn…
Project complete percentage
In this example if a task is marked “Done”, then it is considered complete. The goal is to calculate the percent complete for the project by showing the ratio of complete tasks to total tasks, expressed as a percentage…
Count sold and remaining
The COUNTA function counts non-blank cells that contain numbers or text. The first COUNTA counts non-blank cells in the range B5:B11 and returns the number 7:
COUNTA(B5:B11)
The second COUNTA function…
Generate random text strings
The new dynamic array formulas in Excel 365 make it much easier to solve certain tricky problems with formulas.
In this example, the goal is to generate a list of random 6-character codes. The randomness is handled by…
Sort by random
The SORTBY function allows sorting based on one or more “sort by” arrays, as long long as they have dimensions that are compatible with the data being sorted. In this example, there are 10 values being sorted, the…
Score quiz answers with key
This formula uses the named range “key” (C4:G4) for convenience only. Without the named range, you’ll want to use an absolute reference so the formula can be copied.
In cell I7, we have this formula:
=SUM(–(C7:G7=…
Reverse a list or range
The heart of this formula is the INDEX function, which is given the list as the array argument:
=INDEX(list
The second part of the formula is an expression that works out the correct row number as the formula is…
Bạn đang đọc nội dung bài viết Functions And Formulas That You Can Use In A Word Document trên website Beiqthatgioi.com. Hy vọng một phần nào đó những thông tin mà chúng tôi đã cung cấp là rất hữu ích với bạn. Nếu nội dung bài viết hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất. Chúc bạn một ngày tốt lành!