text/microsoft-resx 2.0 System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Administration Guides Changing portal region Deactivating/deleting portal Document Editor for Android Documents app for Android changelog Getting Started Hide documentation contents Manage files Managing portals The Documents app for Android allows you to access the files stored in your ONLYOFFICE account on your mobile device. Using this app, you can view, create and edit text documents, spreadsheets and presentations, manage your documents as well as connect third-party cloud storages. You can provide different access types to your files and edit documents collaboratively with other portal users or share files via external links. ONLYOFFICE Documents app for Android ONLYOFFICE Documents for Android ONLYOFFICE Mail changelog ONLYOFFICE Workspace Open or create new files and folders Overview Presentation Editor for Android Manage your portal through the Settings section that contains detailed information about your portal and allows you to deactivate or delete it. Spreadsheet Editor for Android Share files and folders Show documentation contents User Guides Viewing portal statistics Watch video Common operations for Android ONLYOFFICE Groups changelog Adding ONLYOFFICE Mail to the ONLYOFFICE Workspace installation Updating ONLYOFFICE Workspace to the latest version Using the Control Panel backup/restore feature Configuring ONLYOFFICE SP and AD FS IdP Receiving audit trail data Browse through the list of the latest changes (creation, modification, deletion etc.) made by users to the entities (tasks, opportunities, files etc.) on your portal How to use the backup/restore feature How to start working with your ONLYOFFICE Workspace Enterprise Edition? Connecting third-party storages How to use Control Panel in ONLYOFFICE Workspace Protect data using encryption Navigating via Full-Text Search feature Switching to HTTPS using Control Panel Installing ONLYOFFICE Groups on a local server Did you try and decide to deploy ONLYOFFICE on your corporate server? This guide will show you how to deploy and install ONLYOFFICE Server without efforts using the express installation file. Installing ONLYOFFICE Workspace for Windows on a local server Altering LDAP settings ONLYOFFICE offers you the 'LDAP Support' option which allows to import the necessary users and groups from an LDAP Server to your portal, literally, in several minutes. Read more... local server Tracking login history Monitor the latest user login activity including successful logins and failed attempts with an indication of reasons More articles Deploying multiple portals using the Multitenancy feature Configuring ONLYOFFICE SP and OneLogin IdP Using the Private Room to work on your documents securely Private Rooms in ONLYOFFICE Workspace for Secure Collaboration on Documents How to buy ONLYOFFICE Workspace Enterprise Edition subscription? Configuring ONLYOFFICE SP and Shibboleth IdP ONLYOFFICE Single Sign-on overview Updating ONLYOFFICE Workspace Enterprise Edition to the latest version Using ONLYOFFICE Docs behind the proxy Branding your online office Adding new fonts, languages and spellcheckers to ONLYOFFICE Docs Adding new themes to the ONLYOFFICE Docs Presentation Editor Compiling ONLYOFFICE Docs for a local server Compiling ONLYOFFICE Groups for a local server Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Docs to ONLYOFFICE Groups ONLYOFFICE Groups Windows version troubleshooting The main problems that user can face while installing server version onto his server as well as configuring and using it are described here. Installing ONLYOFFICE Docs for Debian, Ubuntu, and derivatives Running ONLYOFFICE Docs Developer Edition as Podman on Fedora Installing ONLYOFFICE Docs Developer Edition for Windows on a local server Running ONLYOFFICE Docs Enterprise Edition as Podman on Fedora Installing ONLYOFFICE Docs Enterprise Edition for Windows on a local server Running ONLYOFFICE Docs Community Edition as Podman on Fedora Deploying ONLYOFFICE Docs on your server ONLYOFFICE Docs is an online office suite comprising viewers and editors for texts, spreadsheets and presentations, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time. This guide will show you how to deploy ONLYOFFICE Docs without efforts. Installing ONLYOFFICE Groups for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Groups for Red Hat, CentOS, and derivatives Installing ONLYOFFICE Workspace Enterprise Edition from RPM/DEB packages using the provided script Installing ONLYOFFICE Workspace Enterprise Edition for Windows on a local server Installing ONLYOFFICE Workspace from RPM/DEB packages using the provided script Integrating third-party services in the server version The Authorization keys option allows you to connect your portal with the third-party services like Twitter, Facebook, DropBox etc. Connecting portal with Facebook, Twitter, Google or Linkedin is a good idea if you don't want to introduce your portal credentials every time you enter it. Read more... Migrating from the Cloud version to server version Decided to migrate from your Cloud to Server Solution? Don't know how to realize the plan? Just follow these step-by-step instructions. Migrating from ONLYOFFICE Workspace to Enterprise Edition on Windows Migrating ONLYOFFICE Groups from Docker to Linux Migrating ONLYOFFICE Groups from Linux to Docker Migrating ONLYOFFICE Groups from Windows to Linux ONLYOFFICE Docs Windows version troubleshooting ONLYOFFICE Groups frequently asked questions ONLYOFFICE Groups Linux version troubleshooting The main problems that user can face while installing server version onto his server as well as configuring and using it are described here. Removing unused fonts from ONLYOFFICE Docs Switching ONLYOFFICE Docs Enterprise Edition to HTTPS protocol Switching ONLYOFFICE Groups to HTTPS protocol Switching ONLYOFFICE Groups to HTTPS protocol Switching ONLYOFFICE Talk to TLS protocol on Linux version Switching ONLYOFFICE Talk to TLS protocol on Windows version Switching to HTTPS when installing from RPM/DEB packages Switching to HTTPS for the Windows version Updating ONLYOFFICE Docs Developer Edition for Windows to the latest version Updating ONLYOFFICE Docs Enterprise Edition for Windows to the latest version Updating ONLYOFFICE Docs for Linux to the latest version Updating ONLYOFFICE Docs Community Edition for Windows to the latest version Updating ONLYOFFICE Groups for Linux to the latest version Updating ONLYOFFICE Groups for Windows to the latest version Adding fonts to ONLYOFFICE Docs Adding a new interface language to ONLYOFFICE Docs Adding a new interface language to ONLYOFFICE Docs Adding new themes to the ONLYOFFICE Docs Presentation Editor Configuring network settings on Ubuntu Connecting a MySQL database to ONLYOFFICE Groups Installing ONLYOFFICE Docs for CentOS and derivatives Installing ONLYOFFICE Docs Developer Edition for CentOS and derivatives Installing ONLYOFFICE Docs Developer Edition for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs Developer Edition for Docker on a local server Installing ONLYOFFICE Docs Developer Edition using the provided script Installing ONLYOFFICE Docs on a local server Running ONLYOFFICE Docs using Docker Compose Installing ONLYOFFICE Docs Enterprise Edition for CentOS and derivatives Installing ONLYOFFICE Docs Enterprise Edition for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs Enterprise Edition for Docker on a local server Installing ONLYOFFICE Docs Enterprise Edition using the provided script Installing ONLYOFFICE Docs Community Edition using the provided script Installing ONLYOFFICE Docs for Linux snap package Installing ONLYOFFICE Groups for Docker on a local server Installing ONLYOFFICE Mail for Docker on a local server Installing all ONLYOFFICE Workspace components integrated Installing ONLYOFFICE Workspace using Docker Compose Installing ONLYOFFICE Workspace Enterprise Edition using the provided script Installing ONLYOFFICE Workspace Enterprise Edition with additional script parameters Installing ONLYOFFICE Workspace using the provided script Installing ONLYOFFICE Workspace with additional script parameters Migrating from ONLYOFFICE Workspace to Enterprise Edition using Docker script ONLYOFFICE Docs Docker version troubleshooting The main problems that user can face while installing server version onto his server as well as configuring and using it are described here. ONLYOFFICE Docs Linux version troubleshooting ONLYOFFICE Groups Docker version troubleshooting Removing ONLYOFFICE Docs for Docker from your computer Removing ONLYOFFICE Groups for Docker from your computer Running ONLYOFFICE Groups using HTTPS protocol Running ONLYOFFICE Groups behind NAT Switching ONLYOFFICE Docs to HTTPS protocol Updating ONLYOFFICE Docs Developer Edition for Docker to the latest version Updating ONLYOFFICE Docs Community Edition for Docker to the latest version Updating ONLYOFFICE Docs Enterprise Edition for Docker to the latest version Updating ONLYOFFICE Groups for Docker to the latest version Updating ONLYOFFICE Mail integrated with ONLYOFFICE Groups Using additional ports with ONLYOFFICE Groups Adding new plugins to server editors Changing domain used with ONLYOFFICE Mail Changing passwords for mailboxes in ONLYOFFICE Mail using a script Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Linux Connecting ONLYOFFICE Mail to ONLYOFFICE Groups via Portal Settings Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Windows Creating mailboxes in ONLYOFFICE Mail using a script Enabling vsyscall on Debian Integrating ONLYOFFICE with Alfresco Integrate ONLYOFFICE with Alfresco information management software. Integrating ONLYOFFICE with Chamilo Integrate ONLYOFFICE with Chamilo. Integrating ONLYOFFICE with Confluence Integrate ONLYOFFICE with Confluence collaboration software. Integrating ONLYOFFICE with Humhub Integrate ONLYOFFICE with Humhub social network. Integrating ONLYOFFICE with Jira Integrate ONLYOFFICE with Jira Software. Integrating ONLYOFFICE with Liferay Integrate ONLYOFFICE with Liferay enterprise portal solution. Integrating ONLYOFFICE with Nextcloud Integrate ONLYOFFICE with Nextcloud enterprise portal solution. Integrating ONLYOFFICE with Nuxeo Integrate ONLYOFFICE with Nuxeo. Integrating ONLYOFFICE with ownCloud Integrate ONLYOFFICE with ownCloud cloud storage service. Integrating ONLYOFFICE with Plone Integrate ONLYOFFICE with Plone content management system. Integrating ONLYOFFICE with Redmine Integrate ONLYOFFICE with Redmine. Integrating ONLYOFFICE with SharePoint Integrate ONLYOFFICE with SharePoint collaborative platform. Migrating MS Exchange data to ONLYOFFICE ONLYOFFICE Mail Docker version troubleshooting The main problems that user can face while installing server version onto his server as well as configuring and using it are described here. Removing ONLYOFFICE Mail for Docker from your computer Running an external script after starting ONLYOFFICE Mail Docker container Synchronizing new mailboxes with old ones using the script Uninstall default plugin from the server editors Working with plugins when using CSP Adding custom modules to ONLYOFFICE Groups Creating API for the ONLYOFFICE Groups custom modules Creating a WebDAV server on Ubuntu and connecting it to ONLYOFFICE Creating a WebDAV server on Windows and connecting it to ONLYOFFICE Languages available for ONLYOFFICE Docs interface Languages available for ONLYOFFICE Groups interface server version Docker version Deploying ONLYOFFICE Docs Developer Edition using AMI Deploying ONLYOFFICE Docs in DigitalOcean Deploying ONLYOFFICE Docs Enterprise Edition using AMI Deploying ONLYOFFICE Docs in Vultr Deploying ONLYOFFICE Workspace in DigitalOcean Deploying ONLYOFFICE Workspace Enterprise Edition using AMI Deploying ONLYOFFICE Workspace in Vultr ONLYOFFICE Mail How to install ONLYOFFICE Desktop Editors for Linux to your computer using Flatpak? Flathub is the best place to get Flatpak apps. To enable it, run: Once you have installed Flatpak, restart your system. Visiting Flathub and installing ONLYOFFICE Desktop Editors After the restart follow the command to install ONLYOFFICE Desktop Editors: Alternatively: Go to Flathub at <a href="https://flathub.org/apps/details/org.onlyoffice.desktopeditors">https://flathub.org/apps/details/org.onlyoffice.desktopeditors</a> Install ONLYOFFICE Desktop Editors using the Install button (when offered, open the file with Software Install (by default) and follow further instructions) Launch ONLYOFFICE Desktop Editors right upon installation or later - by pressing Show Applications - ONLYOFFICE Desktop Editors Uninstalling Desktop Editors To remove ONLYOFFICE Desktop Editors from your machine use the following command: <a href="https://flatpak.org/">Flatpak</a> is a distribution agnostic software utility for building and distributing desktop applications on Linux. It allows to install third-party Linux applications without having to add repositories or deal with dependencies. Say ‘y’ to ‘Is this ok [y/n]:’ Installing Flatpak First, you will need to install Flatpak itself - to do that, go to <a href="https://flatpak.org/">https://flatpak.org/</a> and install the software choosing your distribution and following the instruction. For example, to install Flatpak on Ubuntu 18.10 (Cosmic Cuttlefish) or Ubuntu 19.04 (Disco Dingo), simply run: With older Ubuntu versions, the official Flatpak PPA is the recommended way to install Flatpak. To install it, run the following in the terminal: Installing the Software Flatpak plugin Flatpak plugin for the Software app makes it possible to install apps without the command line. To install it, run: Adding the Flathub repository Adding contacts in bulk Building a customer database is essential for getting started with your CRM system. The Import contacts feature will facilitate this process allowing you to add several contacts at once instead of entering them one by one manually. This guide will show you how to transfer your contacts from a CSV file to CRM and restrict access to them. Project management ONLYOFFICE Projects application for easier use of Projects on an Android device. assign task Automatic time tracking while performing a task This tip is aimed at those ONLYOFFICE users who bother their head each time they need to enter time spent performing a certain task. Now you can use the timer that will automatically calculate how long you have been working on the task. The only thing you'll have to do is to start the timer with one mouse click. Coordinate all aspects of your activities using the online office Collaboration is that easy, when you work in a cloud office! Create your own online office. create milestone create project Creating custom task status Once a task is created, a status can be assigned to it. By default, there are only two statuses: Closed and Open. However, there might be a need for additional statuses for specific tasks. edit project edit task Following projects Want to keep track of some projects at your portal? Just click a link and you'll receive notifications about everything new in the needed project by email. follow project CRM. Getting Started CRM is a simple customer relationship management tool which helps companies improve their interactions with clients, therefore reducing the compagny costs and increasing their profitability. Projects. Getting Started Projects is a project management tool developed to help you successfully carry out the project through five main stages: initiating, planning, executing, monitoring, closing. Milestones Project management ONLYOFFICE Projects application for easier use of Projects on an iOS device. Keeping contacts up-to-date An effective well-organized customer database enables you to communicate better with your customers and increase your sales. This guide will show you how to maintain your customer database: arrange and update the available contact information. key milestone Linking an opportunity with a project Sometimes working on an opportunity might require the involvement of the whole team of the specialists. In this case creating a project and linking it with the opportunity will help you coordinate the work and manage it more efficiently. Follow the instructions to learn how to link an existing opportunity with a project. Linking project with a CRM contact Need to know what companies are involved in certain projects and be able to manage them easily? Just link your project with contacts (persons or companies) from your customer database. This guide will show you how it can be done a few mouse clicks. Linking tasks within your project Once the tasks are created, to determine the order in which they will be completed you need to create the task dependencies, i.e. link them. Projects allows you to link tasks in two different way: on the task description page or using the Gantt Chart view. This guide will show you how to determine the dependency relationships between tasks in a few mouse clicks. Manage your projects online with the online office Manage your workflow with Projects. Learn how to create a new project and restrict access to it, build your project team, navigate and set access rights to the Projects module. manage team Managing company documentation Creating a well-organized storage space for your company documentation can help you save time and considerably increase the productivity and efficiency of the work. The ONLYOFFICE Portal offers you a common space to store your company documentation - Common Documents and allows you to structure it as you wish: creating subfolders and setting permissions for them. This quide will show you how it can be done. Managing your project using the Gantt chart The Gantt Chart is a great way to build your project schedule and visually judge its progress. Read this guide to learn how to plan milestones, manage tasks and create task dependencies using the Gantt chart view. Tasks ONLYOFFICE Demonstration Organizing and tracking a common event Using case is an effective way to organize a common event for your customers. It allows to coordinate teamwork, keep all the related documentation organized in one place and track the process more efficiently. This guide will show you how to use a case in CRM. private project Projects project team Using templates for similar projects Did you notice that it takes lots of time to create a project with all associated stuff like building a project team, planning milestones, tasks and discussions? Now you can create a template for similar projects and save time you spend each time on entering the same data. Reattaching tasks to other milestones Need to attach an existing task to another milestone without creating the same task once again? Just follow step-by-step instructions in this tip to learn how to do that. Reporting templates with automatic delivery by E-mail Are you tired of generating reports manually? Now you can set up needed parameters once and regularly receive automatic reports by email on certain date and time. You save lots of time and keep up with everything new at your portal. restrict access Restricting access to projects Are you a project manager and need to restrict the access to your project so that only your team members can access it? Just save it as private. This guide will show you how it can be done in a few easy steps. task statuses Tracking potential sales An opportunity is used to keep track of the potential sales, their estimated due date, budget and success probability and help you manage your sales easily and effectively. This guide will show you how to create and manage your opportunities. Tracking work time efficiently Regardless of the billing method you use (per hour or per project) tracking time is a great possibility to assess the productivity of your team and of each its member and make the necessary corrections to achieve the best result. This article will show you how to track time and manage your time sheet using the Time Tracking feature offered by Projects. How to track time and payments in the online office Track time and manage your time sheet using the Time Tracking feature offered by Projects. Viewing all active tasks quickly Want to learn the fastest and easiest way to view all active tasks assigned to you? Read this tip and you will learn how to do that. add subtask close project close task create discussion delete project delete task generate report Community. Getting Started Community offers you a complete toolset for building a social network inside your company. It lets you communicate and collaborate not only with your project team, but with the entire company. Discussions project settings restrict access to module set priority suspend project Portal Configuration. Getting Started Once your portal is created, you will need to customize and manage it so that it fitted your needs. Workspace Enterprise Edition Security Guide ONLYOFFICE provides many ways to ensure that your portal is properly protected. Set up access rights on your portal Set up the access rights to each portal module. Learn how to manage the portal modules choosing the modules to show and those to hide and restrict access to them for a certain user or a group of users. Calendar. Getting Started Calendar is a built-in scheduling tool that allows you to view all your personal and corporate events at a glance and keep track of all the important dates. lead discussion notifications restrict access to project Get a panoramic picture of multitask activities The online office users are able to organize the events schedule easily. Due to personal calendars filled with tasks and project milestones, they get a visualized workflow overview. How to set or remove an event reminder? You can receive reminders about upcoming events according to the reminder settings specified for a particular event or all calendar. Learn how to do it in a few clicks! Gantt chart Talk. Getting Started Talk is an instant messenger that provides a real-time communication between the co-workers. It offers all the traditional features you expect from a messenger. Portal notifications: manageable notifications Want to know what notifications you can manage and when you can receive them from ONLYOFFICE? Read this tip to learn it. Managing portal subscriptions If you are bored with constant notifications or on the contrary want to keep up with every change on your portal, you need to manage your subscriptions. Read this tip and you will learn how to do that. Portal notifications: non-manageable notifications Want to know what notifications you can't manage and when you will receive them from ONLYOFFICE? Read this tip to learn it. Several ways to communicate with team using Talk Learn more about features offered by Talk web client: history archiving, different types of notifications, mailing lists. Linux version Windows version Installing ONLYOFFICE Docs Enterprise Edition Univention appliance install univention ONLYOFFICE Groups upgrade server Admin Altering LDAP settings in the SaaS version ONLYOFFICE offers you the 'LDAP Support' option which allows to import the necessary users and groups from an LDAP Server to your portal, literally, in several minutes. Read more... Control Panel Importing users from a CSV file Are you tired to add the people to the system manually one by one? This guide will show you how to add several users at once in no time. Following these easy steps you will be able to save your contacts in a .csv file and then add them to your portal. Importing users from a mail client address book The simplest way to add all your colleagues to the portal is to import the contact information stored in the address book of your mail client. To do that just read this guide and follow the instructions step by step. Importing users from Google You have launched the portal in your company and now need to add all your colleagues to the system? It can be really a pain to enter their email adresses manually one by one. This guide will show you how to add several users at once using the contact information from Google. import users LDAP settings ONLYOFFICE Control Panel changelog Manage users on your portal Manage your portal users with People. Learn how to add a new user to your portal or import several users at once, organize them into groups and view their profiles. authorization keys Configuring ONLYOFFICE connector for Nextcloud Configuring ONLYOFFICE connector for ownCloud Editing documents from Box in ONLYOFFICE You have a Box account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your Box from the Documents portal module. Editing documents from Dropbox in ONLYOFFICE You have a Dropbox account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your Dropbox from the Documents portal module. Editing documents from Google Drive in ONLYOFFICE You have a Google account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your Google from the Documents portal module. Editing documents from OneDrive in ONLYOFFICE You have a OneDrive account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your OneDrive from the Documents portal module. CRM settings Setting up the default currency and exchange rates The default currency is used to calculate the total amount for all CRM opportunities. This currency is also used to set prices in the Products & Services list. Read this tip and you'll find out how to change the default currency used in the CRM module and specify exchange rates for other available currencies. How to deploy ONLYOFFICE on DigitalOcean using One-Click App Deploying ONLYOFFICE Docs in Cloudron Deploying ONLYOFFICE Docs Enterprise Edition in Cloudron Deploying ONLYOFFICE Docs in Linode integrate Box account integrate Dropbox account integrate Google account integrate OneDrive account How to integrate ONLYOFFICE with Alfresco Share How to integrate ONLYOFFICE with Chamilo How to integrate ONLYOFFICE with Nextcloud using the app from the official store How to integrate ONLYOFFICE with Nextcloud How to integrate ONLYOFFICE with Nuxeo with the official plugin How to integrate ONLYOFFICE with Nuxeo How to integrate ONLYOFFICE Docs with ownCloud How to integrate ONLYOFFICE with Redmine How to integrate ONLYOFFICE Docs with SharePoint Integrating other resources with the Documents module Do you have some documents stored in other web resources like Box, Dropbox, Google, OneDrive, SharePoint o Yandex? You can easily synchronize them with the Documents module of your portal just within a few minutes. Integrating third-party services in the cloud version Mail module troubleshooting The main problems that user can face while integrating the mail service into the Mail and configuring it are described here. Please read this question and answer section to find out the answers to most questions arising when connecting some popular web mail services, such as Gmail.com, Hotmail.com, Yahoo.com and Mail.ru and some other mailboxes to portals. Manage your documents with the online office Manage your documents workflow using Documents. Learn how to create, edit and share documents on your corporate portal without any additional software and right in your web browser. Open or create new files and folders ONLYOFFICE 7.0: fillable forms, password protection and version history in spreadsheets ONLYOFFICE Docs changelog ONLYOFFICE Docs Using two-factor authentication two-step verification Wish to protect the data stored on your portal and prevent any unauthorized access? Then make use of an extra security level enabling the two-factor authentication. In this case if someone decides to hack into your ONLYOFFICE account even having your password he will need your phone to access it. This guide will explain how it works and how to enable this option. Co-editing documents online Whether you make a contract, or write an article, or translate a text you might need to interact with people especially at the final stage to specify details or proofread the document. In this case the action sequence is more or less similar: sending document - waiting for the result - correcting and editing - sending document - waiting for the result - correcting and editing and so on till the result satisfy both parties. To avoid this continuous procedure and achieve the best result without wasting time on sending and waiting, make use of the Co-editing feature provided by Document Editor. Editing documents from Nextcloud in ONLYOFFICE You have a Nextcloud account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your Nextcloud from the Documents portal module. Editing documents from ownCloud in ONLYOFFICE You have a ownCloud account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your ownCloud from the Documents portal module. Using context menus A context menu represents a menu that appears upon a right mouse click and offers a limited set of choices, i.e. actions related to the selected item within the 'Documents' module. Read this tip to find out what operations you can perform using context menus. Creating CSV files Many of us continue to use spreadsheets for customer databases. It might be enough if you have five or ten customers, but to make your business grow an effective tool, like CRM, for tracking your customers is essential. This step by step guide will show you how to save an existing spreadsheet as a CSV file for importing contacts to CRM. Document collaboration made easy in the online office See how simple online word editing can be in the online office. Make use of real-time collaboration and document commenting. Create your cloud office right now! Documents Documents module troubleshooting On 27th June 2013 Documents got a new uniform format - Open Office XML - instead of the internal format (.doct, .xlst, .pptt). The main problems that user can face thereupon are described here. Sending for electronic signature Send documents, spreadsheets and presentations for electronic signature right from your portal and receive signed documents as PDF files stored in the specified folder of the Documents module. Embedding a document into a blog Wish to complement the information you have posted? Add some documents, spreadsheets or presentations to your blog/website so that everyone can view it right there without downloading or using any additional viewer? So, embed the document using the features provided by ONLYOFFICE. This guide will show you how to embed a document in a few mouse clicks. Learning about folder permissions hierarchy If you want to create a complex folder structure with several nesting levels and set different group permissions, it might be useful to know how the permission priority order is implemented in the Documents module. Documents. Getting Started Documents is a module for storing, viewing, editing and sharing documents, images, spreadsheets, presentations, etc. Managing versions and revisions Managing versions and revisions While using your personal cloud, you might have already noticed that there is a number next to the file title that shows the number of file versions. Want to learn more about file versions and revisions? Read this tip! Using the 'Documents' module and the 'Documents' section of the 'Projects' module, you might have already noticed that there is a number next to the file title that shows the number of file versions. Want to learn more about file versions and revisions? Read this tip! Sharing files and folders Sharing documents When working with text documents, you might need to write a text in co-authorship with your colleagues, or submit an article for review, or prepare a fillable template, such as a questionary. You can easily share a file with an individual or a group of users and set access permissions depending on the tasks each person should accomplish. When working with files, you might need to collaborate on it or share a form to fill out. You can easily share files and folders with an individual user or a user group and set access permissions depending on the tasks each co-editor should accomplish. Please note, that not all ONLYOFFICE Groups and ONLYOFFICE Docs versions can be connected to each other. In case you have ONLYOFFICE Groups version incompatible with the current ONLYOFFICE Docs version or vice versa, please consider upgrading to the latest versions or at least to the nearest compatible ones. The table below shows which server versions can be connected to each other without any problems: ONLYOFFICE Docs version ONLYOFFICE Community Server version View the older ONLYOFFICE Groups and ONLYOFFICE Docs versions compatibility table Hide the older ONLYOFFICE Groups and ONLYOFFICE Docs versions compatibility table No stable work of the incompatible versions can be guaranteed and we strongly recommend that you update your installations to the latest available versions for correct work. add users How to change a pricing plan? Do you want to add new users to your portal ONLYOFFICE but the pricing plan restricts the number of users and you don't know how to change it? Are you tired of paying for your portal every month? Read this guide. Connecting ONLYOFFICE Desktop Editors to Seafile ONLYOFFICE Desktop Editors v7.0: form filling, kDrive & Liferay integration ONLYOFFICE Desktop Editors Running ONLYOFFICE Desktop Editors with parameters Getting started with ONLYOFFICE Desktop Editors People. Getting Started People is a module where all portal members as well as group participants are displayed. Every member has one of the following statuses: active or disabled. Personal ONLYOFFICE Personal is a totally free suite for editing text documents, spreadsheets and presentations online in a personal cloud storage. Insert and format autoshapes Add an autoshape to your document and adjust its properties. insert objects How to install plugins in ONLYOFFICE Desktop Editors invite people How to pay for your portal? You have already evaluated ONLYOFFICE and decided to use it in your company? So after your trial period is over, in order to continue your work on the portal you need to buy a ONLYOFFICE subscription. To do that, you don't need to go to our official website or any other resource. All that is necessary is to switch to the Payments page of your portal. Even if the trial period has already expired, this page will remain accessible. So to pay for your portal just follow these easy steps. payment basis payment method About Presentation Editor The short description of Presentation Editor. Supported formats of electronic presentations The list of presentation formats supported by Presentation Editor. presentations Pricing FAQ Protecting your documents with a password Protect documents with a password in ONLYOFFICE Desktop Editors Protecting your documents with a digital signature Protect documents with a digital signature in ONLYOFFICE Desktop Editors switch to another pricing plan Try and make your decision Try now for free No need to install anything to see all the features in action Uninstall default plugin from the desktop editors Create fillable forms Create fillable forms for advanced form interaction experience. Create a Table of Contents Create and update a table of contents automatically to easily navigate through a multi-page document. Add and Format a Table of Figures Add, format and update Table of Figures using captioned objects and styles. Creating a chart from start to finish Creating a chart from start to finish Decorating posts It's boring to read posts or comments containing pure plain text only. Let's decorate them adding colors, styles, hyperlinks, images, etc. Formatting your text you can not only make it good-looking, but also highlight some important points, demonstrate something using images and videos, give a link to an internal or external source. Fillable forms in ONLYOFFICE Docs Inserting images in posted messages Want to discuss new product models in the ONLYOFFICE forum to select a good one? Or just need to add some pictures as a reference to enhance your blog story? Read these step by step instructions to insert an image directly into your posted message. Add an autoshape to your presentation and adjust its properties. Add an autoshape to your spreadsheet and adjust its properties. Insert and edit charts Add a chart to your presentation and adjust its properties. Add a chart to your spreadsheet and adjust its position, size and properties. Add a chart to your document and adjust its position, size and properties. Insert content controls Insert content controls to create a form with input fields that can be filled in by other users, or protect some parts of the document from being edited or deleted. Insert and adjust images Add an image to your presentation and adjust its size and position. Add an image to your spreadsheet and adjust its position and size. Add an image to your document and adjust its position and properties. Insert sparklines Sparkline is a small chart that fits into a cell to represent trends or variations of data. Insert text objects Insert and format your text Insert and Format your Text. Insert text objects such as text boxes and Text Art to draw attention to a specific part of the spreadsheet. Insert text objects such as text boxes and Text Art to make your text more impressive. Creating a knowledge base Store and organize information creating your own database with ONLYOFFICE Wiki. Read this step by step guide to learn how to create and edit Wiki pages, attach the pages to a category and interlink them. Adjust chart settings Create charts Insert autoshapes Insert charts Insert formulas Insert images Insert tables Insert text Manipulate objects Change text wrapping branding change logo change portal title collaborative editing create documents Create a new document or open an existing one Open a recently edited document, create a new one, or return to the list of existing documents. Create a new presentation or open an existing one Open a recently edited presentation, create a new one, or return to the list of existing presentations. Create a new spreadsheet or open an existing one Create a new spreadsheet, open a recently edited one, or return to the list of existing spreadsheets. How to create your own portal? Are you looking for the tools which help you organize your company and personal documentation, manage your customer relations and projects, create your own community? ONLYOFFICE allows you to achieve all these goals. This guide will show you how to create your own portal in a few easy steps. Community Server Windows version troubleshooting The main problems that user can face while installing server version onto his server as well as configuring and using it are described here. custom domain name customize portal Data backup & restore in the cloud version Need to backup your portal data to be able to resore it later in the cloud version? This procedure is very simple. data backup Advanced settings of Document Editor The advanced settings of Document Editor. Collaborative document editing Tips on collaborative editing. DNS settings manage modules Project documents ONLYOFFICE Projects application for easier use of Projects on an iOS device. password strength Advanced settings of Presentation Editor The advanced settings of Presentation Editor. Communicating in real time In Presentation Editor you can communicate with your co-editors in real time using the built-in Chat tool as well as a number of useful plugins, i.e. Telegram or Rainbow. portal settings About Spreadsheet Editor The short description of Spreadsheet Editor. Advanced Settings of Spreadsheet Editor The advanced settings of Spreadsheet Editor Collaborative spreadsheet editing Tips on collaborative editing. Supported formats of spreadsheets The list of spreadsheet formats supported by Spreadsheet Editor. self-registration share documents share files spreadsheets team template Setting time zone for your calendar time zone It's very convenient to receive notifications about coming events in time. Select a time zone in the calendar settings and keep up with all the events. You'll find the instructions in this tip. trusted domains change time zone deactivate portal delete portal disable module enable module General FAQ How to integrate ONLYOFFICE with Jira How to integrate ONLYOFFICE with Moodle Organizing mass mailing Want to send a newsletter to all the contacts from your customer database or just need to inform some clients about an upcoming event? Now you can do that directly from the CRM module. This guide will show you how it can be done in a few easy steps. ONLYOFFICE translation If you want to make ONLYOFFICE better and more available for as many people as possible all over the world, this article will tell you how you can contribute to our project and improve it. We would like to invite you to collaborate on ONLYOFFICE translations. By translating our content into other languages, you will help other people use our online office in their mother tongues and learn more about ONLYOFFICE. Changing your portal language portal language Need to change the interface language at your portal and have no idea how to do that? Read this tip and you will learn how to alter the language for all the portal users (in case you have administrator rights) or for yourself only. restore backup security Changing SMTP settings for ONLYOFFICE Groups SMTP settings Recently you've stared using a ONLYOFFICE server version and now your portal activity is running at full tilt. Of course you want to keep in line with what is going on on your portal. ONLYOFFICE notifications don't let you miss a thing! But if you want to ensure more efficient functioning of ONLYOFFICE notifications you need to set up the SMPT settings. Read more... Single Sign-on feature in the SaaS version ONLYOFFICE offers you the Single Sign-on feature to improve the login process. Read more... single sign-on view statistics Integrating ONLYOFFICE with Strapi Integrate ONLYOFFICE with Strapi. Deploying ONLYOFFICE Docs Developer Edition on Alibaba Cloud Deploying ONLYOFFICE Docs Enterprise Edition on Alibaba Cloud Deploying ONLYOFFICE Workspace Enterprise Edition on Alibaba Cloud Adding animations Animation tab Introducing the Presentation Editor user interface - Animation tab. Installing ONLYOFFICE Docs on Debian systems for the 64-bit ARM architecture Installing ONLYOFFICE Docs Developer Edition on Debian systems for the 64-bit ARM architecture Installing ONLYOFFICE Docs Enterprise Edition on Debian systems for the 64-bit ARM architecture ONLYOFFICE Document Viewer Support of SmartArt View tab Introducing the Presentation Editor user interface - View tab. Introducing the Document Editor user interface - View tab. Installing ONLYOFFICE Docs on CentOS or RHEL for the 64-bit ARM architecture Installing ONLYOFFICE Docs Developer Edition on CentOS or RHEL for the 64-bit ARM architecture Installing ONLYOFFICE Docs Developer Edition Docker version for the 64-bit ARM architecture Installing ONLYOFFICE Docs Docker version for the 64-bit ARM architecture Installing ONLYOFFICE Docs Enterprise Edition on CentOS or RHEL for the 64-bit ARM architecture Installing ONLYOFFICE Docs Enterprise Edition Docker version for the 64-bit ARM architecture Basic operations Cell text formatting Editing cell properties Editing rows/columns Fillable forms Helpful hints Mail Merge Math equations Operations on objects Operations with sheets Page formatting Paragraph formatting Plugins Program interface Protecting a spreadsheet Text formatting Tools and settings Working with slides Work with functions Managing Active connections Logged into the portal from another device, but then forgot to log out? You can manually close a specific user's active session. Configuring report types Need to know the full details of the current status of all projects? In the Projects module, you can get this information using the Reports. Configuring ONLYOFFICE WebDAV server Migrating Nextcloud data to ONLYOFFICE Workspace Collaboration Common operations for iOS Document Editor Presentation Editor Spreadsheet Editor Integrating ONLYOFFICE with Moodle Integrate ONLYOFFICE with Moodle. Integrating ONLYOFFICE with WordPress Integrate ONLYOFFICE with WordPress. Make Audio and Video Calls Make Audio and Video Calls Create and insert diagrams Tips on using Draw io plugin. Make Audio and Video Calls Protecting presentations with a password Protect your presentations with a password Site map ONLYOFFICE Docs All platforms Appendix Article complete index Control Panel Database Functions Date and Time Functions Desktop ONLYOFFICE Desktop Editors Docker version Documents Engineering Functions Financial Functions Glossary Mail. Getting Started Mail is a communication tool designed to manage your correspondence right on the portal. This message management solution helps you work more efficiently and improve business communication. Information Functions Linux version Logical Functions Lookup and Reference Functions Mac OS version Math and Trigonometry Functions ONLYOFFICE Mobile Apps ONLYOFFICE Groups ONLYOFFICE Mail Portal modules Statistical Functions Text and Data Functions Windows version Calendar CRM General People Projects Server Talk Looking for the alphabetically sorted list of all the Help Center articles? <a href="https://helpcenter.onlyoffice.com/abc-index.aspx">You can always find it here</a> Community Documents app for Android Documents app for iOS Feed Integration Mail Settings Cloud portals DigitalOcean ONLYOFFICE mobile apps How to connect ONLYOFFICE Docs to Confluence Configuring ONLYOFFICE Docs Developer Edition Connecting Amazon S3 bucket as a cache to ONLYOFFICE Docs Connectors Reporting issues Installing ONLYOFFICE Talk for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Talk for Red Hat, CentOS, and derivatives Installing ONLYOFFICE Talk on a local server Migrating from ONLYOFFICE Workspace to Enterprise Edition on Linux Migrating Google Workspace data to ONLYOFFICE Workspace How to add cells How to add cells in ONLYOFFICE Spreadsheet Editor Insert or delete cells, rows, and columns Insert or delete cells, rows, and columns. Insert tables Insert and format tables Add a table to your presentation and adjust its properties. Add a table to your document and adjust its properties. Merge cells Merge some cells into one and split the previously merged cell. Merge cells operations with cells How to split cells How to split cells in ONLYOFFICE Spreadsheet Editor Add borders Add borders to your spreadsheet selecting their style. Align data in cells Everything that pertains to the data alignment in cells. How to calculate percentages How to calculate percentages in ONLYOFFICE Spreadsheet Editor cell formatting Clear text, format in a cell Clear the text or the format within your worksheet. How to insert time How to insert time in ONLYOFFICE Spreadsheet Editor Align data in cells Select cell background color Add cell borders Apply cell style Change number format Selective cell clear Apply table styles Change text orientation Wrap text in a cell Wrapping text Align your text in a line or paragraph align text Everything that pertains to the text alignment in line or paragraph: aligning left, right, justified, center. Align your text in a paragraph Change paragraph indents Align your text in a text box Change text indents Download Teach your robot to read View and edit documents, spreadsheets and presentations of all popular formats ONLYOFFICE Projects Work with your projects on mobile devices and manage your tasks on-the-go No more Microsoft All main platforms support: Windows, Linux and Mac OS Best editors on your website Let your site users view, edit and collaborate on all types of text, spreadsheet and presentation files Power up your iOS Create, browse and manage tasks, subtasks, milestones and projects Create, edit and view documents, spreadsheets and presentations of all popular formats Host on your own server Available for Docker, Windows and Linux Change number format Add borders to your document selecting their style. add and format borders Insert array formulas Insert array formulas. Conditional Formatting Conditional formatting allows you to apply various formatting styles (color, font, decoration, gradient) to cells to work with data on the spreadsheet. data processing Data validation Set the data validation parameters Remove duplicates You can remove duplicate values from the selected data range or a formatted table. Use formatted tables Apply a table template to the selected cell range and automatically enable the filter. Group data The possibility to group rows and columns as well as create an outline allows you to make it easier to work with a spreadsheet that contains a large amount of data. Insert functions Insert function to perform basic calculations. Use named ranges Use named ranges to simplify working with formulas. number format Change the number format to display the numbers in the most convenient way. Create and edit pivot tables Pivot tables allow you to group and arrange data of large data sets to get summarized information. You can reorganize data in many different ways to display only the necessary information and focus on important aspects. Create slicers for tables Once you create a new formatted table or a pivot table, you can create a slicer to quickly filter the data. Sort and filter data Sort your data in ascending or descending order in a spreadsheet. Manage data in rows/columns operations with rows and columns table formatting Align and arrange objects on a page Align and arrange text boxes, autoshapes, images and charts on a page. Align and arrange objects on a slide Align and arrange text blocks, autoshapes and images on a slide. align objects Select background color for a paragraph Learn how to select background color for a paragraph. Change color scheme Learn how to change color scheme for a document. element background Fill objects and select colors Fill the added objects with color, picture or texture, select colors for the slide background, autoshape fill and stroke, font. Apply formatting presets Apply formatting presets: normal, heading, paragraph, table, etc. Freezing rows and columns Manipulate objects Manipulate objects on a slide Move, rotate, resize and reshape autoshapes and images. Move, rotate, resize, reshape and arrange autoshapes, images, charts. Add or remove rows/columns Apply formatting presets Hide or show rows/columns Change presentation theme Remove rows/columns Resize rows/columns Show/hide nonprinting characters nonprinting characters Show or hide nonprinting characters while formatting text, creating tables, and editing documents. position object predefined styles Set slide parameters Set slide parameters: select background fill, themes, color schemes, slide layouts. Change text wrapping text wrapping Change the text wrapping style to specify the way the object is positioned relative to the text. Set font type, size, style, and colors Change the following formatting parameters: font type, size, style, and colors. Select background color for a paragraph Change slide background Changing interface themes in ONLYOFFICE Docs Configuring reverse proxy for Nextcloud and ONLYOFFICE editors Accessibility of ONLYOFFICE Editors Adding new fonts to ONLYOFFICE Desktop Editors ONLYOFFICE Projects for Android changelog. Changelog Common operations Overview ONLYOFFICE Mobile web editors for Android ONLYOFFICE Mobile web editors for iOS ONLYOFFICE Web Editors Mobile web editors provide a complete toolset of editing features and have an interface which is adapted for working with documents in the mobile device web browser. Edit Word docs on your iPad with ONLYOFFICE app Document Editor for iOS Document Editor web version for Android Document Editor web version for iOS Documents app for iOS changelog The Documents app for iOS allows you to access the files stored in your ONLYOFFICE account on your mobile device, view and edit existing text documents, spreadsheets and presentations, create new ones and organize them as well as connect third-party cloud storages. You can edit documents collaboratively with other portal users or work on your files offline. ONLYOFFICE Documents app for iOS ONLYOFFICE Documents for iOS ONLYOFFICE provides mobile solutions to access your files and edit them from an iOS or Android device. The solutions include ONLYOFFICE Documents for iOS and Android, ONLYOFFICE Project for iOS and Android, and ONLYOFFICE web editors that are adapted for working with documents in the mobile device web browser both on iOS and Android. ONLYOFFICE Projects for Android The Projects app for Android allows you to manage projects stored in your ONLYOFFICE account on your mobile device. Using this app, you can view, create and edit projects, milestones, tasks, subtasks, manage your project team, assign responsible persons, access project documents, create discussions and leave comments. ONLYOFFICE Projects for iOS The Projects app for iOS allows you to manage projects stored in your ONLYOFFICE account on your mobile device. Using this app, you can view, create and edit projects, milestones, tasks, subtasks, manage your project team, assign responsible persons, access project documents, create discussions and leave comments. Presentation Editor for iOS Presentation Editor web version for Android Presentation Editor web version for iOS Spreadsheet Editor for iOS Spreadsheet Editor web version for Android Spreadsheet Editor web version for iOS How to create, edit and customize charts in ONLYOFFICE Docs Real-time co-editing in ONLYOFFICE How to compare documents in ONLYOFFICE Using content controls in ONLYOFFICE Document collaboration made easy in the online office Fast and Strict co-editing modes in ONLYOFFICE Manage your documents with the online office ONLYOFFICE Online Editor overview Looking for online editor with perfect formatting? Using the Review mode in ONLYOFFICE How to use Sheet View and custom filtering in spreadsheet collaboration How to connect ONLYOFFICE Documents for Android to Cloud ONLYOFFICE Documents for Android Document Editor overview How to edit documents stored on Nextcloud with ONLYOFFICE on your Android device How to open and save docs to different formats using ONLYOFFICE Documents for Android How to organize files using ONLYOFFICE Documents for Android ONLYOFFICE Documents for Android Presentation Editor overview How to connect ONLYOFFICE Documents for Android to Personal ONLYOFFICE Documents for Android Spreadsheet Editor overview How to connect ONLYOFFICE Documents for Android to Server How to share files using ONLYOFFICE Documents for Android How to edit your documents collaboratively on Linux with ONLYOFFICE. Communication in ONLYOFFICE editors: Comments, Mentions and Chat Conditional formatting Pt. 2: Data bars, color scales, icon sets Conditional formatting Pt. 1: Highlighting numeric and text values How to turn on dark mode in ONLYOFFICE Docs Data validation in ONLYOFFICE How to create ebooks in ONLYOFFICE Docs Learn how to work with Gantt Chart in ONLYOFFICE and get a visualized picture of your projects progress. Coordinate Your Project using ONLYOFFICE Gantt Chart Let's make a kind of competition between the most popular editors to see how they cope with complex formatting. Document Permissions in ONLYOFFICE Pivot Tables in ONLYOFFICE Reference types in ONLYOFFICE Docs: footnotes, endnotes, cross references How to Use Slicers in ONLYOFFICE Using Version History in ONLYOFFICE Schedule an event that lasts for a whole day and does nor require to set a certain time. How to create an all-day event? Assigning different colors to your calendars helps you distinguish events that belong to them at a glance or even group your calendars. For example, you can select a single color for all project-related or shared calendars to find the needed events easily or to set priorities on them. Please refer to this tip for more detailed information. Assigning a color to your calendar Learn how to set up a conference and communicate with many people at once using Talk web client. How to create chat rooms? Improve the interactions with your customers using CRM. Learn how to maintain your customer database, customize the CRM system according to your company needs and set access rights within it. Manage your customer relations with the online office Deploying ONLYOFFICE on your servers takes a couple of minutes if you use Docker. How to deploy Community Server using Docker service How to install Community Server with Document Server on Ubuntu 14.04 How to install Community Server on your Windows server ONLYOFFICE Desktop Editors - free office suite for offline document editing and collaboration How to install plugins in ONLYOFFICE Docs How to install Document Server and connect it to Community Server on Windows Learn how to get powerful online editors ONLYOFFICE Docs ready on your server using Docker. It is super easy and won't take more than a couple of minutes! How to deploy ONLYOFFICE Docs on your server using Docker Run your own office with the ONLYOFFICE on your private AWS cloud How to install Enterprise Edition using the provided script Grammalecte in ONLYOFFICE Docs: spellchecker for French texts You can add guest users to your project and enable them to view and comment tasks, discussions and documents without extra payment for users. How to invite guest users to your online office HTML plugin for ONLYOFFICE Docs Correct grammar with LanguageTool in ONLYOFFICE Docs How to import users from Active Directory to ONLYOFFICE Check ONLYOFFICE Workspace mailboxes using third-party clients Découverte d'ONLYOFFICE dans NextCloud ONLYOFFICE : Édition collaborative dans NextCloud ONLYOFFICE Document Editor ONLYOFFICE Document Editor is an online application that lets you look through and edit documents directly in your browser. Using ONLYOFFICE Document Editor, you can perform various editing operations like in any desktop editor, print the edited documents keeping all the formatting details or download them onto your computer hard disk drive as DOCX, PDF, ODT, TXT, DOTX, PDF/A, OTT, RTF, DOCXF, HTML, FB2, EPUB, PNG, JPG/JPEG files. ONLYOFFICE Presentation Editor ONLYOFFICE Presentation Editor is an online application that lets you look through and edit presentations directly on your portal. Using ONLYOFFICE Presentation Editor, you can perform various editing operations like in any desktop editor, print the edited presentations keeping all the formatting details or download them onto your computer hard disk drive as PPTX, PPSX, PPTM, PDF, ODP, POTX, PDF/A, OTP, PNG, JPG/JPEG files. ONLYOFFICE Spreadsheet Editor ONLYOFFICE Spreadsheet Editor is an online application that lets you edit your spreadsheets directly on the portal. Using ONLYOFFICE Spreadsheet Editor, you can perform various editing operations like in any desktop editor, print the edited spreadsheets keeping all the formatting details or download them onto your computer hard disk drive as XLSX, PDF, ODS, CSV, XLTX, XLTM, PDF/A, OTS, PNG, JPG/JPEG file. ONLYOFFICE CRM. When a good sale goes better. Your perfect day with ONLYOFFICE CRM How to activate pro features in ONLYOFFICE Desktop Editors Learn how to create events that occur at regular intervals: every day, every week, every month or every year. How to add a recurring event? Reference management in ONLYOFFICE documents with Mendeley, Zotero and EasyBib Learn how to keep people informed about all the events from your calendar. How to share your Calendar? To inform people about some of your events you can grant access to a certain event for individuals or groups. Learn how to share your event with colleges from this detailed how-to guide. How to share your event with other portal users? How to log in to ONLYOFFICE using Single sign-on (SSO) How to activate Telegram notifications for ONLYOFFICE Workspace The Telegram messenger for conversations in ONLYOFFICE Docs Translate texts in ONLYOFFICE Docs with Google, DeepL, and Apertium How to call your customers right from ONLYOFFICE CRM using Twilio Count words, characters, and paragraphs in ONLYOFFICE Docs How to integrate ONLYOFFICE with WordPress All Editors Collaborating on documents Collaborating on presentations Collaborating on spreadsheets Collaborating on text documents Editing documents from kDrive in ONLYOFFICE You have a kDrive account and want to edit your documents using ONLYOFFICE? Follow this step-by-step guide to find out how to edit documents stored in your kDrive from the Documents portal module. Documents Module Adding/creating files and folders Documents is a module for storing, managing, sharing, and co-editing documents, spreadsheets, presentations, etc. The multi-format media-player is included. Managing files and folders Overview of the module sections Changing module settings Viewing/editing files Editing documents Editing presentations Editing spreadsheets Editing text documents ONLYOFFICE Docs comprises web-based collaborative editors for text documents, spreadsheets, and presentations that support all major <a href="https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Document-Editor/HelpfulHints/SupportedFormats.aspx">document</a>, <a href="https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Spreadsheet-Editor/HelpfulHints/SupportedFormats.aspx">spreadsheet</a> and <a href="https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Presentation-Editor/HelpfulHints/SupportedFormats.aspx">presentation</a> formats. Troubleshooting All Editors All Editors will help you learn more about the editors' features in details. Working with forms Languages available for ONLYOFFICE Projects app for iOS Protect documents with a password Protect presentations with a password Protect spreadsheets with a password Configuring JWT for ONLYOFFICE Docs Handwriting recognition Create a Table of Contents Plugin manager Change application settings Macros settings Change presentation settings Change spreadsheet settings online editor settings Add bookmarks Bookmarks allow you to quickly jump to a certain position in the current document or add a link to this location within the document. Add watermark Text watermarks allow to indicate your document status (for example, confidential, draft etc.), image watermarks allow to add an image, for example your company logo. endnotes Insert date and time Insert date and time into your document. Insert endnotes Insert endnotes to provide explanations for some terms or make references to the sources. Insert footnotes Insert headers and footers Insert headers and footers into your document, add different headers and footer to the first page or odd and even pages. Insert page breaks Insert page breaks and keep lines together. Insert page numbers Insert page numbers to navigate through your document easier. Insert section breaks Insert section breaks to use different formatting for each section of the document. page formatting Set page parameters Set page parameters: page orientation and size. footnotes Insert column breaks Insert footnotes to provide explanations for some terms or make references to the sources. Adding page numbers in word Assigning a color to your calendar Assigning different colors to your calendars helps you distinguish events that belong to them at a glance or even group your calendars. For example, you can select a single color for all project-related or shared calendars to find the needed events easily or to set priorities on them. Please refer to this tip for more detailed information. Adding a third-party calendar feed Want to view the read-only version of a third-party calendar within Calendar with no need to switch between them? You can add the iCal feed link of this calendar to Calendar and save your time and effort tracking all the events from both calendars. Read this tip to do that. Export calendar to devices Synchronize your portal calendar with a third-party calendar on an Android or iOS device via CalDAV protocol Creating a recurring event A recurring event is an event that repeats on a regular basis: daily, weekly, monthly or yearly. For example, if you have to make a report every Monday, you can add the same event to your calendar several times or create this event once and specify how often it occurs using the Repeat Event feature. This guide will show you how to set a recurring event. add event Creating an all-day event all-day event An all-day event is an event that lasts an entire day or longer. For example, if you plan a seminar or a training for two days you can select a start and end date and check the All-day event feature instead of entering the time. This guide will show you how to create an all-day event. annual event create event daily event delete event delete recurring event edit event entire day monthly event recurrence period recurring event repeat event weekly event Change paragraph indents Change paragraph indents: the first line offset from the left part of the page as well as the paragraph offset from the left and right sides of the page. Copy/clear text formatting Copy/clear text formatting within your document. Insert a drop cap Insert a drop cap and adjust its frame properties to make your document look more expressive. paragraph formatting Create lists Create bulleted and numbered lists in the document changing the lists outline. Creating a hanging indent Insert line breaks Set paragraph line spacing line spacing Set paragraph line spacing in your document. Set up paragraph outline level Set up the paragraph level in the document structure. Set tab stops tab stops Set tab stops. text indentation using rulers View settings and navigation tools The description of view settings and navigation tools such as rulers, zoom, previous/next slide buttons. The description of view settings and navigation tools such as rulers, zoom, previous/next page buttons. Apply font decoration styles Apply font decoration styles: increment/decrement values, bold, italic, underline, strikeout, superscript/subscript. Add hyperlinks Add hyperlinks to a word or text fragment leading to an external website or to another slide in the same presentation. Add hyperlinks to a word or text fragment leading to an external website or another worksheet. Add hyperlinks to a word or text fragment leading to an external website. change color external links font formatting font style Set font type, size, and color Change the following text formatting parameters: font type, size, and color. insert links internal links Change regional settings Save, download, print your document Save, download and print your documents in various formats. View document information View document title, author, location, creation date, persons with the rights to view or edit the document, and statistics. operations with files Save, print, download your presentation Save, print and download your presentations in various formats. View presentation information View presentation title, author, location, creation date, persons with the rights to view or edit the presentation. Save, print, download your spreadsheet Save, print and download your spreadsheet in various formats. View spreadsheet information View spreadsheet title, author, location, creation date, and statistics. file info Use the Find function Use the Find and Replace function Download and print your document Save, export, print your document Download your presentation Print your presentation Save and export your presentation Download and print your spreadsheet Save, export, print your spreadsheet print files save files Search and replace function The description of the document search and replace function in Document Editor. The description of the search function in Presentation Editor. search for text in a file search tools The description of the search and replace functions in Spreadsheet Editor. Switching ONLYOFFICE Docs Community Edition for Windows to HTTPS protocol Logging in on behalf of other users in the server version Change impersonation settings on your local server to log in to the portal on behalf of any user Managing memory quota Getting Started with ONLYOFFICE Docs ADDRESS function CHOOSE function COLUMN function COLUMNS function FORMULATEXT function HLOOKUP function HYPERLINK function INDEX function INDIRECT function LOOKUP function lookup and reference functions MATCH function OFFSET function ROW function ROWS function TRANSPOSE function VLOOKUP function XLOOKUP function ASC function CHAR function CHOOSECOLS function CHOOSEROWS function CLEAN function CODE function CONCATENATE function CONCAT function DOLLAR function DROP function HSTACK function TAKE function text and data functions TOCOL function TOROW function VSTACK function WRAPCOLS function WRAPROWS function EXACT function FIND/FINDB functions FIXED function LEFT/LEFTB functions LEN/LENB function LOWER function MID/MIDB functions NUMBERVALUE function PROPER function REPLACE/REPLACEB functions REPT function RIGHT/RIGHTB functions SEARCH/SEARCHB functions SUBSTITUTE function TEXTAFTER function TEXTBEFORE function TEXT function TEXTJOIN function TEXTSPLIT function T function TIME function UNICHAR function UNICODE function UPPER function Use formulas in tables You can perform simple calculations on data in table cells by adding formulas. using functions using named ranges VALUE function Compiling Desktop Editors for Ubuntu Installing Desktop Editors on Deepin Installing ONLYOFFICE Desktop Editors to Red Hat, CentOS and derivatives Installing Desktop Editors to Ubuntu and derivatives Installing Desktop Editors for Windows Associating files with Desktop Editors on Windows 10 Connecting to your ONLYOFFICE Workspace Enterprise Edition Connecting to your Infomaniak cloud Connecting to your Liferay server Connecting to your Nextcloud server Connecting to your ownCloud server Connecting to your Personal cloud Connecting to your DocSpace cloud Connecting to your Seafile server Running ONLYOFFICE Desktop Editors via AppImage Installing Desktop Editors on EndlessOS Installing Desktop Editors via Flatpak Installing the GUI version of Desktop Editors Installing Desktop Editors on Linux Mint Installing ONLYOFFICE Desktop Editors for Mac OS Installing Desktop Editors on Manjaro Installing Desktop Editors from snap package Installing Desktop Editors on SparkyLinux Installing Desktop Editors on Zorin OS Integrating ONLYOFFICE with Mattermost Integrate ONLYOFFICE with Mattermost. Insert footnotes and endnotes Graphic annotations and markup Changing the user status to "Guest" Change the user status to Guest. Read this guide to learn how it can be done in a few easy steps. Creating a chat room Create a conference to discuss an issue with many people at once in real time. Refer to this step by step guide to learn how to create a chat room in the Talk and start talking instantly. Creating a mailing list Are you tired of typing one and the same message each time selecting a recipient from the contact list? Refer to this step by step guide to learn how to create a mailing list and send the message to many people at once. Exporting CRM database and editing it using spreadsheet editor Do you need to export the customer information from your CRM database as a .csv file to edit and print it later? You can do it right on the portal. Just follow these easy steps. Inviting guests ONLYOFFICE allows you to add guests granting the view-only permissions without any extra payment. Read this guide to learn how it can be done in a few easy steps. Setting up mail server ONLYOFFICE Mail Server is an additional feature of ONLYOFFICE Mail to send and receive emails using your own domain names. By connecting mail to your own domain, you will be able to do business correspondence using your own addresses such as your company name. In the following guide you will find out how to set up and get started with ONLYOFFICE Mail Server. Adding user fields Found out that you need some more fields to enter additional data concerning your customers in the contact list, opportunities you create or cases you organize? It's easy! Just read this tip to learn how to add user fields. Adjusting temperature levels Need to specify or even change the default temperature levels (cold, warm, hot) you can use to characterize your potential customers and navigate through the contact list easier? Read our tip on how to do that. Creating a new category of history events The standard history event categories are mail, note, phone call, meeting. Need more categories for events that are added to history of your contacts, opportunities or cases? It's easy! Just read this tip to learn how to create new categories. Creating a website contact form Wish to gain more prospective customers effortlessly? Just create a website contact form, embed the generated source code into your website and your leads' contact details will be automatically added to your client database. Read this tip to learn how to do that. Creating E-mail templates If you often send emails of the same type or need to reply to similar messages from time to time, you can speed up the communication process by using the Templates option of the Mail module. Creating invoices for your clients When the sales cycle is completed, you can create an invoice for the products and services you have provided and send it to the client. CRM allows you to do it quickly and easily. Just fill in the fields of the invoice form and send it as an attachment to your client using Mail. Getting Started: Feed The Feed list encompasses all recent events on your portal that concern each user individually or are common for all users. Making forums more interactive Would you like to make your forum more interactive? Just add a poll. This step by step guide will show you how to quickly and easily add a poll to your new forum topic. Calling your customers directly from CRM The VoIP feature allows you to receive incoming calls from your customers and make outgoing calls right from a web browser using virtual numbers provided by the Twilio service. Incoming calls from new phone numbers that are not stored in your customer base are automatically saved as new CRM contacts. Deleting duplicate contacts Maintaining a contact list within the CRM module it might happen that portal users add the same contact details several times. After finding duplicate contacts, you can eliminate them in a few easy steps. Please refer to this tip for more information. Exporting all CRM data Want to be on the safe side and backup your CRM data with important information on your customers, opportunities, tasks, cases as well as contact history? Export all data into CSV files and download in a ZIP archive with just one mouse click! Languages available at your portal Want to know what languages you can switch your portal to? Need to find out what languages will be available in the nearest future? Or want to contribute to ONLYOFFICE translation? Just have a look at the table given in this tip! Performing group operations Want to save time while managing your contacts within the CRM module? Use group operations to delete, set permissions, send an email, add a tag to several contacts at once! The needed instructions can be found in this tip. Setting opportunity stages Need to change the default opportunity stages according to the business process in your company? It's not that hard! Just add new stages to the standard ones or change their order. This tip will provide assistance with this operation. Specifying tasks categories Need to change the default tasks categories according to the processes specific for your company? It's easy! Just add new categories characterizing task goals that aren't covered in the default ones. This tip will help you do that. Using search options on your portal You always need to find something after entering your portal, be it a certain task or a blog post. ONLYOFFICE offers you a number of search options that help you achieve your goal as quickly as possible. Read this tip to learn how to use them. Adjusting contact types Are you tired of searching through your contact list? Do you want to specify your contacts more precisely? ONLYOFFICE gives you an opportunity to do that! Are you curious? Read more... Using tags within the CRM module Add tags to your contacts, opportunities, cases to classify, group, describe them and facilitate the search process in this way. Read this tip to learn how to manage existing tags and create new ones. access level Adding alias and creating mail groups Have you already set up your first domain on the portal? Do all the portal users have the corporate mailboxes? If the greater part of the work is done, you're in a right place! Read this article to learn how to create mail groups and aliases. Read more... Adding invoice items and taxes The 'Invoice' option significantly simplifies the cooperation with your clients as long as you have an opportunity to create and send the invoices right from your portal. Read this tip and you'll find out how to add items and taxes to your invoice without a hitch! change photo Changing attachment size Do you need to send a file via Talk but its size exceeds the allowed limit? Since now on you don't need to worry about it. Just change the allowed file size and use the Talk functionality to the full. create groups edit profile How ONLYOFFICE handles Google user data Languages available in ONLYOFFICE Personal Want to know what languages you can use your ONLYOFFICE Personal cloud in? Need to find out what languages will be available in the nearest future? Or want to contribute to ONLYOFFICE translation? Just have a look at the table given in this tip! How it works manage access rights track birthdays CELL function ERROR.TYPE function information functions ISBLANK function ISERR function ISERROR function ISEVEN function ISFORMULA function ISLOGICAL function AND function FALSE function IFERROR function IF function IFNA function IFS function ISNA function ISNONTEXT function ISNUMBER function ISODD function ISREF function ISTEXT function logical functions NA function N function NOT function OR function SHEET function SHEETS function SWITCH function How to switch between two languages in a table TRUE function TYPE function Using the IF and AND functions XOR function add calendar assign color calendar color change calendar color create calendar edit calendar event color share calendar share event event reminder export calendar iCal feed reminder time remove reminder set reminder share with group share with user database functions DAVERAGE function DCOUNTA function DCOUNT function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DVAR function DVARP function Multimedia formats supported in ONLYOFFICE Type via voice Type via voice build source code How to install ONLYOFFICE Docs Developer Edition [Docker Script Guide 2023] translate ONLYOFFICE Translating ONLYOFFICE to other languages https://help.onlyoffice.com/products/files/doceditor.aspx?fileid=3750483&doc=dFpNcW9uR0ZuV28rbDBoZkt0VnBONXROUGJiTVdNaGx5aFpCRnB0bjVidz0_IjM3NTA0ODMi0 The document describes how the portal can be translated into the languages it is currently not available. If you'd like to see ONLYOFFICE in your own language then you are welcome to contribute. translator community BESSELI function BESSELJ function BESSELK function BESSELY function BIN2DEC function BIN2HEX function BIN2OCT function BITAND function BITLSHIFT function BITOR function BITRSHIFT function BITXOR function COMPLEX function CONVERT function DEC2BIN function DEC2HEX function DEC2OCT function DELTA function engineering functions ERFC.PRECISE function ERF function ERF.PRECISE function ERFС function GESTEP function HEX2BIN function HEX2DEC function HEX2OCT function IMABS function IMAGINARY function IMARGUMENT function IMCONJUGATE function IMCOS function IMCOSH function IMCOT function IMCSC function IMCSCH function IMDIV function IMEXP function IMLN function IMLOG10 function IMLOG2 function IMPOWER function IMPRODUCT function IMREAL function IMSEC function IMSECH function IMSIN function IMSINH function IMSQRT function IMSUB function IMSUM function IMTAN function OCT2BIN function OCT2DEC function OCT2HEX function ACCRINT function ACCRINTM function AMORDEGRC function AMORLINC function COUPDAYBS function COUPDAYS function COUPDAYSNC function COUPNCD function COUPNUM function COUPPCD function CUMIPMT function CUMPRINC function DB function DDB function DISC function DOLLARDE function DOLLARFR function DURATION function EFFECT function financial functions FV function FVSCHEDULE function INTRATE function IPMT function IRR function ISPMT function MDURATION function MIRR function NOMINAL function NPER function NPV function ODDFPRICE function ODDFYIELD function ODDLPRICE function ODDLYIELD function PDURATION function PMT function PPMT function PRICEDISC function PRICE function PRICEMAT function PV function RATE function RECEIVED function RRI function SLN function SYD function TBILLEQ function TBILLPRICE function TBILLYIELD function VDB function XIRR function XNPV function YIELDDISC function YIELD function YIELDMAT function Ports which must be opened for ONLYOFFICE Groups ABS function ACOS function ACOSH function ACOT function ACOTH function AGGREGATE function ARABIC function ASIN function ASINH function ATAN2 function ATAN function ATANH function math and trigonometry functions BASE function CEILING function CEILING.MATH function CEILING.PRECISE function CHIINV function COMBINA function COMBIN function COS function COSH function COT function COTH function CSC function CSCH function DECIMAL function DEGREES function ECMA.CEILING function EVEN function EXP function FACTDOUBLE function FACT function FLOOR function FLOOR.MATH function FLOOR.PRECISE function GCD function INT function ISO.CEILING function LCM function LN function LOG10 function LOG function MDЕTERM function MINVERSE function MMULT function MOD function MROUND function MULTINOMIAL function MUNIT function ODD function PI function POWER function PRODUCT function QUOTIENT function RADIANS function RANDARRAY function RANDBETWEEN function RAND function ROMAN function ROUNDDOWN function ROUND function ROUNDUP function SEC function SECH function SERIESSUM function SIGN function SIN function SINH function SQRT function SQRTPI function SUBTOTAL function SUM function SUMIF function SUMPRODUCT function SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMIFS function SUMXMY2 function TAN function TANH function TRUNC function ONLYOFFICE DocSpace ONLYOFFICE PDF Editor ONLYOFFICE PDF Editor is an online application that lets you edit your PDFs directly on the portal. Using ONLYOFFICE PDF Editor, you can perform various editing operations, print the edited PDFs keeping all the formatting details or download them onto your computer hard disk drive. PDF Editor page margins page orientation page size statistical functions column breaks headers and footers Insert footers Headers and footers allow to add some additional info on a slide, such as date and time, slide number, or a text. Headers and footers allow to add some additional info on a printed worksheet, such as date and time, page number, sheet name etc. Headers and footers are displayed in the printed version of a spreadsheet. page breaks page numbering section breaks Apply transitions Add animation effects between slides. document structure Manage sheets Manage sheets in Spreadsheet Editor: insert, delete, rename, copy and move. Manage slides Add new blank slides, duplicate, move or delete them. line breaks arrange objects insert autoshape insert chart modify object Add hyphenation Integrating ONLYOFFICE with Box Integrate ONLYOFFICE with Box content management platform. Integrating ONLYOFFICE with Pipedrive Integrate ONLYOFFICE with Pipedrive sales customer relationship management tool. Integrating ONLYOFFICE with SuiteCRM Integrate ONLYOFFICE with SuiteCRM. AVEDEV function AVERAGEA function AVERAGE function AVERAGEIF function AVERAGEIFS function BETADIST function BETA.DIST function BETA.INV function BETAINV function BINOMDIST function BINOM.DIST function BINOM.DIST.RANGE function BINOM.INV function CHIDIST function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CHISQ.TEST function CHITEST function CONFIDENCE function CONFIDENCE.NORM function CONFIDENCE.T function CORREL function COUNTA function COUNTBLANK function COUNT function COUNTIF function COUNTIFS function COVAR function COVARIANCE.P function COVARIANCE.S function CRITBINOM function DEVSQ function EXPON.DIST function EXPONDIST function F.DIST function FDIST function F.DIST.RT function F.INV function FINV function F.INV.RT function FISHER function FISHERINV function FORECAST.ETS.CONFINT function FORECAST.ETS function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT function FORECAST function FORECAST.LINEAR function FREQUENCY function FTEST function F.TEST function GAMMA.DIST function GAMMADIST function GAMMA function GAMMA.INV function GAMMAINV function GAMMALN function GAMMALN.PRECISE function GAUSS function GEOMEAN function GROWTH function HARMEAN function HYPGEOMDIST function HYPGEOM.DIST function INTERCEPT function KURT function LARGE function LINEST function LOGEST function LOGINV function LOGNORM.DIST function LOGNORMDIST function LOGNORM.INV function MAXA function MAX function MAXIFS function MEDIAN function MINA function MIN function MINIFS function MODE function MODE.MULT function MODE.SNGL function NEGBINOMDIST function NEGBINOM.DIST function NORMDIST function NORM.DIST function NORMINV function Integrating ONLYOFFICE with Dropbox Integrate ONLYOFFICE with Dropbox. Set language and region NORM.INV function NORMSDIST function NORM.S.DIST function NORMSINV function NORM.S.INV function PEARSON function PERCENTILE.EXC function PERCENTILE function PERCENTILE.INC function PERCENTRANK function PERCENTRANK.EXC function PERCENTRANK.INC function PERMUTATIONA function PERMUT function PHI function POISSON.DIST function POISSON function PROB function QUARTILE.EXC function QUARTILE function QUARTILE.INC function RANK.AVG function RANK.EQ function RANK function RSQ function SKEW function SKEW.P function SLOPE function SMALL function STANDARDIZE function STDEVA function STDEV function STDEVP function STDEV.P function STDEV.S function STDEVPA function STEYX function TDIST function Connecting Dameng database to ONLYOFFICE Docs T.DIST.2T function T.DIST function T.DIST.RT function T.INV.2T function T.INV function TINV function TRIMMEAN function TREND function TTEST function T.TEST function UNIQUE function Using the AVERAGE function VARA function VAR function VARPA function VARP function VAR.P function VAR.S function WEIBULL.DIST function WEIBULL function ZTEST function Z.TEST function date and time functions DATEDIF function DATE function DATEVALUE function DAY function DAYS360 function DAYS function EDATE function EOMONTH function HOUR function ISOWEEKNUM function MINUTE function MONTH function NETWORKDAYS function NETWORKDAYS.INTL function NOW function SECOND function TIMEVALUE function TODAY function