Posted 8 September 2017, 12:45 pm EST
I have a spread bound to a DataView containing 3 columns, SortHeight, SortHeight2 and SortRow. The DataView is popuplated by parsing a text file. To get the initial order correct, it is sorted by SortHeight DESC, SortHeight2 DESc and SortRow. This is all working properly.
Once the DataView is loaded, the sort property is changed to SortRow. However, the spread still displays in the original order until the user clicks in the spread somewhere, at which time it then reorders itself correctly. For example, it will display with SortRow = 1, 2, 0 in the spread.
How can I force the spread to show correctly from the beginning? I have tried Refresh, setting the DataSource to Nothing and then resetting the DataSource to the DataView and nothing helps. Thanks in advance for any ideas and/or suggestions!