WPS Skills: "Domain" exhibition style

What is "domain"? The so-called "domain" is actually a functional code. Insert in document: page number, date, hyperlink, table of contents, pinyin ..., just insert the corresponding: page field, date, Hyperlink field, TOC field, eq field ... "Domain" is toiled and little known.

The following examples, for you to show the world class "model workers" style.

1. About the domain shortcut keys and preliminary knowledge

Insert Airspace

Ctrl + F9. Inserts airspace with the key combination that looks like a pair of curly braces--{}. In which the domain name "time" is entered, example 1:{times}, which is to display the current system timing.

Switch between field codes and field results

Example 1 does not appear as expected for a field result that looks like "2:51:47 PM". and navigate to the field (or the internal field code, the following operations are positioned first), press the combination of "shit + F9" to toggle the display of field results and field codes, to get what they want.

Update fields

"2:51:47 PM" does not always move, unless you manually update it (press F9), or until other events that cause a domain update (print on) occur. If you need to update all the fields in the document at the same time, select All, and then F9.

Locking and unlocking

Lock: Ctrl + F11; Unlock: Ctrl + Shift + F11; is a pair of inverse operations.

Avoid the domain being updated, use the locked domain operation, the locked domain can be updated, first unlock;

The update is not valid until the lock is unlocked when the domain of Example 1 is locked.

Unlink a field

Ctrl + Shift + F9. This action converts the field to regular text and is irreversible. Paste from the content of the page, to cancel the inclusion of a large number of hyperlinks, first select all after the conversion.

Conversions are not supported for all domains.

Domain switches and their directives

The code in the field code that controls the final display of results. The field switch is preceded by a backslash "" with multiple characters, spaces separated, and switch instructions followed. There are two broad categories of general switch and proprietary switch.

General switch three kinds: format switch (*), digital picture switch (#), Date time switch (@);

A wide range of special switches, because the domain name varies, with a backslash plus one or more letters as a sign.

Example 2 contract, note in the case of RMB capital format:

field code: {= 123.45 * Chinesenum4} field result: One to three Yuan restaurant corner Wu

"CHINESENUM4" is the Chinese currency Capital Format directive.

Example 3 Foreign trade export Enterprise Order-only figures in English

field code: {= 123.45 * cardtext * Caps} field Result: One hundred twenty-three

"Cardtext" is a digital English ordinal order, the "Caps" instruction is capitalized in the first letter of the word, and a field may have multiple instructions.

Example 4 Accounting statistics thousand digits:

field code: {= 123.45*10^8 # "#,###"} field results: 12,345,000,000

"#" in "#,###" is the number placeholder "," is the thousand separator.

Example 5 Flexible Date-time switch instruction:

field code: {Time @ "H mm minute"} Field results: 14:51

"H" in mm is 24 hours per hour ("H" is a 12-hour system), "MM" is two-digit number of minutes.

Example 6 simple mathematical expressions, using a formula field is better than using the Equation Editor:

field code: {Eq F (-b±r (B2-4AC), 2a)} field Result:

EQ Domain Special switches and instructions: "F (numerator, denominator)" Table fraction, "R (bottom)" table radical.

Nesting of domains

Field codes can contain fields.

Example 7: {= if ({time @ "H"}>12, "Good afternoon!", "Good Morning!")}, not later than 12 o'clock display as: Good morning!, otherwise the display is: Good afternoon!

Through the Table menu-Formula, dialog box "Paste function" listed functions, "if ()" in which the syntax is: if (judgment, true, false), when the "decision" is established, take the "true" representative of the result, otherwise "false".

2. Insert page numbers with special requirements

Example 8 as shown above, a piece of paper is divided into 4 columns, each column page number is:

{={Page * Arabic}*4-3} {={Page * Arabic}*4-2} {={Page * Arabic}*4-1} {={Page * Arabic}*4-0}

"* Arabic" is a general format Arabic numeral instruction.

3. Simple calculation

All the participating operations are half-width symbols.

Example 9 field code: {= (1+2-3) *4/5^6} field result: 0

Example 10 references a mathematical expression "3.14 * 3^2" that already exists and is evaluated.

Select the expression in quotation marks and add a bookmark named "Circles", and then reference the bookmark in the Equality field:

field code: {={ref circles} # "garden area =#.00 (sqm)"} Field results: Garden area = 28.26 (sqm)

The advantage is that when the original expression is partially changed, the solution simply updates the field.

4. In-table statistics

Table internal and external data refer to each other, please refer to Example 10.

The same table, the data reference is relatively simple. In the same way as the ET spreadsheet, the sequence is preceded by a letter, followed by a number indicating the line number. See the last column in the following table.

Table 1 Cell references

SUM () is a sum, and the internal parameter is one or comma-separated multiple, the parameter type is a constant, a computable expression, a reference

5. Imitation random number generator and multi-digit problem

Example 11 imitation random number generator (domain 0-99):

field code: {=mod ({time @ "s"}*{seq kgs},100) # "#"}

The SEQ field inserts an automatic serial number and uses the "C" switch to control the insertion of the nearest previous value {Seq kgs c},mod () remainder function.

Use this code to generate the number of multi-digit questions: 43+86; 18-20; 40x54; 33÷68 ...

Note: 1 To make these operands look more like randomly generated, avoid updating multiple fields at the same time; 2 to ensure that the subtraction is not negative, the division value is an integer, plus the "C" switch control, and the two fields are updated at the same time. The signal is as follows:

{=mod (...) *mod (.....) {Seq kgs} ...) ...} ÷{=mod (.....) {Seq kgs C} ...) ...} =

To provide a reference answer to a job: {=A1+C1} (operands and operators are placed in a table)

Determine whether the student input is correct using: {=if ({=a1+c1}=d1, "√", "X")}

6. To extract the birthday of the ID number

Assuming that a table B1 is filled with 18 ID number: 12345619870123956x, enter the following code in the target unit to extract the birthday:

field code: {=if (B1>10^17,int (b1/10^4), int (b1/10^3)) # "x000 Year 00月 00"}

Field results: January 1987 23

The "x" instruction discards the left digit of the placeholder, "0" is the digit placeholder, and int () is the integer function.

7. "Expired" decision

Example 12 determines whether the system date is over set (in this case, 2012/12/31)

field code: {=if (20121231>{date @ "YYYYMMDD"}, "make every day in life a last day." ", Expired)}

8. Self-creating characters

Example 13 "question" "questions" symbol.

Field codes: {Eq O (t, Gates)} field results:

The "o" instruction followed by a symbol superimposed on the previous symbol.

Example 14 uses "█" to make the mask, occupies the position with the space.

Field codes: {eq O (FAI, █, Month)} field results:

Underline position is white (background color) "█" symbol, small fifth word, the remaining is fifth words; █ a space adjustment placeholder before "month".

Example 15 the word "Earth" created by Wu Zetian

Field codes: {eq o A (sup4 (mountain), water, Sdo4 (soil))} field results:

"s" superscript switch, "Up4" offset 4 points up, "Do4" downward offset 4 points. "Landscape soil" 7th Word, Zoom 200%

Example 16 with font elevation scaling.

field code: {Eq O (辶, lucky, Treasure, Recruit)}

Field results:

In order to avoid, the use of a number of fifth space occupies a position, take: "辶" the first 3, "good" after 2, "recruit" the first 2;

Font settings reference: "辶" XXFarEastFont-Arial, no. third, Zoom 190%; "XXFarEastFont-Arial, No. Fifth, bold, scale 66%, increase 1.06 mm;" Treasure "founder Shu body, second number, scaling 66%, lifting 1.06 mm;

The Paragraph text baseline is aligned.

9. Equations

Example 17 leading and field codes: {{Eq aal (2x2+y=5,3x-y=0)} results: {

"A (,)" column two-dimensional matrix switch, "Al" Left alignment correction switch.

10. Clone labels with ref fields

A piece of paper, print cut multiple rows of small labels, recommend the use of the "Ref" field to clone multiple replicas.

Reference practice: Divide the table into multiple label areas, design the first label, select the cell, and define the bookmark "BK" to insert the {REF BK} field in the other cells.

If you want each label to have a different serial number (ticket ticket, etc.), insert a text box at the print ordinal position, and set the item number (table 2)

Table 2 Label typesetting

11. Other common fields

form fields: By trying the menu-toolbar-form, the toolbar contains a variety of form fields, which are especially useful when designing users to fill out forms;

DocVariable field: Refers to document-named variables that must be programmatically assigned to the following code:

Thisdocument.Variables.Add "Layout description", "This document, no reference to external graphic images"

Use of the field in the document after assignment: {docvariable typesetting description};

The TOC field is used to create a document directory;

The Mergefield field, which displays data in a mail merge.