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.

3

I think I have a similar issue, so let me bump the topic.

Conditional Formatting doesn’t update it’s “rule” responsively.

for example:

A1: “test”
A2: “test”
A3: “not test”

I have a rule set, that applys for “A1:A3”.
All cells that fulfill the rule “$A1=“test”” should be bold.

Now I move these three cells to B3:B5.
The “apply for” changes automatically to “B3:B5”
However the rule stays at “$A1=“test””
Thus the conditional Formatting doesn’t work anymore.

Here is the example Spreadsheet:
test.xlsx (8.6 KB)

→ I guess this is a feature request.

Best,
Alex

5

Hello @GutmenschAlex
Do I reproduce the issue correctly?

6

Thanks for looking into it!
My issue is more with moving the data.

8

Thank you! We are checking the situation.

10

Dear @GutmenschAlex
Thank you for pointing us to this situation!
We have found a bug in the described scenario, we have started working on it.
Thank you for valuable data!

11

Hello @GutmenschAlex, @Rocketman

I’d like to inform you that we are in the process of releasiing new version 9.0 of Desktop Editors. This version brings the fix to the issue discussed in this topic, please update the app and check the situation again.

The update will be available shortly.

1 Like
12

I just got the update and can confirm, that this issue is fixed for me! Thank you!

1 Like
13

Thanks for the feedback. Original posted does not seem to be here anymore, so I am closing the topic as solved.