November 25, 2013

How to Insert Text Form Field in Writer 2013

In Writer 2013, you can add form fields to your word document, and also lock the form to protect other content in the form from deleting or editing.

Insert Text Form Field

Text form field is useful for formal documents which are created for distribution purpose. People who receive this document can easily fill out the form by the suggestions in the text form field. Follow these steps to insert text form field.
Step 1 Open the document you want to insert text form field with Writer 2013.
Step 2 Place the cursor in a desired location in the document, and click on Insert tab. Find Text Form Fieldoption and click on it. In this example, we replace the text of [Street Address] with a text form field.
text form field
Figure 1 Insert Text Form Field
Step 3 The text form field is successfully inserted. You will see that the text form field displays as a gray area. Double click on the gray area to bring up Text Form Field Options dialog.
text form field
Figure 2 Set Text Form Field Properties
In this dialog, you can set the default text shown in the text form field and its case. This can tell readers what content should be filled in.
Step 4 Press OK. Now do the same with other parts of the document and save it.
Text form field is successfully created.
Note: Add shading to text form field will help readers easily recognize it as a field (see Figure 1).

Protect Text Form Field

To prevent others from editing the form, you can protect the form by locking it.
Step 1 Open the form document with Writer 2013.
Step 2 Go to Insert > Protect Form (see Figure 1). Click on Protect Form to lock the form. Then you will see that only the form fields can be edited. And on the menu bar of Writer, most options are grayed out.
To protect the form fields with a password, please go to Review > Document Protection. Click on Document Protection option and in the dialog that pops up, select Form fields and enter a password. Then press OK to finish.
protect form field
Figure 3 Protect Form Field with a Password
To remove the password, go to Review and click on Remove Protection, and enter the password to remove it.

November 19, 2013

How to Copy only Visible Cells in Spreadsheets

When working with workbooks, sometimes there are hidden cells or columns. You have the option of copying all the cells or only the visible cells. By default, Kingsoft Spreadsheets copies all cells including hidden ones. If you want to prevent the hidden cells from being copied, follow the steps in this article to copy visible cells only. See how to hide rows or columns in Spreadsheets.
In default, hidden cells are copied:
hidden cells are copied

Change Spreadsheets to copy only visible cells

Step 1: Select the data range you want to copy.
Step 2: Press Ctrl+G and then the Go to dialog box shows up.
copy visible cell only
Step 3: Select Visible cells only and click Go to.
Step 4: Copy data and paste. Thus the data won’t contain the hidden rows or columns.
copy only visible cells in spreadsheet

Download Kingsoft Office Free 2013 to create free workbooks.

How to Insert Drop-Down Form Field in Kingsoft Writer

How to Insert Drop-Down Form Field in Kingsoft Writer

In Spreadsheet, it’s easy to create a drop-down list and input date efficiently. But how can achieve the same effect in Writer tables? Here is a guide to teach you how to insert drop-down form filed in Writer.
Step 1: Place the cursor in the cell and click the Drop-down From Field option under Insert tab. Then a gray area(form field) will appear in the cell.
 create drop down form field
Step 2: Double click the gray field to bring up the Drop-Down Form Field Options dialog box. Click Add in the Item in Drop-down list box to enter and edit relevant information. Then check the Drop-down Enabled box.
drop down form field options
Step 3: Copy the already-set form field to other cells in this column. Select Protect Form button, cells without form field will be locked. Now, when click the cells with form field, you will see a drop-down list.
set protect form
Note:
1. When you turn to edit other cells without form field, you have to click the Protect Form button again to set the locked cells free to be edited.
2. When the form field is created, there will be gray shading in the cell, which will appear when printing. To remove the shading, just click the Form Field Shading button as shown:
remove form field shading
Download free Office 2013 to create drop-down form field.

November 14, 2013

How to Create Chart in Document with Writer 2013

You can create a chart in document with the data in a spreadsheet file. The chart is edited in Kingsoft Spreadsheets.
To create a chart based on the spreadsheet data, take the following steps.
Step 1 In Writer 2013, go to Insert > Chart. Kingsoft Spreadsheets is opened automatically.
create chart in word
Step 2 In Spreadsheets, a default chart is displayed. The chart is based on the data in the selected area above the chart.
create chart from data
Step 3 To plot different data to the chart, you need to enter your own data in this workbook, or open an existing workbook. To select the new data, click to highlight the chart, and go to Chart Tools > Select Data. See below:
select data for chart
In the Source Data dialog, delete the data range data and then click the select data for chart button in Data range box.
select data for chart
Then on the worksheet that contains your data, hold Ctrl and select the data area (with the labels) you want to plot in the chart. Press Enter to finish.
select data for chart
The chart is plotted with the new data. Press Ctrl+S to save the spreadsheet file and the new chart is successfully inserted to Writer. You can close Kingsoft Spreadsheets and continue editing the document.