Re: how to add a range of columns

2021-07-04 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 20:56, Uwe Brauer wrote: >> Now I want to add also result and new, but only the first two rows, the >> only way to do it seems to be your original approach. > At this point, you need to start using more advanced formulas, > e.g. invol

Re: how to add a range of columns

2021-07-03 Thread Eric S Fraga
On Friday, 2 Jul 2021 at 20:56, Uwe Brauer wrote: > Now I want to add also result and new, but only the first two rows, the > only way to do it seems to be your original approach. At this point, you need to start using more advanced formulas, e.g. involving conditionals, maybe. You could do arit

Re: how to add a range of columns

2021-07-02 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 16:07, Uwe Brauer wrote: >> The problem is the target @<<$3..@>>$3 >> >> There seems no option to specify such a range. > Sorry, I didn't explain myself properly. You can specify which rows > should be calculated automatically so th

Re: how to add a range of columns

2021-07-02 Thread Eric S Fraga
On Friday, 2 Jul 2021 at 16:07, Uwe Brauer wrote: > The problem is the target @<<$3..@>>$3 > > There seems no option to specify such a range. Sorry, I didn't explain myself properly. You can specify which rows should be calculated automatically so that you can then use a simple column formula wi

Re: how to add a range of columns

2021-07-02 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 12:04, Uwe Brauer wrote: >> I will have a look thanks (I already thought about commenting out >> unwanted rows, but that looked ugly). > The nice thing about the advanced features is they give you full control > and none of the extra

Re: how to add a range of columns

2021-07-02 Thread Eric S Fraga
On Friday, 2 Jul 2021 at 12:04, Uwe Brauer wrote: > I will have a look thanks (I already thought about commenting out > unwanted rows, but that looked ugly). The nice thing about the advanced features is they give you full control and none of the extra notation is exported. -- : Eric S Fraga vi

Re: how to add a range of columns

2021-07-02 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 11:23, Uwe Brauer wrote: >> No I only want to add the parts of column $1 and $2 that are between the >> two hlines > Okay; problem 1 is that org formulas are not really vector based: a > range on the left hand side says that each elem

Re: how to add a range of columns

2021-07-02 Thread Eric S Fraga
On Friday, 2 Jul 2021 at 11:23, Uwe Brauer wrote: > No I only want to add the parts of column $1 and $2 that are between the > two hlines Okay; problem 1 is that org formulas are not really vector based: a range on the left hand side says that each element in the range will be assigned the outcom

Re: how to add a range of columns

2021-07-02 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 10:42, Uwe Brauer wrote: >> I'd like to add a range values of two columns something like this > I am not sure what you are trying to achieve. Would you please explain > in more detail? It kind of looks like you are trying to add co

Re: how to add a range of columns

2021-07-02 Thread Eric S Fraga
On Friday, 2 Jul 2021 at 10:42, Uwe Brauer wrote: > I'd like to add a range values of two columns something like this I am not sure what you are trying to achieve. Would you please explain in more detail? It kind of looks like you are trying to add columns 1 and 2 to get column 3? If so, you