Work with an AI assistant

Product: MyOffice Professional

Application: Spreadsheet Desktop version

Open the AI assistant

To open the AI assistant, do one of the following:

–On any tab except the Insert tab, click ui_toolbar_ai_assistant AI assistant.

–Right-click any cell or object to open the context menu, then run the Call AI assistant command.

Adjust the position and width of the pane

By default, the pane is located on the left. You can move it to any location within the main window or outside of it. To do this, proceed as follows:

1.Unpin the pane in one of the following ways:

•In the pane title bar, click ai_assistant_panel_unpin Unpin AI panel.

•Double-click the pane title bar with your mouse.

2.Drag the panel by its title bar while holding down the left mouse button.

To return the pane to its original position, do one of the following:

–In the pane title bar, click ai_assistant_panel_unpin Pin AI panel.

–Double-click the pane title bar with your mouse.

–Drag the pane by its title bar to the left edge of the window. When the workspace shifts to the right, release the left mouse button.

If you need to increase or decrease the width of the pane:

1.Hover your mouse cursor over the border between the pane and the workspace.

2.Drag the border to the right or left.

ai_assistant_panel

Chat with an AI assistant

The conversation with the AI assistant takes place in a chat. The user sends prompts to the AI assistant in any format. A prompt may involve receiving a text response (“How do I create a new sheet?”) or performing actions in the editor (“Create a new sheet”). The AI assistant processes the prompt, provides a response, and, if necessary, performs the specified actions.

Some editor features may not be supported by the AI assistant.

ai_assistant_panel_chat

To send a prompt, follow these steps:

1.If you need to use a specific area of the table when submitting a prompt, select that area on the sheet.

2.Click ai_assistant_panel_modes AI assistant modes and select a mode:

–Chat answers only: The AI assistant can engage in a chat conversation but cannot make changes to the document.

–Answers and editing: The AI assistant can engage in a chat conversation and make changes to the document. This mode is unavailable if the document is open in view mode.

3.Enter a prompt.

4.Click ai_assistant_panel_send Send or press Ctrl+Enter (Windows, Linux) or ⌘Cmd+A (macOS).

5.Wait for the prompt to be processed and the response to be generated.

Neural networks can make mistakes and come up with incorrect facts. We recommend that you cross-check the AI assistant’s responses yourself.

If necessary, you can pause the prompt processing. To do this, click ai_assistant_panel_stop Stop.

To resume the process, click Retry, which appears in the chat below the pending request.

If you want to copy the AI assistant's response, do one of the following:

–Click ai_assistant_panel_copy Copy under the response.

–Select part of the answer or the entire answer, then press Ctrl+C or Ctrl+Insert (Windows, Linux), or ⌘Cmd+C (macOS).

You can undo and redo the document editing actions performed by the AI assistant.

Chat management

You can chat with the AI assistant in multiple chats.

To create a new chat, do one of the following:

–Click the ai_assistant_panel_create_chat button.

–Click the ai_assistant_panel_request_history button. Above the list of chats, click Create chat.

To view your chat history, click the ai_assistant_panel_request_history button.

The buttons for creating chats and viewing history are unavailable while the AI assistant is processing a prompt.

Chat names are generated by an AI assistant. If you want to rename a chat, hover your mouse cursor over its name, click the ai_assistant_panel_edit_chat_name button, and make the necessary changes.

To open a chat, click it in the list.

To delete a chat, hover your mouse over its name and click the ai_assistant_panel_delete_chat button. Any changes made by the AI assistant while working in that chat will remain in the document.

ai_assistant_panel_chat_history

Summarization

In chats where the amount of text exceeds the allowed limit, automatic summarization is performed. This is a process during which the AI assistant retains the key information from the chat conversation while omitting minor details. The appearance of the conversation remains unchanged for the user, but summarization may affect the accuracy of the AI assistant’s responses.

A notification about the summarization process is sent to the chat. During summarization, all controls are disabled except for the mode selection button. The summarization process cannot be interrupted.

Close the AI assistant

To close the AI assistant, click the ai_assistant_panel_close button in the pane title bar. Please note that closing the pane will stop the prompt from being processed.

When you close the document, the chat history is not saved.

Was this helpful?

Yes