https://bugs.documentfoundation.org/show_bug.cgi?id=87058
aaker <markus.weyerm...@gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |markus.weyerm...@gmx.net --- Comment #17 from aaker <markus.weyerm...@gmx.net> --- Created attachment 192450 --> https://bugs.documentfoundation.org/attachment.cgi?id=192450&action=edit verify Maybe misuse? (unexpected use?, not a bug?) Setting the named range as wizard will do to "$Tabelle1.$B$3:$B$6" (compare OP) and "Tools/Options/General/Expand references when new columns/rows are inserted" to "true" does it. Limits of named range are changing whenever row is added or removed at the limits of the range or somewhere else in the range and the value of the cell referencing the name of the range is updated immediately. Sorry for the trouble. Can be closed. -- You are receiving this mail because: You are the assignee for the bug.