[Libreoffice-bugs] [Bug 140352] El rango en formato condicional no funciona adecuadamente

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Feb 11 17:23:36 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=140352

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
     Ever confirmed|0                           |1

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Por favor Victor el idioma de uso en Bugzilla es el inglés.

Paso to comentario en inglés, pero por favor haz la consulta primero en
https://ask.libreoffice.org/es/questions/ aportando un fichero de ejemplo, creo
que solo es un problema de establecer una referencia absoluta $A$9 para que la
comparación sea siempro con ella.

Description:
When I put a range of cells to change the formatting with the idea of crossing
out a whole row or part of it depending on a cell from which I make the
selection only does it with the first cell of the range and not with all of it.
The idea is to have 7 rows that I show if in the cell A9 I have from values
A9=7 I show row 7 and all rows from 1 to 7 except 7 crossed out or blank with a
censored style white letters on white background.
A9=2 the same for row 2.
A9=0 or blank, shows everything normal.

I do the conditional formatting in a range and the condition in a cell but it
only does it in the first cell of the range.
I think it is a bug in the programming of this functionality.

Steps to Reproduce:
1.conditional formatting
2.Range D3:D10
3.formula: A9=7

Actual Results:
only cell D3 changes

Expected Results:
I expected the whole range of cells to change.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210211/76f2b08c/attachment.htm>


More information about the Libreoffice-bugs mailing list