Here is a collection of hints and tips on best practises
of using the spreadsheet editor and they are written by our in-house
experts.
Adjusting axes in a bar chart
In a bar chart of IBM® Lotus®
Symphony™, the
X axis is vertical and displayed in a reversed direction with the
source data by default. You can adjust the axes by doing the following
steps.
Managing automatic calculation through macros IBM Lotus Symphony Spreadsheets provides
a Universal Network Objects (UNO) interface to manage automatic calculation.
You can use the interface to enable or disable the automatic calculation
function.
Converting cell addresses
In IBM Lotus Symphony Spreadsheets, a referenced
cell address is relative by default. When you copy a referenced address
from one cell to another, it changes automatically. You can convert
a relative cell address to an absolute cell address and vice versa.
Creating and deleting page breaks
In IBM Lotus Symphony Spreadsheets, you can create
and delete page breaks. You can delete only the user-defined page
breaks, not the automatic page breaks created by Lotus Symphony. If you are under the page
break view, you can also create and delete page breaks by right-clicking
the cells.
Creating and assigning macros
This section describes how to create and assign macros
in IBM Lotus Symphony Spreadsheets through an
example.
Creating named ranges
This section provides different ways to create named ranges
in IBM Lotus Symphony Spreadsheets.
Creating sheets
This section provides several ways to create sheets in IBM Lotus Symphony Spreadsheets.
Displaying column number
In IBM Lotus Symphony Spreadsheets, columns are
referred in letters. You can display columns in numbers by using a
formula.
Filtering help information in IBM Lotus Symphony
In IBM Lotus Symphony, pressing F1 opens Help and
usually takes you straight to a relevant page. If that page does not
contain what you need, do the following steps to filter the help information.
Referencing data in a spreadsheet
You can reference data from other cells or sheets in the
same document. The result data changes accordingly when the source
data has changed.
Transforming text-formatted numbers into numbers
When numbers are formatted as text in IBM Lotus Symphony Spreadsheets, some functions
that are related to numbers become unavailable. To change the text-formatted
numbers back to real numbers, one way is to reenter the numbers after
modifying the cell properties. If you have a column of text-formatted
numbers to transform and do not want to reenter the numbers, use the
following way.
Ways to import external data
In IBM Lotus Symphony Spreadsheets, you can import
external data in the following ways. You can also import data as a
link by selecting the Link option.