Free Support Forum - aspose.com

Excel custom cell format "@*." has issues

Setting Cell Format to the custom value “@." is not rendered correctly - the dots are not added in the reminder of the cell.

In the Excel.xlsx attached the cell D9 is formatted with the custom cell format "@
.” and its content - “Pointy” - is followed by dots until the end of the cell.

In the generated Word.docx file the corresponding cell is rendered without the dots.

Hi,


Please check my reply in your other thread:
http://www.aspose.com/community/forums/428623/excel-custom-cell-format-quot-.quot-has-issues/showthread.aspx#428623

Thank you.
ibmromania:
Setting Cell Format to the custom value "@*." is not rendered correctly - the dots are not added in the reminder of the cell. In the Excel.xlsx attached the cell D9 is formatted with the custom cell format "@*." and its content - "Pointy" - is followed by dots until the end of the cell. In the generated Word.docx file the corresponding cell is rendered without the dots.
Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this issue using the latest version: Aspose.Cells for .NET v7.3.4.1 and we found that D9 Cell String Value returned by Aspose.Cells is not correct.

Also, when we render it to pdf, it also does not render correct.

We have logged this issue in our database. We will look into this issue and resolve it. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41225.

I have attached the output pdf file generated by this code. Please also see the comments of the code, the console output and the screenshot for your reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\Excel.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


string D9StringValue = worksheet.Cells[“D9”].StringValue;


//It should be something like this Pointy…

//but it is Pointy

//so it is wrong

Debug.WriteLine("[D9 StringValue]: " + D9StringValue);


workbook.Save(filePath + @".out.pdf", SaveFormat.Pdf);


Console Output:
[D9 StringValue]: Pointy

Screenshot:

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue. We will provide you a fix soon.