ONLYOFFICE 7.0: online forms, password protection in sheets, collaboration improvements and much more
ONLYOFFICE 7.0 released

Relative references in conditional formatting

Desktop editors
, ,
#1

Do you want to: Suggest a feature / Report a bug / Ask a how-to question

In MS Excel, references in conditional formatting formulae are relativized in the same way as normal formulae; copying a cell from A2 whose formatting referenced A1 into A3 would instead reference A2. How can similar behavior be achieved in ONLYOFFICE?

To summarize, I’d like to copy a cell with conditional formatting and have it paste like a relative reference instead of an absolute one.

OS version: macOS Catalina 10.15.7 (19H1615)
App version: 6.4.2
Downloaded from: ONLYOFFICE website / Other (specify)

#2

Hello @Rocketman
Could you please provide us with file example where described behavior is implemented and works in MS Excel (with description of behaviour). We need to check it out.