← Back to team overview

dhis2-users team mailing list archive

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