ONLYOFFICE

ONLYOFFICE Docs 9.1 released: A more powerful PDF Editor with Redact and new annotations, faster formulas, and more

The latest update for ONLYOFFICE Docs is here, bringing more than a dozen new features, a host of performance improvements, and over 500 bug fixes. Ready to see what’s new? Let’s take a look at the key updates.

Enhanced PDF Editor

Redact. Need to hide sensitive or confidential information in your PDFs? It’s now simpler than ever.

To redact content, open your file in the editing mode and switch to the newly added Redact tab. Click the Mark for Redaction button and highlight the text you want to remove. For larger documents, you can use the Find & Redact option to quickly locate and select specific words or phrases. The feature also allows you to redact an entire page or a range of pages.

Once you’re ready, press the Apply Redaction button to permanently remove the selected information from the file.

New annotation tools. Enhance your PDF editing experience with new annotation tools, offering greater precision and flexibility. Select shapes like Rectangle, Circle, Arrow, or Connected Lines to draw directly on your document. You can customize the color and size of your annotations to fit your needs.

Adding charts and SmartArt. Elevate your PDF files by adding charts to visually present data, highlight key insights, and make your documents more engaging. You can also now work with SmartArt graphics in your PDFs. This allows you to view and interact with them seamlessly, making it easier to manage visually rich content directly within your PDF files.

Powerful Spreadsheet Editor updates

ONLYOFFICE spreadsheets are packed with numerous updates and improvements designed to boost productivity and streamline data analysis.

Text direction for cells (LTR↔RTL). Easily set the text direction for cells, switching between Left-to-Right and Right-to-Left as needed.

Faster LOOKUP formulas. We have significantly updated the LOOKUP, VLOOKUP, HLOOKUP, and XLOOKUP formulas to enhance performance and efficiency. These improvements include: Faster LOOKUP formulas. We have significantly updated the LOOKUP, VLOOKUP, HLOOKUP, and XLOOKUP formulas to enhance performance and efficiency. These improvements include:

• Improved logic for handling mixed data types, ensuring more accurate results.

• Reduced memory consumption during formula calculations.

• Up to 4x faster exact searches with VLOOKUP.

• A 4x speed boost for linear searches with XLOOKUP.

More spreadsheet enhancements

• Formatted table settings have been moved to a dedicated “Table Design” tab, which appears when you are working within a table. ONLYOFFICE Docs 9.1 released: A more powerful PDF Editor with Redact and new annotations, faster formulas, and more

• Pivot Tables support date filters, making it easier to analyze time-based data and uncover trends.

• Open and view files with Content Controls: Spin Buttons, List Boxes, Scroll Bars, Combo Boxes, and Check Boxes. Your sheets became more dynamic and interactive.

• Rename sheets instantly by double-clicking their names, with no extra windows needed.

• Active arguments are highlighted as you enter a formula, making it easier to track and edit your calculations.

Further useful enhancements across the editors

Beyond the PDF and Spreadsheet editors, version 9.1 introduces useful improvements across the entire suite.

Comment display. For better collaboration, customize the display of resolved and open comments in the left panel.

Updated charts. The Explosion option for 2D pie and doughnut charts is supported for opening, allowing you to view separated segments.

You can also work with external data for diagrams, choosing to embed a file or link to the source when copying charts between editors.

Additionally, you can enable or disable specific diagram elements like axis titles, data labels, and error bars.

Slide Master tab. In the Presentation Editor, all Slide Master settings have been moved to a dedicated toolbar tab for easier access.

Extended format support. The editors now support HEIF images and HWPML documents (for opening and viewing). What else, we added support for PDF -> TXT (directly) and PPTX -> TXT conversions. Moreover, it’s possible to insert mathematical formulas from the MathML format.

Section breaks. The Document Editor supports section breaks within block Content Controls at any nesting level.

Full-featured chart editor. A full-featured chart editor is now available in docs and slides, allowing you to open embedded XLSX files directly, bypassing the chart cache.

For server admins. The server version of ONLYOFFICE Docs introduces an Admin Panel. This new dashboard allows administrators to view server status and configuration settings, making management more straightforward.

Localization. The latest version brings translation of formulas into Serbian Latin and Serbian Cyrillic, as well as Traditional Chinese.

Get ONLYOFFICE Docs 9.1

Download the self-hosted version of ONLYOFFICE Docs 9.1

ONLYOFFICE Docs 9.0 for developers: API updates

The latest release of ONLYOFFICE Docs is here, packed with updates that deliver more functionality, better customization, and improved performance. If you’re a developer or integrator looking to take advantage of the enhanced APIs, there’s plenty to explore in this version. Check all the details below.

Diagram Viewer

The newly introduced Diagram Viewer is available for web, desktop, and mobile web. It allows opening diagram files without the need for any third-party apps.

Where to find in API: the diagram document type is added to the documentType parameter.

Support for new file formats

ONLYOFFICE continues to expand its usability by supporting further file formats. In version 9.0, it’s possible to open Markdown and OpenDocument Graphic files for viewing.

Where to find in API: added opening for odg and md formats.

Additionally, with the launch of the Diagram Viewer, we added conversion from vsdm, vsdx, vssm, vssx, vstm, and vstx formats. Check API

Expanded customization options

Customization has been taken to new heights in version 9.0, empowering your end users to tailor their ONLYOFFICE experience exactly as they need.

New UI themes

Two new themes, Modern Light and Modern Dark, are presented to optimize the look and feel of each editor.

Where to find in API: The theme-white and theme-night theme ids are added to the editorConfig.customization.uiTheme parameter.

const config = {
  editorConfig: {
    customization: {
...
      uiTheme: "theme-white",
...

Font size selection for the Simplified Chinese UI

The new parameter ensures accurate font sizing in Simplified Chinese layouts, offering the flexibility to use either Western or traditional Chinese styles.

***Where to find in API: *editorConfig.customization.forceWesternFontSize parameter, the default value is false.

const config = {
  editorConfig: {
    customization: {
....
 forceWesternFontSize: false,
...

Hiding user avatars

The new parameter enables you to toggle user avatars in the editor header, helping create a clean, distraction-free interface.

***Where to find in API: *editorConfig.customization.layout.header.user parameter, the default value is true.

const config = {
  editorConfig: {
    customization: {
...
layout: {
        header: {
          editMode: true,
          save: true,
          user: true,
          users: true,
        },

Performance boost with preloading

Starting from version 9.0, you can preload static assets (HTML, CSS, JS, fonts) into the browser cache before opening a file to speed up the first-time loading of the document editor. Check API

Two options are available:

1) Using the ?preload=placeholder parameter

2) Manually inserting a preload iframe

Get the latest version of ONLYOFFICE Docs Developer: DOWNLOAD NOW

API enhancements for plugins and macros

Custom buttons for Content Controls. Utilize the Asc.ButtonContentControl class to create unique buttons for your plugins. Define actions using the attachOnClick method and add your own icons to enhance functionality. Check API

(function(window){
  window.Asc.plugin.init = function()
  {
    let button = new Asc.ButtonContentControl();
    button.icons = '/resources/check%scale%(default).png';
    button.attachOnClick(function(contentControlId){
      Asc.plugin.executeMethod("RemoveContentControl", [contentControlId]);
    });
 
    button = new Asc.ButtonContentControl();
    button.icons = '/resources/close%scale%(default).png';
    button.attachOnClick(function(contentControlId){
      Asc.plugin.executeMethod("RemoveContentControls", [[{"InternalId": contentControlId}]]);
    });
  }
})(window);

Setting the active slide by its index. Jump to any slide easily within presentations using the new GoToSlide method.

expression.GoToSlide(slideNumber);

Content Control list element. The introduction of the ContentControlListElement enumeration makes managing content controls within documents even simpler.

Asynchronous calculations. Manage any request within the body of a custom function created using macros.

(function () {
  /**
   * World Bank indicator value for a specific year.
   * @customfunction

   * @param   {string} country   ISO-3 code, e.g. "TUR"
   * @param   {string} indicator Indicator code, e.g. "SP.POP.TOTL"
   * @param   {number} year      Four-digit year, e.g. 2024
   * @returns {any}             Numeric value or #N/A
   *
   * @example =WB("TUR","SP.POP.TOTL",2024)
   */
  async function WB(country, indicator, year) {
    // Build URL (World Bank allows CORS)
    const url =
      `https://api.worldbank.org/v2/country/$%7Bcountry%7D/indicator/$%7Bindicator%7D` +
      `?format=json&per_page=20000`;

    try {
      const r = await fetch(url);
      const [meta, data] = await r.json();

      // Find the row for the requested year
      const row = data.find((v) => v.date === year.toString());
      if (!row || row.value == null) return "#N/A";

      return row.value;               // resolves the Promise
    } catch (e) {
      return "#ERROR";
    }
  }

  // Register the function so it becomes a sheet formula
  Api.AddCustomFunction(WB);
})();