[ODFTOOLKIT-359] setting data using a cell range address with two letters fails

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7-incubating
• Component/s: java, simple api
• Assignee: Unassigned
• Reporter: Michael Kabdebo
• Created: 13/Mar/13 07:33
• Updated: 29/Jan/16 21:07

Description

I've created a table with a big number of columns (=144). Next next step was to generate a chart using the createChart(...)-method of the SpreadsheetDocument class.

This is my cell range address: 'TableName'.A1:'TableName.EN4'

I got this exception:

not able to add chart for sheet 'TableName': For input string: "N4"
java.lang.NumberFormatException: For input string: "N4"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at java.lang.Integer.parseInt(Integer.java:499)
at org.odftoolkit.simple.chart.DataSet.setValues(DataSet.java:596)
at org.odftoolkit.simple.chart.DataSet.<init>(DataSet.java:123)
at org.odftoolkit.simple.chart.AbstractChartContainer.createChart(AbstractChartContainer.java:133)
at org.odftoolkit.simple.SpreadsheetDocument$ChartContainerImpl.createChart(SpreadsheetDocument.java:660)
at org.odftoolkit.simple.SpreadsheetDocument$ChartContainerImpl.access$0(SpreadsheetDocument.java:658)
at org.odftoolkit.simple.SpreadsheetDocument.createChart(SpreadsheetDocument.java:587)

Whats happened:
This is how you try to extract the column and row information: (DataSet.class:594 - 597)

char beginColumn = begincell.charAt(0);
char endColumn = endcell.charAt(0);
int beginRow = Integer.parseInt(begincell.substring(1));
int endRow = Integer.parseInt(endcell.substring(1));}}

This won't work for addresses using column adresses with two letters (or more).

Issue Links

• is related to: ODFTOOLKIT-361 generating chart using a cell range address with two letters fails