[Bug 56702] New: Get one exception java.lang.IllegalStateException: Cannot get a numeric value from a text cell when calling org.apache.poi.ss.usermodel.DataFormatter.formatCellValue

2014-07-08 Thread bugzilla 
https://issues.apache.org/bugzilla/show_bug.cgi?id=56702

Bug ID: 56702
   Summary: Get one exception java.lang.IllegalStateException:
Cannot get a numeric value from a text cell when
calling
org.apache.poi.ss.usermodel.DataFormatter.formatCellVa
lue
   Product: POI
   Version: 3.8
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
  Assignee: dev@poi.apache.org
  Reporter: 278880...@qq.com

There in one cell which value is empty string instead of null cell.
I got the exception 
Caused by: java.lang.IllegalStateException: Cannot get a numeric value from a
text cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
at
org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:202)
at
org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(DateUtil.java:325)
at
org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(DataFormatter.java:756)


Also, I debugged source code and found that the cell type is CELL_TYPE_NUMERIC,
so when it convert to double, the exception will be thrown.

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

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

[GitHub] poi pull request: Manipulation of SlideMaster SlideLayout and Plac...

2014-07-08 Thread valerian-at-pellucid 
GitHub user valerian-at-pellucid opened a pull request:

https://github.com/apache/poi/pull/9

Manipulation of SlideMaster SlideLayout and Placeholders



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/pellucidanalytics/poi pellucid-powerpoint

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/poi/pull/9.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #9


commit 44bcf2a9bdaa17a6c26b37c91656a799029e7a7b
Author: Valerian Barbot v...@zenexity.com
Date:   2014-05-13T12:52:55Z

gitignore

commit b7222f4e3475af155c5269bd5d2c1689a82eedd4
Author: Valerian Barbot v...@zenexity.com
Date:   2014-05-14T14:32:12Z

improve powperpoint integration

commit 08e76bad80cf1fda877648940863370a2b66c8a1
Author: Valerian Barbot v...@zenexity.com
Date:   2014-05-15T11:49:03Z

append shape to XSLFSheet

commit c0381d26b004fc3cc99bfb6f3e95c24020f6d06f
Author: Valerian Barbot v...@zenexity.com
Date:   2014-05-22T13:58:36Z

fix slide creation (slide-layout relationship)

commit e55fadc09da7f9fb94dae93a619800832badc4d0
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-12T13:48:18Z

add Placeholder converter

commit 7ef3386bc05543f69153108b40e1c239b90a5f58
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-12T13:56:33Z

LayoutSlide: insert Placeholder

commit ab8e50f539b68e3fef28ddd04ebba251da5d0c7d
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-12T14:00:08Z

create XSLFSlideLayout  create XSLFSlideMaster

commit 857434ac589d3012df1c901dd0fcacac625a844e
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-12T15:23:04Z

version 3.11-beta1-pellucid-2

commit 95aba451a6eae14269e763b0273ca8a981a0fd4b
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-13T15:18:46Z

fix for create XSLFSlideLayout  create XSLFSlideMaster

commit 67087bc7e0f4e516c88fca1ba7595bda31f1085a
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-17T14:08:19Z

Fix createRelationship: find index

commit 96407b4631d10922efc5d076c4f1a6d3883d6816
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-17T14:19:02Z

Improve comments

commit 8c08165f61c3faa9adcdfb5402eca8950c375581
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-17T14:19:39Z

remove SlideLayout

commit c86e59b346488567eb22f57961bc90e43a317999
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-17T14:20:03Z

remove SlideMaster

commit 8d6e633a7af4a0c8f33e728a24f076a251e0383f
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-17T14:27:04Z

3.11-beta1-pellucid-3

commit 6f3386ba18f0bc5a078ac9cfa567dcd6a389e22d
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-18T16:52:02Z

fix remove Slide Master

commit cd4c99f34e4624218cb8476de60a33c3812b2de3
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-19T12:37:58Z

3.11-beta1-pellucid-5

commit f211024921c28bd927ad9894a600ab94e4a055ce
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-20T15:09:26Z

fix

commit 25fdcd83aefa876afab25a9aab0070fa69515035
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-20T15:32:50Z

3.11-beta1-pellucid-6

commit d417c29a171b093461ebb4d2a42efd3cdaa3b437
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-23T11:43:56Z

test XSLFSlideShow SlideMaster SlideLayout

commit a79ff664bb43cde224ae139a77ce4b44dc5cd2ee
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-23T13:00:06Z

XSLFSlideLayout : test insert Placeholder

commit 3193399b1c7814736824a5d612c9ac5f4580e42a
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-23T15:24:14Z

clean draft test

commit f225bbda63e560f5d5fbf4cb470ec6199e4c8691
Author: Valerian Barbot v...@zenexity.com
Date:   2014-06-26T13:18:42Z

insert placeholder from a XSLFSheet




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

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

[Bug 56705] New: [PATCH] XSSFWorkbook.getSheet(String) is slow with many sheets

2014-07-08 Thread bugzilla 
https://issues.apache.org/bugzilla/show_bug.cgi?id=56705

Bug ID: 56705
   Summary: [PATCH] XSSFWorkbook.getSheet(String) is slow with
many sheets
   Product: POI
   Version: unspecified
  Hardware: PC
OS: Linux
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: cmb-apa...@corefiling.co.uk

Created attachment 31802
  -- https://issues.apache.org/bugzilla/attachment.cgi?id=31802action=edit
patch to add a map from name to sheet

XSSFWorkbook.getSheet(String) showed up as a hot-spot in profiling, as the
project I'm on calls it very often to resolve cross-sheet formula references.

Currently it simply walks the list of sheets looking for one with a matching
name. The attached patch adds a map from name to sheet, which reduces the time
our operation spends in this method by about 80%.

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

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

[Bug 56702] Get one exception java.lang.IllegalStateException: Cannot get a numeric value from a text cell when calling org.apache.poi.ss.usermodel.DataFormatter.formatCellValue

2014-07-08 Thread bugzilla 
https://issues.apache.org/bugzilla/show_bug.cgi?id=56702

Nick Burch apa...@gagravarr.org changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 OS||All

--- Comment #1 from Nick Burch apa...@gagravarr.org ---
3.8 is a little old now, can you please try with a recent svn checkout /
nightly build, and see if the problem still remains?

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

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