We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Date format

Thread ID:

Created:

Updated:

Platform:

Replies:

13208 Apr 22,2004 05:41 PM UTC Apr 30,2004 10:22 AM UTC Windows Forms 3
loading
Tags: XlsIO
Greg
Asked On April 22, 2004 05:41 PM UTC

Thanks for responding positively to my data type inquiry. I have a circumstance in which ExcelRW is saying that the NumberFormat is "mm/dd/yyy" when Excel is displaying "m/d/yyyy" and shows "m/d/yyyy" when switching the format to Custom. The date was entered into Excel simply as 1/2/04, but when I retrieve and display it, I''ll get 01/02/2004 whereas Excel will show 1/2/2004. So it appears that the fetching or creating of the NumberFormat is not getting the appropriate digits. (Be aware that in .Net that m means minutes and M means months, so a .Replace is required for .Net to display it correctly.) Please advise. Thanks, Greg

Administrator [Syncfusion]
Replied On April 23, 2004 12:01 PM UTC

Hi Greg, Just a quick update. I am looking into the issues that you have mentioned. I will update with more information as soon as possible. Sorry for the inconvenience Thanks. Best regards, Stephen. >Thanks for responding positively to my data type inquiry. > >I have a circumstance in which ExcelRW is saying that the NumberFormat is "mm/dd/yyy" when Excel is displaying "m/d/yyyy" and shows "m/d/yyyy" when switching the format to Custom. > >The date was entered into Excel simply as 1/2/04, but when I retrieve and display it, I''ll get 01/02/2004 whereas Excel will show 1/2/2004. So it appears that the fetching or creating of the NumberFormat is not getting the appropriate digits. > >(Be aware that in .Net that m means minutes and M means months, so a .Replace is required for .Net to display it correctly.) > >Please advise. > >Thanks, >Greg >

Greg
Replied On April 29, 2004 03:41 PM UTC

Stephen, Hadn''t heard back. Were you able to duplicate this? -Greg

Administrator [Syncfusion]
Replied On April 30, 2004 10:22 AM UTC

Hi Greg, Sorry for not responding earlier. I thought i had already updated this issue. I was able to reproduce the problem. We are working on all the issue that you have reported so far. I will try to make a custom build available to you with all the fixes early next week. We really appreciate your feedback. Thanks. Best regards, Stephen. >Stephen, > >Hadn''t heard back. Were you able to duplicate this? > >-Greg

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;