kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » COM Scripting » kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted

Page 1 of 1

1

Topic Options

#205017 - 2012-04-29 02:13 PM kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	Shawn, Guys, whazzup with that .. In a GridView in kf.classic, when I insert ie. 29.04.2012 (a common date format around where I do come from) into a cell and hit enter it converts the text to 29042012 Totally inacceptable behavior, and the project is due tomorrow Anyone knows how to workaround this without having to to insert leading chars? Seems to be a bug, if I ever saw one in kf.classic _________________________
Top

#205019 - 2012-04-29 05:41 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	can you give me a snippet I can play around with? _________________________ ! download KiXnet
Top

#205021 - 2012-04-29 06:02 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Lonkero]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	tricky .. but you may just use grid.kix by Shawn .. not a snippet though Attachments grid.kix (650 downloads) Description: _________________________
Top

#205022 - 2012-04-29 07:15 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	well, I tried with that and what you say doesn't happen. _________________________ ! download KiXnet
Top

#205023 - 2012-04-29 07:20 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Lonkero]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	hmmm .. thats weird. could it be a local setting on my notebook interfering with the Grid View ?!?! _________________________
Top

#205024 - 2012-04-29 07:22 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	seems to be not only date but generally integers followed by a dot. Input: 0,34 Cell Value = 0,34 Input: 0.34 Cell Value = 34 _________________________
Top

#205025 - 2012-04-29 07:25 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	$GridView.CurrentColumn.CellType from his code: $GridView.CurrentColumn.ValueType = 3 $GridView.CurrentColumn.ValueType = 5 $GridView.CurrentColumn.ValueType = 6 $GridView.CurrentColumn.ValueType = 7 $GridView.CurrentColumn.ValueType = 8 $GridView.CurrentColumn.ValueType = 11 $GridView.CurrentColumn.ValueType = 12 12 (type variant, a.k.a any type) being in grid.kix the default and it seems to work fine. you changed that? _________________________ ! download KiXnet
Top

#205026 - 2012-04-29 07:26 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Lonkero]
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	oh, and instead of going for cell value, have you tried cell.text? _________________________ ! download KiXnet
Top

#205027 - 2012-04-29 07:30 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Lonkero]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	yeah, Text is my way of choice .. searching for ValueType right now. Maybe explicitly set that? _________________________
Top

#205028 - 2012-04-29 07:43 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	Thanx a Bunch Jooel.. $GridView_Edit.CurrentColumn.ValueType = 8 ;String did the trick .. Nice! _________________________
Top

#205031 - 2012-04-29 09:16 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Jochen]
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	$\:\)$ and "bug" resolved :P once again, kinda miss Shawn. _________________________ ! download KiXnet
Top

#205037 - 2012-04-29 11:25 PM Re: kf.Classic GridView Cell behavior when datestring (29.04.2012) is inserted [Re: Lonkero]
Jochen Jochen KiX Supporter Registered: 2000-03-17 Posts: 6380 Loc: Stuttgart, Germany	true dat! me missing old fart too .. not the first time I mistaken my own incapability for a bug _________________________
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart

Hop to:

Shout Box

Who's Online

0 registered and 739 anonymous users online.

Newest Members

M_Moore, BeeEm, min_seow, Audio, Hoschi
17883 Registered Users

Generated in 0.063 seconds in which 0.026 seconds were spent on a total of 14 queries. Zlib compression enabled.

click tracking