Bug #21695 for OpenOffice-OODoc: unwanted union of cells (probably bug)

Mon Sep 25 07:45:58 2006 ostrochovsky [...] rec.uniba.sk - Ticket created

Subject:	unwanted union of cells (probably bug)
Date:	Mon, 25 Sep 2006 13:48:03 +0200
To:	bug-OpenOffice-OODoc [...] rt.cpan.org
From:	Jan Ostrochovsky <ostrochovsky [...] rec.uniba.sk>

Hello, I am very happy to use OpenOffice::OODoc and want to help to make it more perfect, so: When 2 or more neighbour cells have equal values, parser evaluate it like one cell. Save attached script and ods file to the same directory a run it from there this way: ./testbug2.pl testbug2.ods import ('import' is name of the sheet). Temporary workaround is insert another columns between columns, which can have equal neighbour values. My enviroment specific information: ODS file creator: OpenOffice 2.0.2 (Slovak) at SUSE Linux 10.1 (Slovak environment, UTF-8) ODS file parser: OpenOffice::OODoc 2.028 and Perl: v5.8.7 at Mandrake Linux 9.1 2.4.21-0.13mdk I tried various numeric, alphanumeric and other values, and it seems, that this bug is also determined with spellcheck (in my case Slovak) - look also attached screenshot - red underlined cells are evaluated as with wrong spelling by Slovak spellcheck. And these wrong spelling values are not target of this bug (!). All other (not underlined) values are befallen by this bug, because output of the script above is here: [root@tuxracer import]# ./testbug2.pl testbug2.ods import 1 at ./testbug2.pl line 26. 1 2 at ./testbug2.pl line 26. 1 2 3 at ./testbug2.pl line 26. 1 2 3 4 at ./testbug2.pl line 26. 1 2 3 4 at ./testbug2.pl line 26. 1 2 3 4 3 at ./testbug2.pl line 26. 2 3 4 3 2 at ./testbug2.pl line 26. a at ./testbug2.pl line 26. X at ./testbug2.pl line 26. ; at ./testbug2.pl line 26. ;; at ./testbug2.pl line 26. aa aa aa aa aa aa at ./testbug2.pl line 26. XX xx XX at ./testbug2.pl line 26. XXX at ./testbug2.pl line 26. bb bb bb bb bb bb at ./testbug2.pl line 26. ff ff ff ff ff ff at ./testbug2.pl line 26. ii at ./testbug2.pl line 26. iii at ./testbug2.pl line 26. XXXX at ./testbug2.pl line 26. XXXXXXX at ./testbug2.pl line 26. iiii iiii iiii iiii iiii iiii at ./testbug2.pl line 26. L at ./testbug2.pl line 26. LLLLLL at ./testbug2.pl line 26. EEEEEEE at ./testbug2.pl line 26. NNNNN at ./testbug2.pl line 26. eeeeee eeeeee eeeeee eeeeee eeeeee eeeeee at ./testbug2.pl line 26. B at ./testbug2.pl line 26. BEHEHE at ./testbug2.pl line 26. BeHEHE BeHEHE BeHEHE BeHEHE BeHEHE BeHEHE at ./testbug2.pl line 26. Thanks in advance! Have a nice day. ostry

Download testbug2.ZIP
application/zip 111.9k

Message body not shown because it is not plain text.

Sat Sep 30 09:54:00 2006 jmgdoc [...] cpan.org - Correspondence added

From:

JMGDOC [...] cpan.org

Hello, It's not a bug. Everything works in your script as soon as the following intruction is inserted in the beginning of the loop, i.e. before getTableRows(): $doc->normalizeSheet($sheet, 30, 6); Knowing that OpenOffice.org Calc can store many neighbour cells with equal values in a single XML element, and that the used area of a spreadsheet is unknown, normalizeSheet() is a pre-processing method wich rebuilds the XML storage in order to prepair a rectangular area where the direct cell addressing safely works. For more details, I recommend you to read the getTable() and normalizeSheet() sections in the OpenOffice::OODoc::Text manual chapter http://search.cpan.org/dist/OpenOffice-OODoc/OODoc/Text.pod Le Lun. Sep. 25 07:45:58 2006, ostrochovsky@rec.uniba.sk a écrit : Show quoted text

> Hello, > > I am very happy to use OpenOffice::OODoc and want to help to make it > more perfect, so: > > When 2 or more neighbour cells have equal values, parser evaluate it > like one cell. Save attached script and ods file to the same directory a > run it from there this way: ./testbug2.pl testbug2.ods import ('import' > is name of the sheet). > > Temporary workaround is insert another columns between columns, which > can have equal neighbour values. My enviroment specific information: > > ODS file creator: > OpenOffice 2.0.2 (Slovak) at SUSE Linux 10.1 (Slovak environment, UTF-8) > > ODS file parser: > OpenOffice::OODoc 2.028 and Perl: v5.8.7 at Mandrake Linux 9.1 > 2.4.21-0.13mdk > > I tried various numeric, alphanumeric and other values, and it seems, > that this bug is also determined with spellcheck (in my case Slovak) - > look also attached screenshot - red underlined cells are evaluated as > with wrong spelling by Slovak spellcheck. And these wrong spelling > values are not target of this bug (!). All other (not underlined) values > are befallen by this bug, because output of the script above is here: > > [root@tuxracer import]# ./testbug2.pl testbug2.ods import > 1 at ./testbug2.pl line 26. > 1 2 at ./testbug2.pl line 26. > 1 2 3 at ./testbug2.pl line 26. > 1 2 3 4 at ./testbug2.pl line 26. > 1 2 3 4 at ./testbug2.pl line 26. > 1 2 3 4 3 at ./testbug2.pl line 26. > 2 3 4 3 2 at ./testbug2.pl line 26. > a at ./testbug2.pl line 26. > X at ./testbug2.pl line 26. > ; at ./testbug2.pl line 26. > ;; at ./testbug2.pl line 26. > aa aa aa aa aa aa at ./testbug2.pl line 26. > XX xx XX at ./testbug2.pl line 26. > XXX at ./testbug2.pl line 26. > bb bb bb bb bb bb at ./testbug2.pl line 26. > ff ff ff ff ff ff at ./testbug2.pl line 26. > ii at ./testbug2.pl line 26. > iii at ./testbug2.pl line 26. > XXXX at ./testbug2.pl line 26. > XXXXXXX at ./testbug2.pl line 26. > iiii iiii iiii iiii iiii iiii at ./testbug2.pl line 26. > L at ./testbug2.pl line 26. > LLLLLL at ./testbug2.pl line 26. > EEEEEEE at ./testbug2.pl line 26. > NNNNN at ./testbug2.pl line 26. > eeeeee eeeeee eeeeee eeeeee eeeeee eeeeee at ./testbug2.pl line 26. > B at ./testbug2.pl line 26. > BEHEHE at ./testbug2.pl line 26. > BeHEHE BeHEHE BeHEHE BeHEHE BeHEHE BeHEHE at ./testbug2.pl line 26. > > Thanks in advance! > > Have a nice day. > > ostry

Sat Sep 30 09:54:01 2006 The RT System itself - Status changed from 'new' to 'open'

Sat Sep 30 09:56:24 2006 jmgdoc [...] cpan.org - Status changed from 'open' to 'resolved'