Problem in Font when file is downloaded from query...

Former Member · ‎2007 May 25

Hi,

We are facing a problem as we are not able to simulate a scenario at our end where a file is downloaded from a query. The snapshot of the file which is downloaded in excel is shown below. The name displayed below has special characters in it. The actual value for the name is VÁRADI GÁBORNÉ, but when the file is downloaded into excel, the special characters get converted to some different characters and the last character ie É gets converted to “?” and the values for the next column get concatenated to the Name 1 column and all the values move one column left.

Sold to Cl Name 1 Sal.per. Sales doc.

57983 CD V罵ADI G罛ORN?00002110 2150451

The procedure used by the user to download the file from the query is as follows:

1. The query is executed in background with file name entered in Save with ID option

2. After the job is complete, the file is displayed from the saved list of that query.

3. This saved list is then downloaded as .DAT file and then opened with excel.

Any pointers to solve the problem will be highly appreciated.

Regards,

Kaushal Mehta

former_member223537 · ‎2007 May 26

Hi,

Please check whether the DEVICE TYPE supports the font. If not then you need to upload the necessary font or change the device type to which your job is submitted.

Best regards,

Prashant

Former Member · ‎2007 May 31

Hi,

There is no problem of device type as when we are testing the query with the same inputs (same variant, same printer), the output to the excel comes correctly. But at the user end, the output does not come out properly. Infact the saved list displayed for that query shows the output to be correct, but when that list is exported to excel, the output gets distorted for the user (not for us).

Thanks for your inputs,

Kaushal

Problem in Font when file is downloaded from query output.