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
On Feb 13, 2015, at 9:41 AM, Tom Davies tomc...@gmail.com wrote:
Hi :)
Ok, you are not being a moron. I wasn't trying to be funny of anything.
The software is doing exactly the right thing and even has a little pop-up
that people have to choose which way the existing cells have to go. So
Hi :)
Ok, you are not being a moron. I wasn't trying to be funny of anything.
The software is doing exactly the right thing and even has a little pop-up
that people have to choose which way the existing cells have to go. So it
really shouldn't be a problem at all.
However people often create
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
Hi :)
I think post as a Feature Request. If at all possible i think it's
best to post Feature Requests instead of bug-reports. They have a
much bigger feel-good factor and i suspect they are more likely to
attract new devs.
I think there has got to be a default and i tend to prefer it if there
Brian Barker wrote:
At 12:14 12/02/2015 -0800, Spencer Graves wrote:
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
At 12:14 12/02/2015 -0800, Spencer Graves wrote:
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).
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
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