Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc data named range changes - bug or me?

In LO 4.2.4.2 Calc, there is the possibility of named data ranges. Selection and use seems quite simple (Data->Define range/Select range) and unambiguous. However when I do this and for example run a filter, the range limits change spontaneously. This not only screws up the filter, but modifies the range shown for the name. Is there some setting which says "magically override my selection because calc has a better idea", or is this a bug?

Calc data named range changes - bug or me?

In LO 4.2.4.2 Calc, there is the possibility of named data ranges. Selection and use seems quite simple (Data->Define range/Select range) and unambiguous. However when I do this and for example run a filter, the range limits change spontaneously. This not only screws up the filter, but modifies the range shown for the name. Is there some setting which says "magically override my selection because calc has a better idea", or is this a bug?