DataBar to Image wrong

Aspose.Cells Product Family
1
Workbook wb = new Workbook("C:/内置样式3.xlsx");
int sheetIndex = 0;
Worksheet worksheet = wb.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

ConditionalFormattingCollection conditionalFormattings = worksheet.getConditionalFormattings();
for (int i = 0; i < conditionalFormattings.getCount(); i++) {
FormatConditionCollection formatConditionCollection = conditionalFormattings.get(i);
for (int j = 0; j < formatConditionCollection.getCount(); j++) {
FormatCondition formatCondition = formatConditionCollection.get(j);
switch (formatCondition.getType()) {
case FormatConditionType.DATA_BAR:
DataBar dataBar = formatCondition.getDataBar();
boolean showValue = dataBar.getShowValue();
ImageOrPrintOptions imgOpts = new ImageOrPrintOptions();
imgOpts.setImageFormat(ImageFormat.getPng());
for (int z = 0; z < formatConditionCollection.getRangeCount(); z++) {
CellArea cellArea = formatConditionCollection.getCellArea(z);
for (int x = cellArea.StartRow; x <= cellArea.EndRow; x++) {
for (int y = cellArea.StartColumn; y <= cellArea.EndColumn; y++) {
byte[] img = dataBar.toImage(cells.get(x, y), imgOpts);
String fileName = ReportUtil.cellIndexToString(x, y) + "_" + i + "_" + j + "_" + x
+ "_" + y + ".png";
FileOutputStream out = new FileOutputStream(fileName);
out.write(img);
out.close();
}
}
}
break;
}
}
}



Please note D24_0_0_23_3.png is blank which is opposed to MS Excel
2

ReportUtil.cellIndexToString just convert row column to cell name,


You can change it to CellsHelper.cellIndexToName
3

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested this issue with the following code using the latest version:
Aspose.Cells for Java v8.7.0.2
and found it is generating the correct data bar images. Please check the output pdf generated by the code for your reference.

Please download and try the latest version
Aspose.Cells for Java v8.7.0.2
and see if it fixes your issue.

Java

String filePath = “F:\Shak-Data-RW\Downloads\s.xlsx”;

Workbook workbook = new Workbook(filePath);

workbook.calculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.setOnePagePerSheet(true);

workbook.save(filePath + “.out.pdf”, opts);

4

I tested the v8.7.0.2, and the issue is not fixed.



If you remove opts.setOnePagePerSheet(true); in your test codes, databar images is wrong in pdf, which D24 is smaller than D26

And dataBar.toImage(D24) is still blank.
5

Hi,

Thanks for your posting and using Aspose.Cells.

We were unable to observe the issue precisely. It will be helpful if you could provide us the screenshot highlighting your issues in output pdf. We will look into it and help you asap.

6

Please see my attachments.

7
Workbook workbook = new Workbook("C:/内置样式3.xlsx");

workbook.calculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.setOnePagePerSheet(true);

workbook.save("C:/内置样式3.xlsx.pdf", opts);
int sheetIndex = 0;
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

ConditionalFormattingCollection conditionalFormattings = worksheet.getConditionalFormattings();
for (int i = 0; i < conditionalFormattings.getCount(); i++) {
FormatConditionCollection formatConditionCollection = conditionalFormattings.get(i);
for (int j = 0; j < formatConditionCollection.getCount(); j++) {
FormatCondition formatCondition = formatConditionCollection.get(j);
switch (formatCondition.getType()) {
case FormatConditionType.DATA_BAR:
DataBar dataBar = formatCondition.getDataBar();
boolean showValue = dataBar.getShowValue();
ImageOrPrintOptions imgOpts = new ImageOrPrintOptions();
imgOpts.setImageFormat(ImageFormat.getPng());
for (int z = 0; z < formatConditionCollection.getRangeCount(); z++) {
CellArea cellArea = formatConditionCollection.getCellArea(z);
for (int x = cellArea.StartRow; x <= cellArea.EndRow; x++) {
for (int y = cellArea.StartColumn; y <= cellArea.EndColumn; y++) {
byte[] img = dataBar.toImage(cells.get(x, y), imgOpts);
String fileName = ReportUtil.cellIndexToString(x, y) + "_" + i + "_" + j + "_" + x
+ "_" + y + ".png";
FileOutputStream out = new FileOutputStream(fileName);
out.write(img);
out.close();
}
}
}
break;
}
}
}

8

Sorry, I forget to comment opts.setOnePagePerSheet(true);


Test code is:


Workbook workbook = new Workbook(“C:/内置样式3.xlsx”);

workbook.calculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
// opts.setOnePagePerSheet(true);

workbook.save(“C:/内置样式3.xlsx.pdf”, opts);
int sheetIndex = 0;
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

ConditionalFormattingCollection conditionalFormattings = worksheet.getConditionalFormattings();
for (int i = 0; i < conditionalFormattings.getCount(); i++) {
FormatConditionCollection formatConditionCollection = conditionalFormattings.get(i);
for (int j = 0; j < formatConditionCollection.getCount(); j++) {
FormatCondition formatCondition = formatConditionCollection.get(j);
switch (formatCondition.getType()) {
case FormatConditionType.DATA_BAR:
DataBar dataBar = formatCondition.getDataBar();
boolean showValue = dataBar.getShowValue();
ImageOrPrintOptions imgOpts = new ImageOrPrintOptions();
imgOpts.setImageFormat(ImageFormat.getPng());
for (int z = 0; z < formatConditionCollection.getRangeCount(); z++) {
CellArea cellArea = formatConditionCollection.getCellArea(z);
for (int x = cellArea.StartRow; x <= cellArea.EndRow; x++) {
for (int y = cellArea.StartColumn; y <= cellArea.EndColumn; y++) {
byte[] img = dataBar.toImage(cells.get(x, y), imgOpts);
String fileName = ReportUtil.cellIndexToString(x, y) + “" + i + "” + j + “" + x
+ "” + y + “.png”;
FileOutputStream out = new FileOutputStream(fileName);
out.write(img);
out.close();
}
}
}
break;
}
}
}

9

Please note D24_0_0_23_3.png is a blank png file, without any red bar.

10

Hi Xiong,

Thanks for explaining everything nicely and diligently and using Aspose.Cells.

I have looked into this issue and were able to observe it after converting the worksheet into image using the following code with the latest version and found some of the data bar images are blank.

We have logged this issue in our database for investigation. We will look into it and fix this issue. 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

  • CELLSJAVA-41740 - Some of the DataBar images are blank

I have also attached the output image generated with the following code which also highlights the blank cells with red circles.

Java
String filePath = “F:\Shak-Data-RW\Downloads\3.xlsx”;

//Create workbook from source file.
Workbook workbook = new Workbook(filePath);

workbook.calculateFormula();

//Access the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);


//Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setOnePagePerSheet(true);
options.setImageFormat(ImageFormat.getPng());

//Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
sr.toImage(0, filePath + “.out.png”);
11

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSJAVA-41740 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

12

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v8.8.3.1 and let us know your feedback.

13

The issues you have found earlier (filed as CELLSJAVA-41740) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.