Cell value with wrong format


#1

I tried to convert spreadsheet to pdf file.

Spreadsheet was created using another spreadsheet template with pre-formatfed font (font IDAutomation (barcode font)) and it was set to fit the cell.

Aspose.Cell excludes the text at the bottom.

b.PNG (929 Bytes)
b2.PNG (1.3 KB)


#2

@tylorn,

Thanks for the screenshots.

Well, for certain features, e.g Excel to PDF, Sheet to image, etc. Aspose.Cells requires the underlying fonts (used in the Workbook) to be installed before rendering workbook to PDF/images. it is necessary that the fonts used in the spreadsheet should be available in the operating system’s default font directory (or you may put the fonts in your custom directory but the folder should be specified by Aspose.Cells APIs at the start). In case the required fonts are not present then the Aspose.Cells APIs will try to substitute the required fonts (if available) with the ones available. Also, on a safer side, you may set the fonts folder path using FontConfigs API, see the document for your reference:
https://docs.aspose.com/display/cellsnet/Configuring+Fonts+for+Rendering+Spreadsheets (.NET)
https://docs.aspose.com/display/cellsjava/Configuring+Fonts+for+Rendering+Spreadsheets (Java)

If your issue is not resolved following above and using latest version/fix v18.11.x, kindly provide your final Excel spreadsheet, output PDF file and underlying font files (you may zip the files prior attaching here), we will check it soon.


#3

Hi,

Font was rendered correctly but with wrong format.LoadSheet_11262018_thienn (2).zip (29.2 KB)


#4

@tylorn,

The PDF file you have attached is zero KB file. Could you please upload the file where font is rendered correctly, and sample code snippet. We will reproduce the problem and provide our feedback after analysis.


#6

@tylorn,

Thanks for providing us template file and font file.

After an initial test, we were able to reproduce the issue by converting your template file to PDF (after installing the barcode font). We found the bottom text under the barcode is missing as per your attached screenshots. We will investigate your issue in details and try to figure it out soon.

The issue is logged as following:
CELLSNET-46466 - Bottom text under the barcode is missing in Excel to PDF rendering


#7

@tylorn,

Please try our latest version/fix: Aspose.Cells for .NET v18.11.5 (attached)

We have fixed your issue now.

Let us know your feedback.
Aspose.Cells18.11.5 For .Net4.0.Zip (4.7 MB)