too many characters in zt2009?

rossmounce / NHM-specimens

Aggregating & linking-up mentions of Natural History Museum, London specimens in the literature to specimen identifiers

Creative Commons Zero v1.0 Universal

3 stars 2 forks source link

too many characters in zt2009? #8

Open AimeRankin opened 8 years ago

AimeRankin commented 8 years ago

Hi @rossmounce

I'm back to work but LibreOffice doesn't seem to like the zt2009 file. When I try to open the file it says "The data could not be loaded completely because the maximum number of characters per cell was exceeded.". If I ignore this and open it anyway, a block appears at the end of the spreadsheet (same problem in zt2007 I think). Looking at the file, I can't seem to find any rows with an excessive amount of characters - any ideas?

rossmounce commented 8 years ago

I'll try and get this fixed today.

rossmounce commented 8 years ago

Seems to work for me. Maybe untick "quoted fields as text" ? If not, then please report the line/row number you can get down to (before the block) when it opens in LibreOffice Calc

AimeRankin commented 8 years ago

Hm, it's still not opening properly for me. The last row in zt2009 is row 1587 - the study of appendages and postabdomen. In the case of GOS and NHM, a single female from a tube of type

The last row I can get to in zt2007 is row 1800 - ‘12000ft (equal to 3657m)’ and ‘30.VI.1924’ (BMNH); 1 male, CHINA, Tibet, Nyalam County, 4300m