Grid cell with date time editor and renderer

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Grid cell with date time editor and renderer

steve
Hi,

I need a custom wx.grid cell editor and renderer which will accept only datetime values and represent them in date time format. Is there such a cus to editor and renderer?

Best Regards

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Grid cell with date time editor and renderer

Robin Dunn
On Wednesday, July 3, 2019 at 8:32:18 AM UTC-7, steve wrote:
Hi,

I need a custom wx.grid cell editor and renderer which will accept only datetime values and represent them in date time format. Is there such a cus to editor and renderer?



There's a renderer class that uses wx.DateTime values, I'm not sure why there isn't an editor class for it.  See GridCellDateTimeRenderer in the docs.  If you want to deal with Python datetime objects instead then you need to create your own.

--
Robin

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/wxpython-users/7248bc0d-060c-4729-958d-82304e9f8d6d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

RE: Grid cell with date time editor and renderer

GadgetSteve
In reply to this post by steve
https://docs.wxpython.org/wx.grid.GridCellDateTimeRenderer.html?highlight=gridcelldatetimerenderer should do the job!

-----Original Message-----
From: [hidden email] <[hidden email]> On Behalf Of steve
Sent: 03 July 2019 16:32
To: wxPython-users <[hidden email]>
Subject: [wxPython-users] Grid cell with date time editor and renderer

Hi,

I need a custom wx.grid cell editor and renderer which will accept only datetime values and represent them in date time format. Is there such a cus to editor and renderer?

Best Regards

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/wxpython-users/VI1PR03MB44794433213E6419ECEC2BCF9BFA0%40VI1PR03MB4479.eurprd03.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Grid cell with date time editor and renderer

steve
Hi,

I wrote the following custom editor, it should pop up a wx.adv.DatePickerCtrl object when double clicking the gird cell,  but I get "AttributeError: 'MyCellEditor' object has no attribute '_tc'" error. Coudld you please help?



renderer = MyCellEditor()
attr = wx.grid.GridCellAttr()
attr.SetEditor(renderer)
self.My_grid.SetColAttr(1, attr)


#!/usr/bin/env python

import string

import wx
import wx.grid as gridlib
from datetime import datetime, timedelta
from utilities.functions import *
import sys

#---------------------------------------------------------------------------
class MyCellEditor(gridlib.GridCellEditor):
"""
This is a sample GridCellEditor that shows you how to make your own custom
grid editors. All the methods that can be overridden are shown here. The
ones that must be overridden are marked with "*Must Override*" in the
docstring.
"""
def __init__(self):
self.log = sys.stdout
self.log.write("MyCellEditor ctor\n")
gridlib.GridCellEditor.__init__(self)


def Create(self, parent, id, evtHandler):
"""
Called to create the control, which must derive from wx.Control.
*Must Override*
"""
print("created ctrl")
self.log.write("MyCellEditor: Create\n")
self._tc = wx.adv.DatePickerCtrl(self, size=(120,-1),style=wx.adv.DP_DROPDOWN|wx.adv.DP_SHOWCENTURY)
today = datetime.now()
today = datetime(today.year, today.month, today.day)
self._tc.SetValue(datetime_to_wxdate(today))
self.SetControl(self._tc)

if evtHandler:
self._tc.PushEventHandler(evtHandler)


def SetSize(self, rect):
"""
Called to position/size the edit control within the cell rectangle.
If you don't fill the cell (the rect) then be sure to override
PaintBackground and do something meaningful there.
"""
self.log.write("MyCellEditor: SetSize %s\n" % rect)
self._tc.SetSize(rect.x, rect.y, rect.width+2, rect.height+2,
wx.SIZE_ALLOW_MINUS_ONE)


def Show(self, show, attr):
"""
Show or hide the edit control. You can use the attr (if not None)
to set colours or fonts for the control.
"""
self.log.write("MyCellEditor: Show(self, %s, %s)\n" % (show, attr))
super(MyCellEditor, self).Show(show, attr)


def PaintBackground(self, rect, attr):
"""
Draws the part of the cell not occupied by the edit control. The
base class version just fills it with background colour from the
attribute. In this class the edit control fills the whole cell so
don't do anything at all in order to reduce flicker.
"""
self.log.write("MyCellEditor: PaintBackground\n")


def BeginEdit(self, row, col, grid):
"""
Fetch the value from the table and prepare the edit control
to begin editing. Set the focus to the edit control.
*Must Override*
"""
self.log.write("MyCellEditor: BeginEdit (%d,%d)\n" % (row, col))
self.startValue = grid.GetTable().GetValue(row, col)
try:
tmpDate = wx.DateTime()
tmpDate.ParseFormat(self.startValue, "%d-%b-%y")
self._tc.SetValue(tmpDate)
self._tc.SetFocus()
except:
today = datetime.now()
today = datetime(today.year, today.month, today.day)
self._tc.SetValue(datetime_to_wxdate(today))
self._tc.SetFocus()


# For this example, select the text
# self._tc.SetSelection(0, self._tc.GetLastPosition())


def EndEdit(self, row, col, grid, oldVal):
"""
End editing the cell. This function must check if the current
value of the editing control is valid and different from the
original value (available as oldval in its string form.) If
it has not changed then simply return None, otherwise return
the value in its string form.
*Must Override*
"""
self.log.write("MyCellEditor: EndEdit (%s)\n" % oldVal)
val = self._tc.GetValue()
val_datetime = wxdate_to_datetime3(val)
val_str = val_datetime.strftime("%d-%b-%y")
if val != oldVal: #self.startValue:
return val
else:
return None


def ApplyEdit(self, row, col, grid):
"""
This function should save the value of the control into the
grid or grid table. It is called only after EndEdit() returns
a non-None value.
*Must Override*
"""
self.log.write("MyCellEditor: ApplyEdit (%d,%d)\n" % (row, col))
val = self._tc.GetValue()
val_datetime = wxdate_to_datetime3(val)
val_str = val_datetime.strftime("%d-%b-%y")
grid.GetTable().SetValue(row, col, val_str) # update the table

self.startValue = ''
today = datetime.now()
today = datetime(today.year, today.month, today.day)
self._tc.SetValue(datetime_to_wxdate(today))


def Reset(self):
"""
Reset the value in the control back to its starting value.
*Must Override*
"""
self.log.write("MyCellEditor: Reset\n")
if self.startValue == "":
today = datetime.now()
today = datetime(today.year, today.month, today.day)
self._tc.SetValue(datetime_to_wxdate(today))
else:
try:
tmpDate = wx.DateTime()
tmpDate.ParseFormat(self.startValue, "%d-%b-%y")
self._tc.SetValue(tmpDate)
except:
today = datetime.now()
today = datetime(today.year, today.month, today.day)
self._tc.SetValue(datetime_to_wxdate(today))



def IsAcceptedKey(self, evt):
"""
Return True to allow the given key to start editing: the base class
version only checks that the event has no modifiers. F2 is special
and will always start the editor.
"""
self.log.write("MyCellEditor: IsAcceptedKey: %d\n" % (evt.GetKeyCode()))

## We can ask the base class to do it
#return super(MyCellEditor, self).IsAcceptedKey(evt)

# or do it ourselves
return (not (evt.ControlDown() or evt.AltDown()) and
evt.GetKeyCode() != wx.WXK_SHIFT)


def StartingKey(self, evt):
"""
If the editor is enabled by pressing keys on the grid, this will be
called to let the editor do something about that first key if desired.
"""
self.log.write("MyCellEditor: StartingKey %d\n" % evt.GetKeyCode())
# key = evt.GetKeyCode()
# ch = None
# if key in [ wx.WXK_NUMPAD0, wx.WXK_NUMPAD1, wx.WXK_NUMPAD2, wx.WXK_NUMPAD3,
# wx.WXK_NUMPAD4, wx.WXK_NUMPAD5, wx.WXK_NUMPAD6, wx.WXK_NUMPAD7,
# wx.WXK_NUMPAD8, wx.WXK_NUMPAD9
# ]:
#
# ch = ch = chr(ord('0') + key - wx.WXK_NUMPAD0)
#
# elif key < 256 and key >= 0 and chr(key) in string.printable:
# ch = chr(key)
#
# if ch is not None:
# # For this example, replace the text. Normally we would append it.
# #self._tc.AppendText(ch)
# self._tc.SetValue(ch)
# self._tc.SetInsertionPointEnd()
# else:
# evt.Skip()
evt.Skip()


def StartingClick(self):
"""
If the editor is enabled by clicking on the cell, this method will be
called to allow the editor to simulate the click on the control if
needed.
"""
self.log.write("MyCellEditor: StartingClick\n")


def Destroy(self):
"""final cleanup"""
self.log.write("MyCellEditor: Destroy\n")
super(MyCellEditor, self).Destroy()


def Clone(self):
"""
Create a new object which is the copy of this one
*Must Override*
"""
self.log.write("MyCellEditor: Clone\n")
return MyCellEditor()














On Thursday, July 4, 2019 at 8:05:14 AM UTC+3, Gadget Steve wrote:
<a href="https://docs.wxpython.org/wx.grid.GridCellDateTimeRenderer.html?highlight=gridcelldatetimerenderer" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdocs.wxpython.org%2Fwx.grid.GridCellDateTimeRenderer.html%3Fhighlight%3Dgridcelldatetimerenderer\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHERbldTn3a-ZrvzRV03syf0MnJ-A&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdocs.wxpython.org%2Fwx.grid.GridCellDateTimeRenderer.html%3Fhighlight%3Dgridcelldatetimerenderer\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHERbldTn3a-ZrvzRV03syf0MnJ-A&#39;;return true;">https://docs.wxpython.org/wx.grid.GridCellDateTimeRenderer.html?highlight=gridcelldatetimerenderer should do the job!

-----Original Message-----
From: <a href="javascript:" target="_blank" gdf-obfuscated-mailto="QocsJw_UBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">wxpytho...@googlegroups.com <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="QocsJw_UBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">wxpytho...@googlegroups.com> On Behalf Of steve
Sent: 03 July 2019 16:32
To: wxPython-users <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="QocsJw_UBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">wxpytho...@googlegroups.com>
Subject: [wxPython-users] Grid cell with date time editor and renderer

Hi,

I need a custom wx.grid cell editor and renderer which will accept only datetime values and represent them in date time format. Is there such a cus to editor and renderer?

Best Regards

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="QocsJw_UBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">wxpytho...@googlegroups.com.
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com&#39;;return true;">https://groups.google.com/d/msgid/wxpython-users/3f2c44cf-dd44-4fc5-95ae-9dde37e3ffd6%40googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "wxPython-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/wxpython-users/e4b16b93-2fd9-42a5-9e10-7395b214876b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.