https://bugs.documentfoundation.org/show_bug.cgi?id=143198
Uwe Auer <u...@franke-auer.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Uwe Auer <u...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs