* How to put a Greek sigma into the spreadsheet?
@ 2013-06-03 10:53 Marcin Borkowski
2013-06-03 12:01 ` Jambunathan K
2013-06-03 12:18 ` Michael Brand
0 siblings, 2 replies; 8+ messages in thread
From: Marcin Borkowski @ 2013-06-03 10:53 UTC (permalink / raw)
To: Org-mode mailing list
Hi list,
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?
(My use case is a row which should show the sum the columns, and I
wanted the sigma in the first column. I don't *need* it very badly,
and I could get away with TeX-like \Sigma, but maybe there's some neat
trick to get the Unicode one?)
TIA,
--
Marcin Borkowski
http://octd.wmi.amu.edu.pl/en/Marcin_Borkowski
Adam Mickiewicz University
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
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:18 ` Michael Brand
1 sibling, 1 reply; 8+ messages in thread
From: Jambunathan K @ 2013-06-03 12:01 UTC (permalink / raw)
To: Marcin Borkowski; +Cc: Org-mode mailing list
Marcin Borkowski <mbork@wmi.amu.edu.pl> writes:
> I could get away with TeX-like \Sigma, but maybe there's some neat
> trick to get the Unicode one?)
Use TeX as an input method and enter \Sigma. That's it.
http://lists.gnu.org/archive/html/help-gnu-emacs/2013-06/msg00022.html
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
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:18 ` Michael Brand
2013-06-03 12:28 ` Marcin Borkowski
1 sibling, 1 reply; 8+ messages in thread
From: Michael Brand @ 2013-06-03 12:18 UTC (permalink / raw)
To: Marcin Borkowski; +Cc: Org-mode mailing list
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..@>>)
or
| item | value |
|------+-------|
| a | 1 |
| b | 2 |
|------+-------|
| | ∑ = 3 |
#+TBLFM: @>$2 = vsum(@I..@>>); ∑ = %d
Michael
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
2013-06-03 12:18 ` Michael Brand
@ 2013-06-03 12:28 ` Marcin Borkowski
2013-06-03 12:44 ` Michael Brand
0 siblings, 1 reply; 8+ messages in thread
From: Marcin Borkowski @ 2013-06-03 12:28 UTC (permalink / raw)
To: Michael Brand
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
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
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
0 siblings, 2 replies; 8+ messages in thread
From: Marcin Borkowski @ 2013-06-03 12:29 UTC (permalink / raw)
To: emacs-orgmode
Dnia 2013-06-03, o godz. 17:31:17
Jambunathan K <kjambunathan@gmail.com> napisał(a):
> Marcin Borkowski <mbork@wmi.amu.edu.pl> writes:
>
> > I could get away with TeX-like \Sigma, but maybe there's some neat
> > trick to get the Unicode one?)
>
> Use TeX as an input method and enter \Sigma. That's it.
>
> http://lists.gnu.org/archive/html/help-gnu-emacs/2013-06/msg00022.html
>
The point is, I do not want to export the table, just use/display it in
Org. So "\Sigma" doesn't look very cool (though, as I said, I could
live with it.)
--
Marcin Borkowski
http://octd.wmi.amu.edu.pl/en/Marcin_Borkowski
Adam Mickiewicz University
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
2013-06-03 12:29 ` Marcin Borkowski
@ 2013-06-03 12:42 ` Marcin Borkowski
2013-06-03 12:43 ` Bastien
1 sibling, 0 replies; 8+ messages in thread
From: Marcin Borkowski @ 2013-06-03 12:42 UTC (permalink / raw)
To: emacs-orgmode
Dnia 2013-06-03, o godz. 14:29:22
Marcin Borkowski <mbork@wmi.amu.edu.pl> napisał(a):
> Dnia 2013-06-03, o godz. 17:31:17
> Jambunathan K <kjambunathan@gmail.com> napisał(a):
>
> > Marcin Borkowski <mbork@wmi.amu.edu.pl> writes:
> >
> > > I could get away with TeX-like \Sigma, but maybe there's some neat
> > > trick to get the Unicode one?)
> >
> > Use TeX as an input method and enter \Sigma. That's it.
> >
> > http://lists.gnu.org/archive/html/help-gnu-emacs/2013-06/msg00022.html
> >
>
> The point is, I do not want to export the table, just use/display it
> in Org. So "\Sigma" doesn't look very cool (though, as I said, I
> could live with it.)
>
Sorry, I misread your answer. My problem is not in *entering* sigma (I
used C-x 8 RET and the unicode name, though the TeX input method is
also a viable solution); the problem was connected with my column
formula messing up with my sigma, and I wanted it to be entered by a
field formula.
Thanks anyway,
--
Marcin Borkowski
http://octd.wmi.amu.edu.pl/en/Marcin_Borkowski
Adam Mickiewicz University
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
2013-06-03 12:29 ` Marcin Borkowski
2013-06-03 12:42 ` Marcin Borkowski
@ 2013-06-03 12:43 ` Bastien
1 sibling, 0 replies; 8+ messages in thread
From: Bastien @ 2013-06-03 12:43 UTC (permalink / raw)
To: Marcin Borkowski; +Cc: emacs-orgmode
Hi Marcin,
Marcin Borkowski <mbork@wmi.amu.edu.pl> writes:
> The point is, I do not want to export the table, just use/display it in
> Org. So "\Sigma" doesn't look very cool (though, as I said, I could
> live with it.)
Use C-x RET C-\ TeX RET to select TeX as the input method, then
type \Sigma to insert the character.
--
Bastien
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: How to put a Greek sigma into the spreadsheet?
2013-06-03 12:28 ` Marcin Borkowski
@ 2013-06-03 12:44 ` Michael Brand
0 siblings, 0 replies; 8+ messages in thread
From: Michael Brand @ 2013-06-03 12:44 UTC (permalink / raw)
To: Marcin Borkowski; +Cc: Org Mode
Hi Marcin
On Mon, Jun 3, 2013 at 2:28 PM, Marcin Borkowski <mbork@wmi.amu.edu.pl> wrote:
> 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.
Yes, exactly.
Michael
^ permalink raw reply [flat|nested] 8+ messages in thread
end of thread, other threads:[~2013-06-03 12:51 UTC | newest]
Thread overview: 8+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
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
2013-06-03 12:44 ` Michael Brand
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).