Hi,
We are using your WPF PivotGridControl for a reporting application and we would like to use your Data Bar conditional formatting.
However, I have encountered a few issues when applying the DataBarFormatConditions that I hope you can help me with.
- With the Grid in asynchronous mode, if I apply a DataBarFormatCondition between BeginUpdate and EndUpdateAsync then it does not get applied. If I apply it after the EndUpdateAsync then it does get applied, but it freezes the UI (i.e. it is applied synchronously).
In the attached sample this is demonstrated - clicking the "Data Bar Format Fails" button applies the DataBarFormatCondition asynchronously and does not work, whereas clicking the "Data Bar Format Succeeds" button applies the DataBarFormatCondition synchronously and works as expected.
- When I have a DataBarFormatCondition applied and I update the field orientation, then I get a TargetInvocationException with the InnerException stating that "The calling thread cannot access this object because a different thread owns it."
In the attached sample this can be reproduced by clicking the "Data Bar Format Succeeds" button and then dragging the ID field into the Row Fields area.
- When I set the DataBarFormatCondition Type to "Expression" and the Value to another field, then the conditional formatting seems to ignore this and just take the value of the Measure Field.
In the attached sample this can be reproduced by clicking the "Data Bar Format With Expression Fails" button. I would expect if the expression was applied that the data bars for both Value and Scaled Value columns would be the same.
Please could you take a look and let me know whether there is any way around these issues, or whether I'm doing something wrong!
Thanks in advance,
Stuart
Updated sample including data file this time.
Hi Stuart ,
In order not to mix several problems in one thread, I have opened separate issues on your behalf:
TargetInvocationException is thrown when the field orientation is changed
Expression mode does not work properly with asynchronous mode
Please refer to these reports for further correspondence on this item.
I have reproduced the first issue and passed this thread to our developers for further research. We are going to update it as soon as possible.