Cell Format

Aspose.Cells Product Family
1

Hi Team,

I need help from you on the folowing issue.

I am trying to populate "+8" and "-8" in two different cells.

But after population, cell which contains +8 value also contains a green triange shape in the top most left corner as below.

Cell with formula problem

for the above we should not change(Like (+/-)8(+/-) to 8 or -8 ) the data. we have to display whatever data we recieve.

On Click on the cell it displayed the following icon.

Button image

On Click on the above icon, a list of options are displayed. from the those options on of the option is "Ignore Error".

can you please tell us how to implement the "Ignore Error" through Aspose.Cells.

Thanks in Advance.

2

Hi Soc,

Can you please post sample excel file and sample code to show us the issue. As the images which you have sent are not displaying.

Thanks,

3

Hi,

Please find the sample xls file and sample code below.

Style style = workbook.createStyle();

style.setHAlignment(HorizontalAlignmentType.LEFT);

style.setBorderLine(BorderType.LEFT, BorderLineType.THIN);

style.setBorderLine(BorderType.RIGHT, BorderLineType.THIN);

style.setBorderLine(BorderType.TOP, BorderLineType.THIN);

style.setBorderLine(BorderType.BOTTOM, BorderLineType.THIN);

Font font1 = style.getFont();

font1.setColor(Color.BLACK);

font1.setSize(8);

font1.setBold(false);

font1.setName("Arial");

row.getCell(0).setValue((String)objects[1]);

row.getCell(0).setStyle(style);

row.getCell(1).setValue((String)objects[2]);

row.getCell(1).setStyle(style);

row.getCell(2).setValue((BigDecimal)objects[3]);

row.getCell(2).setStyle(style);

row.getCell(3).setValue(((String)objects[4]), true);

row.getCell(3).setStyle(style);

row.getCell(4).setValue(((String)objects[5]), true);

row.getCell(4).setStyle(style);

row.getCell(5).setValue((Date)objects[6]);

row.getCell(5).setStyle(dateStyle);

row.getCell(6).setValue((Date)objects[7]);

row.getCell(6).setStyle(dateStyle);

From the above text, text in purple color is the code where i am populating the cells with the data.

please have a look into the code and sample excel file and suggest me the solution.

Thanks in Advance.

4

Hi Soc,

Please use the updated version of the Aspose.CellsV2.4.0.1.zip attached. The issue you have mentioned in the sample code has been resolved.

Thanks,

5

Hi Soc,

To remove error check from the generated file, following sample code will help you.

Code snippet:
ErrorCheckOptions opts = new ErrorCheckOptions();
opts.setErrorCheck(ErrorCheckType.TEXT_NUMBER, false);
//disable the check for numerics saved as text
opts.addRange(new CellArea(0, 0, 65535, 256));
//make the error check option apply on the whole sheet
sheet.addErrorCheckOptions(opts);

Thanks,

6

Hi Salman,

I made the changes based on you sample code. Its Working fine.

Thank you very much for your support.

7

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

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