How to Use Wildcards to Search for Certain Characters in Writer 2013

The Search and Replace feature built into Kingsoft Writer includes two different search methods.

Method 1 You can search for simple items such as text or special characters using the Find feature.
Method 2 You can search for text using wildcards for pattern matching and therefore is more powerful than the first one.

By using the second method you can search for very complex character sequences in your document. The following table will introduce the wildcards and their corresponding meanings.

Related articles:

Search and replace specific formatting
Use Go To feature
Find and replace text and objects

Wildcards List

Find What	Wildcards	Example	Finding Result
Any single character	?	t?p to search for the letters t and p separated by one character.	tip, type, etc.
Characters of any length	*	c*n to search for the letters c and n separated by characters of any length.	can, command, etc.
The beginning of a word	<	<(com) to search for words that begin with com.	come, command, etc.
The ending of a word	>	>(er) to search for words that ends with er.	water, writer, etc.
One specified character	[ ]	co[mn]e to search for words with a letter (either mor n) between o and e.	come, cone, comet, etc.
Any single character within a specified range	[-]	[r-t]ight to search for words that begin with eitherr, s or t. Note that the range must be sorted ascending.	right, sight, tight
Any single character outside a specified range	[!x-z]	t[!a-m]ck to search for words with the letter between t and c not from a to m.	tock, tuck
Any number of the previous character	{n}	fe{2}d to search for words feed but not fed.	feed
At least the specified number of the previous character	{n,}	fe{1,}d to search for words with at least one ebetween f and d.	fed, feed
A specified quantity range of the previous item	{n, m}	10{1,3} to search for number with one, two or three 0.	10, 100, 1000
At lease one of the previous character	@	lo@t to search for words with at least one obetween l and t	lot, loot

Use wildcards to find and replace text

Step 1 Press Ctrl + F to bring up the Find and Replace dialog box.

Step 2 If you cannot see the Use wildcards check box in the popup Find and Replace dialog box, click theMore button and then tick the Use wildcards check box.

Figure 1 Search and replace text with wildcards

Step 3 Enter one wildcard in the Find what box. For example, if you want to find "tip", "step", and "type" or similar words, you can type t?p in the Find what box.

• 1. If you want to replace what you have entered in the Find what box, click the Replace tab and then enter the text you want to use as a replacement in the Replace with box.
• 2. If you want to highlight the results, tick the checkbox before Higlight all items found in, and click Find Allbutton. You can apply font style or font color to the highlighted items.

Tips: You can group the above wildcards to search for text or special characters as you need. For instance, enter the wildcards <(pre)*(ed)> in the Find what box to search for presorted, prevented, etc.

Step 4 Press ESC to cancel the current search.

How to Merge or Split Cells and Table in Writer 2013

Knowing how to merge or split table cells can come in handy when you are working with a table. You can merge two or more adjacent cells into one cell and you can also split a cell that has been joint.

Merge Cells

To merge cells:

Step 1 Select the cells which you want to join into one cell.

Step 2 Select the Table Tools tab and click the Merge Cells icon  to combine the selected cells.

Split Cells

To split cells:

Step 1 Select the cell that you want to split into multiple cells.

Step 2 Choose the Table Tools tab, click the Split Cells icon , and open the Split Cells dialog box.

Figure 1 The Split Cells dialog box

Step 3 Enter the number of columns or rows that you prefer into the Number of columns and Number of rows insertion box.

Step 4 If you select several cells, you can select the Merge cells before split check box to combine cells before split.

Step 5 Click OK to complete the operation.

Split tables

Kingsoft Writer provides a table splitting function. There are two ways to use this function:

Split tables by the Split Table icon

You can split tables by command in the Table Tools tab:

Step1 Place the insertion point in the cell that you want to split and go to the Table Tools tab.

Step 2 In the Table Tools tab, click the Split Table icon, and select Split Table by Row or Split Table by Column option in the drop-down list.

Split tables by the context menu

Follow the steps bellow:

Step 1 Place the insertion point in a cell.

Step 2 Right-click and select Split Table option in the context menu. Choose Split Table by Row or Split Table by Column option based on your requirements.

Tips: You can choose the Split Table by Row option only by selecting a certain row in the table and choose the Split Table by Column option only by selecting a certain column in the table.

Figure 2 Select a row to split table

How to Add a New Dictionary to Office 2013 for Spell Check

Kingsoft Office 2013 now supports 2 languages for spell check purposes - English (United States) and English (United Kingdom). To add new dictionaries to Kingsoft Office for spell check, please take the following steps.

Also read: How to Change Spell Checking Language in Kingsoft Office 2013

Add new dictionaries to Kingsoft Office for spell checking

Step 1 Download your desired dictionary files from the internet.

Step 2 Unzip the dictionary files and save the dictionary folder to this path:

Under Windows 8: C:\Program Files (x86)\Kingsoft\Kingsoft Office\office6\dicts

Under Windows 7: C:\Program Files\Kingsoft\Kingsoft Office\office6\dicts

Step 3 Launch Kingsoft Office to see the changes.

Go to Review > Check Spelling > Set SpellcheckLanguage (2013 interface) or Tools > Set SpellcheckLanguage (Classic interface), and the added dictionaries are listed in the following dialog:

How to Change Spell Checking Language in Kingsoft Office 2013

Kingsoft Office 2013 allows you to change the default English (US) spell check to a different language. Currently Kingsoft Office supports two languages, which include English (United States) and English (United Kingdom). You can also add new dictionaries to Kingsoft Office 2013, see this guide: How to Add a New Dictionary to Office 2013 for Spell Check.

Take the following steps to switch between different languages for spell check.

Change spell check language in Office 2013

Let’s take Writer 2013 as example.

Step 1 Open an existing document with Kingsoft Writer

Step 2 Under Classic interface, go to Tools > Set SpellcheckLanguage.

Under 2013 interface, go to Review > Check Spelling > Set SpellcheckLanguage.

Step 3 In the Set SpellcheckLanguage dialog, choose a default language for spell check and press Set as default. 

The default dictionary is successfully changed to English (United Kingdom). You will find that Writer automatically checks spelling according to your new choice of language. 

If you need to switch back to English (United States) dictionary, simply repeat the above steps again. See this video:

How to Restrict Users to Edit in the Specified Ranges of Worksheet

Sometimes, you have to give different levels of permission to people to edit in the same worksheet. Some people may only have the right to check out the data, while others could edit and save the data. This article will guide you to realize how to limit other users to edit in the specified ranges in Spreadsheets, by usingAllow Users to Edit Ranges button.

Step 1 Open an existing worksheet and go to Review tab, click Allow Users to Edit Rangesoption. The following dialog will pop up.

Figure 1 Allow users to edit ranges in worksheet

Step 2 Click New in button in the Allow Users to Edit Ranges dialog box (see Figure 1), and the New Rangedialog box will pop up (see Figure 2). Input the title of the new range.

Figure 2 Add new range for editing

Step 3 In New Range dialog box, click the fold button in Refer to cells field to select the cell range: B3:E6 in the workbook, and click the fold button again to return to the New Range dialog box.

Figure 3 Add new range to protect

Step 4 After going back to the New Range dialog box, click OK to confirm. If you would like to allow people edit this range, then you should not set the Range Password.

Step 5 After going back to the Allow Users to Edit Ranges dialog box, click OK to return to the workbook. Click the Protect Sheet button in Figure 1.

Figure 4 Protect worksheet with password

Step 6 In the Protect Sheet dialog box, set the password for the Select locked cells and Select the unlocked cells.

Step 7 After clicking the OK button, the Confirm Password dialog box will pop up. Reenter password to proceed. Then press OK.

Figure 5 Confirm password

The protection on the sheet is active now.

Notes:

1. You should keep the password in mind, after you set it, otherwise you will not be able to reedit the workbook, and that will bring you a lot of inconvenience.

2. Besides, users could set multiple editable ranges, and you could set different passwords for different ranges. And let different authorized people edit in different ranges. For example, in the “Employee Info” workbook, you could set different editable ranges for different departments, such as Human Resource, Business, or Sales department. So that different department can only edit in their relative ranges.

How to Repeat Header Rows of Table in Writer 2013

Header rows are the first several rows in a table. When you need a large table displayed in multiple pages, the header rows should be repeated in each page.

In Writer 2013, you can repeat header rows of table in your document. Follow these steps to repeat header rows.

Repeat header rows in table

Step 1 Select the table you'd like to repeat header row. 

Step 2 Select one row or several rows as the header rows, go to the Table Tools tab and click the Repeat Header Rows icon .

Tips: Kingsoft Writer can automatically repeat the header rows of the table based on the page breaks. However, if page breaks are manually set, then it cannot repeat the header rows.

How to Apply Border and Shading to Table Cells in Writer 2013

In Writer 2013, after you insert a table in the document, you can apply border and shading styles to the table. Follow this guide to apply border and shading to table.

Insert border and shading to selected cells

You can insert different borders and shading based on your needs by the following steps:

Step 1 Place the insertion point anywhere in the table and select the Table Tools tab.

Step 2 Click the Table Properties icon and open the dialog box.

Step 3 Click the Borders and Shading button and open the Borders and Shading dialog box shown as below:

Figure 1 The Borders and Shading dialog box

Step 4 Select the Borders tab and choose Table in the Apply to drop-down list.

Step 5 Select the border pattern in the Setting section.

Step 6 Select the style of the border line, such as the double-line option in the Style section. Meanwhile, an effect figure will appear in the Preview section.

Step 7 Select the color of the border in the Color drop-down list and select the width of the border line in the Width drop-down list.

Step 8 Click OK to exit.

Figure 2 A table with a border

Apply different border for different cells

To set different border for different cells within the same table, for example to change the bottom border line of the sixth row of a table into a thicker line by the following steps:

Step 1 Place the insertion point to the left of the sixth row of the table. After the cursor changed into an arrow, click the right mouse button to select the whole line:

Figure 3 Select the cells to add borders

Step 2 Click the Table Properties icon and open the dialog box.

Step 3 Click the Borders and Shading button and open the Borders and Shading dialog box.

Step 4 Select the Borders tab and choose Cell in the Apply to drop-down list.

Step 5 Select Custom option in the Setting section.

Step 6 Select single line in the Style section, select the color red in the Color drop-down list, and select 1.5 pt for the border line in the Width drop-down list.

Step 7 Click the Bottom border button  in the Preview section, or directly click the bottom border on the previewed table.

Step 8 Click OK to complete the operation.

Figure 4 Emphasized border

How to Enter Date and Time Quickly in Spreadsheet

Here today I summarize all the ways to input date in the Kingsoft spreadsheet, either quick ways, the normal ways or the advanced ways. I'll explain them in details as following:

Enter date directly and fast

A.Use the keyboard shortcuts:

Ctrl+; for current date

Ctrl+' for current time

B.Enter in the cells directly

3/25/2013 or 3-25-2013

Enter other types of date

Use Ctrl+1 to open the Format Cells, choose Custom and enter the format you want in the Type, for example m"."d"."yyyy;@, then you can enter 3.25.2013 in the cell.

Set the date format

Like you did as above, you can set the date format in the Date option by opening the Format Cells.

Use formula to enter date

Besides the above ways to enter date in spreadsheet, you can also use formula to achieve this, and in this way you can real-time update the date.

Formula=today( )

Formula=now( )

And don't forget to use F9 to refresh it!

How to Use Style Reference Field in Writer 2013

Writer 2013 allows you to insert StyleRef field into header and footer, so that the headings will be shown in header or footer of each page.Take the following steps to use StyleRef in Writer 2013.

Related articles:

Use a style
Apply or delete a style
Create or modify a style

Style Reference Field

To use style reference Field:

Step 1 Select the Header and Footer icon in the Insert tab to edit either the document Header or Footer.

Step 2 Move the cursor to the position where you want to insert the StyleRef.

Step 3 Click the Fields icon in the Insert tab. The Fields dialog box will open and show as follows:

Figure 1 The Fields dialog box

Step 4 Select StyleRef from the Field names drop-down list; choose a style in the Field code such as Heading 1.

Step 5 Press OK to finish. The inserted field will be in the Heading 1 in reference to the dynamic content displayed on each header or footer.

How to Use Wildcards to Search for Certain Characters in Writer 2013

The Search and Replace feature built into Kingsoft Writer includes two different search methods.

Method 1 You can search for simple items such as text or special characters using the Find feature.
Method 2 You can search for text using wildcards for pattern matching and therefore is more powerful than the first one.

By using the second method you can search for very complex character sequences in your document. The following table will introduce the wildcards and their corresponding meanings.

Related articles:

Search and replace specific formatting
Use Go To feature
Find and replace text and objects

Wildcards List

Find What	Wildcards	Example	Finding Result
Any single character	?	t?p to search for the letters tand p separated by one character.	tip, type, etc.
Characters of any length	*	c*n to search for the letters cand nseparated by characters of any length.	can, command, etc.
The beginning of a word	<	<(com) to search for words that begin withcom.	come, command, etc.
The ending of a word	>	>(er) to search for words that ends with er.	water, writer, etc.
One specified character	[ ]	co[mn]e to search for words with a letter (either m or n) between o and e.	come, cone, comet, etc.
Any single character within a specified range	[-]	[r-t]ight to search for words that begin with either r,s or t. Note that the range must be sorted ascending.	right, sight, tight
Any single character outside a specified range	[!x-z]	t[!a-m]ck to search for words with the letter between t andc not from a to m.	tock, tuck
Any number of the previous character	{n}	fe{2}d to search for wordsfeed but not fed.	feed
At least the specified number of the previous character	{n,}	fe{1,}d to search for words with at least onee between fand d.	fed, feed
A specified quantity range of the previous item	{n, m}	10{1,3} to search for number with one, two or three 0.	10, 100, 1000
At lease one of the previous character	@	lo@t to search for words with at least one obetween l andt	lot, loot

Use wildcards to find and replace text

Step 1 Press Ctrl + F to bring up the Find and Replace dialog box.

Step 2 If you cannot see the Use wildcards check box in the popup Find and Replace dialog box, click the More button and then tick the Use wildcards check box.

Figure 1 Search and replace text with wildcards

Step 3 Enter one wildcard in the Find what box. For example, if you want to find "tip", "step", and "type" or similar words, you can type t?p in the Find what box.

• 1. If you want to replace what you have entered in the Find what box, click the Replace tab and then enter the text you want to use as a replacement in the Replace with box.
• 2. If you want to highlight the results, tick the checkbox before Higlight all items found in, and click Find All button. You can apply font style or font color to the highlighted items.

Tips: You can group the above wildcards to search for text or special characters as you need. For instance, enter the wildcards <(pre)*(ed)> in the Find what box to search for presorted, prevented, etc.

Step 4 Press ESC to cancel the current search.