Different in the text display when upgrade Spread 1.0.9.0 to Spread 10J

Different in the text display when upgrade Spread 1.0.9.0 to Spread 10J

Posted by: fjn.tu.nguyen on 4 August 2020, 3:06 am EST

• 

  fjn.tu.nguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 August 2020, 3:06 am EST - Updated 30 September 2022, 1:29 pm EST

  Hello,
  
  I have a prolem with text display when upgrade the Spread version.
  
  Spread 10J: the text is cut at the bottom.
  
  I case of not to change Row Height, how to fix it?

  Display at Spread 1.0.9.0 (Windows 7)
  
  
  
  Display at Spread 10J (10.0.4006.2012)(Windows 10)
  
  

  Thanks

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 4 August 2020, 7:02 am EST

  Hi,

  We could not observe any text clipping in Spread 10.
  
  Please see the attached sample and modify it with any styling and font settings you are using so we can check it.

  ClippedText_Spread10.zip

  Regards,
  
  Jitender

• 

  fjn.tu.nguyen

  • Post Options:
  • Link
    Copy

  Posted 5 August 2020, 12:45 am EST

  Hi, thanks for replied
  
  I attached the sample, please check it.
  
  Work on Spread 1:
  
  ClippedText_Spread1.zip
  
  Work on Spread 10J
  
  ClippedText_Spread10.zip
  
  Thanks for helping.

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2020, 4:09 am EST - Updated 30 September 2022, 1:29 pm EST

  Hi,

  I checked the sample on Windows 7 and Windows 10 and I could observe the text clipping. However, the clipping was also observed with the standard DataGridView control. See the attached image. So, I don’t think the behavior in Spread 10 is not correct.

  

  802×413 4.31 KB

  Please also mention the .NET version you were using with Spread 1.0, and try using the same Font and Row height settings with the standard DataGridView control.

  Regards,
  
  Jitender

• 

  fjn.tu.nguyen

  • Post Options:
  • Link
    Copy

  Posted 6 August 2020, 3:50 am EST - Updated 30 September 2022, 1:29 pm EST

  Hi,
  
  I tried using the same Font and Row height settings with the standard DataGridView control on Windows 7, .Net 4.0.
  
  The DataGridView version also encountered the same problem.
  
  How should I understand this problem correctly?
  
  Spread 1:
  
  
  
  DataGridView:
  
  
  
  Thanks

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 7 August 2020, 11:18 am EST

  Hi,

  We are discussing your issue with the concerned team [SPNET-10615].
  
  I’ll let you know once we get any information from them.

  Regards,
  
  Jitender

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 9 August 2020, 2:17 am EST

  Hi,

  You can try these two solutions:

  1. If you are referencing FarPoint.Win.TextRenderer.dll, remove that reference from the project (also, remove that assembly from the GAC),
  2. Otherwise, you can use the following code:

  GeneralCellType generalCellType = new GeneralCellType();
  generalCellType.TextAdjustmentSpacing = 0;
  sheetView.DefaultStyle.CellType = generalCellType;
  

  Regards,
  
  Jitender

• 

  fjn.tu.nguyen

  • Post Options:
  • Link
    Copy

  Posted 9 August 2020, 11:11 pm EST

  Hi,
  
  It worked fine with solution 2.
  
  (I’m not referencing FarPoint.Win.TextRenderer.dll)
  
  I really appreciate your support.
  
  Thanks.