Sorting/Copying

[TSchulz85]

First of all, this project is excellent, thanks a lot! I really like it.
Two things (which are probably more or less specific to my setup).

1. The sorting function doesn't work (it seems that it has sorted in the background, but doesn't display the content. But when I click on a line, that line will be updated with the sorted values)

2. Copying doesn't work, I receive the following error message:

Traceback (most recent call last):

File "c:\temp\dfgui\dfgui\dfgui.py", line 230, in _on_right_click
unit_x, unit_y = self.GetMainWindow().GetScrollPixelsPerUnit()

AttributeError: 'ListCtrlDataFrame' object has no attribute 'GetScrollPixelsPerUnit'

Do you have any suggestion what the problem could be?
When I start dfgui.show(df), I receive the following error, not sure if it might be connected to this.

Thanks,
Tobias

[bluenote10]

Very difficult to say, because I'm not a Windows user. But yes, both issues could be related to this warning. Did you find anything on Google for that message? What are your Python and wxpython versions?

The first issue could also be related to the kind of data you are using. Maybe you can come up with a minimal example based on some toy data which reproduces the problem.

[jperkins909]

windows user here, confirming sorting doesn't work. handy tool . would be perfect with ability to live update via updating csv and sort

[surferran]

hello
great GUI. wanted to say that as well :) thanks for the publication !

i noticed the problem of not refreshing the table view also. and i see it is not my problem alone ..

but i have a solution that worked for me :
just add 'self.Refresh()' in the last line for the function ' _on_col_click' .

i.e:
`
def _on_col_click(self, event):
....
....
# delete temporary column
del self.df[self.TMP_SELECTION_COLUMN]

    self.Refresh()

`
Regards.

[jibweb]

I was having the same issue but on Ubuntu, with python 2.7.12 and wx 3.0. Took me forever, but I ended up changing the _on_right_click method of ListCtrlDataFrame as follow:

232             scroll_range = self.GetScrollRange(wx.HORIZONTAL)
233             # this is crucial step to get the scroll pixel units
234             #unit_x, unit_y = self.GetMainWindow().GetScrollPixelsPerUnit()
235 
236             #col = bisect(col_locs, x + scroll_pos * unit_x) - 1
237             col = bisect(col_locs, x + 1.*scroll_pos/scroll_range*loc) - 1

In a few words, instead of transforming the scroll_pos in pixels to check, we know the length of all columns in pixels, and we know both the position of the scrollbar and the length of the scrollbar in "scroll units", so taking the ratio gives the same result without using the GetScrollPixelsPerUnit method