Date: · Thread:
2015 Archives by date, by thread · List index

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

First: I missed sending to the list, so here again is my posting.

Ok, I admit. I am the moron. Still I do not see the problem. Calc does not behave the way describe. If you insert a new cell, all its neighbours are influenced, and you yourself chose how, via the dialogue: "Move down ", "Move right", "New line" or "New column" (ok I did not quote the headers correctly, but I am convinced you understand). No other option is given. So after a cell insertion with option "Move right" the neighbours really have new positions one step ahead of the original one. To me, what you describe, Brian, the situation is not inserting a new cell, but a new value, possibly clearing the old one, into cell A1, without changing the structure. Am I correct? If so, the solution is already given by Mark in this thread, namely cell protection. If this is done in an appropriate way, and the user changes the value an allowed cell, no spreadsheet program in this world can hinder that (or warn for it).

I honestly try to understand the core of the original question, but I cannot, sorry.

At 2015-02-13 04:27, Brian Barker wrote:
At 01:14 13/02/2015 +0100, you 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.

You are right that there is no problem to be solved here, but you've misunderstood the detail of the problem. Although you talk of moving content "one step to the right", your subsequent description is of the situation if the insertion into A1 moves the rest of column A *down*.

Instead, the questioner means what he says: he inserts a new, empty cell into A1, moving the whole of row 1 one place to the right. A2 still has 2 and A3 still has =SUM(A1:A2), so the formula now adds the 2 in A2 to the value of the new empty cell A1 - interpreted as zero, of course.

Brian Barker - privately

--
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

### 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.