Excel export of entity with single values and indexed values

[PiispaH]

Currently in the 0.8-dev branch, if an entity has parameter values that are single valued like integers and other parameter values that are indexed like time-series values, the database gets exported correctly in a sense that the parameter values are split into two distinct sheets, one for the single values and another one for the indexed values. However the values are duplicated so that in the indexed values -sheet there can be a lot of information that already exists in the single value -sheet. And on the other hand the single value -sheet shows just the type of the indexed value, which is of no use.

[jkiviluo]

Does someone need this right now? I would push this forward a bit unless there is a current need.

[PiispaH]

Probably not, these exports have been broken for quite a while in 0.7 also and no one has complained.

[soininen]

Just a hint for whoever will eventually tackle this: the Excel export is based on the export mappings in spinedb_api, and it is possible to filter out values that end on a specific sheet by value type. So the mappings that export to single value sheet should filter out non-single values while the indexed value sheet mappings should filter out single values.