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.

Date format

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 08:01 AM

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 11:41 AM

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

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

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.

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.

;