id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
13821	Opendata plugin not opening spreadsheet	nick-tallguy	nick-tallguy	"==== What steps will reproduce the problem?
1. Install Opendata plugin
2. From JOSM, file / open, and select .ods or any format of spreadsheet
3. 

==== What is the expected result?
Spreadsheet opens as new data layer in josm

==== What happens instead?
Error report appears on JOSM screen

==== Please provide any additional information below. Attach a screenshot if possible.
On the same laptop I booted into Windows 7 and then installed new josm from fresh download of .exe from site. Fresh install of java - from oracle site. Same result - unable to open spreadsheet. 

I've been trying for 2 days - sometimes the data appears, but is obviously distorted - instead of the points appearing as a roughly even 'round' shape, they appear as a column. I have used this spreadsheet before to input data, but this was on and around the 21/06/2016 and presumably both my java & josm files are new versions.

{{{
URL:http://josm.openstreetmap.de/svn/trunk
Repository:UUID: 0c6e7542-c601-0410-84e7-c038aed88b3b
Last:Changed Date: 2016-09-06 00:16:07 +0200 (Tue, 06 Sep 2016)
Build-Date:2016-09-05 22:21:00
Revision:10966
Relative:URL: ^/trunk

Identification: JOSM/1.5 (10966 en_GB) Linux Mint 18 Sarah
Memory Usage: 250 MB / 1730 MB (63 MB allocated, but free)
Java version: 1.8.0_91-8u91-b14-3ubuntu1~16.04.1-b14, Oracle Corporation, OpenJDK 64-Bit Server VM
Screen: :0.0 1600x900
Maximum Screen Size: 1600x900
Java package: openjdk-8-jre:amd64-8u91-b14-3ubuntu1~16.04.1
WebStart package: icedtea-netx:amd64-1.6.2-3ubuntu1
VM arguments: [-Dicedtea-web.bin.name=javaws, -Dicedtea-web.bin.location=/usr/bin/javaws, -Djava.security.manager, -Djava.security.policy=/etc/icedtea-web/javaws.policy]

Plugins:
+ apache-commons (32699)
+ buildings_tools (32944)
+ ejml (32680)
+ geotools (32813)
+ jts (32699)
+ opendata (32898)
+ todo (30000)
+ utilsplugin2 (32815)

Map paint styles:
+ https://github.com/hotosm/HDM-JOSM-style/archive/master.zip

Last errors/warnings:
- E: null is NOT valid
- E: Reason: cvc-elt.1: Cannot find the declaration of element 'Workbook'.
- W: Old style SideButton usage for action org.openstreetmap.josm.plugins.todo.TodoDialog$SelectAction@79ccbc6e
- W: Old style SideButton usage for action org.openstreetmap.josm.plugins.todo.TodoDialog$AddAction@4fe6740e
- W: Old style SideButton usage for action org.openstreetmap.josm.plugins.todo.TodoDialog$PassAction@168c8f46
- W: Old style SideButton usage for action org.openstreetmap.josm.plugins.todo.TodoDialog$MarkAction@4d8a93a9
- W: Skipping line 2 because no valid coordinates have been found at columns CoordinateColumns [proj=WGS84 Geographic, xCol=2, yCol=2]
- W: Skipping line 2 because no valid coordinates have been found at columns CoordinateColumns [proj=WGS84 Geographic, xCol=2, yCol=2]


=== REPORTED CRASH DATA ===
BugReportExceptionHandler#handleException:
No data collected.

Warning issued by: BugReportExceptionHandler#handleException

=== STACK TRACE ===
Thread: AWT-EventQueue-1 (21) of JOSM
java.lang.NullPointerException
	at org.openstreetmap.josm.plugins.opendata.core.io.tabular.SpreadSheetReader.doParse(SpreadSheetReader.java:234)
	at org.openstreetmap.josm.plugins.opendata.core.io.tabular.SpreadSheetReader.parse(SpreadSheetReader.java:279)
	at org.openstreetmap.josm.plugins.opendata.core.io.tabular.OdsReader.parseDataSet(OdsReader.java:35)
	at org.openstreetmap.josm.plugins.opendata.core.io.tabular.OdsImporter.parseDataSet(OdsImporter.java:29)
	at org.openstreetmap.josm.io.OsmImporter.loadLayer(OsmImporter.java:113)
	at org.openstreetmap.josm.io.OsmImporter.importData(OsmImporter.java:90)
	at org.openstreetmap.josm.plugins.opendata.core.io.AbstractImporter.importData(AbstractImporter.java:55)
	at org.openstreetmap.josm.io.FileImporter.importDataHandleExceptions(FileImporter.java:90)
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.importData(OpenFileAction.java:349)
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.realRun(OpenFileAction.java:274)
	at org.openstreetmap.josm.gui.PleaseWaitRunnable.doRealRun(PleaseWaitRunnable.java:93)
	at org.openstreetmap.josm.gui.PleaseWaitRunnable.run(PleaseWaitRunnable.java:141)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
}}}
"	defect	closed	normal		Plugin opendata		fixed	template_report