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

2011-05-16 Thread Carsten Dominik
On 16.5.2011, at 20:08, Nick Dokos wrote: > Carsten Dominik wrote: > >> >> On 16.5.2011, at 15:23, Christian Moe wrote: >> >>> On 5/16/11 2:20 PM, Carsten Dominik wrote: When the OP says he needs this for accounting, I guess he is exporting this data somehow? How about changing >>>

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

2011-05-16 Thread Nick Dokos
Carsten Dominik wrote: > > On 16.5.2011, at 15:23, Christian Moe wrote: > > > On 5/16/11 2:20 PM, Carsten Dominik wrote: > >> When the OP says he needs this for accounting, I guess > >> he is exporting this data somehow? How about changing > >> from dot to comma only in one of the export hooks

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

2011-05-16 Thread Carsten Dominik
On 16.5.2011, at 15:23, Christian Moe wrote: > On 5/16/11 2:20 PM, Carsten Dominik wrote: >> When the OP says he needs this for accounting, I guess >> he is exporting this data somehow? How about changing >> from dot to comma only in one of the export hooks? > > Ah... sanity. Yes. > > And just

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

2011-05-16 Thread Christian Moe
On 5/16/11 2:20 PM, Carsten Dominik wrote: When the OP says he needs this for accounting, I guess he is exporting this data somehow? How about changing from dot to comma only in one of the export hooks? Ah... sanity. Yes. And just in time, too, as I was ready to unleash on Izzie the ultimate

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

2011-05-16 Thread Carsten Dominik
On May 16, 2011, at 1:26 PM, Christian Moe wrote: > Hi, > > This seems to be a limitation in Emacs Calc, on which Org table spreadsheet > functions are based. Calc accepts only the dot as decimal point for number > *entry*. However, you can have it *display* the point as you like by > customi

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

2011-05-16 Thread Christian Moe
Hi, This seems to be a limitation in Emacs Calc, on which Org table spreadsheet functions are based. Calc accepts only the dot as decimal point for number *entry*. However, you can have it *display* the point as you like by customizing calc-point-char (that's `d .' in a Calc buffer). In Org

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

2011-05-16 Thread 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-s

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

2011-05-15 Thread Izzie
Hi, 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 f