Excel export output appears garbled #4

Excel export output appears garbled #4

Posted by: ilia on 6 July 2018, 4:28 am EST

• 

  ilia

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 July 2018, 4:28 am EST - Updated 30 September 2022, 9:09 am EST

  The sample attached.
  
  SectionReportApplication2.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 July 2018, 3:35 pm EST

  Hello,

  Please set “UseCellMerging” property of excel export to “True” to get the desired result.

  Thanks,

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 8 July 2018, 6:55 pm EST - Updated 30 September 2022, 9:09 am EST

  I tried to set “UseCellMerging” property of excel export to “True”. It still appears garbled.
  
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 July 2018, 10:26 pm EST

  Hello,

  Please refer to the modified project.

  Thanks,
  
  Mohit
  
  Prj_Modified.zip

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 10 July 2018, 11:41 pm EST

  In your sample appears vertical space, despite the fact that RemoveVerticalSpace is set to True.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 4:26 pm EST

  Hello Ilia,

  I am unable to observe any verticle space. Please refer the attached excel file. Also, Please set “RepeatToFill” to false to remove the unwanted border.

  Thanks,
  
  Mohit
  
  444.zip

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 4:48 pm EST - Updated 30 September 2022, 9:09 am EST

  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 7:32 pm EST - Updated 30 September 2022, 9:10 am EST

  Hello Ilia,

  I am unable to reproduce the issue at our end. I have even tired after changing system culture to “Hebrew”, however, the issue is not reproducible at my end. Please refer to the attached images.

  Thanks,
  
  Mohit
  
  

  

  1212×932 82.8 KB

  
  
  

  

  1215×933 81.6 KB

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 8:55 pm EST

  The sample attached.Prj_Modified.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 9:24 pm EST

  Hello,

  Unfortunately, the issue is still not reproducible at my end with attached sample also. Could you please share the build number. I think you have the latest hotfix of AR12.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 12 July 2018, 12:14 am EST

  GrapeCity.ActiveReports.SectionReport, GrapeCity.ActiveReports.v12, Version=12.1.13748.0

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 12 July 2018, 8:41 pm EST

  Hello Ilia,

  I am using the same build at my end. However, I am not able to reproduce the issue. I have even checked with Office 2010,2007,365

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 15 July 2018, 3:23 pm EST - Updated 30 September 2022, 9:10 am EST

  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 15 July 2018, 8:49 pm EST - Updated 30 September 2022, 9:10 am EST

  Hello Ilia,

  Could you please check on another computer as issue is not reproducible with above screen setting at my end. Please refer to the image.

  Thanks,
  
  Mohit

  

  993×670 32.9 KB

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 15 July 2018, 11:52 pm EST

  On Server 2012 R2 it is same. 444.zip

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 16 July 2018, 4:12 pm EST

  It seems. It is Excel problem. My font in “Hebrew Location” is “Arial,9.75pt” but Excel calculates its as “Arial,10”.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 16 July 2018, 4:34 pm EST

  Hello Ilia,

  I am able to replicate the problem at my end after adding “Hebrew” language pack for Office. Also, you can see the difference on changing the language of the excel.

  Thanks,
  
  Mohit