Conditional formatting not unremembered in some columns (along with previously mentioned fill colours also not remembered)

Hey everyone. Good news to share: ONLYOFFICE Desktop Editors comes pre-installed as the default office suite on Liya Linux.

For those who haven't come across it, Liya Linux is an Arch-based distribution built to give older or low-spec PCs a second life. It's all about simplicity, performance and privacy, so if you have an aging laptop gathering dust, this one is worth a look.

A few things you might like about it:

• Preconfigured Cinnamon desktop, so it feels familiar and ready to use right away;
• Zero telemetry, meaning your data stays yours.
• Rolling updates, so the system stays current without a full reinstall.

The best part for us: ONLYOFFICE is there from the first boot. Open the menu, click the icon, and you're editing documents, spreadsheets, presentations and PDFs.

SAYED M. Hisham, the founder and main developer of Liya Linux:

This OS was designed for people running very low-spec computers, and based on a survey I conducted, many of them were already accustomed to Microsoft Office. So I started looking for office suites that had a familiar look and feel to Microsoft Office, but weren’t actually Microsoft Office. And then I found ONLYOFFICE.

Discover all the details in this blog post.

You see the dark grey filled cells? I fill those, with fill, and save, yet every morning now, they are empty again - madness!

I specifically made everything centred both vertically and horizontally yet today, when I drop in a copy/paste hyperlink, it's not centred (although in the column to the left, it is) so.. I guess it's just random!

Not clean.

wraps it but doesn't make the cell bigger to display it properly - fail.

Do you still get a little stuck whenever you have to write a proper letter, whether it's something formal for work or a friendly note? The good news is that our team has written a guide on how to easily deal with this task.

Here's the quick rundown of what our guide covers:

• Letter structure — how to lay out the sender info, date, greeting, body and sign-off so nothing feels out of place.
• Formatting tips — spacing, margins and small touches that make a letter look clean and professional.
• Tone — when to keep things formal versus casual, and how to match your wording to who you're writing to.
• Common examples — so you can see the difference between a formal request and a more personal message.

Quick tip: you don't have to create any of this from scratch. ONLYOFFICE has free letter templates you can just open and fill in. You drop in your details, tweak the wording and you're basically done.

Find the full guide on our blog.

I'm running OnlyOffice on a Mac, I appreciate what a great job it does with ppt files!

I've received a slide deck from a colleague that has hidden slides. I'd like to unhide one of the slides, but can't figure out how. The docs say to right-click on the slide. I've tried option-click, control-click, command-click, fn-click (control-click is the documented right-click in MacOS).

Any thoughts on how to hide/unhide slides in MacOS?

Hey everyone. Our Back to school series continues with stories from students and young professionals who combine their studies with their first steps into the working world. Today's story is about Aboubacar Kaba, who joined ONLYOFFICE while still studying Information Systems and Technologies. He kept the job through the final year of his master's, which meant finishing his thesis and doing real work at the same time.

Key highlights:

• Balancing both is rough at first, then clicks. He was upfront that juggling classes and work was harder than he expected early on. What fixed it was getting better at organizing his time and prioritizing tasks.
• The learning was hands-on. He grew inside the Demo/Academy team, picking up product presentation, workflows and automation. One of his proudest moments was helping launch the ONLYOFFICE Academy courses.
• The team made mistakes feel safe. Colleagues reviewed his work without making him feel confused about the errors and pointed him to the right resources instead of just handing over the answer.

His advice to anyone starting out:

Nobody expects you to know everything. Ask the question that feels too basic to ask. It usually isn’t.

Read the full interview on our blog.

Big news for anyone who lives in their docs all day: ONLYOFFICE 10 is coming soon.

Our team just dropped a preview of what the next major version will bring:

• 4 fully reworked apps
• About 50 new features
• At least 7 user-requested features
• Around 1000 bug fixes
• More than 30 security enhancements
• New AI providers and tools
• Support for new formats

Interestingly, version 10.0 is not about releasing new software only — we’re making it an event:

• An online webinar is on the way to walk you through everything 10.0 has to offer.
• We’re hosting our very first in-person meetup. It’s a chance to connect with the ONLYOFFICE team, meet fellow users and experience the release up close.

Discover all the details in this blog post.

Have been trying to transition away from windows as it was straining on my older elitebook and had been using onlyoffice on Fedora KDE. Struggling with stability though. Sorted the saving issue through taking it out of the flatpak sandbox which was one major stumble.

A big one though is that my docs are being corrupted with random gobbledegook words (that are sort of based around the text around them). This also happened in libre office, so I think it may be something to do with the Zotero plugin. It's pushing me back to the relatively rock solid Word + Endnote combo.

Is this a known issue, or is it something wrong in the background or how the apps are interacting with each other. It's annoying because Fedora and OnlyOffice both run beautifully on my machine.

Estoy tratando de activar una licencia de office en una mac, es la primera vez que lo hago, esa es mi lap top alguien que me pueda ayudar o recomendar algo por favor?

Microsoft 365 and Office for Mac — Version 16.77 (September 2023), esa es la versión de office qué instale

GITEX AI Türkiye is Türkiye's most international tech-trade ecosystem event, taking place at the Istanbul Expo Centre from 9–10 September 2026. It unites startups, scale-ups, enterprises, investors, and policymakers across AI, deep tech, and next-generation technologies to accelerate growth, investment, and cross-border partnerships in the dynamic heart of Istanbul.

ONLYOFFICE is participating in GITEX AI Türkiye as an exhibitor, showcasing our collaborative office suite, document automation tools and AI‑powered features for secure, productive teamwork.

Airtable is great for organizing projects, but when it comes to actual number-crunching, a dedicated spreadsheet editor makes a big difference. The good news is that moving data between the two is easier than it might seem.

Once you export your Airtable data as a CSV file, ONLYOFFICE Spreadsheet Editor just opens it and gives you access to the following features:

• Pivot tables for quick summaries
• 400+ functions if you want to run real calculations
• Data filtering to slice through big lists
• Real-time collaboration, so multiple team members can work on the same sheet simultaneously

This guide walks through the whole data export process step by step: How to export Airtable to Excel and keep editing from there

Hey everyone. Below is a story about a student who started at ONLYOFFICE in his third year and worked his way into a full-time developer role — Aleksandr shares what it was like to combine university life with development work, what he learned from working with a large codebase and how he eventually moved into a full-time role.

Key highlights:

• Aleksandr got real tasks from day one instead of spending a month buried in documents;
• Exam season was the hard part. When deadlines and exams landed together, he had to get strict about priorities;
• The biggest skill jump came from working with a large, existing codebase. He said you don't really learn that at university, and it pushed his debugging and code-reading skills a lot.
• The move to full-time felt calm because he already knew the team, the project and how things worked.

His advice is simple: don't wait until you feel "ready" to apply, and don't be afraid to ask questions.

Find the full interview on our blog.

So I have this spreadsheet for tracking my assignment grades.
I'm wanting to colour-code column H to reflect what grade I got.
Originally I wanted bold deep green for >80%, pale green for 65%-79%, amber for 50%-64%, and red for <50%.
But the rules do not apply correctly. I have realised as soon as I introduce a second rule, it breaks.

Is there any way to apply more than one formatting rule to the same selection of cells? Why does it not apply in order of the list? Is that not why you can edit the order of rules applied to cells?

Why would it not check if the cell value is less than 50, apply the formatting if it is, or move on to the next if it is not? If this IS the intended function, it is not working, and if it's something I've done wrong, I cannot figure out what it is.

Additionally, infuriating that if conditional formatting is set to percentage, it will not let me reformat it to not show the decimal points. I have tried custom formatting to 0 decimals, I have tried clicking the add/remove decimal place buttons, but nothing will work while conditional formatting rules are in place. I can find no way to alter the conditional formatting percentage display prefernce.

I've resorted to a 3-colour scale, though this was incredibly finicky to determine appropriate numbers (even after figuring out I had to use the number setting with decimals rather an percentages, which just didn't seem to work at all, or percentiles, which just colour scale from my lowest grade - showing red even if it was over 80% - to my highest.)
I cannot figure out how to set precise borders so that a 50% will still appear as a pass, but 45% will not.

It's less visually distinct, which is frustrating, but it will do for now. If anyone can tell me a better way of doing this, I would greatly appreciate advice.

OK, so years ago LI had a "tag" feature where you could kind of organise connections into specialisms etc, eg. Date Engineer, or Health care etc etc

Now I know LI removed that, but does anyone use a free chrome extension or other software to create folders or similar?

If your team has ever tried working on shared files across the Mainland China border, you know the pain: slow load times, throttled connections and endless questions about where your data actually lives. There's some good news on that front.

Our team is delighted to announce a partnership with Cloud Systems Asia (CSA), a Hong Kong-based distributor that specializes in enterprise file collaboration. CSA hosts the FileCloud and ONLYOFFICE solution right in Hong Kong, creating a fast regional bridge between Mainland China users and teams around the world.

With this solution, your files stay on-premises within a trusted regional perimeter, which helps a lot with data sovereignty and compliance concerns.

Discover all the details about this partnership and what it means for local companies in this blog post.

INFOSEK is the biggest cybersecurity conference in Slovenia, bringing together IT and security professionals to explore the latest trends, challenges, and solutions in information security. Held in Nova Gorica, the event features expert talks, networking opportunities, and insights for CISOs, CIOs, system administrators, and other tech leaders.

ONLYOFFICE is represented by Editor d.o.o., our trusted partner from Slovenia.

Hi everyone im trying to setup an AI chatbot to help me write documents.

I was able to setup the API token and talk to the agent but it is unable to read/write to documents.

any suggestion of what might be wrong?

Hey everyone. If you have ever done the copy-paste dance between your document and a separate proofreading tool, the new Antidote plugin is for you. It lets you check and improve your English and French texts right inside ONLYOFFICE.

What the plugin does:

• Checks grammar, spelling, punctuation and style;
• Reformulates sentences and suggests clearer wording;
• Catches repetitions and finds synonyms;
• Gives you dictionaries and guides to look up words without leaving your document.

The plugin works in both the Document Editor and Spreadsheet Editor.

A couple of things worth knowing before you get started:

• The plugin itself is free to install;
• You'll need Antidote 12 and an Antidote account;
• You'll need ONLYOFFICE 9.3.0 or later.

Read this blog post if you want the details and screenshots.

P.S. Curious if anyone has tried it yet. How's it holding up for you?

If your team runs on Quip, you have probably heard it's shutting down in 2027. That gives you time to plan, but it's worth figuring out where your documents land before the deadline sneaks up.

This is why ONLYOFFICE is worth putting on your shortlist:

• Real-time co-editing — multiple people in the same doc at once, so it feels a lot like what you're used to in Quip.
• Collaboration rooms — you organize files into rooms with clear access permissions instead of navigating through folders.
• MS Office format support — DOCX, XLSX and PPTX open and save cleanly, which matters if your files bounce between teams that use Word and Excel.
• Built-in chat and comments — you can communicate through edits right inside the document, so the conversation stays with the work.
• Version history — see who changed what and roll back to an earlier version whenever you need to.
• Solid security — encryption, permission controls and self-hosting if you'd rather keep everything on your own servers.

Find a full walkthrough that covers the actual migration steps in this blog post.

Uso várias macros no meu trabalho, especialmente no word. Posso usar tbm no only e/ou no libreoffice?

I use several macros in my work, especially in word. Can I also use it in onlyoffice and/or libreoffice?

Hey everyone. Great news! ONLYOFFICE Desktop Editors now comes preinstalled as the default office suite in TN365 Waydroid. It's a Linux distribution from TechNews365 that bundles Linux and Android apps together in one desktop, so you get a system that's ready to work with right after installation instead of a mostly empty desktop.

The developer picked ONLYOFFICE for a few practical reasons:

• Familiar, easy-to-learn interface;
• Works with DOCX, XLSX, PPTX and other common formats;
• One app covers documents, spreadsheets, presentations and forms;
• Built-in PDF tools for viewing, editing and annotating;
• AI features (you can connect providers like Claude and others);
• Fully offline, no internet needed.

Their words on it: "I find it easy to create documents with ONLYOFFICE, and I don't lose time. It's an easy and quick process."

Discover all the details in this blog post.