Re: [Libreoffice-ux-advise] Possible change of Calc option : Expand references when new columns/rows are .. ?

Hi Eike,

Eike Rathke wrote (20-03-13 14:36)

> On Thursday, 2013-03-14 11:25:43 +0100, Cor Nouws wrote:
>
> > Working with users, I quite often have the impression that it's
> > wrong that the setting
> >   Tools > Options > Calc > General >
> >     Expand references when new columns/rows are inserted
> > is set to OFF by default.
> >
> > Objections to change that to ON ?
>
> It may have unwanted effects, most users probably are not aware that
> every (!) expression that references an adjacent range would have that
> range extended and suddenly calculate differently, probably even
> silently. Those users who are aware can easily change that option.

Initially I thought about that too. But I expect the situation to be 
rather rare, that someone inserts a row / column, directly adjacent to a 
referenced range, without wanting a range to extend. (Hmmm, maybe that's 
likely for rows rather then columns.. )
OTOH I really often see people having to change formulae when a row is 
inserted, just because of this option, while they are not aware of it...
(Ah well, a good reason to give training of course... ;-) )

Better/more thoughts?

--
 - Cor
 - http://nl.libreoffice.org
 - www.librelex.org