Close Help Center Installation Guides Administration Guides Integration Guides User Guides Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors 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 Adding alias and creating mail groups Adding a third-party calendar feed Adding invoice items and taxes Adding fonts to ONLYOFFICE Docs Adding new fonts, languages and spellcheckers to ONLYOFFICE Docs Adding user fields ADDRESS function Adjust chart settings Adjusting contact types 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. Getting Started 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 Changing SMTP settings for ONLYOFFICE Groups Changing your portal language CHAR function CHOOSE function CLEAN function Clear text, format in a cell CODE function Collaborative document editing Communicating in real time Collaborative spreadsheet editing COLUMN function COLUMNS function COMBIN function Manage files Manage files Community. Getting Started ONLYOFFICE Groups Docker version troubleshooting ONLYOFFICE Groups for Docker system requirements ONLYOFFICE Groups for Linux system requirements ONLYOFFICE Groups for Windows system requirements ONLYOFFICE Groups Linux version troubleshooting ONLYOFFICE Groups frequently asked questions ONLYOFFICE Groups Windows version troubleshooting Compiling ONLYOFFICE Groups for a local server Compiling ONLYOFFICE Docs for a local server COMPLEX function CONCATENATE function CONFIDENCE function Configuring network settings on Ubuntu Connecting a MySQL database to ONLYOFFICE Groups Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Connecting ONLYOFFICE Docs to ONLYOFFICE Groups Using context menus 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 Creating a new category of history events Creating a website contact form CRITBINOM function CRM. Getting Started Cut/copy/paste data CUMIPMT function CUMPRINC function Data backup & restore in the cloud version DATE function DATEDIF function DATEVALUE function DAY function DAYS360 function DB function DDB function DEC2BIN function DEC2HEX function DEC2OCT function Decorating posts DEGREES function DELTA function DEVSQ function DISC function Document collaboration made easy in the online office ONLYOFFICE Docs Docker version troubleshooting ONLYOFFICE Docs for Docker system requirements ONLYOFFICE Docs for Linux system requirements ONLYOFFICE Docs for Windows system requirements Documents. Getting Started 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 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 Deleting duplicate contacts Performing group operations HARMEAN function HEX2BIN function HEX2DEC function HEX2OCT function Hide or show rows/columns HLOOKUP function HOUR function Creating a recurring event How to add a recurring event? Adding contacts in bulk Adding ONLYOFFICE Mail to the ONLYOFFICE Workspace installation Importing users from a CSV file Importing users from a mail client address book Importing users from Google ONLYOFFICE translation How to change a pricing plan? Co-editing documents online Connecting to your SaaS portal Creating a chat room Creating CSV files Creating a knowledge base Creating a mailing list Creating an all-day event How to create an all-day event? How to create chat rooms? Creating invoices for your clients Admin How to create your own portal? How to deploy Community Server using Docker service Deploying ONLYOFFICE Docs on your server Exporting CRM database and editing it using spreadsheet editor Embedding a document into a blog Inserting images in posted messages Installing ONLYOFFICE Groups on a local server Installing Desktop Editors for Windows Installing Desktop Editors to Ubuntu and derivatives Admin How to invite guest users to your online office Inviting guests Keeping contacts up-to-date Linking an opportunity with a project Linking tasks within your project Linking project with a CRM contact Making forums more interactive Managing your project using the Gantt chart Migrating ONLYOFFICE Groups from Docker to Linux Migrating ONLYOFFICE Groups from Docker to Linux Migrating ONLYOFFICE Groups from Linux to Docker Migrating ONLYOFFICE Groups from Linux to Docker Migrating ONLYOFFICE Groups from Windows to Linux Migrating ONLYOFFICE Groups from Windows to Linux Managing company documentation Organizing and tracking a common event Organizing mass mailing How to pay for your portal? How to buy ONLYOFFICE Workspace Enterprise Edition subscription? Restricting access to projects How to set or remove an event reminder? Setting up mail server How to share your event with other portal users? How to share your Calendar? How to start working with your ONLYOFFICE Workspace Enterprise Edition? Switching ONLYOFFICE Groups to HTTPS protocol Switching ONLYOFFICE Groups to HTTPS protocol Switching ONLYOFFICE Docs to HTTPS protocol Switching to HTTPS using Control Panel Tracking potential sales Tracking work time efficiently How to track time and payments in the online office Updating ONLYOFFICE Workspace to the latest version Updating ONLYOFFICE Groups for Linux to the latest version Updating ONLYOFFICE Groups for Windows to the latest version Updating ONLYOFFICE Groups for Docker to the latest version Using two-factor authentication 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 and format autoshapes Insert autoshapes Insert autoshapes Insert and edit charts Insert charts Insert and edit charts Insert equations Insert formulas Insert functions Insert headers and footers Insert and adjust images Insert and adjust 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 ONLYOFFICE Groups for Docker on a local server Installing ONLYOFFICE Groups for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs on a local server Installing ONLYOFFICE Docs for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Workspace Enterprise Edition using the provided script Installing ONLYOFFICE Mail for Docker on a local server INT function Integrating other resources with the Documents module 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 ONLYOFFICE Mail Docker version troubleshooting ONLYOFFICE Mail 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 Migrating from the Cloud version to server version 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. Getting Started PERCENTILE function PERCENTRANK function PERMUT function PI function PMT function POISSON function Portal Configuration. Getting Started 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. Getting Started 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 Branding your online office RECEIVED function Removing ONLYOFFICE Groups for Docker from your computer Removing ONLYOFFICE Docs for Docker from your computer Removing ONLYOFFICE Mail for Docker from your computer Removing unused fonts from ONLYOFFICE Docs REPLACE/REPLACEB functions Reporting templates with automatic delivery by E-mail REPT function Resize rows/columns RIGHT/RIGHTB functions ROMAN function ROUND function ROUNDDOWN function ROUNDUP function ROW function ROWS function RSQ function Running ONLYOFFICE Groups 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 and Replace 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 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 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. Getting Started TAN function TANH function TBILLEQ function TBILLPRICE function TBILLYIELD function Technology FAQ Using templates for similar projects TEXT function Integrating third-party services in the server version 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 ONLYOFFICE Groups Using search options on your portal 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 Managing versions and revisions 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 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 ONLYOFFICE Workspace using the provided script ONLYOFFICE Workspace for Docker system requirements Installing the GUI version of Desktop Editors Installing ONLYOFFICE Desktop Editors to Red Hat, CentOS and derivatives Deploying multiple portals using the Multitenancy feature Updating ONLYOFFICE Mail integrated with ONLYOFFICE Groups Sort and filter data Running ONLYOFFICE Docs using Docker Compose Ports which must be opened for ONLYOFFICE Groups Ports which must be opened for ONLYOFFICE Docs Ports which must be opened for ONLYOFFICE Mail Installing ONLYOFFICE Workspace Enterprise Edition for Windows on a local server Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Windows Connecting ONLYOFFICE Mail to ONLYOFFICE Groups on Linux Installing ONLYOFFICE Docs for CentOS and derivatives Installing ONLYOFFICE Workspace Enterprise Edition with additional script parameters Installing ONLYOFFICE Workspace with additional script parameters ONLYOFFICE Groups changelog ONLYOFFICE Docs changelog Connecting ONLYOFFICE Mail to ONLYOFFICE Groups via Portal Settings ONLYOFFICE Docs Linux version troubleshooting ONLYOFFICE Docs Windows version troubleshooting SUMIFS function Insert equations Insert equations ONLYOFFICE Mail changelog Desktop Editors changelog ONLYOFFICE Workspace Enterprise Edition for Linux system requirements Settings for most popular mail services Calling your customers directly from CRM Sending for electronic signature AVERAGEIFS function COUNTIFS function Insert footnotes Installing ONLYOFFICE Workspace for Windows on a local server Migrating from ONLYOFFICE Workspace to Enterprise Edition on Windows Migrating from ONLYOFFICE Workspace to Enterprise Edition using Docker script Using ONLYOFFICE Docs behind the proxy ONLYOFFICE Single Sign-on overview Configuring ONLYOFFICE SP and Shibboleth IdP Configuring ONLYOFFICE SP and OneLogin IdP Switching ONLYOFFICE Talk to TLS protocol on Windows version Switching ONLYOFFICE Talk to TLS protocol on Linux version Installing ONLYOFFICE Groups for Red Hat, CentOS, and derivatives Adding a new interface language to ONLYOFFICE Docs Adding a new interface language to ONLYOFFICE Docs Languages available for ONLYOFFICE Docs interface Languages available for ONLYOFFICE Groups interface Switching to HTTPS when installing from RPM/DEB packages Languages available for Desktop Editors interface Installing all ONLYOFFICE Workspace components integrated Installing all ONLYOFFICE Workspace components integrated Installing all ONLYOFFICE Workspace components 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 Configuring ONLYOFFICE SP and AD FS IdP Migrating MS Exchange data to ONLYOFFICE Setting up the default currency and exchange rates Ports which must be opened for ONLYOFFICE Docs Developer Edition 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 for Windows on a local server Installing ONLYOFFICE Docs Developer Edition for CentOS and derivatives Switching ONLYOFFICE Docs Developer Edition for Windows to HTTPS protocol Control Panel changelog Integration Edition frequently asked questions Developer Edition license frequently asked questions Installing ONLYOFFICE Workspace Enterprise Edition from RPM/DEB packages using the provided script Installing ONLYOFFICE Workspace 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 ONLYOFFICE Groups Creating API for the ONLYOFFICE Groups custom modules Learning about folder permissions hierarchy Creating a WebDAV server on Ubuntu and connecting it to ONLYOFFICE Creating a WebDAV server on Windows and connecting it to ONLYOFFICE Integrating third-party services in the cloud version How it works Create a Table of Contents References tab Collaboration tab Create and 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 Switching to HTTPS for the Windows version FTEST function HYPGEOM.DIST function CONVERT function 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 Insert charts Change text wrapping Manipulate objects View document information Use the Find and Replace function Download and print your document Installing 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 and filter data Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects View spreadsheet information Use the Find and Replace function Download and print 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 Insert charts Manipulate objects View presentation information Use the Find and Replace function Download your presentation Overview Common operations Project management Milestones Tasks Discussions Project documents Connecting to your ONLYOFFICE Workspace Enterprise Edition Associating files with Desktop Editors on Windows 10 Add bookmarks Layout tab Connecting to your Nextcloud server Languages available for ONLYOFFICE Documents app for Android Languages available for ONLYOFFICE Documents app for iOS Languages available for ONLYOFFICE Projects app for iOS ONLYOFFICE Workspace Enterprise Edition for Windows system requirements ONLYOFFICE Workspace Enterprise Edition for Docker system requirements Updating ONLYOFFICE Workspace Enterprise Edition to the latest version Changing domain used with ONLYOFFICE Mail Export calendar to devices 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 Running ONLYOFFICE Groups behind NAT Deploying ONLYOFFICE Workspace in DigitalOcean Protecting your documents with a password 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 Docs with ownCloud How to integrate ONLYOFFICE Docs 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 How ONLYOFFICE handles Google user data Spell-checking Spell-checking Document Review 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 Insert footnotes 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 Collaborative document editing Spell-checking Use the Find and Replace function Change application settings Download and print your document View document information Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Freeze panes Create/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 and filter data Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Collaborative spreadsheet editing Use the Find and Replace function Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Mobile presentation viewer 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, color Apply font decoration styles Align 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 Communicating in real time Spell-checking Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Manage slides Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Insert text Set font type, size, 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 Create charts Manipulate objects View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Overview Languages available for ONLYOFFICE Mobile web editors for iOS Manage files 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 Insert footnotes 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 Collaborative document editing Spell-checking Use the Find and Replace function Change application settings Download and print your document View document information Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Freeze panes Create/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 Add or remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Collaborative spreadsheet editing Use the Find and Replace function Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Mobile presentation viewer 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, color Apply font decoration styles Align 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 Communicating in real time Spell-checking Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Adding new themes to the ONLYOFFICE Docs Presentation Editor Adding new themes to the ONLYOFFICE Docs Presentation Editor Add watermark Set up paragraph outline level Insert footers Data tab Formula tab Insert headers and footers Group data Spell checking Installing ONLYOFFICE Docs for Linux snap package Creating a hanging indent Adding page numbers in word Freezing rows and columns Creating a chart from start to finish Wrapping text Using the IF and AND functions Using the AVERAGE function Calculating the number of days between dates Installing Desktop Editors via Flatpak Deploying ONLYOFFICE Workspace Enterprise Edition using AMI Creating custom task status Creating E-mail templates Connecting third-party storages Enabling vsyscall on Debian Add caption Insert symbols and characters Compare documents Insert symbols and characters Insert symbols and characters Scale a worksheet Working with plugins when using CSP Compiling Desktop Editors for Ubuntu Compiling Document Builder Using the Review mode in ONLYOFFICE Fast and Strict co-editing modes in ONLYOFFICE Creating fillable forms in ONLYOFFICE How to compare documents in ONLYOFFICE Run your own office with the ONLYOFFICE on your private AWS cloud Deploying ONLYOFFICE Docs Developer Edition using AMI Sharing files and folders How to integrate ONLYOFFICE with Alfresco Share Reference management in ONLYOFFICE documents with Mendeley, Zotero and EasyBib Using pro features in ONLYOFFICE Desktop Editors Installing ONLYOFFICE Desktop Editors for Mac OS Using the Private Room to work on your documents securely Connecting to your Personal cloud Using pro features in ONLYOFFICE Desktop Editors Getting started with ONLYOFFICE Desktop Editors Protect data using encryption Navigating via Full-Text Search feature Ports which must be opened for ONLYOFFICE Docs Enterprise Edition Installing ONLYOFFICE Docs Enterprise Edition for Docker on a local server Installing ONLYOFFICE Docs Enterprise Edition for Debian, Ubuntu, and derivatives Installing ONLYOFFICE Docs Enterprise Edition for CentOS and derivatives Installing ONLYOFFICE Docs Enterprise Edition for Windows on a local server Switching ONLYOFFICE Docs Enterprise Edition to HTTPS protocol Deploying ONLYOFFICE Docs Enterprise Edition using AMI Working with plugins when using CSP Updating ONLYOFFICE Docs Developer Edition for Docker to the latest version Updating ONLYOFFICE Docs Developer Edition for Windows to the latest version Updating ONLYOFFICE Docs Enterprise Edition for Docker to the latest version Updating ONLYOFFICE Docs Enterprise Edition for Windows to the latest version Updating ONLYOFFICE Docs Community Edition for Docker to the latest version Updating ONLYOFFICE Docs Community Edition for Windows to the latest version AutoCorrect features AutoCorrect features AutoCorrect features Conditional Formatting Use formatted tables Create slicers for tables Remove duplicates CELL function LINEST function Insert date and time Change text orientation Change text orientation Macros settings Macros settings Macros settings Macros settings Macros settings Macros settings Macros settings Macros settings Change text orientation Macros settings Tracking login history Receiving audit trail data Private Rooms in ONLYOFFICE Workspace for Secure Collaboration on Documents How to deploy ONLYOFFICE Docs on your server using Docker How to use Sheet View and custom filtering in spreadsheet collaboration Reference types in ONLYOFFICE Docs: footnotes, endnotes, cross references How to create, edit and customize charts in ONLYOFFICE Docs How to use Control Panel in ONLYOFFICE Workspace How to activate pro features in ONLYOFFICE Desktop Editors Uninstall default plugin from the desktop editors Uninstall default plugin from the server editors UNIQUE function TREND function GROWTH function LOGEST function Create fillable forms Data validation Forms tab Add and Format a Table of Figures MUNIT function RANDARRAY function 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 Protecting documents with a password Protecting presentations with a password Protecting spreadsheets with a password XLOOKUP function Connecting to your ownCloud server Connecting to your Seafile server Protecting your documents with a digital signature Altering LDAP settings in the SaaS version Single Sign-on feature in the SaaS version Adding new fonts to ONLYOFFICE Desktop Editors Enabling Support for Video Playback in ONLYOFFICE Desktop Editors How to add cells How to calculate percentages How to insert time How to split cells How to switch between two languages in a table How to insert a video Changing the user status to "Guest" Installing ONLYOFFICE Docs Community Edition using the provided script Installing ONLYOFFICE Docs Enterprise Edition using the provided script Installing ONLYOFFICE Docs Developer Edition using the provided script Overview Common operations Project management Tasks Discussions Project documents Insert sparklines Insert array formulas Deploying ONLYOFFICE Docs in Vultr Deploying ONLYOFFICE Workspace in Vultr