Hello Support,We are using Infragistics Excel engine to read and write the values from Excel. We want to write a date values in the a specific column with the date format as set in the regional settings. Also we want that when reading the date values from these columns, the values should be read in the format set in the regional settings on the machine. However, we found that the dates values are not read correctly when read from different machine having different regional settings.FOr e.g. suppose from a machine having regional setting set to "English (New Zeland)" with the date format as "mm/dd/yyyy", when we open the excel file from a machine having regional settings as "English (United States)" with date format as "dd/mm/yyyy", some of the date values are not read correctly.We wanted to know is there any property in the Infragstics Excel Engine so that when writing to excel we can set cell format to default date (* format) or set the "locale" of the cell. And later when we open and read the excel file it would pick up and read the dates in the format set on the machine?
Hello,
You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.
There are many benefits to submitting a product idea:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea:
- Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).
- Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
- Add your product idea and be sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
Hi Mike,
Thank you for all your support.
It will be really helpful if the Excel library has a feature to use the culture specific date pattern. Please let us know if Infragistics incorporates this feature in their future releases.
Well, if you open MS Excel on a specific machine and go into the "Format Cells" dialog, under the "Number" tab, and in the "Date" Category, the first date type has an asterisk next to it. If you select it and then go to the "Custom" category, the text box under the label "Type:" will show you the format code used for this date format in the current culture of the system. This is what you would have to specify to our Excel library to use the culture specific date format. Currently, the Excel library does not support any way for you to say "Use the culture specific date pattern, regardless of what that pattern currently is." Would you like me to submit a feature request for this kind of thing on your behalf?
Thank you for your reply.
In our application we have an option to Export and Import the data to and from Excel. So when exporting the data to excel we need to export the dates in the format or regional settings set in the Source machine. And while importing the data from excel we would need that we import the dates with the format set on the destination machine. So we can't really set the format to "m/d/yyyy", it has to be the format set on the machine. Is there any other way we can achieve this?
Regarding the duplicate post, please ignore the post submitted in the "General discussion".
I see you posted this question twice, so I will repeat my answer from the other thread here: "We try to mimic MS Excel behavior whenever possible in the Excel engine. When using a date format such as "mm/dd/yyyy", MS Excel does not reorder the format sections based on culture, so we do not either. They do however, reorder it when using a date format such as "m/d/yyyy", and we honor this behavior as well, so use this format instead."