This is a migrated thread and some comments may be shown as answers.

Date Filter Value Not Fully Visible in Edit Mode & Format Not Match Column's FormatString

8 Answers 109 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Tom Chien
Top achievements
Rank 1
Tom Chien asked on 30 Oct 2009, 05:16 PM
When editing the filter value on a Date column:

1. It cuts off the left part of the date regardless of how wide I make the Column.

2. It always requires editing in a "ToLongDateString" fromat (aka "D", aka "dddd, MMMM dd, yyyy") vs. (oh, I don't know, call me crazy, but maybe perhaps) the format specified by the user in your  "FormatString" Property of your "GridViewDataColumn" Class.  ;) This is: a) non-intuitive as it may not (and probably usually does not) match the format used in the data columns since the "D" format is rarely used especially in tables where horizontal space is at a premium, b) may be (and probably usually will be) too wide to fit in the Column (even if #1 is fixed) even when the Column is wide enough to fit the Data Row values which are probably usually in a much shorter format like "MM/dd/yy" or "MM/dd/yyyy" (at least for us weirdos in B.F.E. USA ;) anyway).

Telerik WinForms 2009Q3 Beta (2009.2.9.1016) / 2009Q2 (2009.2.9.729), VB, VS 2005 (v8.0.50727.762 SP.050727-7600), .Net 2.0 (2.0.50727), XP SP3, 3GB, 2.99GHZ, Core2Duo.

8 Answers, 1 is accepted

Sort by
0
Tom Chien
Top achievements
Rank 1
answered on 30 Oct 2009, 07:56 PM
Addendum to #1: It happens when editing the filter value only after a previous edit was done while the Date Column width was narrower than that needed to display the whole "dddd, MMMM dd, yyyy" which again like said, is probably going to be almost all the time due to the probable rare use of the long date format esp. in grids.
0
Jack
Telerik team
answered on 04 Nov 2009, 02:15 PM
Hello Tom,

We believe that this issue is addressed in our last version - Q3 2009 - which is right now on its way to be released. Please, could you confirm that the issue is addressed in Q3. If not, send us a sample application that reproduces it.

Thank you for this report and I am looking forward to your reply.

Best wishes,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Tom Chien
Top achievements
Rank 1
answered on 05 Nov 2009, 07:50 PM
1. It's fixed but only on the 2nd time I click on the Filter Row after expanding the Column Width long enough to show the whole Long Date Format..

2. You didn't say anything about my "feature request".

Telerik WinForms 2009Q3 (2009.3.9.1103), VB, VS 2005 (v8.0.50727.762 SP.050727-7600), .Net 2.0 (2.0.50727), XP SP3, 3GB, 2.99GHZ, Core2Duo.

0
Jack
Telerik team
answered on 06 Nov 2009, 01:30 PM
Hi Tom,

Regarding your questions:

1. I was not able to reproduce the issue. Please, could you send me a sample project or describe the exact steps to reproduce it?

2. Maybe, I didn't understand the issue. I thought that it was related to the first one. You can easily change the formatting used in the editor by changing DataEditFormatString property of GridViewDateTimeColumn.

I hope this helps. If you need further assistance, please write back.

Greetings,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Tom Chien
Top achievements
Rank 1
answered on 06 Nov 2009, 05:48 PM
1. To reproduce the "bug report":

1.a. Design a RadGridView with a Date Column whose default width is (wide enough for the data values but*) narrower than that needed to display a "dddd, MMMM dd, yyyy" Format.  * = optional scenario to reproduce the issue but is probably the normal scenario since the long date format is rarely used esp. in horizontal-space-sensitive grids.
1.b. Click on the Filter Row of the Date Column (i.e. before expanding the Column Width which is what most users would probably do since they probably wouldn't expect to need to expand the Column's Width to edit a Date Filter Row's Value if that Column is already wide enough to display the Data Rows' Values of that Column, ergo my "feature request" in #2 below).
1.c. Expand the Column Width so that it's wide enough for the "dddd, MMMM dd, yyyy" Format.
1.d. Click on the Filter Row of the Date Column.  You'll see that it cuts off the beginning part of the Date Filter Value.
1.e. If you exit the Filter Row of the Date Column and then Click on it again (i.e. "2nd" time), now, it finally shows the entire Date Filter Value.

2. This is a "feature request" (or 2nd "bug report" - call it what you want) which is in addition to the "bug report" in #1 above and applies irregardless of whether the "bug" in #1 is fixed.  I'm requesting that Telerik adds a feature / fixes it so that the Format used to edit the Date Filter Row Value is the same Format used to display / edit the Date Data Rows' Values.  It displays the Date Filter Row Value in the same Format used to display / edit the Date Data Rows' Values.  However, it doesn't edit the the Date Filter Row Value in the same Format used to display / edit the Date Data Rows' Values.
0
Jack
Telerik team
answered on 12 Nov 2009, 02:25 PM
Hi Tom Chien,

Thank you for the detailed description for the first issue. I managed to reproduce it. I updated your Telerik points and the issue will be addressed in one of our upcoming releases. However, I was not able to reproduce the second issue. RadGridView uses the same format for filter rows as for data cells, it uses also the same editors. You can specify the cell text format by using the DataTextFormatString property and the editor format by using DataEditFormatString property. Could you give an example of this issue? Thank you in advance for your cooperation.

Regards,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Tom Chien
Top achievements
Rank 1
answered on 18 Nov 2009, 07:46 PM
Re. 2: Thanks, setting DataEditFormatString fixes it and I just noticed that's kind of what your docs already say (http://www.telerik.com/help/winforms/grid_gridviewdatetimecolumn.html).

However:

a) Those same docs say to use FormatString, not DataTextFormatString for the display format.
b) DataEditFormatString needs to be a normal Format String whereas FormatString and requires a Composite Format String
c) Appears DataTextFormatString is begin auto-set to FormatString's value.
d) According to your "Breaking Changes for Q1 2008" (http://www.telerik.com/help/winforms/radgridview-breaking-changes.html), for "GridViewDataColumn": "DataTextFormatString property is replaced by FormatString property.  DataEditFormatString property is obsolete, replaced by FormatString property".

0
Jack
Telerik team
answered on 23 Nov 2009, 09:06 AM
Hi Tom,

Yes, your findings are correct. We have to update our documentation. It turned out that FormatString can't replace the DataEditFormatString in all cases. Thank you for pointing us to this issue. I updated your Telerik points.

Best wishes,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
GridView
Asked by
Tom Chien
Top achievements
Rank 1
Answers by
Tom Chien
Top achievements
Rank 1
Jack
Telerik team
Share this question
or