DEV Community

Cover image for What's new in ONLYOFFICE Docs 9.1: PDF Editor with Redact and new annotations, faster formulas, and more
Kseniya Fedoruk for ONLYOFFICE

Posted on

What's new in ONLYOFFICE Docs 9.1: PDF Editor with Redact and new annotations, faster formulas, and more

The latest major update for ONLYOFFICE Docs is here, and version 9.1 is packed with features designed to boost productivity, enhance security, and streamline workflows. This release brings a more powerful PDF Editor, significant performance boosts in spreadsheets, and a host of improvements across the entire suite.

Let's break down the key updates from a developer's perspective and see how they can improve your projects and workflows.

A More Powerful PDF Editor

Handling PDFs programmatically or through a web interface just got a lot more powerful. Version 9.1 introduces several key features to the PDF Editor that expand its capabilities.

Securely Redact Information

For anyone building solutions that handle sensitive data, the new Redact feature is a game-changer. You can now permanently remove confidential information from PDF documents directly within the editor.

To use it, switch to the new Redact tab. You can mark text for redaction manually or use the Find & Redact function to target specific strings, patterns, or even entire pages. Once you apply the redaction, the selected content is permanently removed from the file, ensuring data privacy and compliance. This is a crucial feature for legal, financial, or healthcare applications where data security is non-negotiable.

Redact

New Annotation Tools & More

Beyond redaction, the PDF Editor now includes new annotation tools. You can draw shapes like rectangles, circles, and arrows directly onto the document, making visual feedback and collaboration more intuitive.

Annotations

Additionally, you can now insert charts and view SmartArt graphics within PDFs, making it easier to work with visually rich content without leaving the editor.

Big Performance Gains in the Spreadsheet Editor

Data processing and analysis are at the core of many applications. ONLYOFFICE Docs 9.1 delivers significant performance enhancements to the spreadsheet editor, particularly with its formula calculation engine.

Up to 4x Faster LOOKUP Formulas

We’ve re-engineered the logic for LOOKUP, VLOOKUP, HLOOKUP, and XLOOKUP formulas. The improvements are substantial:

  • Faster Searches: Enjoy up to a 4x speed increase for exact searches with VLOOKUP and linear searches with XLOOKUP.
  • Reduced Memory Usage: Formula calculations now consume less memory, making the editor more efficient when handling large datasets.
  • Improved Data Handling: The logic for processing mixed data types has been refined, leading to more accurate and reliable results.

LOOKUP formulas

These updates mean that applications relying on heavy data lookups and calculations will feel faster and more responsive for end-users.

More Spreadsheet Enhancements

Several other quality-of-life updates make the spreadsheet editor more functional:

  • Text Direction (LTR/RTL): You can now set text direction on a per-cell basis, which is essential for applications supporting multiple languages and writing systems.
  • New "Table Design" Tab: Formatted table settings are now consolidated into a dedicated tab that appears when a table is active.
  • Date Filters in Pivot Tables: Analyzing time-series data is now easier with support for date filters in Pivot Tables.
  • View Content Controls: Files containing Spin Buttons, List Boxes, Scroll Bars, and other content controls can now be opened and viewed.

Text direction for cells

Suite-Wide Improvements for a Better Workflow

Version 9.1 also introduces useful updates that apply across the document, spreadsheet, and presentation editors.

Expanded Format Support

Interoperability is key. This release expands support for more file formats:

  • HEIF/HEIC: View images in this modern format.
  • HWPML: Open and view documents created with the Hangul word processor.
  • Conversions: You can now convert PDF to TXT and PPTX to TXT directly.
  • MathML: Insert mathematical formulas from the MathML format.

Better Chart Handling

The chart editor is now full-featured in documents and presentations. This allows you to open and edit embedded XLSX files directly, giving you more control over your data visualizations without needing to switch between applications. You can also work with external data sources for charts, choosing to embed a file or link to the source.

Charts

New Admin Panel for Server Admins

For those managing self-hosted instances, ONLYOFFICE Docs Enterprise now includes a new Admin Panel. This web-based dashboard provides a centralized interface to monitor server status and manage configuration settings, simplifying administration and troubleshooting.

Explore the New Features in Action

To see all these features in detail, check out the free webinar:

Get Started with ONLYOFFICE Docs 9.1

This latest release delivers a powerful mix of performance boosts, security features, and usability enhancements that developers can leverage to build more robust and efficient document-centric applications.

We encourage you to explore the new features and see how they can benefit your projects. Check out the full changelog for a complete list of the 500+ bug fixes and improvements.

Ready to try it out? Download the self-hosted version of ONLYOFFICE Docs 9.1.

Your feedback is invaluable, so share your thoughts and suggestions on how we can continue to improve.

Top comments (0)