[Libreoffice-bugs] [Bug 143198] Cell Range Data Validity Doesn't Work Properly For A Selected Set Of Cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

Uwe Auer <uwe at franke-auer.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Uwe Auer <uwe at franke-auer.de> ---
The validity was defined "Fruits.A2:A10000" for cell "A2". Obviously the cell
validity was copied down to cell "A3" and due to using a relative addressing
scheme the validity range turns top "Fruits.A3:A10001" as per general rules and
behavior. But is was expected to stay at "Fruits.A2:A10000". This proceeds
until there is no value an longer in the validity list (cell "A7" and validity
range being "Fruits.A7:A10005"). To achieve the intended behavior you need to
use an absolute adrdessing scheme using "$": 
- Add "Fruits.A$2:A$10000" as validity for "A2" 
- Copy cell "A2" down to get the correct validity expression for subsequent
rows

[1] LibreOffice Help - Addresses and References, Absolute and Relative:
https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html?DbPAR=CALC#bm_id3156423

>From my perspective not a bug.

-- 
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/20210705/6bc7d017/attachment.htm>