I am using GetVisibleValues to provide a list of column names in the PivotGrid. Most of the time, this works fine, returning a list of my columns.
However, one of our reports has the possibility of a blank value , and a column is displayed with the totals of blank entries. However, this is not listed on the GetVisibleValues (or the related GetAvailableValues or GetUniqueValues). I can also not find an indicator on the CellInfo that says blanks are permitted or valid.
Is there a way of identifying whether blank entries are permissible and displayed? I can enhance the GetVisibleValues to include an extra blank value, but I only want to do this if it is displayed on the grid.
No responses from DevExpress folk? Disappointing.
Thank you for your patience, Steve. I have reproduced this behavior and passed it to our research team. Once we have any news, we will update this thread.
Thank you. It is the final problem I am trying to sort, so is really frustrating to be stuck on it!
I see, Steve. We are going to examine this behavior to help you.
Nudge? Any progress?
This issue is not resolved yet, and I cannot provide you with any estimation. Please let us know if this issue is critical for you. In this case, we will try to process it with higher priority.
In addition, would you please clarify your task in greater detail? We will check whether it is possible to accomplish it in a different way now.
It is not critical, but it will impact a release - we may have to release with reduced functionality.
I am trying to export a grid to excel, because the built-in export does not provide some of the facilities that we need on the exported grid. This has - with some much-appreciated help - been very successful so far, but one report we produce does have this issue.
Thank you for the clarification. Would you please specify which facilities you want to implemented in exported pivot grid?
The requirement that started it was to have one grid column present in one spreadsheet column, something which was raised with you, and I was told was not possible to do with the existing code.
As I understand, at present you generate a report manually by data shown in the pivot grid. If so, I suggest you iterate through cells and use the PivotGridControl.GetCellInfo Method to get information about processed cells. To get corresponding column and row field values, it is possible to use the PivotCellBaseEventArgs.GetFieldValue Method.
Does this solution help?
That is the method I am using, in broad terms. But I still need to get a list of displayed values for the Column fields, for which I am using GetVisibleValues. I need this to identify the list of columns.
Thank you for the clarification.