/* -*- mode: java; c-basic-offset: 2; indent-tabs-mode: nil -*- */

/*

Part of the Processing project - http://processing.org

Copyright (c) 2011-13 Ben Fry and Casey Reas

Copyright (c) 2006-11 Ben Fry

This library is free software; you can redistribute it and/or

modify it under the terms of the GNU Lesser General Public

License version 2.1 as published by the Free Software Foundation.

This library is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU

Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General

Public License along with this library; if not, write to the

Free Software Foundation, Inc., 59 Temple Place, Suite 330,

Boston, MA 02111-1307 USA

*/

package processing.data;

import java.io.*;

import java.lang.reflect.*;

import java.nio.charset.Charset;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Types;

import java.util.*;

import java.util.concurrent.ExecutorService;

import java.util.concurrent.Executors;

import java.util.zip.ZipEntry;

import java.util.zip.ZipInputStream;

import java.util.zip.ZipOutputStream;

import javax.xml.parsers.ParserConfigurationException;

import org.xml.sax.SAXException;

import processing.core.PApplet;

import processing.core.PConstants;

/**

* <b>Table</b> objects store data with multiple rows and columns, much like in

* a traditional spreadsheet. Tables can be generated from scratch, dynamically,

* or using data from an existing file. Tables can also be output and saved to

* disk, as in the example above.<br />

* <br />

* Additional <b>Table</b> methods are documented in the <a href=

* "http://processing.github.io/processing-javadocs/core/processing/data/Table.html">Processing

* Table Javadoc</a>.

*

* <h3>Advanced</h3>

* <p>

* Generic class for handling tabular data, typically from a CSV, TSV, or other

* sort of spreadsheet file.

* </p>

* <p>

* CSV files are

* <a href="http://en.wikipedia.org/wiki/Comma-separated_values">comma separated

* values</a>, often with the data in quotes. TSV files use tabs as separators,

* and usually don't bother with the quotes.

* </p>

* <p>

* File names should end with .csv if they're comma separated.

* </p>

* <p>

* A rough "spec" for CSV can be found

* <a href="http://tools.ietf.org/html/rfc4180">here</a>.

* </p>

*

* @webref data:composite

* @webBrief Generic class for handling tabular data, typically from a CSV, TSV,

* or other sort of spreadsheet file

* @see PApplet#loadTable(String)

* @see PApplet#saveTable(Table, String)

* @see TableRow

*/

public class Table {

protected int rowCount;

protected String missingString = null;

protected int missingInt = 0;

protected long missingLong = 0;

protected float missingFloat = Float.NaN;

protected double missingDouble = Double.NaN;

protected int missingCategory = -1;

String[] columnTitles;

HashMapBlows[] columnCategories;

HashMap<String, Integer> columnIndices;

protected Object[] columns; // [column]

// accessible for advanced users

static public final int STRING = 0;

static public final int INT = 1;

static public final int LONG = 2;

static public final int FLOAT = 3;

static public final int DOUBLE = 4;

static public final int CATEGORY = 5;

int[] columnTypes;

protected RowIterator rowIterator;

// 0 for doubling each time, otherwise the number of rows to increment on

// each expansion.

protected int expandIncrement;

/**

* Creates a new, empty table. Use addRow() to add additional rows.

*/

public Table() {

init();

}

/**

* @nowebref

*/

public Table(File file) throws IOException {

this(file, null);

}

/**

* version that uses a File object; future releases (or data types)

* may include additional optimizations here

*

* @nowebref

*/

public Table(File file, String options) throws IOException {

// uses createInput() to handle .gz (and eventually .bz2) files

init();

parse(PApplet.createInput(file),

extensionOptions(true, file.getName(), options));

}

/**

* @nowebref

*/

public Table(InputStream input) throws IOException {

this(input, null);

}

/**

* Read the table from a stream. Possible options include:

* <ul>

* <li>csv - parse the table as comma-separated values

* <li>tsv - parse the table as tab-separated values

* <li>newlines - this CSV file contains newlines inside individual cells

* <li>header - this table has a header (title) row

* </ul>

*

* @nowebref

* @param input

* @param options

* @throws IOException

*/

public Table(InputStream input, String options) throws IOException {

init();

parse(input, options);

}

public Table(Iterable<TableRow> rows) {

init();

int row = 0;

int alloc = 10;

for (TableRow incoming : rows) {

if (row == 0) {

setColumnTypes(incoming.getColumnTypes());

setColumnTitles(incoming.getColumnTitles());

// Do this after setting types, otherwise it'll attempt to parse the

// allocated but empty rows, and drive CATEGORY columns nutso.

setRowCount(alloc);

// sometimes more columns than titles (and types?)

setColumnCount(incoming.getColumnCount());

} else if (row == alloc) {

// Far more efficient than re-allocating all columns and doing a copy

alloc *= 2;

setRowCount(alloc);

}

//addRow(row);

// try {

setRow(row++, incoming);

// } catch (ArrayIndexOutOfBoundsException aioobe) {

// for (int i = 0; i < incoming.getColumnCount(); i++) {

// System.out.format("[%d] %s%n", i, incoming.getString(i));

// }

// throw aioobe;

// }

}

// Shrink the table to only the rows that were used

if (row != alloc) {

setRowCount(row);

}

}

/**

* @nowebref

*/

public Table(ResultSet rs) {

init();

try {

ResultSetMetaData rsmd = rs.getMetaData();

int columnCount = rsmd.getColumnCount();

setColumnCount(columnCount);

for (int col = 0; col < columnCount; col++) {

setColumnTitle(col, rsmd.getColumnName(col + 1));

int type = rsmd.getColumnType(col + 1);

switch (type) { // TODO these aren't tested. nor are they complete.

case Types.VARCHAR:

case Types.CHAR:

case Types.BLOB:

setColumnType(col, STRING);

break;

case Types.INTEGER:

case Types.TINYINT:

case Types.SMALLINT:

setColumnType(col, INT);

break;

case Types.BIGINT:

setColumnType(col, LONG);

break;

case Types.FLOAT:

setColumnType(col, FLOAT);

break;

case Types.DECIMAL:

case Types.DOUBLE:

case Types.REAL:

setColumnType(col, DOUBLE);

break;

}

}

int row = 0;

while (rs.next()) {

for (int col = 0; col < columnCount; col++) {

switch (columnTypes[col]) {

case STRING: setString(row, col, rs.getString(col+1)); break;

case INT: setInt(row, col, rs.getInt(col+1)); break;

case LONG: setLong(row, col, rs.getLong(col+1)); break;

case FLOAT: setFloat(row, col, rs.getFloat(col+1)); break;

case DOUBLE: setDouble(row, col, rs.getDouble(col+1)); break;

default: throw new IllegalArgumentException("column type " + columnTypes[col] + " not supported.");

}

}

row++;

// String[] row = new String[columnCount];

// for (int col = 0; col < columnCount; col++) {

// row[col] = rs.get(col + 1);

// }

// addRow(row);

}

} catch (SQLException s) {

throw new RuntimeException(s);

}

}

public Table typedParse(InputStream input, String options) throws IOException {

Table table = new Table();

table.setColumnTypes(this);

table.parse(input, options);

return table;

}

protected void init() {

columns = new Object[0];

columnTypes = new int[0];

columnCategories = new HashMapBlows[0];

}

/*

protected String checkOptions(File file, String options) throws IOException {

String extension = null;

String filename = file.getName();

int dotIndex = filename.lastIndexOf('.');

if (dotIndex != -1) {

extension = filename.substring(dotIndex + 1).toLowerCase();

if (!extension.equals("csv") &&

!extension.equals("tsv") &&

!extension.equals("html") &&

!extension.equals("bin")) {

// ignore extension

extension = null;

}

}

if (extension == null) {

if (options == null) {

throw new IOException("This table filename has no extension, and no options are set.");

}

} else { // extension is not null

if (options == null) {

options = extension;

} else {

// prepend the extension, it will be overridden if there's an option for it.

options = extension + "," + options;

}

}

return options;

}

*/

static final String[] loadExtensions = { "csv", "tsv", "ods", "bin" };

static final String[] saveExtensions = { "csv", "tsv", "ods", "bin", "html" };

static public String extensionOptions(boolean loading, String filename, String options) {

String extension = PApplet.checkExtension(filename);

if (extension != null) {

for (String possible : loading ? loadExtensions : saveExtensions) {

if (extension.equals(possible)) {

if (options == null) {

return extension;

} else {

// prepend the extension to the options (will be replaced by other

// options that override it later in the load loop)

return extension + "," + options;

}

}

}

}

return options;

}

protected void parse(InputStream input, String options) throws IOException {

// boolean awfulCSV = false;

boolean header = false;

String extension = null;

boolean binary = false;

String encoding = "UTF-8";

String worksheet = null;

final String sheetParam = "worksheet=";

String[] opts = null;

if (options != null) {

opts = PApplet.trim(PApplet.split(options, ','));

for (String opt : opts) {

if (opt.equals("tsv")) {

extension = "tsv";

} else if (opt.equals("csv")) {

extension = "csv";

} else if (opt.equals("ods")) {

extension = "ods";

} else if (opt.equals("newlines")) {

//awfulCSV = true;

//extension = "csv";

throw new IllegalArgumentException("The 'newlines' option is no longer necessary.");

} else if (opt.equals("bin")) {

binary = true;

extension = "bin";

} else if (opt.equals("header")) {

header = true;

} else if (opt.startsWith(sheetParam)) {

worksheet = opt.substring(sheetParam.length());

} else if (opt.startsWith("dictionary=")) {

// ignore option, this is only handled by PApplet

} else if (opt.startsWith("encoding=")) {

encoding = opt.substring(9);

} else {

throw new IllegalArgumentException("'" + opt + "' is not a valid option for loading a Table");

}

}

}

if (extension == null) {

throw new IllegalArgumentException("No extension specified for this Table");

}

if (binary) {

loadBinary(input);

} else if (extension.equals("ods")) {

odsParse(input, worksheet, header);

} else {

InputStreamReader isr = new InputStreamReader(input, encoding);

BufferedReader reader = new BufferedReader(isr);

// strip out the Unicode BOM, if present

reader.mark(1);

int c = reader.read();

// if not the BOM, back up to the beginning again

if (c != '\uFEFF') {

reader.reset();

}

/*

if (awfulCSV) {

parseAwfulCSV(reader, header);

} else if ("tsv".equals(extension)) {

parseBasic(reader, header, true);

} else if ("csv".equals(extension)) {

parseBasic(reader, header, false);

}

*/

parseBasic(reader, header, "tsv".equals(extension));

}

}

protected void parseBasic(BufferedReader reader,

boolean header, boolean tsv) throws IOException {

String line = null;

int row = 0;

if (rowCount == 0) {

setRowCount(10);

}

//int prev = 0; //-1;

try {

while ((line = reader.readLine()) != null) {

if (row == getRowCount()) {

setRowCount(row << 1);

}

if (row == 0 && header) {

setColumnTitles(tsv ? PApplet.split(line, '\t') : splitLineCSV(line, reader));

header = false;

} else {

setRow(row, tsv ? PApplet.split(line, '\t') : splitLineCSV(line, reader));

row++;

}

if (row % 10000 == 0) {

/*

// this is problematic unless we're going to calculate rowCount first

if (row < rowCount) {

int pct = (100 * row) / rowCount;

if (pct != prev) { // also prevents "0%" from showing up

System.out.println(pct + "%");

prev = pct;

}

}

*/

try {

// Sleep this thread so that the GC can catch up

Thread.sleep(10);

} catch (InterruptedException e) {

e.printStackTrace();

}

}

}

} catch (Exception e) {

throw new RuntimeException("Error reading table on line " + row, e);

}

// shorten or lengthen based on what's left

if (row != getRowCount()) {

setRowCount(row);

}

}

// public void convertTSV(BufferedReader reader, File outputFile) throws IOException {

// convertBasic(reader, true, outputFile);

// }

/*

protected void parseAwfulCSV(BufferedReader reader,

boolean header) throws IOException {

char[] c = new char[100];

int count = 0;

boolean insideQuote = false;

int alloc = 100;

setRowCount(100);

int row = 0;

int col = 0;

int ch;

while ((ch = reader.read()) != -1) {

if (insideQuote) {

if (ch == '\"') {

// this is either the end of a quoted entry, or a quote character

reader.mark(1);

if (reader.read() == '\"') {

// it's "", which means a quote character

if (count == c.length) {

c = PApplet.expand(c);

}

c[count++] = '\"';

} else {

// nope, just the end of a quoted csv entry

reader.reset();

insideQuote = false;

// TODO nothing here that prevents bad csv data from showing up

// after the quote and before the comma...

// set(row, col, new String(c, 0, count));

// count = 0;

// col++;

// insideQuote = false;

}

} else { // inside a quote, but the character isn't a quote

if (count == c.length) {

c = PApplet.expand(c);

}

c[count++] = (char) ch;

}

} else { // not inside a quote

if (ch == '\"') {

insideQuote = true;

} else if (ch == '\r' || ch == '\n') {

if (ch == '\r') {

// check to see if next is a '\n'

reader.mark(1);

if (reader.read() != '\n') {

reader.reset();

}

}

setString(row, col, new String(c, 0, count));

count = 0;

row++;

if (row == 1 && header) {

// Use internal row removal (efficient because only one row).

removeTitleRow();

// Un-set the header variable so that next time around, we don't

// just get stuck into a loop, removing the 0th row repeatedly.

header = false;

// Reset the number of rows (removeTitleRow() won't reset our local 'row' counter)

row = 0;

}

// if (row % 1000 == 0) {

// PApplet.println(PApplet.nfc(row));

// }

if (row == alloc) {

alloc *= 2;

setRowCount(alloc);

}

col = 0;

} else if (ch == ',') {

setString(row, col, new String(c, 0, count));

count = 0;

// starting a new column, make sure we have room

col++;

ensureColumn(col);

} else { // just a regular character, add it

if (count == c.length) {

c = PApplet.expand(c);

}

c[count++] = (char) ch;

}

}

}

// catch any leftovers

if (count > 0) {

setString(row, col, new String(c, 0, count));

}

row++; // set row to row count (the current row index + 1)

if (alloc != row) {

setRowCount(row); // shrink to the actual size

}

}

*/

static class CommaSeparatedLine {

char[] c;

String[] pieces;

int pieceCount;

// int offset;

int start; //, stop;

String[] handle(String line, BufferedReader reader) throws IOException {

// PApplet.println("handle() called for: " + line);

start = 0;

pieceCount = 0;

c = line.toCharArray();

// get tally of number of columns and allocate the array

int cols = 1; // the first comma indicates the second column

boolean quote = false;

for (int i = 0; i < c.length; i++) {

if (!quote && (c[i] == ',')) {

cols++;

} else if (c[i] == '\"') {

// double double quotes (escaped quotes like "") will simply toggle

// this back and forth, so it should remain accurate

quote = !quote;

}

}

pieces = new String[cols];

// while (offset < c.length) {

// start = offset;

while (start < c.length) {

boolean enough = ingest();

while (!enough) {

// found a newline inside the quote, grab another line

String nextLine = reader.readLine();

// System.out.println("extending to " + nextLine);

if (nextLine == null) {

// System.err.println(line);

throw new IOException("Found a quoted line that wasn't terminated properly.");

}

// for simplicity, not bothering to skip what's already been read

// from c (and reset the offset to 0), opting to make a bigger array

// with both lines.

char[] temp = new char[c.length + 1 + nextLine.length()];

PApplet.arrayCopy(c, temp, c.length);

// NOTE: we're converting to \n here, which isn't perfect

temp[c.length] = '\n';

nextLine.getChars(0, nextLine.length(), temp, c.length + 1);

// c = temp;

return handle(new String(temp), reader);

//System.out.println(" full line is now " + new String(c));

//stop = nextComma(c, offset);

//System.out.println("stop is now " + stop);

//enough = ingest();

}

}

// Make any remaining entries blanks instead of nulls. Empty columns from

// CSV are always "" not null, so this handles successive commas in a line

for (int i = pieceCount; i < pieces.length; i++) {

pieces[i] = "";

}

// PApplet.printArray(pieces);

return pieces;

}

protected void addPiece(int start, int stop, boolean quotes) {

if (quotes) {

int dest = start;

for (int i = start; i < stop; i++) {

if (c[i] == '\"') {

++i; // step over the quote

}

if (i != dest) {

c[dest] = c[i];

}

dest++;

}

pieces[pieceCount++] = new String(c, start, dest - start);

} else {

pieces[pieceCount++] = new String(c, start, stop - start);

}

}

/**

* Returns the next comma (not inside a quote) in the specified array.

* @param c array to search

* @param index offset at which to start looking

* @return index of the comma, or -1 if line ended inside an unclosed quote

*/

protected boolean ingest() {

boolean hasEscapedQuotes = false;

// not possible

// if (index == c.length) { // we're already at the end

// return c.length;

// }

boolean quoted = c[start] == '\"';

if (quoted) {

start++; // step over the quote

}

int i = start;

while (i < c.length) {

// PApplet.println(c[i] + " i=" + i);

if (c[i] == '\"') {

// if this fella started with a quote

if (quoted) {

if (i == c.length-1) {

// closing quote for field; last field on the line

addPiece(start, i, hasEscapedQuotes);

start = c.length;

return true;

} else if (c[i+1] == '\"') {

// an escaped quote inside a quoted field, step over it

hasEscapedQuotes = true;

i += 2;

} else if (c[i+1] == ',') {

// that was our closing quote, get outta here

addPiece(start, i, hasEscapedQuotes);

start = i+2;

return true;

} else {

// This is a lone-wolf quote, occasionally seen in exports.

// It's a single quote in the middle of some other text,

// and not escaped properly. Pray for the best!

i++;

}

} else { // not a quoted line

if (i == c.length-1) {

// we're at the end of the line, can't have an unescaped quote

throw new RuntimeException("Unterminated quote at end of line");

} else if (c[i+1] == '\"') {

// step over this crummy quote escape

hasEscapedQuotes = true;

i += 2;

} else {

throw new RuntimeException("Unterminated quoted field mid-line");

}

}

} else if (!quoted && c[i] == ',') {

addPiece(start, i, hasEscapedQuotes);

start = i+1;

return true;

} else if (!quoted && i == c.length-1) {

addPiece(start, c.length, hasEscapedQuotes);

start = c.length;

return true;

} else { // nothing all that interesting

i++;

}

}

// if (!quote && (c[i] == ',')) {

// // found a comma, return this location

// return i;

// } else if (c[i] == '\"') {

// // if it's a quote, then either the next char is another quote,

// // or if this is a quoted entry, it better be a comma

// quote = !quote;

// }

// }

// if still inside a quote, indicate that another line should be read

if (quoted) {

return false;

}

// // made it to the end of the array with no new comma

// return c.length;

throw new RuntimeException("not sure how...");

}

}

CommaSeparatedLine csl;

/**

* Parse a line of text as comma-separated values, returning each value as

* one entry in an array of String objects. Remove quotes from entries that

* begin and end with them, and convert 'escaped' quotes to actual quotes.

* @param line line of text to be parsed

* @return an array of the individual values formerly separated by commas

*/

protected String[] splitLineCSV(String line, BufferedReader reader) throws IOException {

if (csl == null) {

csl = new CommaSeparatedLine();

}

return csl.handle(line, reader);

}

/**

* Returns the next comma (not inside a quote) in the specified array.

* @param c array to search

* @param index offset at which to start looking

* @return index of the comma, or -1 if line ended inside an unclosed quote

*/

/*

static protected int nextComma(char[] c, int index) {

if (index == c.length) { // we're already at the end

return c.length;

}

boolean quoted = c[index] == '\"';

if (quoted) {

index++; // step over the quote

}

for (int i = index; i < c.length; i++) {

if (c[i] == '\"') {

// if this fella started with a quote

if (quoted) {

if (i == c.length-1) {

//return -1; // ran out of chars

// closing quote for field; last field on the line

return c.length;

} else if (c[i+1] == '\"') {

// an escaped quote inside a quoted field, step over it

i++;

} else if (c[i+1] == ',') {

// that's our closing quote, get outta here

return i+1;

}

} else { // not a quoted line

if (i == c.length-1) {

// we're at the end of the line, can't have an unescaped quote

//return -1; // ran out of chars

throw new RuntimeException("Unterminated quoted field at end of line");

} else if (c[i+1] == '\"') {

// step over this crummy quote escape

++i;

} else {

throw new RuntimeException("Unterminated quoted field mid-line");

}

}

} else if (!quoted && c[i] == ',') {

return i;

}

if (!quote && (c[i] == ',')) {

// found a comma, return this location

return i;

} else if (c[i] == '\"') {

// if it's a quote, then either the next char is another quote,

// or if this is a quoted entry, it better be a comma

quote = !quote;

}

}

// if still inside a quote, indicate that another line should be read

if (quote) {

return -1;

}

// made it to the end of the array with no new comma

return c.length;

}

*/

/**

* Read a .ods (OpenDoc spreadsheet) zip file from an InputStream, and

* return the InputStream for content.xml contained inside.

*/

private InputStream odsFindContentXML(InputStream input) {

ZipInputStream zis = new ZipInputStream(input);

ZipEntry entry = null;

try {

while ((entry = zis.getNextEntry()) != null) {

if (entry.getName().equals("content.xml")) {

return zis;

}

}

} catch (IOException e) {

e.printStackTrace();

}

return null;

}

protected void odsParse(InputStream input, String worksheet, boolean header) {

try {

InputStream contentStream = odsFindContentXML(input);

XML xml = new XML(contentStream);

// table files will have multiple sheets..

// <table:table table:name="Sheet1" table:style-name="ta1" table:print="false">

// <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">

// <table:table table:name="Sheet3" table:style-name="ta1" table:print="false">

XML[] sheets =

xml.getChildren("office:body/office:spreadsheet/table:table");

boolean found = false;

for (XML sheet : sheets) {

// System.out.println(sheet.getAttribute("table:name"));

if (worksheet == null || worksheet.equals(sheet.getString("table:name"))) {

odsParseSheet(sheet, header);

found = true;

if (worksheet == null) {

break; // only read the first sheet

}

}

}

if (!found) {

if (worksheet == null) {

throw new RuntimeException("No worksheets found in the ODS file.");

} else {

throw new RuntimeException("No worksheet named " + worksheet +

" found in the ODS file.");

}

}

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} catch (ParserConfigurationException e) {

e.printStackTrace();

} catch (SAXException e) {

e.printStackTrace();

}

}

/**

* Parses a single sheet of XML from this file.

* @param The XML object for a single worksheet from the ODS file

*/

private void odsParseSheet(XML sheet, boolean header) {

// Extra <p> or <a> tags inside the text tag for the cell will be stripped.

// Different from showing formulas, and not quite the same as 'save as

// displayed' option when saving from inside OpenOffice. Only time we

// wouldn't want this would be so that we could parse hyperlinks and

// styling information intact, but that's out of scope for the p5 version.

final boolean ignoreTags = true;

XML[] rows = sheet.getChildren("table:table-row");

//xml.getChildren("office:body/office:spreadsheet/table:table/table:table-row");

int rowIndex = 0;

for (XML row : rows) {

int rowRepeat = row.getInt("table:number-rows-repeated", 1);

// if (rowRepeat != 1) {

// System.out.println(rowRepeat + " " + rowCount + " " + (rowCount + rowRepeat));

// }

boolean rowNotNull = false;

XML[] cells = row.getChildren();

int columnIndex = 0;

for (XML cell : cells) {

int cellRepeat = cell.getInt("table:number-columns-repeated", 1);

// <table:table-cell table:formula="of:=SUM([.E7:.E8])" office:value-type="float" office:value="4150">

// <text:p>4150.00</text:p>

// </table:table-cell>

String cellData = ignoreTags ? cell.getString("office:value") : null;

// if there's an office:value in the cell, just roll with that

if (cellData == null) {

int cellKids = cell.getChildCount();

if (cellKids != 0) {

XML[] paragraphElements = cell.getChildren("text:p");

if (paragraphElements.length != 1) {

for (XML el : paragraphElements) {

System.err.println(el.toString());

}

throw new RuntimeException("found more than one text:p element");

}

XML textp = paragraphElements[0];

String textpContent = textp.getContent();

// if there are sub-elements, the content shows up as a child element

// (for which getName() returns null.. which seems wrong)

if (textpContent != null) {

cellData = textpContent; // nothing fancy, the text is in the text:p element

} else {

XML[] textpKids = textp.getChildren();

StringBuilder cellBuffer = new StringBuilder();

for (XML kid : textpKids) {

String kidName = kid.getName();

if (kidName == null) {

odsAppendNotNull(kid, cellBuffer);

} else if (kidName.equals("text:s")) {

int spaceCount = kid.getInt("text:c", 1);

for (int space = 0; space < spaceCount; space++) {

cellBuffer.append(' ');

}

} else if (kidName.equals("text:span")) {

odsAppendNotNull(kid, cellBuffer);

} else if (kidName.equals("text:a")) {

// <text:a xlink:href="http://blah.com/">blah.com</text:a>

if (ignoreTags) {

cellBuffer.append(kid.getString("xlink:href"));

} else {

odsAppendNotNull(kid, cellBuffer);

}

} else {

odsAppendNotNull(kid, cellBuffer);

System.err.println(getClass().getName() + ": don't understand: " + kid);

//throw new RuntimeException("I'm not used to this.");

}

}

cellData = cellBuffer.toString();

}

//setString(rowIndex, columnIndex, c); //text[0].getContent());

//columnIndex++;

}

}

for (int r = 0; r < cellRepeat; r++) {

if (cellData != null) {

//System.out.println("setting " + rowIndex + "," + columnIndex + " to " + cellData);

setString(rowIndex, columnIndex, cellData);

}

columnIndex++;

if (cellData != null) {

// if (columnIndex > columnMax) {