dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #10168
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
Hi there,
many thanks for all the feedback and the votes.
The feedback clearly tells that there are multiple needs / views out there,
and that having this configurable per system is desired. So we will turn
this into a system setting for 2.24.
Issues:
https://github.com/dhis2/settings-app/issues/62
https://github.com/dhis2/dhis2-pivot/issues/5
Thanks again for the feedback.
regards,
Lars
On Wed, May 4, 2016 at 11:47 AM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
> I *think* we discuss the space separator business purely related to
> display. So when exporting to excel, or any other case where the
> number is expected to be consumed as a number (including storage in
> the database), exported via api in json/xml datavalueset etc there
> should be no spaces, commas etc. Confusion on this would be a recipe
> for disaster.
>
> Everyone seems to agree that how numbers display should be
> configurable. Though I thought the question was more what would be
> the default appearance in the absence of any configuration. In which
> case there are only two approaches: (i) pick something, in which case
> space seems to be the most standard default, or (ii) infer something
> based on the locale.
>
> On 4 May 2016 at 09:56, Lars Helge Øverland <lars@xxxxxxxxx> wrote:
> > Hi all,
> >
> > many thanks for all the feedback. Will make this configurable per system
> > then given the all the various opinions.
> >
> >
> > Another point of clarification: It seems that space is a preferred
> separator
> > in the Web based pivot table. However, when downloading to Excel, it
> seems
> > space is useless as it makes Excel interpret the cell as text, not
> numbers.
> >
> > So as a short term solution (which could be back-ported) could be that
> when
> > downloading to Excel, the system could fall back to no separator when
> space
> > is selected as separator. This because space never seems useful for Excel
> > spreadsheets.
> >
> > Would that work?
> >
> >
> > regards,
> >
> > Lars
> >
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help : https://help.launchpad.net/ListHelp
> >
>
--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>
References
-
Digit group separator in pivot table - what should the default value be?
From: Lars Helge Øverland, 2016-05-03
-
Re: Digit group separator in pivot table - what should the default value be?
From: Prosper BT, 2016-05-03
-
Re: Digit group separator in pivot table - what should the default value be?
From: Jim Grace, 2016-05-03
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Ola Hodne Titlestad, 2016-05-03
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Hannan Khan, 2016-05-04
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: ramaso hasina, 2016-05-04
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Morten Olav Hansen, 2016-05-04
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Uwe Wahser, 2016-05-04
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Lars Helge Øverland, 2016-05-04
-
Re: [Dhis2-devs] Digit group separator in pivot table - what should the default value be?
From: Bob Jolliffe, 2016-05-04