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:
> > I recently noticed that a complicated spreadsheet that had previously
> > 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