Navigation:  7.19 > 7.19.0739

Released on March 26, 2020

Bug Fix: Legends altered in charts on exchange with Excel

Because we have to use XLS format instead of XLSX to exchange with Excel and keep controls available (XLSX format of control is not in the public domain yet), some problems may occur on features not supported by XLS.

When you exchange a chart with Excel doing a 'Edit under Excel' you may get corrupted legends as shown below:

This is because XLS format allows legends anywhere in a chart and don't memorize fixed positions while under QDV, we need fixed position among Top, Left, Bottom, Right or Top-Right.

Now QDV analyses how close the legend is to a border and choose one of these positions accordingly.

The fixing function is also invoked when doing a 'Check and Repaint' operation so that existing estimates with this error can be fixed.