… Continuation to above
For your first problem, I found, you need to set title text as null. Please see the following code, source and output file.
String path = “F:\Shak-Data-RW\Downloads\Source.xlsx”;
Workbook workbook = new Workbook(path);
Worksheet worksheet = workbook.getWorksheets().get(0);
Chart ch = worksheet.getCharts().get(0);
workbook.save(path + “.out.xlsx”);
Please provide us your complete code and screenshots explaining the problem. Please provide us your expected output file also. And if you are using some source/input file then, please also attach it. We will look into it and help you asap.
I think, that’s a right behavior, because when cell is not filled, then its background color is white.
That is correct. But I am getting values as 0, 0, 0 when there is no fill. I should get values corresponding to white i.e. -1, -1, -1. 0, 0 , 0 corresponds to black. Why should I get the background color as black when there is no fill?
please refer to below post for the details. I have marked that post private as some attachments contain client specific material.
For the issue 2 of secondary axis (and your new thread at
For the issue 3 of color of cell, please check Style.getPattern() at first. If the pattern value is BackgroundType.NONE, then the cell has no fill and the color returned by the style object is meaningless.