Re: [O] wrap long table formula
henry atting wrote:
> Nick Dokos writes:
>
> > Christian Moe 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
Re: [O] wrap long table formula
Nick Dokos writes:
> Christian Moe 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
Re: [O] wrap long table formula
Christian Moe 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
Re: [O] wrap long table formula
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
Re: [O] wrap long table formula
Carsten Dominik 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
Re: [O] wrap long table formula
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.
Re: [O] wrap long table formula
Would a column formula work? Samuel -- The Kafka Pandemic: http://thekafkapandemic.blogspot.com === Bigotry against people with serious diseases is still bigotry.
Re: [O] wrap long table formula
Carsten Dominik 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
Re: [O] wrap long table formula
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
[O] wrap long table formula
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
