calc - insert - link to external data does not import correctly

[bt]

Binary package hint: openoffice.org

[I did not find item Help -> Report a Bug in my ooo calc menu]

1) UBUNTU release: Ubuntu 10.04 LTS
--------------------------
2) package version: openoffice.org-calc version 1:3.2.0-7ubuntu4
-------------------------
3 & 4) scenario description:
-----------------------------------
- download and then unzip file located here: http://dl.free.fr/qMH7eNCTQ (file test.html also attached to this bug report)
- in calc, select cell A1 and do : insert -> link to external data. Choose "test.html" from the unzipped files previously downloaded
- don't modify the options and click ok
- select "HTML_12" then click ok
- select cell A3 and do : insert -> link to external data. Choose "test.html" from the unzipped files previously downloaded
- don't modify the options and click ok
- select "HTML_13" then click ok

Expected behaviour:
---------------------------
Column A shall contain words from cell 1 to cell 40, cell A13 shall contain "Orvets" and cell A14 shall contain "Crevettes"

what happens:
-------------------
Cell A13 and A14 are empty.

A13 and A14 appear to be right below the end of column C.
HTML_12 and HTML_13 are nested sub tables of a single uppertable.

This is a regression, the import was working perfectly on Ubuntu 9.10 and OOO 3.1

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org (not installed)
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Fri May 14 10:23:32 2010
ProcEnviron:
 LANGUAGE=fr_FR:fr:en_GB:en
 LANG=fr_FR.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[Chris Cheney (ccheney)]

I'm not sure I understand what is happening with your output, can you please attach an example file with what it looks like for you and if you are able to do so with an example of what you think it should actually look like, with both labeled clearly so I can tell which one you think is correct.

Thanks,

Chris

[bt (web-bt)]

Adding two .ods files:

- bugged-result-with-ooo-3.2.ods -> the import done under ooo 3.2 (as I tried to explain in the description). This is the bugged output, with cells A13 and A14 being empty

- expected-result-as-with-ooo-3.1.ods -> The result of the same import as it was under ooo 3.0 and 3.1. This is also the result obtained by selecting the equivalent zones on the web page and pasting them on the sheet.

I hope this clarifies, let me know if I can help more.

Regards,
Bruno

[bt (web-bt)]

This is the file containing the expected output.
This is the output I was getting when using ooo 3.0 & ooo 3.1, and also when copying/pasting the contents of a part of the web page.
You can see cells A13 and A14 are containing text values

[bt (web-bt)]

This is the file containing the actual ooo 3.2 output, with the bug.
You can see cells A13 and A14 are empty instead of containing text values as shown in the expected result' attachment, or if you copy/paste the data from the web page

[bt (web-bt)]

zipped attachment containing:
- test2.html : the source web file that I modified to verify my hypothesis (explanations below)
- test-import2.ods : the result (bugged) of the import, which shows that hypothesis is valid.

Explanations:
The 2 imports I am doing are 2 tables from the html file (let's name them "Table-1" and "Table-2")
Table-1 and Table-2 are 1 column tables.
They are both contained in another table ("Table-3"): a 1 row - 2 columns table, Table-1 being in the left cell of Table-3 and Table-2 being in the right cell of Table-3
Drawing:

Table-3
+----------+----------+
| Table-1 | Table-2 |
| +------+ | +------+ |
| +------+ | +------+ |
| +------+ | +------+ |
| +------+ | |
| +------+ | |
| +------+ | |
| +------+ | |
+----------+----------+

In the attached version I changed the number of rows of Table-2
You can see in the 1st attachments (bugged-result-with-ooo-3.2.ods) as well as in test-import2.ods that there are 2 empty cells in the A column, the 1st always correspond to the 1st empty cell of C column (that is right after the last element of Table-2 in the html table.

I hope my explanations are clearer... If not don't hesitate to contact me, I can try to explain throught instant messaging tools for instance.
Regards

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.