Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-09 Thread Uwe Brauer
> Uwe Brauer writes: > Ah well, this was a basis to get you started... This one > should work > (defun my-format-timestamps (cell) > (org-quote-csv-field > (replace-regexp-in-string > org-ts-regexp-both (lambda (m) > (format-time-string >

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-09 Thread Uwe Brauer
> Uwe Brauer writes: > Ah well, this was a basis to get you started... This one should work > (defun my-format-timestamps (cell) > (org-quote-csv-field > (replace-regexp-in-string > org-ts-regexp-both > (lambda (m) > (format-time-st

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Uwe Brauer writes: > > Uwe Brauer writes: > > > You don't need to. These are only suggestions, the final format needs > > not matching any item in this list. > > > > Not really. See `org-table-export' docstring, last paragraph. > > > > You could try (untested): > > >

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Uwe Brauer writes: > You don't need to. These are only suggestions, the final format needs > not matching any item in this list. > Not really. See `org-table-export' docstring, last paragraph. > You could try (untested): > (defun my-format-timestamps (cell)

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Uwe Brauer writes: > You don't need to. These are only suggestions, the final format needs > not matching any item in this list. > Not really. See `org-table-export' docstring, last paragraph. > You could try (untested): > (defun my-format-timestamps (cell)

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Uwe Brauer writes: > > Uwe Brauer writes: > > > I have no trouble calling M-x org-table-export RET then choosing a file > > name and forcing my-tbl-to-csv during prompt. > > Hm I had to copy org-export-table into my addons file and > (let* ((formats '("my-tbl-to-csv" "orgtbl-to

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Uwe Brauer writes: > I have no trouble calling M-x org-table-export RET then choosing a file > name and forcing my-tbl-to-csv during prompt. Hm I had to copy org-export-table into my addons file and (let* ((formats '("my-tbl-to-csv" "orgtbl-to-csv" "orgtbl-to-tsv" "orgtb

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Uwe Brauer writes: >> Uwe Brauer writes: > >> Use `my-tbl-to-csv' as a replacement for `orgtbl-to-csv'. How did you > that is what I thought. > > So I called org-table-export > but then the prompt did not allow my to specify my-tbl-to-csv > so I customized (customize-option (quote org-ta

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Uwe Brauer writes: > Use `my-tbl-to-csv' as a replacement for `orgtbl-to-csv'. How did you that is what I thought. So I called org-table-export but then the prompt did not allow my to specify my-tbl-to-csv so I customized (customize-option (quote org-table-export-default-format)) to you

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Uwe Brauer writes: >> Uwe Brauer writes: > >> For example: > >> (defun my-format-timestamps (cell) >> (org-quote-csv-field >> (replace-regexp-in-string org-ts-regexp-both "\\1" cell))) > >> (defun my-tbl-to-csv (table params) >> (orgtbl-to-csv table >

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Uwe Brauer writes: > For example: > (defun my-format-timestamps (cell) > (org-quote-csv-field > (replace-regexp-in-string org-ts-regexp-both "\\1" cell))) > (defun my-tbl-to-csv (table params) > (orgtbl-to-csv table >(org-combine-p

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Uwe Brauer writes: >> Hello, >> Uwe Brauer writes: > > >> None. The export to CSV looks correct and complete. Conversion to CSV >> does not pretend converting anything else, in particular timestamps, to >> another format. > > Ok, > > Now how could that be achieved? I seem not

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Uwe Brauer
> Hello, > Uwe Brauer writes: > None. The export to CSV looks correct and complete. Conversion to CSV > does not pretend converting anything else, in particular timestamps, to > another format. Ok, Now how could that be achieved? I seem not the only one missing that a feature.

Re: [O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-08 Thread Nicolas Goaziou
Hello, Uwe Brauer writes: > Hi > > consider please > > | Entry | Date | > | 100 | <2018-01-07 Sun> | > > I first export this to csv > > > Entry,Date > 100,<2018-01-07 Sun> > > > > and then via gnumeric ssconvert or LO unoconv > to xlsx or ods, however the datestamp is not correctly conve

[O] org table with datestamp convert to csv and then xlsx or ods: problem

2018-01-07 Thread Uwe Brauer
Hi consider please | Entry | Date | | 100 | <2018-01-07 Sun> | I first export this to csv Entry,Date 100,<2018-01-07 Sun> and then via gnumeric ssconvert or LO unoconv to xlsx or ods, however the datestamp is not correctly converted to a datestamp understood my xlsx or unoconv. Is