You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2011/06/01 16:56:41 UTC

DO NOT REPLY [Bug 51308] NoClassErrorFound when parse basic xslx file

https://issues.apache.org/bugzilla/show_bug.cgi?id=51308

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2011-06-01 14:56:41 UTC ---
See the FAQ: http://poi.apache.org/faq.html#faq-N10025

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

Re: Suppress extraction of some/all numeric fields in XLS documents ?

Posted by Nick Burch <ni...@alfresco.com>.

On Fri, 3 Jun 2011, Chris Bamford wrote:
> Say we have a percentage 56%
>
> In a spreadsheet display this shows as
>
>  56%
>
> The text extraction gives us
>
>  0.5590614886731392

You probably just want to apply the formatting rules to the cell when you 
extract it. org.apache.poi.ss.usermodel.DataFormatter should help here

Nick

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

Suppress extraction of some/all numeric fields in XLS documents ?

Posted by Chris Bamford <cb...@mimecast.com>.

Hi

Is it possible to suppress the extraction of some/all numeric fields in XLS documents via Aperture/POI?
Sometimes the string equivalents of numeric values produce weird strings which can confuse some of our processes.  For example,

Say we have a percentage 56%

In a spreadsheet display this shows as

  56%

The text extraction gives us

  0.5590614886731392

Unfortunately this number resembles an international telephone number or even a credit card number and could generate a false positive when matching.

Any ideas?

Thanks,

- Chris