Using numbers w/ commas in spreadsheets?

From: "Parker, Matthew" <MParker@seic.com>
To: emacs-orgmode@gnu.org
Subject: Using numbers w/ commas in spreadsheets?
Date: Wed, 27 Aug 2008 00:18:14 -0400	[thread overview]
Message-ID: <9E067A1AECCB154485D4CF7E4BEF4D8E097A1E3B@post07.corp.seic.com> (raw)

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