Created attachment 195952 [details] Screeshot Cell Referenz Bug I use a table with random numbers, as in the instructions https://help.libreoffice.org/latest/de/text/scalc/guide/cellstyle_conditional.html?DbPAR=CALC I have used the complete instructions. If I then use the conditional formatting, which refers to a fixed cell that is defined with the condition cell value is greater than “cell” and with the second condition cell value is less than “cell”, then almost all cells are selected as a result, except for the first cell A1, although half of the cells are smaller than the desired value. It doesn't matter whether I use a cell with a formula or with a fixed number. I1 is with formula I2 is with a number, for both the conditional formatting does not work. If I enter the same value as a number in conditional formatting instead of the cell, the conditional formatting works.
Please go to the report web page (in this case, <https://bugs.documentfoundation.org/show_bug.cgi?id=162559>) and click on the "Add an attachment" link in that page, in order to attach a minimal sample spreadsheet file that would reproduce the problem.
Created attachment 195966 [details] Cell Referenz Bug
Using attachment 195966 [details], in the CF conditions, all you have to do is to change the current relative reference (cell I1), to be an absolute reference (cell $I$1), so as to obtain the desired result. Next time that you have some doubt, please go first to <https://ask.libreoffice.org> and post your doubt / question there. If other users can confirm that there is really a bug, only then open a bug report (and you can then also add a link to the specific topic). I am closing this report now.
Many thanks for the quick check and help. Now I know that this is described incorrectly in the German manual. As this is also the official manual, I assumed that it had been checked. I will report this to the German team so that the instructions can be corrected. Next time I will also ask via aks.libreoffice.org as written.
Let's fix the help page.
Patch: https://gerrit.libreoffice.org/c/help/+/172309
Ilmari Lauhakangas committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/b27934a3330f48716085cacbc2054a605675f2a5 tdf#162559 Clarify conditional formatting example