Navigation:  7.22 (QDV 2022) > 7.22.0997

Released on September 19, 2022

Bug fix: Some operations with the minutes data in macros were wrong in some cases

The problem occurred if the database of the estimate was activated and some row in the minutes pointed to a set in the database (via ReferenceToInternalArticle field). All sub-items of such a set are displayed in Minutes and their LineNumber field is empty. Let's call them "fake" rows.

In the QDV API (macros), the following methods behaved incorrectly in such a case:

oIMinute.GetFullData included the "fake" rows in the result but instead of the special value 100000, they had normal LineNumber. If there were some normal rows after them, their LineNumber were increased accordingly, which was wrong. Now all the "fake" rows have LineNumber=100000 and normal rows have the correct LineNumber.

oIMinute.GetFieldValue could return the value from a different row since the LineNumber were incorrect as described above.

oFor the same reason, IMinute.UpdateValuesConditionally method could update incorrect rows.

All other IMinute methods worked fine, such as GetFieldsValues, SetFieldsValues, etc.

Bug fix: QDVTools4XL Gantt – Contextual menu are restored

For security reasons, the contextual menus that show or hide rows and columns are hidden. This persists after closing Excel. Now, these menus are restored when closing the Gantt workbook or when exiting Excel. If these menus are hidden, it is enough to restart Excel to recover them.

Bug fix: QDVTools4XL Distribution– Some parameters could not be reset

In the task pane of the distribution application, the ‘computed total’ and ‘Row removal criteria’ parameters could not be removed. Fixed.

Bug fix: QDVTools4XL– Avoid an error with cloud files (Onedrive, …)

Some users work with cloud files that do not have a local copy. In this case, finding the associated estimate (for pricing, distribution, …) is not always possible. Instead of leading to an exception, a message is now shown.

New: QDVTools4XL Gantt – Linear Distribution mode preset

In the task pane, the user can now preset the Linear Distribution mode by default. If it is enabled, inserting a new article or a new set in the resources of a Gantt sheet will automatically activate this mode for the new lines.

New: Estimate Converter – Option – ‘Move to bottom’ mapping column

There is new ‘Option – Move to bottom’ mapping column:

for estimate Option – Move to bottom property:

This new column is used only when also ‘Is Option’ column is mapped and has value 1. When branch is an Option, all children inherit both Option and Move to bottom properties.

Bug Fix: Error in “CalculateSumOfRefs” fixed.

In some rare configurations, the error message “Error in Calculate Sum Of References” could pop up.