2015 Archives by date, by thread · List index

# Re: [libreoffice-users] Calc fails to warn when insert cell breaks sum(A1:A2)

```Hi :)
I'm guessing you are a fairly logical and astute thinker rather than a
typical office drone or a typically tech-averse accountancy person.

Yes there is no problem unless the user is a moron.  Sadly many of us
often are a bit moronic from time to time.

The suggestion was to maybe write a feature request to guard against
user-error or pebkac problems.
Regards from
Tom :)

On 13 February 2015 at 00:14, Kaj <70147persson@telia.com> wrote:
```
```I think have a wee difficult to understand what you are doing, as I do not
see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum
formula in A3. Then you insert an empty cell in A1 while moving the existing
content in the cells one step to the right. Hence after the insertion A2
contains the constant 1, A3 contains the constant 2 and A4 contains the
formula. All references are relative, so cell A4 now is = sum(A2:A3) giving
the result 3, just as before. That the cell A3 computes 2 is evident as it
contains the constant you put in cell A2 before the move.

So sorry, I am not clever enough to realize your problem.

Den 2015-02-12 21:14, skrev Spencer Graves:
```
```
functioned correctly was giving wrong answers without warning.  After the
usual wailing and gnashing of teeth, I traced the problem to a cell
containing "=C4-SUM(G11:G1016)”.  Further experimentation produced the
following simple version of the problem:

(1) Let A1=1, A2=2, and A3=sum(A1:A2);  A3 computes here as 3.
(2) Insert cell A1 shift right.
(3) Observe: A3 now computes as 2. This is obvious in this case but far
from obvious in a complicated spreadsheet, where the connection between A1
and A3 is obscure. In such cases, For an insert that would cause an error in
a reference like A1:A2, I believe that Calc should issue a warning something
like, “WARNING: Insert may change the answer computed in A3. Do you want to
proceed?” I further think there should be no default and the user should be
forced to select either “Yes” or “No”.

This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56,
and MS Excell 2003 sp3.

Should this be filed as a bug report or a feature request?  If yes, which,
and what message should display?

Wikipedia says, "A software bug is an error, flaw, failure, or fault in a
computer program or system that causes it to produce an incorrect or
unexpected result, or to behave in unintended ways.”  I think this fits that
definition.  However, it may qualify as a feature request, because the fix
is less than obvious (and it has been around for so long).

Enjoy, Spencer

```
```

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
```
```
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```