Troubleshooting document describes known problems and solutions encountered during usage of qXL COM add-in.
Note:
Please use our google group or open a ticket in case you encounter any installation/startup problem which is not covered in this document.
It was observed that memory usage is constantly growing for Excel Workbooks which contain charts built dynamically based on the data from RTD formula. The increase in memory usage depends on the charts types and amount of data they require.
The issue is caused by the memory leak for Excel charts with external data source.
Using charts with RTD data is generally not recommended. Open again the Workbook to free the memory.
In case of calling qRTDClose function the subscription is properly closed and the RTD formulas stop updating. However, calling qRTDOpen with the same alias again does not result in subscribing for new values.
Calling qRTDOpen with different alias refreshes the connection and results in subscribing for new values.
In case of stopping the publishing q process to which Excel is subscribed the RTD formula values stop updating. Even after restrting the process the subscription is not automatically re-opened, values are not updating.
Calling qRTDOpen with different alias refreshes the connection and results in subscribing for new values.
#####Problem
Nested results (with more than two dimensions) are displayed differently in Excel in qQuery and qQueryResult formulas.
Whenever we try to display something different than q atom in single cell qQuery prints #VALUE error and qQueryRange
leaves the cell blank.
Please see the example below:
We query nested list which have atoms on all position except for the first element of the second row where there is another list.
qQuery displays nested result as #VALUE error in Excel as can be seen below:
qQueryRange displays nested result as empty cell as can be seen below:
To have the same display qQuery can be wrappred with IFERROR formula as can be seen below:
