emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Marcin Borkowski <mbork@wmi.amu.edu.pl> (by way of Marcin Borkowski <mbork@wmi.amu.edu.pl>)
To: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: How to put a Greek sigma into the spreadsheet?
Date: Mon, 3 Jun 2013 14:28:08 +0200	[thread overview]
Message-ID: <20130603142808.2eb7b412@aga-netbook> (raw)
In-Reply-To: <CALn3zogkoCEEzsA8u4gZXhpCAUtiX=FB_LtO-QGimgWuk_-VYg@mail.gmail.com>

Dnia 2013-06-03, o godz. 14:18:33
Michael Brand <michael.ch.brand@gmail.com> napisał(a):

> Hi Marcin
> 
> On Mon, Jun 3, 2013 at 12:53 PM, Marcin Borkowski
> <mbork@wmi.amu.edu.pl> wrote:
> > basically the subject has it.  While :=string("asdf")
> > works, :=string("Σ") does not.  I suspect the reason is that this is
> > not an ASCII symbol.  Is there a way to get around this problem?
> 
> The function "string" of Calc does not support characters above 127,
> see towards the end of
> (info "(calc) Strings")
> or
> http://www.gnu.org/software/emacs/manual/html_node/calc/Strings.html
> 
> If I understand your example you can use just
> 
> | item | value |
> |------+-------|
> | a    |     1 |
> | b    |     2 |
> |------+-------|
> | ∑    |     3 |
> #+TBLFM: @>$2 = vsum(@I..@>>)

Well, I forgot to mention that the first column has a column formula
(something like =@-1+1, so that I get row numbering).  I should
probably use a range formula instead.

> 
> or
> 
> | item | value |
> |------+-------|
> | a    |     1 |
> | b    |     2 |
> |------+-------|
> |      | ∑ = 3 |
> #+TBLFM: @>$2 = vsum(@I..@>>); ∑ = %d

That's interesting, thanks!

> 
> Michael

Best,

-- 
Marcin Borkowski
http://octd.wmi.amu.edu.pl/en/Marcin_Borkowski
Adam Mickiewicz University

  reply	other threads:[~2013-06-03 12:28 UTC|newest]

Thread overview: 8+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-06-03 10:53 How to put a Greek sigma into the spreadsheet? Marcin Borkowski
2013-06-03 12:01 ` Jambunathan K
2013-06-03 12:29   ` Marcin Borkowski
2013-06-03 12:42     ` Marcin Borkowski
2013-06-03 12:43     ` Bastien
2013-06-03 12:18 ` Michael Brand
2013-06-03 12:28   ` Marcin Borkowski [this message]
2013-06-03 12:44     ` Michael Brand

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20130603142808.2eb7b412@aga-netbook \
    --to=mbork@wmi.amu.edu.pl \
    --cc=michael.ch.brand@gmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
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).