Importing existing spreadsheets

After you upload IBM® Lotus® Symphony® spreadsheets or other spreadsheet file types to your files list, you can import them so that you and others can work with them in web browsers.

About this task

Supported formats include .ods, .ots, .xls, .xlsx, .xlt, .xltx, and .csv. To import an existing spreadsheet, perform the following steps:

Procedure

  1. Upload a file to the Connections Files application.
  2. Click My Files.
  3. Find the file that you want to open in IBM Connections Docs, and click the file name to go to a page with actions that you can take.
  4. Click Edit to automatically import the file into Connections Docs format.
    Note:
    • Only spreadsheets with 20,000 rows or less and 1,024 columns or less can be opened.
    • If the spreadsheet is a template file with a format of .xlt, .xltx, or .ots, click Create File. A New from File window opens. Type a file name and then click Create. The template file is imported into Connections Docs and a new spreadsheet that is based on the template file is created at the same time.
  5. Optional: If you want to return to the files list, clickopen files list button on the toolbar.

If you are using IBM Content Navigator:

  1. Find the file that you want to open in IBM Connections Docs.
  2. Right-click the file and select Edit in Docs.

Results

Note:
  • Occasionally, certain formatting from uploaded files does not display precisely in Connections Docs, yet is preserved in the file. For example, for an unsupported formula, you see the formula name in the cell instead of the calculated value. In these cases, once a version is published, you can download the file back to its original format.
  • You can import .xlsx files that contain .jpg, .jpeg, .png, .gif, and .bmp images. You can also import .xlsx files that contain .wmf, .emf, .tif, and .tiff images, but these file types are converted to supported types during the import.
  • Data validation that was previously set in an .xlsx, .xls, or .ods file works properly after the file is imported to Connections Docs. Within a range, such data validation still functions when you use autofill to add data to cells in the range, and when you cut or copy the range and paste it to another range.