Close Help Center Installation Guides Administration Guides Integration Guides User Guides Contribution Guides Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors Trial period Looking for the alphabetically sorted list of all the Help Center articles? You can always find it here Site map Help Center Installation Guides ONLYOFFICE Docs Community Edition All platforms ONLYOFFICE Docs changelog Languages available for ONLYOFFICE Docs interface Ports which must be opened for ONLYOFFICE Docs Using ONLYOFFICE Docs behind the proxy Uninstall default plugin from the server editors Adding new plugins to server editors Connecting Amazon S3 bucket as a cache to ONLYOFFICE Docs 1-click install Installing ONLYOFFICE Docs Community Edition using the provided script Docker version ONLYOFFICE Docs for Docker system requirements Installing ONLYOFFICE Docs on a local server Installing ONLYOFFICE Docs Docker version for the 64-bit ARM architecture Running ONLYOFFICE Docs using Docker Compose Installing all ONLYOFFICE Workspace components integrated Adding a new interface language to ONLYOFFICE Docs Updating ONLYOFFICE Docs Community Edition for Docker to the latest version Removing ONLYOFFICE Docs for Docker from your computer ONLYOFFICE Docs Docker version troubleshooting Linux version ONLYOFFICE Docs for Linux system requirements Compiling ONLYOFFICE Docs for a local server Compiling Document Builder Installing ONLYOFFICE Docs for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs on Debian systems for the 64-bit ARM architecture Installing ONLYOFFICE Docs for CentOS and derivatives Installing ONLYOFFICE Docs on CentOS or RHEL for the 64-bit ARM architecture Installing ONLYOFFICE Docs for Linux snap package Updating ONLYOFFICE Docs for Linux to the latest version Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Adding fonts to ONLYOFFICE Docs Switching ONLYOFFICE Docs to HTTPS protocol Adding a new interface language to ONLYOFFICE Docs Adding new themes to the ONLYOFFICE Docs Presentation Editor Removing ONLYOFFICE Docs for Linux from your computer ONLYOFFICE Docs Linux version troubleshooting Windows version ONLYOFFICE Docs for Windows system requirements Deploying ONLYOFFICE Docs on your server Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Adding new fonts, languages and spellcheckers to ONLYOFFICE Docs Removing unused fonts from ONLYOFFICE Docs Adding new themes to the ONLYOFFICE Docs Presentation Editor Updating ONLYOFFICE Docs Community Edition for Windows to the latest version ONLYOFFICE Docs Windows version troubleshooting 1-Click Apps Deploying ONLYOFFICE Docs in DigitalOcean Deploying ONLYOFFICE Docs in Cloudron Deploying ONLYOFFICE Docs in Vultr Podman Running ONLYOFFICE Docs Community Edition as Podman on Fedora ONLYOFFICE Docs Enterprise Edition All platforms Ports which must be opened for ONLYOFFICE Docs Enterprise Edition Working with plugins when using CSP Connecting Amazon S3 bucket as a cache to ONLYOFFICE Docs 1-click install Installing ONLYOFFICE Docs Enterprise Edition using the provided script Docker version Installing ONLYOFFICE Docs Enterprise Edition for Docker on a local server Installing ONLYOFFICE Docs Enterprise Edition Docker version for the 64-bit ARM architecture Updating ONLYOFFICE Docs Enterprise Edition for Docker to the latest version Linux version Installing ONLYOFFICE Docs Enterprise Edition for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs Enterprise Edition on Debian systems for the 64-bit ARM architecture Installing ONLYOFFICE Docs Enterprise Edition for CentOS and derivatives Installing ONLYOFFICE Docs Enterprise Edition on CentOS or RHEL for the 64-bit ARM architecture Windows version Installing ONLYOFFICE Docs Enterprise Edition for Windows on a local server Switching ONLYOFFICE Docs Enterprise Edition to HTTPS protocol Updating ONLYOFFICE Docs Enterprise Edition for Windows to the latest version 1-Click Apps Installing ONLYOFFICE Docs Enterprise Edition Univention appliance Deploying ONLYOFFICE Docs Enterprise Edition in Cloudron Amazon Deploying ONLYOFFICE Docs Enterprise Edition using AMI Alibaba Cloud Deploying ONLYOFFICE Docs Enterprise Edition on Alibaba Cloud Podman Running ONLYOFFICE Docs Enterprise Edition as Podman on Fedora ONLYOFFICE Docs Developer Edition All platforms Ports which must be opened for ONLYOFFICE Docs Developer Edition Working with plugins when using CSP Changing interface themes in ONLYOFFICE Docs Configuring ONLYOFFICE Docs Developer Edition Connecting Amazon S3 bucket as a cache to ONLYOFFICE Docs 1-click install Installing ONLYOFFICE Docs Developer Edition using the provided script Docker version Installing ONLYOFFICE Docs Developer Edition for Docker on a local server Installing ONLYOFFICE Docs Developer Edition Docker version for the 64-bit ARM architecture Updating ONLYOFFICE Docs Developer Edition for Docker to the latest version Linux version Installing ONLYOFFICE Docs Developer Edition for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs Developer Edition on Debian systems for the 64-bit ARM architecture Installing ONLYOFFICE Docs Developer Edition for CentOS and derivatives Installing ONLYOFFICE Docs Developer Edition on CentOS or RHEL for the 64-bit ARM architecture Windows version Installing ONLYOFFICE Docs Developer Edition for Windows on a local server Switching ONLYOFFICE Docs Developer Edition for Windows to HTTPS protocol Updating ONLYOFFICE Docs Developer Edition for Windows to the latest version Amazon Deploying ONLYOFFICE Docs Developer Edition using AMI Alibaba Cloud Deploying ONLYOFFICE Docs Developer Edition on Alibaba Cloud Podman Running ONLYOFFICE Docs Developer Edition as Podman on Fedora ONLYOFFICE Workspace Docker version ONLYOFFICE Workspace for Docker system requirements Installing ONLYOFFICE Workspace using the provided script Installing ONLYOFFICE Workspace with additional script parameters Installing ONLYOFFICE Workspace using Docker Compose Installing all ONLYOFFICE Workspace components integrated Migrating from ONLYOFFICE Workspace to Enterprise Edition using Docker script Linux version Installing ONLYOFFICE Workspace from RPM/DEB packages using the provided script Migrating from ONLYOFFICE Workspace to Enterprise Edition on Linux Windows version Installing ONLYOFFICE Workspace for Windows on a local server Migrating from ONLYOFFICE Workspace to Enterprise Edition on Windows 1-Click Apps Deploying ONLYOFFICE Workspace in DigitalOcean Deploying ONLYOFFICE Workspace in Vultr Configuring Configuring ONLYOFFICE WebDAV server ONLYOFFICE Workspace Enterprise Edition All platforms How to start working with your ONLYOFFICE Workspace Enterprise Edition? How to buy ONLYOFFICE Workspace Enterprise Edition subscription? Docker version ONLYOFFICE Workspace Enterprise Edition for Docker system requirements Installing ONLYOFFICE Workspace Enterprise Edition using the provided script Installing ONLYOFFICE Workspace Enterprise Edition components on separate servers Installing ONLYOFFICE Workspace Enterprise Edition with additional script parameters Linux version ONLYOFFICE Workspace Enterprise Edition for Linux system requirements Installing ONLYOFFICE Workspace Enterprise Edition from RPM/DEB packages using the provided script Switching to HTTPS when installing from RPM/DEB packages Migrating MS Exchange data to ONLYOFFICE Windows version ONLYOFFICE Workspace Enterprise Edition for Windows system requirements Installing ONLYOFFICE Workspace Enterprise Edition for Windows on a local server Switching to HTTPS for the Windows version Updating ONLYOFFICE Workspace Enterprise Edition to the latest version Amazon Deploying ONLYOFFICE Workspace Enterprise Edition using AMI Alibaba Cloud Deploying ONLYOFFICE Workspace Enterprise Edition on Alibaba Cloud ONLYOFFICE Workspace Cloud Service (SaaS version) How to pay for your portal? How to change a pricing plan? ONLYOFFICE Groups All platforms ONLYOFFICE Groups changelog Languages available for ONLYOFFICE Groups interface 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 Ports which must be opened for ONLYOFFICE Groups Integrating third-party services in the server version Changing SMTP settings for ONLYOFFICE Groups Docker version ONLYOFFICE Groups for Docker system requirements Installing ONLYOFFICE Groups for Docker on a local server Migrating ONLYOFFICE Groups from Linux to Docker Migrating ONLYOFFICE Groups from Docker to Linux Installing all ONLYOFFICE Workspace components integrated Updating ONLYOFFICE Groups for Docker to the latest version Using additional ports with ONLYOFFICE Groups Connecting a MySQL database to ONLYOFFICE Groups Running ONLYOFFICE Groups using HTTPS protocol Running ONLYOFFICE Groups behind NAT Removing ONLYOFFICE Groups for Docker from your computer ONLYOFFICE Groups Docker version troubleshooting Linux version ONLYOFFICE Groups for Linux system requirements Installing ONLYOFFICE Groups for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Groups for Red Hat, CentOS, and derivatives Migrating ONLYOFFICE Groups from Windows to Linux Migrating ONLYOFFICE Groups from Linux to Docker Migrating ONLYOFFICE Groups from Docker to Linux Updating ONLYOFFICE Groups for Linux to the latest version Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Linux Switching ONLYOFFICE Groups to HTTPS protocol Configuring network settings on Ubuntu Switching ONLYOFFICE Talk to TLS protocol on Linux version ONLYOFFICE Groups Linux version troubleshooting Windows version ONLYOFFICE Groups for Windows system requirements Compiling ONLYOFFICE Groups for a local server Installing ONLYOFFICE Groups on a local server Migrating from the Cloud version to server version Migrating ONLYOFFICE Groups from Windows to Linux Updating ONLYOFFICE Groups for Windows to the latest version Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Windows Connecting ONLYOFFICE Mail to ONLYOFFICE Groups via Portal Settings Switching ONLYOFFICE Groups to HTTPS protocol Switching ONLYOFFICE Talk to TLS protocol on Windows version ONLYOFFICE Groups Windows version troubleshooting ONLYOFFICE Mail All platforms ONLYOFFICE Mail changelog Ports which must be opened for ONLYOFFICE Mail Docker version ONLYOFFICE Mail for Docker system requirements Installing ONLYOFFICE Mail for Docker on a local server Installing all ONLYOFFICE Workspace components integrated Updating ONLYOFFICE Mail integrated with ONLYOFFICE Groups Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Windows Connecting ONLYOFFICE Mail to ONLYOFFICE Groups via Portal Settings Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Linux Changing domain used with ONLYOFFICE Mail Running an external script after starting ONLYOFFICE Mail Docker container Creating mailboxes in ONLYOFFICE Mail using a script Changing passwords for mailboxes in ONLYOFFICE Mail using a script Synchronizing new mailboxes with old ones using the script Removing ONLYOFFICE Mail for Docker from your computer ONLYOFFICE Mail Docker version troubleshooting Enabling vsyscall on Debian ONLYOFFICE Talk All platforms Ports which must be opened for ONLYOFFICE Talk Linux version Installing ONLYOFFICE Talk for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Talk for Red Hat, CentOS, and derivatives Switching ONLYOFFICE Talk to TLS protocol on Linux version Windows version Installing ONLYOFFICE Talk on a local server Switching ONLYOFFICE Talk to TLS protocol on Windows version Desktop ONLYOFFICE Desktop Editors All platforms Desktop Editors changelog Languages available for Desktop Editors interface Desktop Editors troubleshooting Windows version Desktop Editors for Windows system requirements Installing Desktop Editors for Windows Linux version Desktop Editors for Linux system requirements Compiling Desktop Editors for Ubuntu Installing Desktop Editors to Ubuntu and derivatives Installing ONLYOFFICE Desktop Editors to Red Hat, CentOS and derivatives Installing Desktop Editors on Deepin Installing Desktop Editors on EndlessOS Installing Desktop Editors on Linux Mint Installing Desktop Editors on Manjaro Installing Desktop Editors on SparkyLinux Installing Desktop Editors on Zorin OS Running ONLYOFFICE Desktop Editors via AppImage Installing the GUI version of Desktop Editors Installing Desktop Editors from snap package Installing Desktop Editors via Flatpak Mac OS version Desktop Editors for Mac OS system requirements Installing ONLYOFFICE Desktop Editors for Mac OS Configuring ONLYOFFICE Desktop Editors Getting started with ONLYOFFICE Desktop Editors Associating files with Desktop Editors on Windows 10 Uninstall default plugin from the desktop editors Running ONLYOFFICE Desktop Editors with parameters Connecting ONLYOFFICE Desktop Editors to a Cloud Connecting to your SaaS portal Connecting to your Personal cloud Connecting to your ONLYOFFICE Workspace Enterprise Edition Connecting to your Nextcloud server Connecting to your ownCloud server Connecting to your Liferay server Connecting to your Infomaniak cloud Security Settings of ONLYOFFICE Desktop Editors Using the Private Room to work on your documents securely Protecting your documents with a password Protecting your documents with a digital signature Administration Guides Managing portals Portal Configuration. Getting Started Reinforcing security Portal Configuration. Getting Started Using two-factor authentication Data backup & restore in the cloud version Workspace Enterprise Edition Security Guide Configuring modules and tools Documents. Getting Started Managing company documentation Projects. Getting Started CRM. Getting Started Exporting all CRM data Adding user fields Setting opportunity stages Adjusting temperature levels Adjusting contact types Specifying tasks categories Creating a new category of history events Using tags within the CRM module Adding invoice items and taxes Setting up the default currency and exchange rates Creating a website contact form Organizing mass mailing People. Getting Started Community. Getting Started Mail. Getting Started How it works Setting up mail server Adding alias and creating mail groups Settings for most popular mail services Calendar. Getting Started Talk. Getting Started Changing attachment size Customizing modules and tools Portal Configuration. Getting Started Changing your portal language Languages available at your portal Managing users People. Getting Started Importing users from Google Importing users from a CSV file Importing users from a mail client address book Inviting guests Changing the user status to "Guest" Managing Active connections Connecting external services Portal Configuration. Getting Started Altering LDAP settings in the SaaS version Single Sign-on feature in the SaaS version Integrating third-party services in the server version Integrating third-party services in the cloud version Integrating other resources with the Documents module Editing documents from Dropbox in ONLYOFFICE Editing documents from Google Drive in ONLYOFFICE Editing documents from kDrive in ONLYOFFICE Editing documents from Nextcloud in ONLYOFFICE Editing documents from ownCloud in ONLYOFFICE Editing documents from Box in ONLYOFFICE Editing documents from OneDrive in ONLYOFFICE Control Panel Control Panel changelog Adding ONLYOFFICE Mail to the ONLYOFFICE Workspace installation Updating ONLYOFFICE Workspace to the latest version Using the Control Panel backup/restore feature Protect data using encryption Connecting third-party storages Navigating via Full-Text Search feature Branding your online office Switching to HTTPS using Control Panel Altering LDAP settings Deploying multiple portals using the Multitenancy feature Using the Private Room to work on your documents securely ONLYOFFICE Single Sign-on overview Configuring ONLYOFFICE SP and Shibboleth IdP Configuring ONLYOFFICE SP and OneLogin IdP Configuring ONLYOFFICE SP and AD FS IdP Tracking login history Receiving audit trail data Migrating Nextcloud data to ONLYOFFICE Workspace Integration Guides Integrating ONLYOFFICE with Nextcloud Integrating ONLYOFFICE with ownCloud Integrating ONLYOFFICE with Confluence Integrating ONLYOFFICE with Humhub Integrating ONLYOFFICE with Alfresco Integrating ONLYOFFICE with Liferay Integrating ONLYOFFICE with SharePoint Integrating ONLYOFFICE with Plone Integrating ONLYOFFICE with Chamilo Integrating ONLYOFFICE with Jira Integrating ONLYOFFICE with Nuxeo Integrating ONLYOFFICE with Redmine Integrating ONLYOFFICE with Strapi Integrating ONLYOFFICE with Moodle Integrating ONLYOFFICE with WordPress User Guides ONLYOFFICE Docs Document Editor Program interface Introducing the Document Editor user interface File tab Home tab Insert tab Draw tab Layout tab References tab Forms tab Collaboration tab Protection tab View tab Plugins tab Basic operations Create a new document or open an existing one Copy/paste text passages, undo/redo your actions Change color scheme Page formatting Set page parameters Show/hide nonprinting characters Insert section breaks Insert headers and footers Insert date and time Insert page numbers Insert line numbers Insert footnotes Insert endnotes Convert endnotes and footnotes Add bookmarks Add watermark Add hyphenation Paragraph formatting Align your text in a paragraph Set up paragraph outline level Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert page breaks Add borders Set tab stops Create lists Create hanging indents Text formatting Apply formatting presets Set font type, size, and color Apply font decoration styles Copy/clear text formatting Add hyperlinks Insert cross-references Insert a drop cap Operations on objects Insert tables Use formulas in tables Insert images Insert autoshapes Insert charts Insert text objects Insert SmartArt objects Draw freehand on a document Add caption Insert symbols Align and arrange objects on a page Change text wrapping Insert content controls Create a table of contents Add and format a table of figures Insert videos Fillable forms Create fillable forms Filling out a form Mail Merge Use Mail Merge Math equations Insert equations Collaboration Sharing files and folders Co-editing documents in real time Communicating in real time Commenting documents Tracking changes Comparing and combining documents Version history Plugins Plugin manager Edit an image Create and insert diagrams Edit HTML Correct typography Count words Include a video Insert highlighted code Insert references Translate text Extract text from an image Read the text out loud Type via voice Replace a word by a synonym Upload a document to Wordpress Communicate while editing Make Audio and Video Calls Host and schedule Zoom meetings Use AI to write text Tools and settings View document information Save, download, print your document Advanced settings of Document Editor View settings and navigation tools ONLYOFFICE Document Viewer Search and replace function Spell-checking AutoCorrect features Protecting documents with a password Helpful hints About Document Editor Supported formats of electronic documents Keyboard shortcuts Spreadsheet Editor Program interface Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Draw tab Layout tab Formula tab Data tab Pivot Table tab Collaboration tab Protection tab View tab Plugins tab Basic operations Create a new spreadsheet or open an existing one Cut/copy/paste data Undo/redo your actions Add external links to cells Operations with sheets Manage sheets Insert headers and footers Insert breaks Cell text formatting Set font type, size, style, and colors Add hyperlinks Clear text, format in a cell Editing cell properties Add borders Align data in cells Merge cells Change number format Editing rows/columns Add cells Insert or delete cells, rows, and columns Freeze rows and columns Split cells Sort and filter data Use formatted tables Create and edit pivot tables Create slicers for tables Group data Remove duplicates Conditional formatting Data validation Work with functions Insert functions Date and Time Functions DATE function DATEDIF function DATEVALUE function DAY function DAYS function DAYS360 function EDATE function EOMONTH function HOUR function ISOWEEKNUM function MINUTE function MONTH function NETWORKDAYS function NETWORKDAYS.INTL function NOW function SECOND function TIME function TIMEVALUE function TODAY function WEEKDAY function WEEKNUM function WORKDAY function WORKDAY.INTL function YEAR function YEARFRAC function Engineering Functions 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 ERF function ERF.PRECISE function ERFС function ERFC.PRECISE 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 Text and Data Functions ASC function CHAR function CLEAN function CODE function CONCATENATE function CONCAT function DOLLAR 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 T function TEXT function TEXTJOIN function TRIM function UNICHAR function UNICODE function UPPER function VALUE function Statistical Functions AVEDEV function AVERAGE function AVERAGEA 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 CHIINV function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CHITEST function CHISQ.TEST function CONFIDENCE function CONFIDENCE.NORM function CONFIDENCE.T function CORREL function COUNT function COUNTA function COUNTBLANK 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 function FORECAST.ETS function FORECAST.ETS.CONFINT function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT function FORECAST.LINEAR function FREQUENCY function FTEST function F.TEST function GAMMA function GAMMA.DIST function GAMMADIST 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 LOGNORM.INV function LOGNORMDIST function MAX function MAXA function MAXIFS function MEDIAN function MIN function MINA function MINIFS function MODE function MODE.MULT function MODE.SNGL function NEGBINOMDIST function NEGBINOM.DIST function NORMDIST function NORM.DIST function NORMINV function NORM.INV function NORMSDIST function NORM.S.DIST function NORMSINV function NORM.S.INV function PEARSON function PERCENTILE function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK function PERCENTRANK.EXC function PERCENTRANK.INC function PERMUT function PERMUTATIONA function PHI function POISSON function POISSON.DIST function PROB function QUARTILE function QUARTILE.EXC function QUARTILE.INC function RANK function RANK.AVG function RANK.EQ function RSQ function SKEW function SKEW.P function SLOPE function SMALL function STANDARDIZE function STDEV function STDEV.S function STDEVA function STDEVP function STDEV.P function STDEVPA function STEYX function TDIST function T.DIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function TINV function TRIMMEAN function TREND function TTEST function T.TEST function UNIQUE function VAR function VARA function VARP function VAR.P function VAR.S function VARPA function WEIBULL function WEIBULL.DIST function ZTEST function Z.TEST function Financial Functions 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 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 PRICE function PRICEDISC 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 YIELD function YIELDDISC function YIELDMAT function Math and Trigonometry Functions ABS function ACOS function ACOSH function ACOT function ACOTH function AGGREGATE function ARABIC function ASIN function ASINH function ATAN function ATAN2 function ATANH function BASE function CEILING function CEILING.MATH function CEILING.PRECISE function COMBIN function COMBINA function COS function COSH function COT function COTH function CSC function CSCH function DECIMAL function DEGREES function ECMA.CEILING function EVEN function EXP function FACT function FACTDOUBLE function FLOOR function FLOOR.PRECISE function FLOOR.MATH function GCD function INT function ISO.CEILING function LCM function LN function LOG function LOG10 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 RAND function RANDBETWEEN function RANDARRAY function ROMAN function ROUND function ROUNDDOWN 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 SUMIFS function SUMPRODUCT function SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMXMY2 function TAN function TANH function TRUNC function Lookup and Reference Functions ADDRESS function CHOOSE function COLUMN function COLUMNS function FORMULATEXT function HLOOKUP function HYPERLINK function INDEX function INDIRECT function LOOKUP function MATCH function OFFSET function ROW function ROWS function TRANSPOSE function UNIQUE function VLOOKUP function XLOOKUP function Database Functions DAVERAGE function DCOUNT function DCOUNTA function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DVAR function DVARP function Information Functions CELL function ERROR.TYPE function ISBLANK function ISERR function ISERROR function ISEVEN function ISFORMULA function ISLOGICAL function ISNA function ISNONTEXT function ISNUMBER function ISODD function ISREF function ISTEXT function N function NA function SHEET function SHEETS function TYPE function Logical Functions AND function FALSE function IF function IFERROR function IFNA function IFS function NOT function OR function SWITCH function TRUE function XOR function Insert array formulas Use named ranges Protecting a spreadsheet Protecting a spreadsheet Protecting ranges Protecting your spreadsheets with a password Protecting a sheet Protecting a workbook Operations on objects Insert images Insert charts Insert sparklines Insert and format autoshapes Insert text objects Wrap text Insert SmartArt objects Draw freehand on a spreadsheet Insert symbols and characters Manipulate objects Math equations Insert equations Collaboration Sharing files and folders Co-editing spreadsheets in real time Managing sheet view presets Communicating in real time Commenting spreadsheets Version history Plugins Plugin manager Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Host and schedule Zoom meetings Use AI to write text Tools and settings View file information Save/print/download your spreadsheet Scale a worksheet Advanced settings of Spreadsheet Editor View settings and navigation tools Search and replace functions Spell-checking AutoCorrect features Get data from TXT/CSV file Helpful hints About Spreadsheet Editor Supported formats of spreadsheets Keyboard shortcuts Presentation Editor Program interface Introducing the Presentation Editor user interface File tab Home tab Insert tab Draw tab Transitions tab Animation tab Collaboration tab View tab Plugins tab Basic operations Create a new presentation or open an existing one Copy/paste data, undo/redo your actions Working with slides Manage slides Set slide parameters Apply transitions Insert headers and footers, notes and handouts Preview your presentation Text formatting Insert and format your text Add hyperlinks Create lists Copy/clear formatting Operations on objects Insert and format autoshapes Insert and adjust images Insert and edit charts Insert and format tables Insert SmartArt objects Draw freehand on a slide Adding animations Creating a motion path animation Insert symbols and characters Fill objects and select colors Manipulate objects on a slide Align and arrange objects on a slide Math equations Insert equations Collaboration Sharing files and folders Co-editing presentations in real time Communicating in real time Commenting presentations Version history Plugins Plugin manager Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Host and schedule Zoom meetings Use AI to write text Tools and settings View presentation information Save/print/download your presentation Advanced settings of Presentation Editor View settings and navigation tools Search and Replace Function Spell-checking AutoCorrect features Protecting presentations with a password Enable support for video playback in ONLYOFFICE Desktop Editors Helpful hints About Presentation Editor Supported formats of electronic presentations Keyboard shortcuts User Guides about Editors Adding new fonts to ONLYOFFICE Desktop Editors How to enable dark theme in ONLYOFFICE Docs? Accessibility of ONLYOFFICE Editors Creating a hanging indent How to insert a video Freezing rows and columns Creating a chart from start to finish How to split cells Wrapping text ONLYOFFICE Workspace General questions Managing portal subscriptions Portal notifications: manageable notifications Portal notifications: non-manageable notifications Using search options on your portal ONLYOFFICE Groups ONLYOFFICE Docs ONLYOFFICE Mail ONLYOFFICE Talk ONLYOFFICE Personal Languages available in ONLYOFFICE Personal Personal Managing versions and revisions Sharing documents Editing documents from Dropbox in ONLYOFFICE Editing documents from Google Drive in ONLYOFFICE Editing documents from kDrive in ONLYOFFICE Editing documents from Nextcloud in ONLYOFFICE Editing documents from ownCloud in ONLYOFFICE Editing documents from Box in ONLYOFFICE Editing documents from OneDrive in ONLYOFFICE ONLYOFFICE Groups Documents. Getting Started Integrating other resources with the Documents module Creating CSV files Co-editing documents online Managing versions and revisions Using context menus Sharing files and folders Sending for electronic signature Learning about folder permissions hierarchy Documents module troubleshooting Projects. Getting Started Using templates for similar projects Linking project with a CRM contact Following projects Reattaching tasks to other milestones Viewing all active tasks quickly Linking tasks within your project Managing your project using the Gantt chart Tracking work time efficiently Automatic time tracking while performing a task Reporting templates with automatic delivery by E-mail Configuring report types Creating custom task status Restricting access to projects CRM. Getting Started Adding contacts in bulk Keeping contacts up-to-date Exporting CRM database and editing it using spreadsheet editor Performing group operations Deleting duplicate contacts Tracking potential sales Linking an opportunity with a project Organizing and tracking a common event Creating invoices for your clients Calling your customers directly from CRM People. Getting Started Community. Getting Started Decorating posts Making forums more interactive Inserting images in posted messages Creating a knowledge base Calendar. Getting Started Creating an all-day event Creating a recurring event Assigning a color to your calendar Setting time zone for your calendar Export calendar to devices Adding a third-party calendar feed Mail. Getting Started Creating E-mail templates Mail module troubleshooting Talk. Getting Started Changing attachment size Creating a mailing list Creating a chat room Getting Started: Feed ONLYOFFICE Mobile Apps Documents ONLYOFFICE Documents app for iOS Overview Languages available for ONLYOFFICE Documents app for iOS Manage files Open or create new files and folders Share files and folders Document Editor for iOS Basic operations Navigate through your document Select, cut, copy, paste text Undo/redo your actions Handwriting recognition Graphic annotations and markup Page formatting Set page parameters Insert page breaks Insert section breaks Insert page numbers Insert footnotes and endnotes Add hyphenation Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert line breaks Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects Fillable forms Filling out a form Tools and settings View document information Change application settings Use the Find and Replace function Save, export, print your document Protect documents with a password Spreadsheet Editor for iOS Basic operations Navigate through your spreadsheet Select, cut, copy, paste, AutoFill data Undo/redo your actions Operations with sheets Create/delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Wrap text in a cell Merge cells Change number format Apply table styles Editing rows/columns Manage data in rows/columns Add or remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings View spreadsheet information Change application settings Use the Find and Replace function Set language and region Save, export, print your spreadsheet Protect spreadsheets with a password Presentation Editor for iOS Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Change text indents Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Create charts Manipulate objects Tools and settings View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Protect presentations with a password ONLYOFFICE Documents app for Android Overview Languages available for ONLYOFFICE Documents app for Android Manage files Open or create new files and folders Share files and folders Document Editor for Android Basic operations Navigate through your document Switch between editing modes Select, cut, copy, paste text Undo/redo your actions Page formatting Set page parameters Insert section breaks Insert page numbers Insert footnotes Insert endnotes Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Fillable forms Fill out OFORM fillable forms Operations on objects Insert tables Insert autoshapes Insert images Insert charts Change text wrapping Manipulate objects Tools and settings Collaborative document editing Protect documents with a password Spell-checking Use the Find and Replace function Download and print your document View document information Spreadsheet Editor for Android Basic operations Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Operations with sheets Create or delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Wrap text in a cell Merge cells Change number format Selective cell clear Editing rows/columns Remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings Collaborative spreadsheet editing Protect spreadsheets with a password Use the Find and Replace function Change spreadsheet settings Change regional settings Download and print your spreadsheet View spreadsheet information Presentation Editor for Android Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Set slide parameters Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Insert charts Manipulate objects Tools and settings Communicating in real time Protect presentations with a password Spell-checking Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information ONLYOFFICE Mobile web editors for iOS Overview Languages available for ONLYOFFICE Mobile web editors for iOS Manage files Open or create new files and folders Share files and folders Document Editor web version for iOS Basic operations Navigate through your document Select, cut, copy, paste text Undo/redo your actions Page formatting Set page parameters Insert page breaks Insert column breaks Insert section breaks Insert page numbers Insert footnotes Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Fillable forms Filling out a form Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects Create a Table of Contents Tools and settings Collaborative document editing Spell-checking Use the Find and Replace function Change application settings Macros settings Download and print your document View document information Spreadsheet Editor web version for iOS Basic operations Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Freeze panes Operations with sheets Create/delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Editing rows/columns Add or remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings Collaborative spreadsheet editing Use the Find and Replace function Change spreadsheet settings Change application settings Macros settings Download and print your spreadsheet View spreadsheet information Presentation Editor web version for iOS Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Set slide parameters Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Change text indents Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Manipulate objects Tools and settings Communicating in real time Spell-checking Use the Find and Replace function Change presentation settings Change application settings Macros settings Download your presentation Print your presentation View presentation information ONLYOFFICE Mobile web editors for Android Overview Languages available for ONLYOFFICE Mobile web editors for Android Manage files Open or create new files and folders Share files and folders Document Editor web version for Android Basic operations Navigate through your document Select, cut, copy, paste text Undo/redo your actions Page formatting Set page parameters Insert page breaks Insert column breaks Insert section breaks Insert page numbers Insert footnotes Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Fillable forms Fill out OFORM fillable forms Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects Create a Table of Contents Tools and settings Collaborative document editing Spell-checking Use the Find and Replace function Change application settings Macros settings Download and print your document View document information Spreadsheet Editor web version for Android Basic operations Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Freeze panes Operations with sheets Create/delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Editing rows/columns Remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings Collaborative spreadsheet editing Use the Find and Replace function Change spreadsheet settings Change application settings Macros settings Download and print your spreadsheet View spreadsheet information Presentation Editor web version for Android Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Set slide parameters Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Change text indents Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Manipulate objects Tools and settings Communicating in real time Spell-checking Use the Find and Replace function Change presentation settings Change application settings Macros settings Download your presentation Print your presentation View presentation information Projects ONLYOFFICE Projects for iOS Overview Languages available for ONLYOFFICE Projects app for iOS Common operations Project management Milestones Tasks Discussions Project documents ONLYOFFICE Projects for Android Overview Common operations Project management Tasks Discussions Project documents Contribution ONLYOFFICE translation Reporting issues FAQ General FAQ Technology FAQ Pricing FAQ ONLYOFFICE Workspace Enterprise Edition frequently asked questions Document Server Enterprise Edition frequently asked questions Developer Edition license frequently asked questions ONLYOFFICE Groups frequently asked questions Connectors Watch video Portal modules General Coordinate all aspects of your activities using the online office Admin Set up access rights on your portal ONLYOFFICE Demonstration Documents Looking for online editor with perfect formatting? ONLYOFFICE Online Editor overview Real-time co-editing in ONLYOFFICE Manage your documents with the online office Document collaboration made easy in the online office Using the Review mode in ONLYOFFICE Fast and Strict co-editing modes in ONLYOFFICE Using content controls in ONLYOFFICE How to compare documents in ONLYOFFICE How to use Sheet View and custom filtering in spreadsheet collaboration How to create, edit and customize charts in ONLYOFFICE Docs Reference types in ONLYOFFICE Docs: footnotes, endnotes, cross references Using Version History in ONLYOFFICE How to Use Slicers in ONLYOFFICE Communication in ONLYOFFICE editors: Comments, Mentions and Chat Pivot Tables in ONLYOFFICE Document Permissions in ONLYOFFICE Data validation in ONLYOFFICE How to create ebooks in ONLYOFFICE Docs How to turn on dark mode in ONLYOFFICE Docs Conditional formatting Pt. 1: Highlighting numeric and text values Conditional formatting Pt. 2: Data bars, color scales, icon sets ONLYOFFICE 7.0: fillable forms, password protection and version history in spreadsheets Fillable forms in ONLYOFFICE Docs Projects Manage your projects online with the online office How to track time and payments in the online office Coordinate Your Project using ONLYOFFICE Gantt Chart CRM Your perfect day with ONLYOFFICE CRM Manage your customer relations with the online office How to call your customers right from ONLYOFFICE CRM using Twilio People Admin Manage users on your portal Admin How to invite guest users to your online office Mail Check ONLYOFFICE Workspace mailboxes using third-party clients Calendar Get a panoramic picture of multitask activities Assigning a color to your calendar How to create an all-day event? How to add a recurring event? How to share your Calendar? How to share your event with other portal users? How to set or remove an event reminder? Talk Several ways to communicate with team using Talk How to create chat rooms? Plugins Reference management in ONLYOFFICE documents with Mendeley, Zotero and EasyBib Count words, characters, and paragraphs in ONLYOFFICE Docs The Telegram messenger for conversations in ONLYOFFICE Docs Grammalecte in ONLYOFFICE Docs: spellchecker for French texts Translate texts in ONLYOFFICE Docs with Google, DeepL, and Apertium HTML plugin for ONLYOFFICE Docs Correct grammar with LanguageTool in ONLYOFFICE Docs How to integrate ONLYOFFICE with WordPress Server ONLYOFFICE Workspace Enterprise Edition How to install Enterprise Edition using the provided script Run your own office with the ONLYOFFICE on your private AWS cloud ONLYOFFICE Workspace How to deploy ONLYOFFICE on DigitalOcean using One-Click App How to import users from Active Directory to ONLYOFFICE How to use Control Panel in ONLYOFFICE Workspace How to use the backup/restore feature How to log in to ONLYOFFICE using Single sign-on (SSO) How to activate Telegram notifications for ONLYOFFICE Workspace ONLYOFFICE Groups How to deploy Community Server using Docker service How to install Community Server on your Windows server How to install Community Server with Document Server on Ubuntu 14.04 ONLYOFFICE Docs How to install Community Server with Document Server on Ubuntu 14.04 How to install Document Server and connect it to Community Server on Windows How to deploy ONLYOFFICE Docs on your server using Docker How to install plugins in ONLYOFFICE Docs Integration How to integrate ONLYOFFICE with Nextcloud using the app from the official store How to integrate ONLYOFFICE with Nextcloud How to integrate ONLYOFFICE Docs with ownCloud How to integrate ONLYOFFICE Docs with SharePoint How to integrate ONLYOFFICE with Alfresco Share How to integrate ONLYOFFICE with Nuxeo How to integrate ONLYOFFICE with Nuxeo with the official plugin How to connect ONLYOFFICE Docs to Confluence How to integrate ONLYOFFICE with Chamilo Configuring ONLYOFFICE connector for Nextcloud Configuring ONLYOFFICE connector for ownCloud How to integrate ONLYOFFICE with Redmine How to integrate ONLYOFFICE with Jira How to integrate ONLYOFFICE with Moodle ONLYOFFICE Desktop Editors General ONLYOFFICE Desktop Editors - free office suite for offline document editing and collaboration Private Rooms in ONLYOFFICE Workspace for Secure Collaboration on Documents Connecting ONLYOFFICE Desktop Editors to Seafile Protect documents with a digital signature in ONLYOFFICE Desktop Editors Protect documents with a password in ONLYOFFICE Desktop Editors ONLYOFFICE Desktop Editors v7.0: form filling, kDrive & Liferay integration ONLYOFFICE Mobile Apps ONLYOFFICE Documents for Android ONLYOFFICE Documents for Android Document Editor overview ONLYOFFICE Documents for Android Spreadsheet Editor overview ONLYOFFICE Documents for Android Presentation Editor overview How to open and save docs to different formats using ONLYOFFICE Documents for Android How to share files using ONLYOFFICE Documents for Android How to organize files using ONLYOFFICE Documents for Android How to connect ONLYOFFICE Documents for Android to Cloud How to connect ONLYOFFICE Documents for Android to Personal How to connect ONLYOFFICE Documents for Android to Server How to edit documents stored on Nextcloud with ONLYOFFICE on your Android device Appendix Glossary Article complete index Site map