Enhance the layout of the flags and footnotes in the exported Excel file
To be done together with #895 (closed)
As Eléonore,
I want to have all the information from the [Table] and [Flags & Footnotes] sheets in a single view and to delete the Sheet [Sheet1] which is empty and does not bring any added value,
So that users can easier understand the Excel export file content.
Functional specifications
Instead of writing the flags and footnotes into a separate sheet with the same table structure, write them directly in the data table with a similar look and feel of the web table using:
- a custom cell number format to display the flag and/or star
*
- a cell comment to display the full flag and/or footnote text on mouse-over
Also:
- remove the empty "Sheet1" sheet
- remove the obsolete "Flags & footnotes" sheet
This should also solve ticket #895 (closed).
Examples
- https://de-qa.siscc.org/vis?fs%5b0%5d=Topic%2C1%7CEnvironment%23ENV%23%7CWaste%23ENV_WAS%23&pg=0&fc=Topic&snb=1&vw=tb&df%5bds%5d=ds%3Aqa%3Astable&df%5bid%5d=AIR_EMISSIONS_DF&df%5bag%5d=OECD&df%5bvs%5d=1.0&pd=2017%2C2017&dq=AUS%2BAUT%2BBEL.SOX%2BNOX.TOT
- https://de-qa.siscc.org/vis?fs[0]=datasourceId%2Cds%3Aqa%3Astable&pg=0&fc=datasourceId&snb=43&df[ds]=ds%3Aqa%3Astable&df[id]=SNA_TABLE1&df[ag]=OECD&df[vs]=1.0&pd=2018%2C2020&dq=..&vw=tb
- COMMENTS_EXAMPLE.xlsx
Technical notes
-
The custom cell number format can already be applied today using the xlsx-populate cell numberFormat property:
cell.style("numberFormat", "(\E,\*) #,##0.000");
The custom format needs to be preceded by the corresponding flag characters and the footnote star
*
, which have to be escaped with backslash and separated by comma. -
The cell comment feature is currently not available in xlsx-populate and needs to be implemented. The complete specification is in the related ticket comment: https://github.com/dtjohnson/xlsx-populate/issues/116#issuecomment-1242318645 If implemented as spec'd then the comment box size (width and height) can be set by the calling application. We suggest to use width=400pt and height=50pt. The required (generic) comment author should be configurable and by default be the configured name of the DE application.