Bug #15739 for OpenOffice-OODoc: oobuild produces empty spreadsheets

Sat Nov 12 17:35:19 2005 Guest - Ticket created

Subject:

oobuild produces empty spreadsheets

I cannot get data into the cells of a spreadsheet. I'm using version 2.014. I had the problem with a script I was writing but find I can reproduce the problem using oobuild: /usr/bin/oobuild zapme.ods --force --class spreadsheet \ --readable_XML --source - <<EOF Show quoted text

> 1;2;3;4 > 6;7;8;9 > hello > EOF

zapme.ods is attached. If the class is changed to 'text' then it works.

Download zapme.ods
application/vnd.oasis.opendocument.spreadsheet 5k

Message body not shown because it is not plain text.

Sun Nov 13 15:31:51 2005 jmgdoc [...] cpan.org - Taken

Sun Nov 13 15:41:42 2005 jmgdoc [...] cpan.org - Correspondence added

[guest - Sat Nov 12 17:35:19 2005]: Show quoted text

> I cannot get data into the cells of a spreadsheet. I'm using version > 2.014. I had the problem with a script I was writing but find I can > reproduce the problem using oobuild: > /usr/bin/oobuild zapme.ods --force --class spreadsheet \ > --readable_XML --source - <<EOF

> > 1;2;3;4 > > 6;7;8;9 > > hello > > EOF

> zapme.ods is attached. If the class is changed to 'text' then it > works.

Thanks for your report. You got a bug that prevents the cellValue() method to work when its first argument is a row object. This method is used in the oobuild example to populate the spreadsheet. This bug is fixed in the upcoming relase (2.015). As an immediate workaround, you can replace any cell addressing using a row element by the absolute addressing with table, row number and colomn number.

Sun Nov 13 15:43:12 2005 jmgdoc [...] cpan.org - Status changed from 'new' to 'resolved'