You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Mille4Ever <gi...@git.apache.org> on 2017/05/18 11:56:10 UTC
[GitHub] poi pull request #55: fix: NumberFormatException if XSSFName.setNameName is ...
GitHub user Mille4Ever opened a pull request:
https://github.com/apache/poi/pull/55
fix: NumberFormatException if XSSFName.setNameName is set with a long name
If you call XSSFName.setNameName with a long value consisting of a letter followed by a big number, you will get a NumberFormatException.
**For example:**
I want to set the name "F04030020010". In Excel using name box, I can set the name without any problems. If I want set the same name using poi, I will get the exception mentioned above.
The reason for the NumberFormatException:
The method XSSFName.validateName splits the value "F04030020010" in a column part and in a row part. Columns only have letters, rows only numbers. The outcome looks like:
_Column = F_
_Row = 04030020010_
In the next step, row will be converted into a number using _Integer.parseInt_. But the current row value exceed the max value of an Integer resulting in a NumberFormatException.
Since the logic is fine, I replaced Integer.parseInt with BigDecimal, so there is no problem with parsing big numbers anymore.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Mille4Ever/poi trunk
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/poi/pull/55.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 #55
----
commit 339838b909faf0744e8408ef12718f0a6463ffb7
Author: Thomas S <mi...@users.noreply.github.com>
Date: 2017-05-18T11:35:59Z
fix: NumberFormatException if XSSFName.setNameName is set with a long name which consists of a letter followed by a lot of numbers.
----
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[GitHub] poi pull request #55: fix: NumberFormatException if XSSFName.setNameName is ...
Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:
https://github.com/apache/poi/pull/55
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org