* Using numbers w/ commas in spreadsheets?
@ 2008-08-27 4:18 Parker, Matthew
2008-09-03 7:03 ` Carsten Dominik
0 siblings, 1 reply; 2+ messages in thread
From: Parker, Matthew @ 2008-08-27 4:18 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1.1: Type: text/plain, Size: 963 bytes --]
Is it possible to work w/ numbers w/ commas in 'spreadsheets'?
when trying to add 3,000 to 4,000 below...
=$1+$2
... yields 7
and this works but is long winded:
@2$3='(+ (string-to-number (replace-regexp-in-string "," "" $1))
(string-to-number (replace-regexp-in-string "," "" $2)) )
I reviewed the chapter on tables... am I missing something simple?
Thanks
| one | two | sum |
|---------+---------+-----------------------|
| 3000 | 4000 | 7000 |
| 3,000 | 4,000 | 7 |
| 3,000 | 4,000 | 7000 |
| "3,000" | "4,000" | [103, 88, 96, 96, 96] |
| 3\,000 | 4\,000 | #ERROR |
| '3,000' | '4,000' | #ERROR |
#+TBLFM: @2$3='(+ (string-to-number (replace-regexp-in-string "," ""
$1)) (string-to-number (replace-regexp-in-string "," "" $2))
)::@3$3=$1+$2
[-- Attachment #1.2: Type: text/html, Size: 6118 bytes --]
[-- Attachment #2: Type: text/plain, Size: 204 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: Using numbers w/ commas in spreadsheets?
2008-08-27 4:18 Using numbers w/ commas in spreadsheets? Parker, Matthew
@ 2008-09-03 7:03 ` Carsten Dominik
0 siblings, 0 replies; 2+ messages in thread
From: Carsten Dominik @ 2008-09-03 7:03 UTC (permalink / raw)
To: Parker, Matthew; +Cc: emacs-orgmode
[-- Attachment #1.1: Type: text/plain, Size: 1242 bytes --]
On Aug 27, 2008, at 6:18 AM, Parker, Matthew wrote:
> Is it possible to work w/ numbers w/ commas in 'spreadsheets'?
No, this is not possible.
- Carsten
>
> when trying to add 3,000 to 4,000 below...
> =$1+$2
> ... yields 7
>
> and this works but is long winded:
> @2$3='(+ (string-to-number (replace-regexp-in-string "," "" $1))
> (string-to-number (replace-regexp-in-string "," "" $2)) )
>
> I reviewed the chapter on tables... am I missing something simple?
>
> Thanks
>
> | one | two | sum |
> |---------+---------+-----------------------|
> | 3000 | 4000 | 7000 |
> | 3,000 | 4,000 | 7 |
> | 3,000 | 4,000 | 7000 |
> | "3,000" | "4,000" | [103, 88, 96, 96, 96] |
> | 3\,000 | 4\,000 | #ERROR |
> | '3,000' | '4,000' | #ERROR |
> #+TBLFM: @2$3='(+ (string-to-number (replace-regexp-in-string "," ""
> $1)) (string-to-number (replace-regexp-in-string "," "" $2)) )::@3$3=
> $1+$2
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
[-- Attachment #1.2: Type: text/html, Size: 10031 bytes --]
[-- Attachment #2: Type: text/plain, Size: 204 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2008-09-03 7:03 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2008-08-27 4:18 Using numbers w/ commas in spreadsheets? Parker, Matthew
2008-09-03 7:03 ` Carsten Dominik
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).