[Solved] Inserting rows breaks my spreadsheet..

Discuss the spreadsheet application
Post Reply
abrogard
Posts: 28
Joined: Wed Nov 12, 2014 1:49 am

[Solved] Inserting rows breaks my spreadsheet..

Post by abrogard »

I have a very simple spreadsheet. (because I don't know much).

Basically three columns. B,C,D.

In B I add together a fixed amount and the amount found in column C from one row higher.
In C I add together B and D

That's all. But it works fine. It shows the start amount for that week in B, being the fixed amount plus 'leftover' from the previous week.
And it shows the 'leftover' for this week in C being that start amount less any input from D.

But if I get inputs during the week and insert rows to all for them then the formula don't work any more and I have to resort to doing it all by hand.

I would just like to find a way to keep it all automated if I can.

Here is the spreadsheet: http://abrogard.com/tinytwo.ods
Last edited by abrogard on Sat Apr 17, 2021 12:11 am, edited 2 times in total.
Open Office 4.0.1 Win7
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Inserting rows breaks my spreadsheet..

Post by MrProgrammer »

abrogard wrote:But if I get inputs during the week and insert rows to all for them then the formula don't work any more and I have to resort to doing it all by hand. I would just like to find a way to keep it all automated if I can.
Rearrange your layout so you do not need to insert rows when you have varying numbers of inputs in a week.
202104151700.ods
(14.54 KiB) Downloaded 94 times
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
abrogard
Posts: 28
Joined: Wed Nov 12, 2014 1:49 am

Re: Inserting rows breaks my spreadsheet..

Post by abrogard »

Well that's lovely. Elegant you might even say.
Thanks a lot for that. I will adopt it I think.

:)
Open Office 4.0.1 Win7
Post Reply