I have a table with 3 columns and 13 rows. Each field of the 3rd column calculates the average of the preceding rows of the 2nd column. For this I wrote formulas for 11 of 13 rows which results in a very long line. How can I wrap this line? henry -- http://literaturlatenight.de

```
On Oct 31, 2011, at 3:01 PM, henry atting wrote:
> I have a table with 3 columns and 13 rows. Each field of the 3rd
> column calculates the average of the preceding rows of the 2nd column.
> For this I wrote formulas for 11 of 13 rows which results in a very
> long line.
> How can I wrap this line?
You don't.
You can use the equation editor to have a more convenient way to edit the equations.
- Carsten
```

Carsten Dominik <carsten.dominik@gmail.com> writes: > On Oct 31, 2011, at 3:01 PM, henry atting wrote: > >> I have a table with 3 columns and 13 rows. Each field of the 3rd >> column calculates the average of the preceding rows of the 2nd column. >> For this I wrote formulas for 11 of 13 rows which results in a very >> long line. >> How can I wrap this line? > > You don't. > > You can use the equation editor to have a more convenient way to edit the equations. > > - Carsten > This is great; I did not know the formula editor yet. Thanks. henry -- http://literaturlatenight.de

Would a column formula work? Samuel -- The Kafka Pandemic: http://thekafkapandemic.blogspot.com === Bigotry against people with serious diseases is still bigotry.

On 31.10.2011, at 19:10, Samuel Wales wrote: > Would a column formula work? Good idea! Quite likely it would. - Carsten > > Samuel > > -- > The Kafka Pandemic: http://thekafkapandemic.blogspot.com > === > Bigotry against people with serious diseases is still bigotry.

Carsten Dominik <carsten.dominik@gmail.com> writes: > On 31.10.2011, at 19:10, Samuel Wales wrote: > >> Would a column formula work? > > Good idea! Quite likely it would. > > - Carsten > >> >> Samuel >> >> -- >> The Kafka Pandemic: http://thekafkapandemic.blogspot.com >> === >> Bigotry against people with serious diseases is still bigotry. I was thinking of a column formula but have no clue if it's possible and if so, how. In this short example the formula's length is no problem but for a table with 12 rows or more it certainly is; -- and currently it's the only way I can realize it. | | | |---+---| | 2 | | | 6 | 4 | | 7 | 5 | #+TBLFM: @3$2=vmean(@2$1..@3$1::@4$2=vmean(@2$1..@4$1 henry -- http://literaturlatenight.de

```
On 11/1/11 8:17 AM, henry atting wrote:
> I was thinking of a column formula but have no clue if it's
> possible and if so, how.
>
> In this short example the formula's length is no problem but for a
> table with 12 rows or more it certainly is; -- and currently it's the
> only way I can realize it.
>
> | | |
> |---+---|
> | 2 | |
> | 6 | 4 |
> | 7 | 5 |
> #+TBLFM: @3$2=vmean(@2$1..@3$1::@4$2=vmean(@2$1..@4$1
| | |
|---+-----|
| 2 | |
| 6 | 4 |
| 7 | 5 |
| 3 | 4.5 |
| 9 | 5.4 |
#+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1)
hth,
Christian
```

```
Christian Moe <mail@christianmoe.com> wrote:
> On 11/1/11 8:17 AM, henry atting wrote:
>
> > I was thinking of a column formula but have no clue if it's
> > possible and if so, how.
> >
> > In this short example the formula's length is no problem but for a
> > table with 12 rows or more it certainly is; -- and currently it's the
> > only way I can realize it.
> >
> > | | |
> > |---+---|
> > | 2 | |
> > | 6 | 4 |
> > | 7 | 5 |
> > #+TBLFM: @3$2=vmean(@2$1..@3$1::@4$2=vmean(@2$1..@4$1
>
>
> | | |
> |---+-----|
> | 2 | |
> | 6 | 4 |
> | 7 | 5 |
> | 3 | 4.5 |
> | 9 | 5.4 |
> #+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1)
>
Another common way to deal with an exceptional cell is to use a field
formula for the exceptional cell and a column formula for the rest:
field formulas take precedence:
#+TBLFM: @2$2 = string("") :: $2 = vmean(@2$1..@0$2)
Nick
```

Nick Dokos <nicholas.dokos@hp.com> writes: > Christian Moe <mail@christianmoe.com> wrote: > >> On 11/1/11 8:17 AM, henry atting wrote: >> >> > I was thinking of a column formula but have no clue if it's >> > possible and if so, how. >> > >> > In this short example the formula's length is no problem but for a >> > table with 12 rows or more it certainly is; -- and currently it's the >> > only way I can realize it. >> > >> > | | | >> > |---+---| >> > | 2 | | >> > | 6 | 4 | >> > | 7 | 5 | >> > #+TBLFM: @3$2=vmean(@2$1..@3$1::@4$2=vmean(@2$1..@4$1 >> >> >> | | | >> |---+-----| >> | 2 | | >> | 6 | 4 | >> | 7 | 5 | >> | 3 | 4.5 | >> | 9 | 5.4 | >> #+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1) >> > > Another common way to deal with an exceptional cell is to use a field > formula for the exceptional cell and a column formula for the rest: > field formulas take precedence: > > #+TBLFM: @2$2 = string("") :: $2 = vmean(@2$1..@0$2) > > Nick Thanks again to all, both solutions are working fine; I could get rid of my tapeworm formula. Is there a place where these advanced features are explained more thoroughly? henry -- http://literaturlatenight.de

henry atting <nsmp_02@online.de> wrote: > Nick Dokos <nicholas.dokos@hp.com> writes: > > > Christian Moe <mail@christianmoe.com> wrote: > > > >> | | | > >> |---+-----| > >> | 2 | | > >> | 6 | 4 | > >> | 7 | 5 | > >> | 3 | 4.5 | > >> | 9 | 5.4 | > >> #+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1) > >> > > > > Another common way to deal with an exceptional cell is to use a field > > formula for the exceptional cell and a column formula for the rest: > > field formulas take precedence: > > > > #+TBLFM: @2$2 = string("") :: $2 = vmean(@2$1..@0$2) > > > Thanks again to all, both solutions are working fine; I could get rid of my > tapeworm formula. > > Is there a place where these advanced features are explained more thoroughly? > All of this is contained in (info "(org) The spreadsheet") but sometimes you have to read the section a few times (and refer back to it a few more times): in particular (info "(org) References") and (info "(org) Field and range formulas") deserve repeated reading. (info "(org) Column formulas") describes the field formula trick. The whole spreadsheet section of the manual could benefit from a list of well chosen examples (perhaps on Worg, with a pointer from the manual). But afaict, everything is in the manual. Nick