Date: prev next · Thread: first prev next last
March 2013 Archives by date, by thread · List index


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


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.