This week's book giveaway is in the Reactive Progamming forum.
We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line!
See this thread for details.
Win a copy of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams this week in the Reactive Progamming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

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

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I made cell type to String. Excel generating. There I am getting blue triangle
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe there's an option in Excel that lets you turn off that indicator.
 
Mohanasundar Nagarajan
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
I carry this gun in case a vending machine doesn't give me my fritos. This gun and this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!