emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Spreadsheet error: invalid reference when using @> in range
@ 2015-11-09  9:13 Karl Voit
  2015-11-10 23:42 ` Nicolas Goaziou
  0 siblings, 1 reply; 5+ messages in thread
From: Karl Voit @ 2015-11-09  9:13 UTC (permalink / raw)
  To: emacs-orgmode

Hi!

|     |             20 | 21 | 22 | 23 | 24 |
|     | :=vsum(@3..@>) |    |    |    |    |
|-----+----------------+----+----+----+----|
|     |                |    |    |    |    |
|-----+----------------+----+----+----+----|
|     |              1 |  1 |    |    |  1 |
| Foo |              2 |    |    |    |    |
| Bar |                |    |  2 |  3 |    |
|-----+----------------+----+----+----+----|
|     |                |    |    |    |    |
|-----+----------------+----+----+----+----|
| Bar |                |  4 |  1 |    |    |
| Foo |                |    |  2 |    |  2 |
| Bar |                |    |  3 |  5 |    |
| Foo |                |  1 |    |    |  5 |
|-----+----------------+----+----+----+----|

I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I
try to apply the formula.

Also tried and also failed with same message:
vsum(@3$2..@>$2)
vsum(@I$2..@>$2)
vsum(@I+1$2..@>$2)

Working: 
vsum(@I$2..@11$2)
vsum(@I$2..@IIIII$2)

So the problem seems to be the "@>" part.

Why can't I use the "@>" for "last row" in the formula?

Bonus question: when I want to apply the formula to @2$2 and *all*
table elements rights of it until the last column, is there a way to
define this without having five separate formula?

Thanks!

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github

^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: Spreadsheet error: invalid reference when using @> in range
  2015-11-09  9:13 Spreadsheet error: invalid reference when using @> in range Karl Voit
@ 2015-11-10 23:42 ` Nicolas Goaziou
  2015-11-11  9:47   ` Karl Voit
  0 siblings, 1 reply; 5+ messages in thread
From: Nicolas Goaziou @ 2015-11-10 23:42 UTC (permalink / raw)
  To: Karl Voit; +Cc: Karl Voit, emacs-orgmode

Hello,

Karl Voit <devnull@Karl-Voit.at> writes:

> |     |             20 | 21 | 22 | 23 | 24 |
> |     | :=vsum(@3..@>) |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |              1 |  1 |    |    |  1 |
> | Foo |              2 |    |    |    |    |
> | Bar |                |    |  2 |  3 |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> | Bar |                |  4 |  1 |    |    |
> | Foo |                |    |  2 |    |  2 |
> | Bar |                |    |  3 |  5 |    |
> | Foo |                |  1 |    |    |  5 |
> |-----+----------------+----+----+----+----|
>
> I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I
> try to apply the formula.

I cannot reproduce the problem.
>
> Also tried and also failed with same message:
> vsum(@3$2..@>$2)
> vsum(@I$2..@>$2)
> vsum(@I+1$2..@>$2)

Same here.

> Bonus question: when I want to apply the formula to @2$2 and *all*
> table elements rights of it until the last column, is there a way to
> define this without having five separate formula?

  @2$2..@2$>=vsum(@3..@>)


Regards,

-- 
Nicolas Goaziou

^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: Spreadsheet error: invalid reference when using @> in range
  2015-11-10 23:42 ` Nicolas Goaziou
@ 2015-11-11  9:47   ` Karl Voit
  2015-11-11 19:47     ` Nicolas Goaziou
  0 siblings, 1 reply; 5+ messages in thread
From: Karl Voit @ 2015-11-11  9:47 UTC (permalink / raw)
  To: emacs-orgmode

* Nicolas Goaziou <mail@nicolasgoaziou.fr> wrote:
> Hello,

Hello Nicolas (again)!

> Karl Voit <devnull@Karl-Voit.at> writes:
>
>> |     |             20 | 21 | 22 | 23 | 24 |
>> |     | :=vsum(@3..@>) |    |    |    |    |
>> |-----+----------------+----+----+----+----|
>> |     |                |    |    |    |    |
>> |-----+----------------+----+----+----+----|
>> |     |              1 |  1 |    |    |  1 |
>> | Foo |              2 |    |    |    |    |
>> | Bar |                |    |  2 |  3 |    |
>> |-----+----------------+----+----+----+----|
>> |     |                |    |    |    |    |
>> |-----+----------------+----+----+----+----|
>> | Bar |                |  4 |  1 |    |    |
>> | Foo |                |    |  2 |    |  2 |
>> | Bar |                |    |  3 |  5 |    |
>> | Foo |                |  1 |    |    |  5 |
>> |-----+----------------+----+----+----+----|
>>
>> I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I
>> try to apply the formula.

Funny thing: today, it worked so far :-O

>> Bonus question: when I want to apply the formula to @2$2 and *all*
>> table elements rights of it until the last column, is there a way to
>> define this without having five separate formula?
>
>   @2$2..@2$>=vsum(@3..@>)

However, this does not work at my side:

|                               | 20 | 21 | 22 | 23 | 24 |
| Foo + 2 Bar + Foo + Bar + Foo |  3 |    |    |    |    |
|-------------------------------+----+----+----+----+----|
|                               |    |    |    |    |    |
|-------------------------------+----+----+----+----+----|
|                               |  1 |  1 |    |    |  1 |
| Foo                           |  2 |    |    |    |    |
| Bar                           |    |    |  2 |  3 |    |
|-------------------------------+----+----+----+----+----|
|                               |    |    |    |    |    |
|-------------------------------+----+----+----+----+----|
| Bar                           |    |  4 |  1 |    |    |
| Foo                           |    |    |  2 |    |  2 |
| Bar                           |    |    |  3 |  5 |    |
| Foo                           |    |  1 |    |    |  5 |
|-------------------------------+----+----+----+----+----|
#+TBLFM: @2$2..@2$>=vsum(@3..@>)

At least, the error is gone. What might be the cause of the wrong
result?

Thank you for your time!

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github

^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: Spreadsheet error: invalid reference when using @> in range
  2015-11-11  9:47   ` Karl Voit
@ 2015-11-11 19:47     ` Nicolas Goaziou
  2015-12-27  9:43       ` Karl Voit
  0 siblings, 1 reply; 5+ messages in thread
From: Nicolas Goaziou @ 2015-11-11 19:47 UTC (permalink / raw)
  To: Karl Voit; +Cc: Karl Voit, emacs-orgmode

Karl Voit <devnull@Karl-Voit.at> writes:

> However, this does not work at my side:
>
> |                               | 20 | 21 | 22 | 23 | 24 |
> | Foo + 2 Bar + Foo + Bar + Foo |  3 |    |    |    |    |
> |-------------------------------+----+----+----+----+----|
> |                               |    |    |    |    |    |
> |-------------------------------+----+----+----+----+----|
> |                               |  1 |  1 |    |    |  1 |
> | Foo                           |  2 |    |    |    |    |
> | Bar                           |    |    |  2 |  3 |    |
> |-------------------------------+----+----+----+----+----|
> |                               |    |    |    |    |    |
> |-------------------------------+----+----+----+----+----|
> | Bar                           |    |  4 |  1 |    |    |
> | Foo                           |    |    |  2 |    |  2 |
> | Bar                           |    |    |  3 |  5 |    |
> | Foo                           |    |  1 |    |    |  5 |
> |-------------------------------+----+----+----+----+----|
> #+TBLFM: @2$2..@2$>=vsum(@3..@>)
>
> At least, the error is gone. What might be the cause of the wrong
> result?

You need to update Org.

Regards,

^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: Spreadsheet error: invalid reference when using @> in range
  2015-11-11 19:47     ` Nicolas Goaziou
@ 2015-12-27  9:43       ` Karl Voit
  0 siblings, 0 replies; 5+ messages in thread
From: Karl Voit @ 2015-12-27  9:43 UTC (permalink / raw)
  To: emacs-orgmode

* Nicolas Goaziou <mail@nicolasgoaziou.fr> wrote:
> You need to update Org.

Thank you for your help!

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github

^ permalink raw reply	[flat|nested] 5+ messages in thread

end of thread, other threads:[~2015-12-27  9:45 UTC | newest]

Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2015-11-09  9:13 Spreadsheet error: invalid reference when using @> in range Karl Voit
2015-11-10 23:42 ` Nicolas Goaziou
2015-11-11  9:47   ` Karl Voit
2015-11-11 19:47     ` Nicolas Goaziou
2015-12-27  9:43       ` Karl Voit

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).