Project

General

Profile

Actions

Patch #37621

open

Field separator in CSV export options

Added by Karel Pičman about 1 year ago. Updated 11 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Text formatting
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

I would like to add a field separator option to the CVS export option form.

Background:

If I have set the language e.g. to English in my Redmine profile, the separator is taken from config/locales/en.yml (general_csv_separator) and it is comma. If I have installed e.g. German Microsoft Office and try to open such a CSV, it expects that the separator is semicolon. Unfortunately, Microsoft Office doesn't offer to choose the separator prior opening a CSV file and always uses the default value.

It is also related to #37581, where many translations have set general_csv_separator to different value than is expected in Microsoft Office.


Files

Actions #1

Updated by Go MAEDA about 1 year ago

Is the ability to select decimal separator unnecessary?

I think you need to change the decimal separator to ";" when you change the field separator to ",".

Actions #2

Updated by Karel Pičman about 1 year ago

No, you needn't. When the decimal separator is comma, values containing comma are enclosed in apostrophes.

...2022-09-12,"","2,50","2,50",0,2022-09-12 07:37...

Actions #3

Updated by Go MAEDA 11 months ago

  • Target version set to Candidate for next major release
Actions #4

Updated by Go MAEDA 11 months ago

  • Target version changed from Candidate for next major release to 5.1.0

Setting the target version to 5.1.0.

Actions

Also available in: Atom PDF