We have released version 6.4 with new features, improvements for collaborative processes, and more accessibility.

ONLYOFFICE Docs v6.4 with conditional formatting | #site_title

We have released version 6.4 with new features, improvements for collaborative processes, and more accessibility.
<img decoding="async" loading="lazy" class="alignnone size-full wp-image-24063" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/Blog_docs_6_4.jpg" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="371" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/Blog_docs_6_4.jpg 736w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/Blog_docs_6_4-300x151.jpg 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/Blog_docs_6_4-634x320.jpg 634w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/Blog_docs_6_4-353x178.jpg 353w" sizes="(max-width: 736px) 100vw, 736px" />

<h3>New features in spreadsheets</h3>
Conditional formatting to identify trends. Specify your own conditions and apply them to cell ranges. If the condition is true, the ranges will be formatted accordingly.
Where to find: Home tab -&gt; Conditional formatting
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24060" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/conditional_formatting-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Sparklines. Insert cell-size mini-charts to show trends in a series of values. There are three types of them: Column, Line, and Win/Loss.
Where to find: Insert tab -&gt; Sparkline.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24061" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/sparklines-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Data import from txt or csv. Easily get data from cvs and txt files without having to copy their contents and pasting them into your spreadsheet.
Where to find: Data tab -&gt; From txt/csv.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24064" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/get_data-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Hyperlink autocorrect. Replace links and local paths with hyperlinks automatically. Just enable this option in settings.
Where to find: Advanced settings -&gt; Spell checking -&gt; AutoFormat as you type.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24065" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/spreadsheet_autocorrect-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Other improvements:
<ul>
<li>assigning a macro to be executed when you click on a graphic object,</li>
<li>presets for Freeze Panes,</li>
<li>Show or hide zeros in cells,</li>
<li>new translations for the descriptions and names of function arguments.</li>
</ul>
<h3>New features in documents</h3>
Text to table. Quickly convert existing text to a table in a couple of clicks instead of creating a new table and then copying the content to it. It’s also possible to reverse the process and arrange your table as plain text.
Where to find: To convert text to a table, go to Insert -&gt; Table -&gt; Convert text to table.
To convert table to text, select the table, click the Table settings on the right panel and then click Convert table to text.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24072" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/table_to_text-1-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Auto-capitalization of the first letter in a sentence. The option is enabled by default so that you can automatically start a new sentence with a capital letter. This feature is also available in presentations.
Where to find: File tab -&gt; Advanced settings -&gt; Proofing -&gt; Autocorrect.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24073" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/autocorrect-1-1-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
<h3>New features in presentations</h3>
Version History. View and restore previous versions of your presentations.
Where to find: File tab -&gt; Version History.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24070" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/presentation_versions-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
Hide notes panel. To hide the notes you don’t need, use settings on the top right toolbar under your user name.
<h3>Collaboration enhancements: bulk work with comments</h3>
Delete or resolve comments you already reviewed in a couple of clicks. This could be done for all comments left in the document, comments for a specific abstract, and all of your own comments.
Where to find: Collaboration tab
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24071" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/comments-1-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
<h3>More accessibility and usability: new scaling options and chart styles</h3>
New scaling options. In addition to 100%, 150%, and 200%, documents, spreadsheets, and presentations can now be scaled to 125% and 175%. The scaling is applied automatically in accordance with browser or system settings.
Accessible charts. There are also new color-blind-friendly chart styles where patterns are used to signify different segments. These charts are available in all three editors.
<a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles.png"><img decoding="async" loading="lazy" class="alignnone wp-image-24074" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles.png" alt="ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/08/chart_styles-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a>
<h3>Video overview &amp; webinar</h3>
The most important updates from version 6.4 in a short video:
<iframe loading="lazy" width="736" height="400" src="https://www.youtube.com/embed/jEBpXeCeRjs" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="allowfullscreen">﻿</iframe>
Would like to learn how to use new features? <a href="https://www.onlyoffice.com/webinars.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=v6_4" target="_blank" rel="noopener">Register for our live webinar</a>
<h3>Availability</h3>
Self-hosted version 6.4 of ONLYOFFICE Docs is already available, including Docker, deb, rpm, and exe packages. Snap will be released a bit later.
<a class="red button" href="https://www.onlyoffice.com/download-docs.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=v6_4#docs-enterprise" target="_blank" rel="noopener">Download now</a>
The new version will soon appear in the cloud-based solutions (both business and personal) and in the desktop app.
<div class="useful-links">
<h3>Useful links</h3>
<a href="https://github.com/ONLYOFFICE/DocumentServer/blob/master/CHANGELOG.md" target="_blank" rel="noopener">Version 6.4 changelog</a>
<a href="https://github.com/ONLYOFFICE/DocumentServer/" target="_blank" rel="noopener">Source code</a>
<a href="https://www.onlyoffice.com/download-docs.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=v6_4#docs-community" target="_blank" rel="noopener">Free Community version</a>
<a href="https://www.onlyoffice.com/download-docs.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=v6_4#docs-enterprise" target="_blank" rel="noopener">Start Enterprise Edition free trial</a>
<a href="https://www.onlyoffice.com/download-docs.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=v6_4#docs-developer" target="_blank" rel="noopener">ONLYOFFICE Docs for developers</a>
</div>

ONLYOFFICE Docs v6.4 with conditional formatting and new scaling options

Recent posts

Use ONLYOFFICE macro to analyze spreadsheet data

Back to school 2023 with ONLYOFFICE: discounts for education

Best AI writers 2023