Re: [Orgmode] Using numbers w/ commas in spreadsheets?

[Carsten Dominik]

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.
address@hidden
http://lists.gnu.org/mailman/listinfo/emacs-orgmode