Calc: problems with conditional formatting

[phaolo]

Hello, I have some problems with conditional formatting (CF) in Calc.

In Excel I was used to set the CF for entire columns for convenience.
Just as a very simplified example: CF range A:A (becomes full like A1:A1048576), formula A1=0, style gray text. In the second column B:B, B1=0, gray, etc.
When I shift dynamic cell formulas, the program detects the existing column CF and shifs it too properly, without altering its height range. No problem.

LibreOffice Calc, instead, ignores the existing CF and creates sub-ranges, making a mess.
It adds a new one every time I shift (laterally), like A2:B2;C30:E30 etc.
At the moment the only workaround seems to avoid shifting and instead copy-paste formulas one by one, but it’s quite cumbersome.

Could this be fixed, please?

–

Other issues in the “Manage Conditional Formatting” panel:

• the window width is too small and not resizeable
• showing only the first condition column is not enough to avoid deleting the wrong entries
• that panel needs a Duplicate\Copy button

–

Could you also make editing a CF with formulas a bit faster?
Every time I have to click the Conditional button > Condition > More rules > confirm warning about existing CF.
Just give me a “Edit CF” button, please.

[sokol92]

@phaolo

When I shift dynamic cell formulas, the program detects the existing column CF and shifs it too properly,

Please clarify what you mean (preferably using your uploaded example): “shift dynamic cell formulas”.
Are you talking about inserting a range of cells? Which one exactly?

[fpy]

@phaolo

Just

→ Get Involved | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with Microsoft

[phaolo]

The formula in the cells doesn’t matter much, because it could be whatever, if it makes sense shifting it.
For example this could always point to the column A entries, but search different text inserted in the first header row (let’s ignore the not find error for semplicity):

=FIND(B$1;$A2) ➡️ =FIND(C$1;$A2) ➡️ =FIND(D$1;$A2)
      ⬇️               ⬇️                ⬇️
=FIND(B$1;$A3) ➡️ =FIND(C$1;$A3) ➡️ =FIND(D$1;$A3)

The vertical shift seems to work, but the horizontal one messes up the CF

[LeroyG]

@phaolo

shifting

What do you mean with shifting?
Do you insert new cells (i.e., with Ctrl++) and choose Shift?


Do you drag cells to another position?

[phaolo]

Ah yes, I drag the cells from the corner

[LeroyG]

@phaolo

drag the cells from the corner

Copying Formulas

Moving Cells by Drag-and-Drop

[phaolo]

“Copying” formulas seems a bit a generic term, but ok, I meant that.

–

Btw in the meantime I found that as a better alternative to preserve the CF I can select multiple cells and use “Paste Special”>Formula.
Still, shifting\copying should be fixed IMO, since it’s a basic feature for spreadsheets.

[phaolo]

Do LO devs check this forum, or is it only for user support?
Should I post bugs and feature requests elsewhere?

[robleyd]

How to report bugs.
Feature requests