~savoy/ade

added: fill NaN values with 0.00 prior

Signed-off-by: savoy <git@liberation.red>
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>
poetry: dependency updates

Signed-off-by: savoy <git@liberation.red>
bug: hide Excel alerts to not crash with xlwings

Signed-off-by: savoy <git@liberation.red>
version bump

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>
bug: accounting calendar has been modified

Signed-off-by: savoy <git@liberation.red>
version bump

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: pivot formatting compatible with None subs

Signed-off-by: savoy <git@liberation.red>
version bump

Signed-off-by: savoy <git@liberation.red>
bug: correct pivot formatting if zero columns

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>
bug: incorrect handling of pivot type [None]

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>
bug: override for formatting works in GUI

Signed-off-by: savoy <git@liberation.red>
version bump

Signed-off-by: savoy <git@liberation.red>
Next