Hello,
We have been using your DevExtreme Data Grid (Angularjs approach) in all the applications we build in house, but we are experiencing issues in Excel with the files we export using the grid, when Excel's "Text to Columns" functionality is used. Below I send you the steps to reproduce the crashing.
Do you have any fix to resolve this issue?
Thank you.
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
Hi,
Having thoroughly examined this issue, we concluded that it is specific to MS Excel as we already mentioned in the context of the ASPxGridView control for ASP.NET: T252593: ASPxGridView - The "Text to Columns" option doesn't work for an exported Excel document produced by Excel Data Aware Export. The next version of the dxDataGrid widget will include a similar option: export.ignoreExcelErrors. You will need to set it to false until Microsoft fixes the issue, mentioned here: T252593: ASPxGridView - The "Text to Columns" option doesn't work for an exported Excel document produced by Excel Data Aware Export.
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hello David,
Thank you for reporting this issue. I have managed to replicate this behavior and passed this ticket to our developers so that they can research it and find a suitable solution. You will be automatically notified once we make progress.