With the functions in Symphony 3, we can construct array formula to search for the strings by multiple keywords. There is an example: QUESTION: Now, we have some text in cell range A2:A12 which has been named "Sourcetext". The text in cell D1(named "Str1" ) and D2(named "Str2"), are the ...

If you want to display Arabic numerals as Chinese numerals in Spreadsheet, you can follow these steps: 1. Select a cell and click menu "LayoutPropertiesText and Cell Properties...". 2. Select "Numbers" tab. 3. Change category to "Number" and language to "Chinese (simplified)". 4. Input ...

Symphony 3.0 supports formulas with Excel wildcard with some restrictions In Excel, some formulas can support wildcard(, ?, ~). When open Excel file in Symphony 3.0, Symphony can calculate these formulas correctly if these formulas have wildcard. User can also edit these formulas with wildcard in ...

How to make a diagonal separated table head which is widely used in China? In China, people are used to create diagonal separated table head just like following. Symphony do not have a predefined function to support it. But user can still create a similar one by existed function. 1)add a diagonal ...

How to make text formatted number real number? Sometimes, people may get some ods or xls document which contain some text formatted number. It will not work if we use these text formatted number as number in some situation. For an example, using text formatted number to do auto group in ...

Suppose we have a sales data table like following, only parts of data is shown We can create a DataPilot for it. The Page field is Year. The row field is Sales. Following is DataPilot for it. Click page field selection button to open page field member selection window. We find the source data ...

Text to Columns is a feature that was requested and required by many users. This tool allows users to separate data in cells into columns. Now we have this feature in IBM Lotus Symphony 3. Here we have an example, a spreadsheet containing data of employee of a department, but the data are in one ...

If you use a cell range as the value for a validity list, you may wish to add rows to that range to add new values to the list. The problem is that if you specify a cell range use the sheet, column and rows (example: A.C4:C8 or A.C4:C8), when new rows are added the list will not adjust to ...

You can set one or more rows and/or column(s) to print on each page of a spreadsheet. This can be useful when you have several pages to print, or when you want to print just a selection of data but n

Introduction Office Automation Developers find it necessary to update and change components based on a change of state in a document.  There are a few ways to monitor the changing state of a document: listen to the state change, test the document timestamp and see if the timestamp changes, and ...

This demonstration shows you how to use keyboard navigation to perform common tasks in Lotus Symphony Presentations.  You will learn how to navigate through spreadsheets, select and edit cells and cell ranges, and select and edit graphing objects.

This demonstration shows you how to use keyboard navigation to perform common tasks in Lotus Symphony Spreadsheets.

It's always useful to make selection list for a cell. For example, you may create a drop-down list for a cell with various options. In Symphony Spreadsheets, you may use Validity to do the trick. F

By default, if there's no print range defined, all contents in the worksheet will be printed out. Sometimes, when you need to print out specific area within the large spreadsheet. It would be useful i

Does anyone know how to install excel essbase plugin on a lotus symphony application? Essbase is used to query various APEX reports To install the plugin you can use the Plugin Install Guide http:www.ibm.comsoftwarelotussymphonyplugin.nsfInstallationGuide?opentypeguide

At any time editing the document, you can select from menu: File - Security - Document Protection and save the file. There you can set or clear the password ( for opening in the future ) which consist