changed: headcount no longer holds manager changes
The original reporting which uses the headcount is outdated, while any
future use of it or a recreation will demand a change. The use of not
changing managers was specific to that report.
Signed-off-by: savoy <git@liberation.red>
bug: hide Excel alerts to not crash with xlwings
Signed-off-by: savoy <git@liberation.red>
bug: added a new date column that takes precedence over the default dateId
Signed-off-by: savoy <git@liberation.red>
feature: sheets cleared prior to data insertion
The range of potentially pre-existing data already present in a sheet is
now cleared of both its values as well as its formatting. The onus will
be on the template creator therefore to create robust and effective
templates that don't rely on static ranges for formatting, but dynamic.
Signed-off-by: savoy <git@liberation.red>
poetry: dependency updates
Most importantly xlwings jumping from 0.24 to 0.26.2 for the
xw.Sheet.clear_formats() method.
Signed-off-by: savoy <git@liberation.red>
feature: custom structures added to config pivots
In order to make report configurations more flexible, pivot tables can
now be designated to specific Excel sheets and cells as well as be
"adhoc" formatted. The criteria for having a template file has been
further decoupled from "adhoc" vs "configured" reporting as well, where
reports with templates can have auto-formatted sheets and
user-configured sheet structures.
In addition, checking for existing templates is more robust than before
and un-needed sheets are removed prior to saving.
Signed-off-by: savoy <git@liberation.red>
bug: raw data wasn't being included when specified
For reports that don't rely on compile methods, the ordering for the
DataStructure wasn't correct and the raw data wasn't being included in
the final data. Raw data wasn't also an option for reports with compile
methods.
Signed-off-by: savoy <git@liberation.red>
feature: no more manual formatting switch
The sole check for whether or not a report should be put through
automatic formatting is decided if there exists a template for the
report. If there doesn't, it'll be formatted.
Signed-off-by: savoy <git@liberation.red>
feature: pivot and inclue_data override in pull
Allows full control of compilation steps if running a configuration from
reports.yaml.
Signed-off-by: savoy <git@liberation.red>