poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54868] Write numbers to text cells in Excel generates warnings that number is stored as text
Date Sat, 20 Apr 2013 11:55:47 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54868

--- Comment #2 from Mark B <markbrdsly@tiscali.co.uk> ---
I have found where you will need to look. There is an element within the xml
markup for the sheet that allows you to specify which cell's errors ought to be
ignored, it looks a little like this;

   <ignoredErrors>
      <ignoredError sqref="A2" numberStoredAsText="1"/>
   </ignoredErrors>
</worksheet>

and, as you can see from this fragment, is positioned close to the bottom of
the markup for the sheet. I am going to guess that you will need to create an
ignoredError element for each cell and am further going to guess that within
the xmlbeans layer for the sheet there should be an object to support this. You
will need to dig around within this layer to identify it however and the best
tool for this is a good IDE such as NetBeans or Eclipse.

As before, if you do find out the objects to use and are able to engineer a
opatch, please contribute it to the project.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message