[Solved] Inserting rows breaks my spreadsheet..

Discuss the spreadsheet application

[Solved] Inserting rows breaks my spreadsheet..

Postby abrogard » Thu Apr 15, 2021 10:28 pm

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
abrogard
 
Posts: 20
Joined: Wed Nov 12, 2014 1:49 am

Re: Inserting rows breaks my spreadsheet..

Postby MrProgrammer » Fri Apr 16, 2021 9:19 pm

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 6 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 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3957
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Inserting rows breaks my spreadsheet..

Postby abrogard » Sat Apr 17, 2021 12:09 am

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
abrogard
 
Posts: 20
Joined: Wed Nov 12, 2014 1:49 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests