Close Help Center Documents Projects CRM People Community Calendar Mail Talk Settings Glossary FAQ General Technology Pricing Enterprise Edition Integration Edition Developer Edition Community Server All A B C D E F G H I J K L M N O P Q R S T U V W X Y Z BIN2DEC function BIN2HEX function BIN2OCT function BINOMDIST function About Document Editor About Presentation Editor About Spreadsheet Editor ABS function ACCRINT function ACCRINTM function ACOS function ACOSH function Add borders Add borders Add cell borders Add hyperlinks Add hyperlinks Add hyperlinks Add hyperlinks Add hyperlinks Add or remove rows/columns Admin Adding alias and creating mail groups Adding a third-party calendar feed to Calendar Adding content to your portal via email Admin Adding invoice items and taxes Adding fonts to Document Server Adding new fonts, languages and spellcheckers to Document Server Admin Adding user fields ADDRESS function Adjust chart settings Admin Adjusting contact types Admin Adjusting temperature levels Advanced settings of Document Editor Advanced settings of Presentation Editor Advanced Settings of Spreadsheet Editor Align and arrange objects on a slide Align data in cells Align data in cells Align your text in a line or paragraph Align your text in a paragraph Altering LDAP settings AMORDEGRC function AMORLINC function AND function Apply cell style Apply font decoration styles Apply font decoration styles Apply formatting presets Apply formatting presets Apply table styles Apply transitions ASIN function ASINH function Assigning a color to your calendar Assigning a color to your calendar ATAN function ATAN2 function ATANH function Automatic time tracking while performing a task AVEDEV function AVERAGE function AVERAGEA function AVERAGEIF function Calendar CEILING function Change application settings Change application settings Change color scheme Change number format Change number format Change paragraph indents Change paragraph indents Change text wrapping Changing attachment size in Talk Changing SMTP settings for Community Server Changing your portal language CHAR function CHOOSE function CLEAN function Clear text, format in a cell CODE function Collaborative document editing Collaborative presentation editing Collaborative spreadsheet editing COLUMN function COLUMNS function COMBIN function Manage files Manage files Community Community Server Docker version troubleshooting Community Server for Docker system requirements Community Server for Linux system requirements Community Server for Windows system requirements Community Server Linux version troubleshooting Community Server version frequently asked questions Community Server Windows version troubleshooting Compiling Community Server for a local server Compiling Document Server for a local server COMPLEX function CONCATENATE function CONFIDENCE function Configuring network settings on Ubuntu Connecting a MySQL database to Community Server Connecting Document Server to Community Server Connecting Document Server to Community Server Connecting Document Server to Community Server Connecting Document Server to Community Server Context menus in the Documents module Coordinate all aspects of your activities using the online office Coordinate your project using ONLYOFFICE Gantt chart Copy/clear formatting Copy/clear text formatting Copy/paste data, undo/redo your actions Copy/paste text passages, undo/redo your actions CORREL function COS function COSH function COUNT function COUNTA function COUNTBLANK function COUNTIF function COUPDAYBS function COUPDAYS function COUPDAYSNC function COUPNCD function COUPNUM function COUPPCD function COVAR function Create a new document or open an existing one Create a new presentation or open an existing one Create a new spreadsheet or open an existing one Create/delete sheets Create lists Create lists Create lists Admin Creating a new category of history events Admin Creating a website contact form CRITBINOM function CRM Cut/copy/paste data CUMIPMT function CUMPRINC function Admin Data backup Admin Data import from Basecamp DATE function DATEDIF function DATEVALUE function DAY function DAYS360 function DB function DDB function DEC2BIN function DEC2HEX function DEC2OCT function Decorating your posts DEGREES function DELTA function DEVSQ function DISC function Document collaboration made easy in the online office Document Server Docker version troubleshooting Document Server for Docker system requirements Document Server for Linux system requirements Document Server for Windows system requirements Documents Documents module troubleshooting DOLLAR function DOLLARDE function DOLLARFR function DURATION function EDATE function EFFECT function EOMONTH function ERF function ERFС function ERROR.TYPE function EVEN function EXACT function EXP function EXPONDIST function Admin Exporting all CRM data FACT function FACTDOUBLE function FALSE function Fill objects and select colors FIND/FINDB functions FISHER function FISHERINV function FIXED function FLOOR function Following projects FORECAST function FREQUENCY function FV function FVSCHEDULE function GAMMALN function GCD function GEOMEAN function GESTEP function General FAQ Get a panoramic picture of multitask activities Getting rid of duplicate contacts Group operations with contacts HARMEAN function HEX2BIN function HEX2DEC function HEX2OCT function Hide or show rows/columns HLOOKUP function HOUR function How to add a recurring event? How to add a recurring event? How to add contacts to CRM in bulk? How to add Mail Server to Enterprise Edition installation? Admin How to add users using the contact information from a CSV file? Admin How to add users using the contact information from a mail client address book? Admin How to add users using the contact information from Yahoo, Google? How to become an ONLYOFFICE translator? How to change a pricing plan? How to co-edit the document online? How to connect Desktop Editors to your SaaS portal? How to create a chat room using Talk? How to create a CSV file? How to create a knowledge base? How to create a mailing list in Talk? How to create an all-day event? How to create an all-day event? How to create chat rooms? How to create invoices for your clients? Admin How to create your own portal? How to deploy Community Server using Docker service Admin How to deploy Document Server on your server? How to export your CRM customer database and edit it using Spreadsheet Editor? How to embed a document into your blog? How to insert an image into your posted message? How to install Community Server on your server? How to install Desktop Editors for Windows to your computer? How to install Desktop Editors to Ubuntu and derivatives? Admin How to invite guest users to your online office Admin How to invite guests to your portal? How to keep your contacts up-to-date? How to link an opportunity with a project? How to link tasks within your project? How to link your project with a CRM contact? How to make your forum more interactive? How to manage your project using the Gantt chart? How to migrate your Community Server from Docker to Linux? How to migrate your Community Server from Docker to Linux? How to migrate your Community Server from Linux to Docker? How to migrate your Community Server from Linux to Docker? How to migrate your Community Server from Windows to Linux? How to migrate your Community Server from Windows to Linux? How to organize and manage your company documentation? How to organize and track a common event? Admin How to organize mass mailing? How to pay for your portal? How to buy Enterprise Edition Server Subscription? How to restrict access to your project? How to set or remove an event reminder? Admin How to set up mail server ? How to share your event with other portal users? How to share your Calendar? How to start working with your Enterprise Edition? How to switch your Community Server to HTTPS protocol? How to switch your Community Server to HTTPS protocol? How to switch your Document Server to HTTPS protocol? How to switch your office to HTTPS using Control Panel? How to track your potential sales? How to track the work time efficiently? How to track time and payments in the online office How to update your Enterprise Edition to the latest version? How to upgrade your Community Server to the latest version? How to upgrade your Community Server to the latest version? How to upgrade your Docker Community Server to the latest version? How to use two-factor authentication on portals? HYPGEOMDIST function IF function IFERROR function IMABS function IMAGINARY function IMARGUMENT function IMCONJUGATE function IMCOS function IMDIV function IMEXP function IMLN function IMLOG10 function IMLOG2 function IMPOWER function IMPRODUCT function IMREAL function IMSIN function IMSQRT function IMSUB function IMSUM function INDEX function INDIRECT function Insert a drop cap Insert and adjust images Insert and edit charts Insert and format autoshapes Insert and format autoshapes Insert and format tables Insert and format your text Insert autoshapes Insert autoshapes Insert autoshapes Insert chart Insert charts Insert charts Insert equations Insert formulas Insert function Insert headers and footers Insert images Insert images Insert images Insert images Insert line breaks Insert or delete cells, rows, and columns Insert page breaks Insert page breaks Insert page numbers Insert page numbers Insert section breaks Insert section breaks Insert tables Insert tables Insert text objects Insert text objects Installing Community Server for Docker on a local server Installing Community Server for Debian, Ubuntu and derivatives Installing Document Server for Docker on a local server Installing Document Server for Linux on Debian, Ubuntu and derivatives Installing Enterprise Edition using the provided script Installing Mail Server for Docker on a local server INT function Integrating other resources with Documents Integrating Talk into an IM client INTERCEPT function INTRATE function IPMT function IRR function ISBLANK function ISERR function ISERROR function ISEVEN function ISLOGICAL function ISNA function ISNONTEXT function ISNUMBER function ISODD function ISPMT function ISREF function ISTEXT function Keyboard shortcuts Keyboard shortcuts Keyboard shortcuts KURT function Languages available at your portal LARGE function LCM function LEFT/LEFTB functions LEN/LENB function LN function LOG function LOG10 function LOGINV function LOGNORMDIST function Looking for online editor with perfect formatting? LOOKUP function LOWER function Mail Mail module troubleshooting Mail Server Docker version troubleshooting Mail Server for Docker system requirements Manage data in rows/columns Manage existing sheets Manage sheets Manage slides Admin Manage users on your portal Manage your customer relations with the online office Manage your documents with the online office Manage your projects online with the online office Managing portal subscriptions Manipulate objects Manipulate objects Manipulate objects Manipulate objects on a slide MATCH function MAX function MAXA function MDЕTERM function MDURATION function MEDIAN function Merge cells Merge cells MID/MIDB functions Migration to server solution MIN function MINA function MINUTE function MINVERSE function MIRR function MMULT function MOD function MODE function MONTH function MROUND function MULTINOMIAL function N function NA function Navigate through your document Navigate through your spreadsheet NEGBINOMDIST function NETWORKDAYS function NOMINAL function NORMDIST function NORMINV function NORMSDIST function NORMSINV function NOT function NOW function NPER function NPV function OCT2BIN function OCT2DEC function OCT2HEX function ODD function ODDFPRICE function ODDFYIELD function ODDLPRICE function ODDLYIELD function OFFSET function ONLYOFFICE Documents OR function PEARSON function People PERCENTILE function PERCENTRANK function PERMUT function PI function PMT function POISSON function Portal Configuration Portal notifications: manageable notifications Portal notifications: non-manageable notifications POWER function PPMT function Preview your presentation PRICE function PRICEDISC function PRICEMAT function Pricing FAQ PROB function PRODUCT function Projects PROPER function PV function QUARTILE function QUOTIENT function RADIANS function RAND function RANDBETWEEN function RATE function Real-time co-editing in ONLYOFFICE Reattaching tasks to other milestones Rebranding your office using White Label feature RECEIVED function Removing Community Server for Docker from your computer Removing Document Server for Docker from your computer Removing Mail Server for Docker from your computer Removing unused fonts from Document Server REPLACE/REPLACEB functions Report templates with automatic delivery by email REPT function Resize rows/columns RIGHT/RIGHTB functions ROMAN function ROUND function ROUNDDOWN function ROUNDUP function ROW function ROWS function RSQ function Running Community Server using HTTPS protocol Save/download/print your document Save/export/print your document Save/export/print your spreadsheet Save/print/download your presentation Save/print/download your spreadsheet Search and replace function Search and replace functions Search function SEARCH/SEARCHB functions SECOND function Select background color for a paragraph Select background color for a paragraph Select cell background color Select, cut, copy, paste data Select, cut, copy, paste text SERIESSUM function Set font type, size, and color Set font type, size, and color Set font type, size, and color Set font type, size, style, and colors Set page parameters Set page parameters Set paragraph line spacing Set paragraph line spacing Set slide parameters Set tab stops Admin Set up access rights on your portal Admin Setting opportunity stages Setting time zone for your calendar Several ways to communicate with team using Talk Show/hide nonprinting characters SIGN function SIN function SINH function SKEW function SLN function SLOPE function SMALL function Sort and filter data Admin Specifying tasks categories Spell-checking SQRT function SQRTPI function STANDARDIZE function STDEV function STDEVA function STDEVP function STDEVPA function STEYX function SUBSTITUTE function SUM function SUMIF function SUMPRODUCT function SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMXMY2 function Supported formats of electronic documents Supported formats of electronic presentations Supported formats of spreadsheets SYD function T function Talk TAN function TANH function TBILLEQ function TBILLPRICE function TBILLYIELD function Technology FAQ Templates for similar projects TEXT function The Authorization Keys option TIME function TIMEVALUE function TODAY function TRANSPOSE function TRIM function TRUE function TRUNC function TYPE function Undo/redo your actions Undo/redo your actions Undo/redo your actions UPPER function Use Mail Merge Use named ranges Use the Find and Replace function Use the Find and Replace function Using additional ports with Community Server Using search options on your portal Admin Using tags within the CRM module Using the Control Panel backup/restore feature VALUE function VAR function VARA function VARP function VARPA function VDB function Versions and revisions in Documents View document information View document information View file information View presentation information View settings and navigation tools View settings and navigation tools View settings and navigation tools View spreadsheet information Viewing all active tasks assigned to you quickly VLOOKUP function WEEKDAY function WEEKNUM function WORKDAY function Wrap text in a cell XIRR function XNPV function YEAR function YEARFRAC function YIELD function YIELDDISC function YIELDMAT function Your perfect day with ONLYOFFICE CRM Installing Community Edition using the provided script How to migrate your Community Server from Docker to Linux? Community Edition for Docker system requirements How to install the GUI version of Desktop Editors? How to install Desktop Editors to Red Hat and derivatives? How to deploy multiple portals using the Multitenancy feature? Updating Mail Server integrated with Community Server Sort and filter data Running Document Server using Docker Compose Ports which must be opened for Integration Edition Installing Integration Edition for Linux on Debian, Ubuntu and derivatives Installing Integration Edition for Docker on a local server Ports which must be opened for Community Server Ports which must be opened for Document Server Ports which must be opened for Mail Server Installing Integration Edition for Windows on a local server Installing Enterprise Edition for Windows on a local server Connecting Mail Server to Community Server on Windows Connecting Mail Server to Community Server on Linux Installing Document Server for Linux on CentOS and derivatives Installing Enterprise Edition with additional script parameters Installing Community Edition with additional script parameters Community Server changelog Document Server changelog Installing Integration Edition for Linux on CentOS and derivatives Connecting Mail Server to Community Server via Portal Settings Installing Document Server as a cluster Installing Document Server as a cluster Compiling Document Server using Docker Document Server Linux version troubleshooting Document Server Windows version troubleshooting SUMIFS function Insert equations Insert equations Mail Server changelog Desktop Editors changelog Installing Community Server as a cluster Enterprise Edition for Linux system requirements Settings for most popular mail services How to call your customers directly from your CRM? How to send documents for electronic signature? Adding new portal language to Community Server How to switch Integration Edition for Windows to HTTPS protocol? AVERAGEIFS function COUNTIFS function Insert footnotes Installing Community Edition for Windows on a local server How to migrate from Community Edition to Enterprise Edition on Windows? How to migrate from Community Edition to Enterprise Edition on Windows? How to migrate from Community Edition to Enterprise Edition using Docker script? How to migrate from Community Edition to Enterprise Edition using Docker script? Using Document Server behind the proxy ONLYOFFICE Single Sign-on overview How to configure Shibboleth v2.x - 3.x IdP and ONLYOFFICE SP How to configure ONLYOFFICE SP and OneLogin IdP How to switch Talk to TLS protocol? How to switch Talk to TLS protocol? Installing Community Server for Red Hat, CentOS and derivatives Adding a new interface language to Document Server Adding a new interface language to Document Server Languages available for Document Server interface Languages available for Community Server interface How to switch your office to HTTPS when installing from RPM/DEB packages? Languages available for Desktop Editors interface Installing all three servers (Community Server, Document Server, Mail Server) integrated Installing all three servers (Community Server, Document Server, Mail Server) integrated Installing all three servers (Community Server, Document Server, Mail Server) integrated Insert content controls Spell-checking ACOT function ACOTH function ARABIC function BASE function CEILING.MATH function CEILING.PRECISE function COMBINA function COT function COTH function CSC function CSCH function DECIMAL function FLOOR.PRECISE function FLOOR.MATH function ISO.CEILING function SEC function SECH function SUBTOTAL function BETADIST function BETA.DIST function BETA.INV function BINOM.DIST function BINOM.INV function CHIDIST function CHIINV function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CONFIDENCE.NORM function CONFIDENCE.T function EXPON.DIST function F.DIST function F.DIST.RT function FDIST function F.INV function FINV function F.INV.RT function GAMMA function GAMMA.DIST function GAMMADIST function GAMMA.INV function GAMMAINV function GAMMALN.PRECISE function GAUSS function LOGNORM.DIST function LOGNORM.INV function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK.EXC function PERCENTRANK.INC function RANK function RANK.AVG function RANK.EQ function T.DIST function TDIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function TINV function CONCAT function NUMBERVALUE function IFNA function XOR function IMCOSH function IMCOT function IMCSC function IMCSCH function IMSEC function IMSECH function IMSINH function IMTAN function Open or create new files and folders Share files and folders How to configure ONLYOFFICE SP and AD FS IdP Migrating MS Exchange data to ONLYOFFICE Admin Setting up the default currency and exchange rates Ports which must be opened for Developer Edition Installing Developer Edition for Linux on Debian, Ubuntu and derivatives Installing Developer Edition for Docker on a local server Installing Developer Edition for Windows on a local server Installing Developer Edition for Linux on CentOS and derivatives Installing Document Server as a cluster Installing Document Server as a cluster How to switch Developer Edition for Windows to HTTPS protocol? Control Panel changelog Integration Edition frequently asked questions Developer Edition license frequently asked questions Installing Enterprise Edition from RPM/DEB packages using the provided script Installing Community Edition from RPM/DEB packages using the provided script Align and arrange objects on a page Change text wrapping Introducing the Document Editor user interface File tab Home tab Insert tab Layout tab Collaboration tab Plugins tab Introducing the Presentation Editor user interface File tab Home tab Insert tab Plugins tab Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Plugins tab AGGREGATE function ECMA.CEILING function DAYS function ISOWEEKNUM function NETWORKDAYS.INTL function WORKDAY.INTL function BESSELI function BESSELJ function BESSELK function BESSELY function BITAND function BITLSHIFT function BITOR function BITRSHIFT function BITXOR function ERF.PRECISE function ERFC.PRECISE function TEXTJOIN function UNICHAR function UNICODE function BINOM.DIST.RANGE function CHITEST function CHISQ.TEST function COVARIANCE.P function COVARIANCE.S function FORECAST.LINEAR function MAXIFS function MINIFS function MODE.MULT function MODE.SNGL function NEGBINOM.DIST function NORM.DIST function NORM.INV function NORM.S.DIST function NORM.S.INV function PERMUTATIONA function PHI function POISSON.DIST function QUARTILE.EXC function QUARTILE.INC function SKEW.P function STDEV.S function STDEV.P function TRIMMEAN function TTEST function T.TEST function VAR.P function VAR.S function WEIBULL function WEIBULL.DIST function ZTEST function Z.TEST function RRI function ISFORMULA function SHEET function SHEETS function SWITCH function DAVERAGE function DCOUNT function DCOUNTA function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DVAR function DVARP function Adding custom modules to Community Server Creating API for the Community Server custom modules Folder permissions hierarchy in the Documents module How to create a WebDAV server on Ubuntu and connect it to ONLYOFFICE How to create a WebDAV server on Windows and connect it to ONLYOFFICE Admin The authorization keys option How it works Create a Table of Contents References tab Collaboration tab Edit pivot tables Pivot Table tab Collaboration tab PDURATION function IFS function FORMULATEXT function FORECAST.ETS function FORECAST.ETS.CONFINT function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT function F.TEST function How to switch your office to HTTPS for the Windows version? FTEST function HYPGEOM.DIST function CONVERT function ONLYOFFICE Documents for Android - Overview Open or create new files and folders Share files and folders Navigate through your document Select, cut, copy, paste text Undo/redo your actions Set page parameters Insert page breaks Insert column breaks Insert section breaks Insert page numbers Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Create lists Set font type, size, and color Apply font decoration styles Add hyperlinks Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects View document information Use the Find and Replace function Download your document How to install Desktop Editors from snap package? Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Create or delete sheets Manage existing sheets Set font type, size, and color Add hyperlinks Select cell background color Add cell borders Apply cell style Align data in cells Wrap text in a cell Merge cells Change number format Remove rows/columns Hide or show rows/columns Resize rows/columns Sort data Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects View spreadsheet information Use the Find and Replace function Download spreadsheet Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Manage slides Set slide parameters Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation 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 Insert tables Insert autoshapes Insert images Adjust chart settings Manipulate objects View presentation information Use the Find function Download your presentation Overview Common operations Project management Milestones Tasks Discussions Project documents How to connect Desktop Editors to your Enterprise Edition? How to associate files with Desktop Editors on Windows 10? Add bookmarks Layout tab How to connect Desktop Editors to your Nextcloud or ownCloud server? How to encrypt documents and co-edit them securely? End-to-end encryption in the ONLYOFFICE Desktop Editors Languages available for ONLYOFFICE Documents app for Android Languages available for ONLYOFFICE Documents app for iOS Languages available for ONLYOFFICE Projects app for iOS Enterprise Edition for Windows system requirements Enterprise Edition for Docker system requirements How to upgrade your Enterprise Edition to the latest version? Changing domain used with Mail Server Export calendar to devices How to run an external script after starting Mail Server Docker container? How to create mailboxes on the mail server using a script? How to change passwords for mailboxes on the mail server using a script? How to synchronize new mailboxes with old ones using the script? Configuring the server to run behind NAT How to deploy the ONLYOFFICE application in DigitalOcean? How to protect your documents with a password using Desktop Editors? ONLYOFFICE Demonstration ONLYOFFICE Online Editor overview How to call your customers right from ONLYOFFICE CRM using Twilio How to integrate ONLYOFFICE with Nextcloud using the app from the official store How to integrate ONLYOFFICE with Nextcloud How to integrate ONLYOFFICE Document Server with ownCloud How to integrate ONLYOFFICE Document Server with SharePoint How to deploy ONLYOFFICE on DigitalOcean using One-Click App ONLYOFFICE Desktop Editors - free office suite for offline document editing and collaboration 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 Use formulas in tables ASC function BETAINV function HYPERLINK function