Welcome
Using HCL Connections Docs 2.0.2
Welcome to the HCL Connections Docs 2.0.2 documentation, where you can find information about HCL Docs 2.0.2. HCL Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
Using HCL Docs
HCL Connections™ Docs is a new office productivity suite for working on documents, spreadsheets and presentations together. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
Working with spreadsheets
Calculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
Spreadsheets quick reference
This topic helps you discover or remember how to do certain spreadsheet tasks.

Deploying HCL Connections Docs 2.0.2
Welcome to the HCL Connections Docs 2.0.2 documentation, where you can find information about installing and deploying HCL Docs 2.0.2. HCL Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
Using HCL Connections Docs 2.0.2
Welcome to the HCL Connections Docs 2.0.2 documentation, where you can find information about HCL Docs 2.0.2. HCL Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
- Using HCL Docs
  HCL Connections™ Docs is a new office productivity suite for working on documents, spreadsheets and presentations together. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
  - Supported browsers
    See what Web browsers are supported by HCL Connections™ Docs.
  - What's new in HCL Docs 2.0.2
    Learn about new features and functions in HCL Docs 2.0.2.
  - Publishing a version of a file
    In order for readers to see a draft created in HCL Connections Docs, or edits made in Docs, a new version of the file must be published. As of August 2015, if a file is being created or edited in Docs for the first time, publishing is set to occur automatically. If a file was previously created or edited in Docs, you must either enable the Publish Automatically command in that file, or publish each new version manually.
  - What if I have a file conflict?
    A person can decide to upload a new version of a file while another person is editing the file online or has saved an online file that is not yet published. The new uploaded version is stored in Files as its own version number, and you are warned of the conflict the next time you try to edit the file from the Files list.
  - Reverting to last version
    When you are editing in HCL Connections™ Docs, if you are not satisfied with the current version of your document, you can revert to the last version that was published. You can choose to save or discard your current edits before you revert to the last version of a document.
  - Viewing a file by using the viewer
    You can view an uploaded document, spreadsheet, presentation, or PDF file while you are working in Files.
  - Accessibility features for HCL Docs
    Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
  - Working with documents
    Work on a document by yourself or collaborate on files with your colleagues. You can comment on a document, or even participate in a discussion. All this in real-time. Upload an existing Open Document Format or Microsoft™ Word file or create a document to begin.
  - Working with spreadsheets
    Calculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
    - Creating and importing spreadsheets
      Learn how to create spreadsheets and work with existing spreadsheets in your web browser.
    - File compatibility and exporting spreadsheets
      Find out which file types you can use with HCL Connections™ Docs spreadsheets.
    - Working with spreadsheets in Content Navigator
      If your organization uses IBM Content Navigator as its file repository, see the following topics to learn how to create, import, check in, and save spreadsheet files in the repository.
    - Sharing spreadsheets
      You can make a spreadsheet public for anyone to read, or share it with specific people and communities. You can allow people to edit a spreadsheet and even share it with others. You can also change or delete access levels after you share a spreadsheet.
    - Collaborating on spreadsheets in real time
      You can collaborate on a spreadsheet in real time with others as a team. You can co-edit with other editors in real time, and create comments and discussions.
    - Changing the look of your spreadsheets
      Simple enhancements to the way your spreadsheets look can improve their effectiveness.
    - Managing sheets in spreadsheets
      You can insert a sheet into a spreadsheet, and then move, rename, hide and show the sheet. For an overview of the basics and for tasks that you might need help with, see the following topics.
    - Formatting numbers
      A number can look different from the actual value entered in a cell, depending on the number format. Number formats differentiate one kind of data from another; for example, currency from percentages. Number formats affect only how HCL Connections™ Docs displays numbers, not how it stores or calculates numbers.
    - Entering and editing data
      Most editing tasks in HCL Connections™ Docs are easy to do on your own. For an overview of the basics and for tasks that you might need help with, see the following topics.
    - Working with images in spreadsheets
      You can insert an image into a spreadsheet, and then resize and move the image.
    - Working with charts in spreadsheets
      You can insert a chart into a spreadsheet, and then resize, move, and delete the chart.
    - Managing data ranges
      Learn how to sort data in a sheet or range and reference data that is on a different sheet.
    - Using formulas in calculations
      This section provides background information on formulas and functions, and organizes the functions in alphabetical order or by category to make it easy to find related functions.
    - Spreadsheets quick reference
      This topic helps you discover or remember how to do certain spreadsheet tasks.
    - Spreadsheets keyboard shortcuts
      You can use shortcut keys to perform tasks in spreadsheets. All shortcuts are valid on Windows™ operating systems. On Mac OS, press Command instead of Ctrl.
  - Working with presentations
    Create high impact, professional presentations. Or, you can upload existing presentations from your computer to HCL Docs Cloud for online editing. You can edit presentations with your colleagues in real-time and collaborate with others through comments and discussions.
  - Glossary
  - Notices
API Reference
APIs are available for developers who are creating applications that integrate social capabilities, features, and functionality. Most APIs use the Open Authorization (OAuth) protocol for authentication and authorization. OAuth is a protocol that provides a way for a third-party application to interact with an API on a user's behalf without knowing the user's authentication credentials.

Spreadsheets quick reference

This topic helps you discover or remember how to do certain spreadsheet tasks.

Table 1. Working with cells, rows, and columns
How Do I...	Action
Merge or split cells?	Select the cells or cell, and click the Merge or Split Cells icon .
Wrap text in a cell?	Select the text and make sure the Format > Wrap Text command is selected.
Add a hyperlink in a cell?	Click the cell and type the URL you want to link to from the cell (for example, http://www.ibm.com). Press Enter.
Hide or show rows?	Select a row or multiple contiguous rows. To hide rows, click Format > Hide Row. To show rows previously hidden, select some rows that contain the hidden rows and click Format > Show Row.
Hide or show columns?	Select the column you want to hide, and click Format > Hide Column. To show a column previously hidden, select the column after the hidden column and click Format > Show Column.
Insert rows above or below?	Select a row or multiple continuous rows, and click Insert > Row Above or Row Below to insert rows. The inserted rows style follows the most bottom row style of selected rows.
Insert columns before or after?	Select a column or multiple continuous columns, and click Insert > Column Before or Column After to insert columns. The inserted columns style follows the most right column style of selected columns.
Resize a row or column?	Drag the border of the header for the row or column.

Table 2. Working with data
How do I...	Action
Change the number format of selected data?	For currency or percent formats, select the cell or range and click the Format as Currency icon or Format as Percent icon . For other formats, click Format > Number and select a format from the list.
Return selected data to the default number format?	Select the cell or range for which you want to change the number format, and click Format > Remove Formatting.
Change future number formats to conform to a different language?	Click File > Set Document Locale and select the locale that you want.
Have numbers be recognized as text?	Type an apostrophe (') before the number.
Enter a formula in a cell?	Select the cell and, beginning with an equal sign (=), type the formula in the formula bar while the cell is selected.
Enter a function in a cell or formula?	Click in the cell or formula bar, click the All Formulas button, and select a function from the list. Tip: To quickly enter the SUM or AVERAGE function, select the cell, range, or column that you want to apply the function to and click Insert > Function.
Find, edit, or remove named ranges?	Click Insert > Named Range > Manage Ranges.
Sort the order of data in a range?	Click Data > Sort and then select Ascending or Descending.
Filter data that you want?	Click Data > Instant Filter.
Copy and paste data?	Select the cell or range that you want to copy and press Ctrl+C. Click the location where you want to paste the data and press Ctrl+V.
Cut and paste data?	Select the cell or range that you want to cut and press Ctrl+X. Click the location where you want to paste the data and press Ctrl+V.

Table 3. Working with text files
How do I...	Action
Import text files to spreadsheets?	Click File > Import.
Export spreadsheets to CSV files?	Click File > Download > CSV.

Table 4. Changing the look of your spreadsheets
How Do I...	Action
Add a background color to a cell or range?	Select the cell or range and click the Set Background Color icon .
Add a border to a cell or range?	Select the cell or range and click the Set Border Color icon .
Align text within a cell?	Click Format > Align and then select the appropriate alignment option.
Change the color of text?	Select the text and click the Set Font Color icon .
Return to default appearance?	Select the cell or range that you want to change and click Format > Remove Formatting.

Table 5. Collaborating with others in real time
How Do I...	Action
Share the current document?	Click File > Share.
Make updates available to people you shared with as Readers	Make sure File > Publish Automatically is selected, or click File > Publish Now.
Add a comment?	Place the cursor where you want to add a comment and click Team > Add Comment.
Open or close co-editing indicators?	Click View > Co-editing Highlights.