Released on February 25, 2022

Bug fix: QDVTools4XL – Ribbon was not set according to Excel’s option

In Excel, the user can discard the Welcome Screen at startup. In this case, he will directly open a new workbook each time he starts Excel. In this situation, the ribbon was incorrectly set. Fixed.

New: Qdv Long path support has been enabled (full paths exceed 260 characters)

According to Microsoft documentation, net 4.8 supports long paths by default, however it has been identified that Windows setting longPathAware is needed for proper long path support in Qdv so it has been added to application manifest of Qdv, Qdv Converter and Qdv Management tools to support paths longer than 260 characters.

New: Enable Long Paths in Windows 10, Version 1607, and Later

Starting in Windows 10, version 1607 - released on August 2, 2016, MAX_PATH limitations have been removed from common Win32 file and directory functions. However, you must opt-in to the new behavior.

To enable the new long path behavior, both of the following conditions must be met:

The registry key Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem\LongPathsEnabled (Type: REG_DWORD) must exist and be set to 1. The key's value will be cached by the system (per process) after the first call to an affected Win32 file or directory function (see below for the list of functions). The registry key will not be reloaded during the lifetime of the process. In order for all apps on the system to recognize the value of the key, a reboot might be required because some processes may have started before the key was set.

You can also copy this code to a .reg file which can set this for you, or use the PowerShell command from a terminal window with elevated privileges:

New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Control\FileSystem" -Name "LongPathsEnabled" -Value 1 -PropertyType DWORD -Force

This registry key can also be controlled via Group Policy at Computer Configuration > Administrative Templates > System > Filesystem > Enable Win32 long paths.

The application manifest must also include the longPathAware element.

<ws2:longPathAware>true</ws2:longPathAware>

</windowsSettings>

</application>

Change: QDVTools4XL Gantt – Copy Paste to import free tasks

When editing the free tasks of a Gantt, the copy paste operation is less automated and more user-driven. For each column of the copied area (till 4), user can chose in which column it will be pasted. The Gantt will be refreshed after each edition of the free tasks.

Change: QDVTools4XL Gantt – Sheet protection