Using numbers w/ commas in spreadsheets?
Subject: Using numbers w/ commas in spreadsheets?
Newsgroups: gmane.emacs.orgmode
Date: 2008-08-27 04:18:14 GMT
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:
<at> 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: <at> 2$3='(+ (string-to-number (replace-regexp-in-string "," "" $1)) (string-to-number (replace-regexp-in-string "," "" $2)) ):: <at> 3$3=$1+$2
_______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode <at> gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
RSS Feed