We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Problems with broken fonts and lines when converting sheets to an image

I have a question from our customer who has been using your trail version of

Aspose cells for Java before his actual purchase, and he like to know a couple of

things which he need to know for sure.

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

He tried to convert Excel sheets to images and had some problems.

1) Some portion of the sheet was not converted or (deleted)

2) Korean characters were not converted and cracked.

3) lines from tables and borders are not showing.

He likes to know the way way to solve ;

i) not showing Korean font problems

ii) Lines and borders shows as they should.

I have attached his captured images for you to take a look.

What he was trying to do was read excel files from the server directory and

save selected sheets to images back to the server directory.

Testing Environment;

- Programs are in Java

- Weblogic 10

- Unix based

- Web based system

- Added 5 jar files to the web application lib

aspose-cells-2.5.2-java\JDK 5.0\aspose-cells-2.5.2-java\lib

aspose-cells-2.5.2.jar
dom4j-1.6.1.jar
jsr173_1.0_api.jar
stax2-api-3.0.2.jar
woodstox-core-asl-4.0.8.jar

Did some test like below and confirmed that image files are generated in Server Directory.

import com.aspose.cells.*;

// Instantiate a new workbook
Workbook book = new Workbook();
// Open an existing file
String excel_file = UPLOAD_DIR + "/" + cuid+".xls";
book.open(excel_file);

// Create an object for ImageOptions
ImageOptions imgOptions = new ImageOptions();
// Set the format type of the image
imgOptions.setImageFormat(ImageFormat.PNG);
// Get the first worksheet.
Worksheet sheet = book.getWorksheets().getSheet(0);
// Create a SheetRender object with respect to your desired sheet
SheetRender sr = new SheetRender(sheet, imgOptions);
String image_file = UPLOAD_DIR + "/" + cuid;
for (int j = 0; j < sr.getPageCount(); j++)
{
//Generate image(s) for the worksheet
sr.toImage(j, image_file+"_" + j + ".png");
}

This customer is very important to us and I hope

if you can tell us how to approach this customer.

Hi,


Please try our latest version/fix (attached) and let us know if it works fine.

If you still find the issue, please give us your template file and image(s) to show the issue. We will check your issue soon and may provide you the fixed version (if possible) soon.

Thank you.

Hi,

For the Korean characters, user must specified the correct font path so we can find the proper font to render them. Otherwise java’s default font cannot render asian characters correctly.

For other issues such as sheet content lost, border lost and so on, if you can find it with latest fix, please provide us the template file to reproduce the issue and we will figure it out soon.