Meet ONLYOFFICE Docs v6.2 with data validation and table of figures

ONLYOFFICE Docs v6.2 | #site_title

<p>Hello everyone!</p>
<p>Prepare to update and get a lot of new features and improvements for your favorite online editors.</p>
<p><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2.jpg"><img decoding="async" loading="lazy" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2.jpg" alt="ONLYOFFICE Docs v6.2 with data validation and table of figure released" width="736" height="371" class="alignnone size-full wp-image-21598" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2.jpg 736w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2-300x151.jpg 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2-634x320.jpg 634w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/Blog_6_2-353x178.jpg 353w" sizes="(max-width: 736px) 100vw, 736px" /></a><br />
</p>
<h3>Data validation to restrict the entered data type</h3>
<p>The feature helps you restrict the type of data entered into a cell. The most popular use case for this feature is creating drop-down lists. They limit the entry choices for a selected cell — users just pick an item from a list which speeds the process and reduces the risk of errors.</p>
<p><strong>Where to find</strong>: Data tab -&gt; Data validation</p>
<p><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation.png"><img decoding="async" loading="lazy" class="alignnone wp-image-21519" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation.png" alt="ONLYOFFICE Docs v6.2 with data validation and table of figure released" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/data-validation-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a></p>
<h3>Slicers to visualize filtering in pivot tables</h3>
<p>The <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" rel="noopener noreferrer">spreadsheet editor</a> now has Slicers for pivot tables. This functionality provides quick filtering and helps you indicate the filtering state to understand what data is currently displayed.</p>
<p><strong>Where to find</strong>: Table settings -&gt; Insert slicers</p>
<p><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables.png"><img decoding="async" loading="lazy" class="alignnone wp-image-21520" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables.png" alt="ONLYOFFICE Docs v6.2 with data validation and table of figure released" width="736" height="421" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables.png 1239w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/slicers-for-pivot-tables-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a></p>
<p><em>Quick reminder</em>: slicers for formatted tables appeared in <a href="https://wpblog.onlyoffice.com//2020/12/meet-onlyoffice-docs-6-1-with-advanced-filtering-for-spreadsheets-and-endnotes-for-documents/?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener">ONLYOFFICE Docs v6.1</a>.</p>
<h3>Custom number format</h3>
<p>If the existing number formats don’t meet your needs, starting from version 6.2 you can change the way the values show up by creating and applying custom number formats.</p>
<p><strong>Where to find</strong>: Home tab -&gt; drop-down Number format -&gt; More formats</p>
<p><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1.png"><img decoding="async" loading="lazy" class="alignnone wp-image-21534" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1.png" alt="ONLYOFFICE Docs v6.2 with data validation and table of figure released" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/custom-number-format-1-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a></p>
<h3>New functions</h3>
<p>The developers also added new functions to spreadsheets:</p>
<ul>
<li><code>GROWTH</code> to calculate predicted exponential growth by using existing data.</li>
<li><code>TREND</code> to calculate a linear trend line.</li>
<li><code>LOGEST</code> to calculate an exponential curve that fits the data and get an array of values that describes the curve.</li>
<li><code>UNIQUE</code> to get a list of unique values from the specified range.</li>
<li><code>MUNIT</code> to get the unit matrix for the specified dimension.</li>
<li><code>RANDARRAY</code> to get an array of random numbers.</li>
</ul>
<h3>Table of figures to organize illustrations</h3>
<p>In <a href="https://www.onlyoffice.com/document-editor.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener noreferrer">ONLYOFFICE 6.2</a>, it’s possible to create a table of figures. Much like a table of contents, it allows to list and organize the tables, equations, images, charts, and shapes.</p>
<p>To create a table of figures, you need to add captions for all the objects that have to be included in it.</p>
<p><strong>Where to find</strong>: References tab</p>
<p><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures.png"><img decoding="async" loading="lazy" class="alignnone wp-image-21527" src="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures.png" alt="ONLYOFFICE Docs v6.2 with data validation and table of figure released" width="736" height="420" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures.png 1240w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures-300x171.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures-1024x585.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures-768x439.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2021/02/table-of-figures-312x178.png 312w" sizes="(max-width: 736px) 100vw, 736px" /></a></p>
<h3>Other improvements</h3>
<ul>
<li><strong>New interface languages</strong>: Belarusian, Catalan, Greek, Lao, Romanian.</li>
<li><strong>New proofing options in <a href="https://www.onlyoffice.com/presentation-editor.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener noreferrer">presentations</a></strong>. Choose where you want to use autocorrect as you type, e.g. create numbered or bulleted lists automatically.</li>
<li><strong>Setting font size up to 300px</strong> (up to 409px in spreadsheets) manually.</li>
</ul>
<p>The new version is already available for the self-hosted versions. It will appear in the ONLYOFFICE cloud soon.</p>
<h3>Watch video overview</h3>
<p><iframe loading="lazy" width="560" height="315" src="https://www.youtube.com/embed/c-_ld86EMNQ" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe></p>
<div class="useful-links">
<h3>Useful links</h3>
<p>Source code on <a href="https://github.com/ONLYOFFICE/DocumentServer" target="_blank" rel="noopener noreferrer">GitHub</a></p>
<p>Detailed changelog on <a href="https://github.com/ONLYOFFICE/DocumentServer/blob/master/CHANGELOG.md" target="_blank" rel="noopener noreferrer">GitHub</a></p>
<p>Browse our <a href="https://helpcenter.onlyoffice.com/" target="_blank" rel="noopener">Help Center</a> for new features instructions</p>
<p>Download the free Community version of ONLYOFFICE Docs. <a href="https://www.onlyoffice.com/download.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener noreferrer">Download now</a></p>
<p>Try the Enterprise version of ONLYOFFICE Docs. <a href="https://www.onlyoffice.com/download-commercial.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener noreferrer">Try now</a></p>
<p><a href="https://www.onlyoffice.com/compare-editions.aspx?utm_source=blog&amp;utm_medium=social&amp;utm_campaign=Docsv6_2" target="_blank" rel="noopener noreferrer">Compare editions</a></p>
</div>

ONLYOFFICE Docs v6.2 with data validation and table of figures released

Recent posts

Use ONLYOFFICE macro to analyze spreadsheet data

Back to school 2023 with ONLYOFFICE: discounts for education

Best AI writers 2023