How to fix blue triangle in top left corner of cell in excel while creating using apache poi 3.6

[Mohanasundar Nagarajan]

Dear Sir/Madam/Friends,

I’m generating a excel in java using apache poi api. Here in some cell, I would be displaying numeric as test. So that I’m getting

blue triangle in top left corner of the cell

, can any one suggest me to fix that error?

Thanks in advance.

Regards,
Mohanasundar.n

[Lester Burnham]

What does that triangle indicate - does it signal an error or something like that? We know neither the code you're using to create the file, nor do we have access to the file itself, so you need to tell us the details.

[Mohanasundar Nagarajan]

Thanks for the reply.


Excel is being created by me in java using apache API. Here I may fill numeric data(00012) to cell but the cell type is String.

After creating the excel if I open that excel File I am getting that triangle where I filled numeric. If I select that cell I am getting ! symbol. There I am getting tool tip like "Number Stored as String"

[Lester Burnham]

It sounds as if the cell type is set to "text", not "numeric", despite the content actually being numeric. Is that what you intended to do? There's a method -in HSSFCell/XSSFCell/Cell, I think- that sets the cell type.

[Mohanasundar Nagarajan]

I made cell type to String. Excel generating. There I am getting blue triangle

[Lester Burnham]

Maybe there's an option in Excel that lets you turn off that indicator.

[Mohanasundar Nagarajan]

In excel there is on option but client side we cant go and do disable.
That is why I am asking any thing can be done through coding.

[Joshua Barrett]

Hi there,

I'm experiencing the same issue, although mine is green, and the text on mouse over says "Number in this cell is formatted as Text or preceded by an apostrophe".

Now this is exactly what I wish to do, as the number is a customer number and may contain preceding zero's that are required.

I've looked through documentation and can’t seem to locate any methods that format cells to ignore errors.

Has the OP found a solution to this?