7.22.1005

Navigation:  7.22 (QDV 2022) >

7.22.1005

Previous pageReturn to chapter overviewNext page

Released on October 14, 2022

Change: QDVTools4XL Distribution – spaces in items

The distribution module in the Tools for Excel now accepts that an item of the WBS has space(s) in its caption. For example, ‘A.    1.    3’ is now permitted.

Bug Fix: NUM2WORDS didn’t work fine without units

The function NUM2WORDS which can be used in almost any QDV spreadsheets was designed to be used with units, like: =NUM2WORDS(D3;"EN";"Euro";"Euros";"Cent";"Cents"). It works fine with this syntax. But we noticed that some users take this function without units, like: =NUM2WORDS(D7;"EN").

When we did this, we simply didn’t get the units in the resulting text, so “One hundred twenty euros and two cents” became “One hundred twenty and two” which is wrong. It has been fixed so that when you don’t use unit it returns correct string: “One hundred twenty point zero two”

This has been fixed for all supported NUM2WORDS languages: English, French, Dutch and Italian.

Bug Fix: Gantt assignation from the minutes could fail

Depending on the layout of the columns in the Gantt diagram, the assignation of a Gantt task to a row of the minutes could fail.