Number format and data sorting (e.g. years) in the xls download

[sosiology]

Currently the data downloaded in xls

• are not sorted as in the graph (e.g. the years are not sorted chronologically)
• have a "standard" format. The user has to reformat them if he wants to make a graph in excel.

When downloading, the order of data and Data Format must be kept. In particular, numbers must be exported as number.

[sosiology]

Tested with this chart: https://test.visualize.admin.ch/v/eaJr-s6bZOv6?dataSource=Int

• CSV sorted by date
• Excel Sorted by date
• In Excel the values appear with a green notification indicating the number is stored as text
  • This issue can be solved by double clicking in the cell or selecting all values and using the excel prompt to convert values to numbers

[bprusinowski]

Hi @sosiology, thanks for testing!

The current approach is to keep dates as strings, even when their resolution equals Year. We can change this to convert dates to strings only when they're not yearly dates – let me know what you think about this.

For the Hierarchie dimension, we can't really do a lot, as it's marked as NominalDimension, without a numerical data type (it's simply marked as string dimension in Cube Creator) – so it appears as number in the export, but technically shouldn't be treated like one, at least according to the metadata 👀

[sosiology]

@bprusinowski tested by BAFU and approved 🎉

[bprusinowski]

Nice! 🎉