Using numbers w/ commas in spreadsheets?

Using numbers w/ commas in spreadsheets?

[Parker, Matthew]

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

Re: Using numbers w/ commas in spreadsheets?

[Carsten Dominik]

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