Free Support Forum - aspose.com

Font spacing issues when set chartacters format

Hi all,
I have simple code to set italic for some character but when open by ms excel it have spacing between them (italic to i t a l i c )
This is sample code:
var _book = new c.Workbook();
var _sheet = _book.Worksheets[0];
var _cell = _sheet.Cells[0, 0];

_cell.PutValue("Test italic string");

for (int _i = 5; _i <= 10; _i++)
 {
       var _fs = _cell.Characters(_i, 1);
       _fs.Font.IsItalic = true;
}

@DungLT,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47652 - Font spacing issues when set chartacters format
1 Like

@ahsaniqbalsidiqui
I tried format on ms excel, and amazing, it have same issue.

@DungLT,
Thanks for the feedback. Once we have an update on it, we will let you know here.

@DungLT,

Please change codes as:

_cell.PutValue(“Test italic string”);
var _fs = _cell.Characters(5, 6);
_fs.Font.IsItalic = true;

If you format a character as italic, MS Excel will add spacing for italic character.

@DungLT,

Please try our latest version/fix: Aspose.Cells for .NET v20.9.12 (attached)
Aspose.Cells20.9.12 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.12 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.9.12 For .NetStandard20.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

1 Like

@Amjad_Sahi
I tested and it working fine.
Thank for your support. :smiling_face_with_three_hearts:

@DungLT,
You are welcome.

The issues you have found earlier (filed as CELLSNET-47652) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (https://www.nuget.org/packages/Aspose.Cells/20.10.0).