How do I view formula in my spreadsheets instead of formula result?

You can view formula as follow:

1. Choose File > Preferences.
2. Choose IBM Lotus Symphony > Lotus Symphony Spreadsheets.
3. Select View and then select Formulas under the Page Display section.

Back to top

How do I edit a URL in a spreadsheet hyperlink?

1. Select an existing hyperlink by moving focus on the cell and pressing F2. When the cursor is located at the end of the cell string, press Shift+Right Arrow.
2. Choose Create > Hyperlink.
3. Edit the URL in the hyperlink dialog.

Back to top

What is the purpose of the .SXC file format?

The .SXC file is one of Lotus Symphony Spreadsheets format.

The SXC represents the Open Document Format 1.x and is included for backwards compatibility. The recent version 2.x Open Document Spreadsheet format uses the new file extension of .ODS. By default, Lotus Symphony Spreadsheets saves documents using the Open Document Format version 2.x format (ODS).

Back to top

How can I import data into Lotus Symphony Spreadsheets?

Three methods of importing external data into Lotus Symphony Spreadsheets are available.

1. Open a .CSV file to import data.
2. Copy/paste from tab-delimited .TXT file.
3. Import external data via exposed API.

Back to top

Why does Lotus Symphony Spreadsheets prompt to remove the password on an .XLS file, while Microsoft Excel opens the file without any password prompt?

Microsoft Excel file has the function of workbook protection password. So when the Microsoft Excel application opens this kind of file, it can parse the password and open the file smoothly. Lotus Symphony Spreadsheets does not recognize such file. So it will prompt to remove the password before opening it. Before opening the Microsoft Excel in Lotus Symphony, you should remove the password in Excel. The password can be removed by following these steps:

1. Open the .XLS file using Microsoft Excel.
2. Select unprotect worksheet or unprotect workbook from the Tool > Protection menu.
3. Remove all protection and save the file.

Lotus Symphony Spreadsheets now is able to open the .XLS file.

Back to top

Does Lotus Symphony Spreadsheets support pivot tables?

Yes. Lotus Symphony Spreadsheets provides an alternative function - the Datapilot, which you can access it by choosing Data > DataPilot. It provides the major functions that the Pivot table offers. What's more, Symphony DataPilot UI are friendly and easy to use.

Back to top

How can I know what an error code means when I input an incorrect formula?

Open the Lotus Symphony Spreadsheets online help, and then enter the error code formula in the Search field. The Error Code in Lotus Symphony Spreadsheets topic will show a table with all error codes and their meanings.

Back to top

How do I set the locale of currency and other measurements?

Choose File > Preferences > IBM Lotus Symphony > Regional Settings and then select the locale.

Back to top

How can I make my customized spreadsheet template?

Just save the example file as an .OTS file.

Back to top

How can I edit my printable area?

You can either choose File > Page Breaks, then right-click and select Define Print Range to edit the printable area or choose Layout > Print Ranges to edit the print range.

Back to top

Can I put absolute reference to the cell?

Add $ to both column header and row line number, like $A$123 to A123. You may use the shortcut key "Shift+F4" to switch between absolute reference and relative reference.

Back to top

How do I place absolute references to 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. You must be editing directly in the cell, and not in the Input line.

Back to top