Re: [O] tables: is it possible to use a comma instead of a period as a number delimiter

[Michael Brand]

Hi Izzie

The only direct solution I can think of now is with Emacs Lisp for
number/string conversion and ./, replacement:

#+begin_src emacs-lisp :results silent
  (defun com2num (com)
    "convert number string with comma like \"2,3\" to number like 2.3"
    (string-to-number (replace-regexp-in-string "," "." com)))
  (defun num2com (fmt num)
    "convert number like 2.300001 to number string with comma
like \"2,3\", formatted with fmt like \"%.1f\""
    (replace-regexp-in-string "\\." "," (format fmt num)))
#+end_src

|  <r> |
|------|
| 10,2 |
|  3,0 |
|  5,6 |
|------|
| 18,8 |
#+TBLFM: @5='(num2com "%.1f" (apply '+ (mapcar 'com2num '(@address@hidden))))

Michael

On Mon, May 16, 2011 at 01:12, Izzie <address@hidden> wrote:
> I started using org tables including a column of numbers formatted the 
> European
> way with a comma instead of a period, for example 127,43 for 127.43.
>
> When I use a formula to sum the whole column it expect a period and ends up 
> with
> a false calculation. I'd revert my numbers to the American format but this 
> table
> is used for accounting so it's not an option. Going through the manual didn't
> provide any help.
>
> Is there a way to have org use the european format or am I to ditch the 
> formula
> and make use of C-c + to manually calculate the sum ?