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.
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.
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.
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.
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.
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)