BuyLog In
Bug Report Q487518
Visible to All Users

Export - Exporting special characters (&, ", <, or >) in the Korean(Korea) locale makes the resulting XLSX file unreadable

created 12 years ago

ExportGridToXLSX is not work.
cxGridDBTableView - normal operation
but
cxGridDBBandedTableView - not working , crafted Excel file does not open.
This problem same v12.4 .
My Code :

Delphi
procedure Export_ExcelGrid( FileName : String; Grid : TcxGrid );  
Var  
 F_Name : String;  
begin  
  F_Name := FileName + '_' + FormatDateTime('YYYYMMDD_HHNNSS',Now)+'.XLSX';  
  ExportGridToXLSX( F_Name, Grid, True, True, False );  
  if FileExists(F_Name) then  
    ShellExecute(Application.Handle, 'open', PWideChar( F_Name ), nil, nil, SW_ShowNormal);  
end;

Thx.

Show previous comments (3)
SH SH
Sungho Hur 12 years ago

    Hello,
    Oh My God~~~
    Please This Looks AVI file. Here, a file is created, the problem occurs.
    2 file attached. Avi file and create unreadable files.
    Country : Korea
    OS : Windows 7 x64, Wndows XP
    Office : Office 2010, Office 2007
    Hangul (Korea) Office from both customers and developers who can not read the file will be created.
    What's the problem?

    DevExpress Support Team 12 years ago

      Thank you for your clarification. I have reproduced the described behavior with the Korean(Korea) locale and forwarded this ticket to our developers for research. Meanwhile, I suggest you use the ExportGridToExcel procedure instead (it works as expected in my test with the Korean(Korea) locale).

      SH SH
      Sungho Hur 12 years ago

        Thank you Paulo.
        Just worried about the 65,000 + customers require Excel yet, but if you can hold out.
        For good results in quick time and look forward.
        Thank you.

        Sign in to comment on this post

        Answers approved by DevExpress Support

        created 12 years ago (modified 12 years ago)

        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.

          Sign in to comment on this post

          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.