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
_______________________________________________
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
