What is the purpose of the .SXC file format?
The .SXC file is one of the Lotus Symphony Spreadsheets format.
The SXC represents the Open Document Format 1 or later and is included for backwards compatibility. The recent version 3 or later Open Document Spreadsheet format uses the new file extension of .ODS. By default, Lotus Symphony Spreadsheets saves documents using the Open Document Format version 3 or later format (ODS).
Back to top
How can I import data into Lotus Symphony Spreadsheets?
Five methods of importing external data into Lotus Symphony Spreadsheets are available.
- Open a .CSV file to import data.
- Copy and paste from a tab-delimited .TXT file.
- Create a sheet by importing data source from files by clicking Create > Sheets.
- Import data by clicking Data > Import Data to open the external data.
- Import external data using an API.
Back to top
Does Lotus Symphony Spreadsheets support pivot tables?
Yes, Lotus Symphony Spreadsheets provides an alternative function, the Datapilot, which you can access by clicking Data > DataPilot. It provides the major functions that pivot tables offer.The Lotus Symphony DataPilot UI is friendly and easy-to-use.
Back to top
Does Lotus Symphony support VBA macros?
Only Lotus Symphony Spreadsheets supports importing VBA macros. Editing and saving VBA macro is not supported.
See the wiki article for more detail information about Lotus Symphony VBA interoperability: http://www-10.lotus.com/ldd/lswiki.nsf/dx/Lotus_Symphony_VBA_API_documentation.
Back to top
How can I know what an error code means when I enter an incorrect formula?
Open the Lotus Symphony Spreadsheets online help, and then enter the error code formula in the Search field. The topic shows a table with all error codes and their meanings.
Back to top
How do I set the locale of currency and other measurements?
You can set currency and other measurements by clicking Layout > Properties > Text and Cell Properties.
Back to top
How can I make a customized spreadsheet template?
Save the example file as an .OTS file.
Back to top
How can I define and edit a printable area?
You can click File > Print Ranges > Define to define print range, and edit the printable area by selecting File > Print Ranges > Edit.
Back to top
Can I place absolute references in a cell?
Add the dollar sign($) to both the column header and the row line number, such as $A$123 to A123.
You can use the shortcut Shift+F4 to switch between absolute and relative references.
If you start with a relative address, such as A1, the first time that you press this shortcut key, both the row and column are set to absolute references ($A$1). The second time you press the key combination, only the row is set (A$1) is set. The third time, only the column ($A1) is set. If you press the shortcut key once more, both column and row references are switched back to relative references (A1) .
Back to top
How do I place absolute references in a cell?
Select the cell and press Shift+F4.
Back to top
How do I make cells not capitalize the first letter automatically?
Click Tools > Instant Corrections. On the Options page, clear Capitalize first letter of every sentence.
Back to top
How do I add multiple lines of text in a spreadsheet cell?
To create a new line in a spreadsheet cell, press Ctrl+Enter or Alt+Enter.
You must edit directly in the cell, and not in the Input line.
Back to top
What are the row and column limitations in a spreadsheet?
The largest row number is 1048576 (1 million rows), and the largest number of columns is 1024.
Back to top
What type of charts are supported in a spreadsheet?
Lotus Symphony Spreadsheets supports the following chart type: column, bar, pie, area, line, XY (scatter), bubble, net, stock, column, and line.
Back to top
How do I set the secondary Y axis for a chart?
You can create a secondary Y axis by clicking Create > Axes when the chart is in edit mode. Then, you can assign a data series to the secondary Y axis on the Option page in the data series object properties winodw.
Back to top
How do I select a chart element within a chart and change its format?
In the chart edit mode, a list containing all chart elements shows in the formatting toolbar. Selecting an item in the list selects the element within the chart. Press Format Selection button next to the list to open the properties window for that element and change the formatting.
Back to top
Is the Show data as option for data fields available in the DataPilot in Lotus Symphony?
Select one DataPilot table. In the right DataPilot panel, double-click one data field in the data area to open the Data Field Option window. The function Show data as for data field is located on the Display Value page.
Back to top