Cell formatting formula - Bug

Docs
, ,
1

Report a bug / Ask a how-to question
For feature suggestions, describe the result you would like to achieve in detail.
For bug reports, provide the steps to reproduce and if possible a minimal demo of the problem.
OS version: MacOS 26.3
App version: 9.3.0
Downloaded from: ONLYOFFICE website / Other (specify). Please point us to the installation guide that you used as well.
Additional information:
Hi

When I want to apply conditional cell formatting using a formula based on the pattern: IF D1=“XXX” then color cells A1:C1 green and then save the table, the formatting is ineffective after reopening the table, meaning that it is no longer applied.

If I then change any character in the formatting, save it, and execute it once, the entire formatting works again.

Is this bug already known, or are there any working solutions for it?

I work in .xlsx format, but switching to .ods format does not improve the situation.

2

Hey @wilma, :wave:

Thanks for the report!

To reproduce and test it faster on our side, could you please:

  1. Record a short video showing the steps from start to finish:

    • Create the conditional formatting rule with the IF formula
    • Apply it (works initially)
    • Save → close → reopen → formatting is gone
    • Then edit → save → it works again

    Upload the video to ONLYOFFICE DocSpace / Google Drive / kDrive / Dropbox and share the link here.

  2. Attach the sample .xlsx file (or a minimal version that shows the issue).
    You can upload it directly to this thread.

This will help us see exactly what’s happening and confirm if it’s a bug.

Also, just a quick note: the primary format for ONLYOFFICE is OOXML (.xlsx for spreadsheets). When you open .ods files, they are internally converted to .xlsx for editing — so switching to .ods won’t change the behavior here.

Thanks a lot for your help — looking forward to the video/file!

3

Hi Nikolas,

here is the Link to my Video Bugreport - Cell formatting formula

The Bug has changed a little bit since updating OO to 9.3.1

Now i have to delete one formatting formula and renew it to get all of them working again.

Unfortunately as a new user, i can´t attach files, so here is another LINK to the File.

After saving it, it will now not work, unless one Formula will be deleted and renewed.

Hope everything is ok so and I can help fix the bug and improve OnlyOffice a little bit.

1 Like
4

Hi @Nikolas

did you receive or watch my short video and the demo file?

And do you find it useful?

This bug is incredibly annoying, and it would be great if I could help fix it.

Best regards