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 '(@2..@4))))
Michael
On Mon, May 16, 2011 at 01:12, Izzie <[email protected]> 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 ?
