Created attachment 116440 [details] Simple example of unsupported HTML page If you try to link to an external data source in an HTML format and the table contains <PRE></PRE> tags in some columns, the table is not loaded correctly. It looks like the <PRE> prevent calc from detecting the column tag <TD> (see example file provided). Web browsers like Firefox or IE don't have any problem displaying such table. The problem first appeared using an URL from web server, but can be reproduced with a simple html file. Unfortunately I can't prevent my data source (on the server) to put the useless <PRE> tag in the page code (it's a comercial product).
How do I do this "link to an external data source"? I tried with DDE function, but I got an error. https://help.libreoffice.org/4.4/Calc/Spreadsheet_Functions#DDE
Created attachment 116484 [details] printscreen LO 4.4.3, win7 I can load data with Insert->Link to external data Problem is empty row 6 and 7 or something else? Thanks
set back to Unconfirmed after you answer questions from comment 1 and comment 2. thank you.
Yes, open the attached file with Insert -> Link to external data select the file after clicking on "..." button then select Table_all (or something like that; unfortunately my LO now crash at this step with a message "application has stopped working"). The table loads but the cell with the <PRE> in the HTML source (i.e. Dat11 in table "wrong") is not loaded and a shift appear in the resulting table. Table correctly imported looks like this: +------+------+ | Col1 | Col2 | +------+------+ | Dat11| Dat12| +------+------+ | Dat21| Dat22| +------+------+ Wrong table looks like that: +------+------+ | Col1 | Col2 | +------+------+ | Dat12| | +------+------+ | Dat21| Dat22| +------+------+ As I mention it here above my LO now crash short after I start it so I can't reproduce or test more. I tried to "re install" it (I use a portable version on Windows) but still have the crash problem. Sorry for the ASCII art.
In 5.1 the menu item has changed to Sheet->Link to external data. Lang used for import: automatic From the available, I selected HTML_tables The only problem with the lower table is that there appears a gap of two empty rows before Dat21 and Dat22. So Dat11 is visible for me. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 437210d58f32177ef1829d704f7f4d2f1bbfbfdd TinderBox: Win-x86@39, Branch:master, Time: 2015-06-18_07:21:56 Locale: fi-FI (fi_FI)
Created attachment 116623 [details] Printscreen LO 4.4.3 I finally got my LO work again. So there is a screen shot of what I get.
(In reply to Jo Bobit from comment #6) > Created attachment 116623 [details] > Printscreen LO 4.4.3 > > I finally got my LO work again. > So there is a screen shot of what I get. So did you do the same as me, select HTML_tables from the list of available tables/ranges?
Created attachment 116626 [details] Example of HTML output from data server Yes, I select HTML_tables to get the result shown in the screen shot. But I just realize I used a slightly different HTML source file; the <PRE> tag was around the <TD></TD> not in between. Here is attached the "real" output of my data server (with <PRE> around <TD></TD>).
(In reply to Jo Bobit from comment #8) > Created attachment 116626 [details] > Example of HTML output from data server > > Yes, I select HTML_tables to get the result shown in the screen shot. > But I just realize I used a slightly different HTML source file; the > <PRE> tag was around the <TD></TD> not in between. > > Here is attached the "real" output of my data server (with <PRE> around > <TD></TD>). Ok, with this I do get the same result as you :) Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 437210d58f32177ef1829d704f7f4d2f1bbfbfdd TinderBox: Win-x86@39, Branch:master, Time: 2015-06-18_07:21:56 Locale: fi-FI (fi_FI)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
Created attachment 127678 [details] screenshot LO 5.2.1.2 I tested with LO 5.2.1.2 Portable (see screenshot added) and the bug is still there. I used Sheet->Link to External Data... pointed to the Example of HTML file and selected automatic language detection, then HTML_all. I got the same result (missing Dat11 in the second table). OS Name Microsoft Windows 7 Professional Version 6.1.7601 Service Pack 1 Build 7601 System Type x64-based PC
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I tested again the problem with the version 6.1.0 and the problem evolved a bit. I simply can't anymore link the file! When I try to link the test file, the dialog let me choose the file but do not detect any table in the file and the "Ok" stay disabled. So it's impossible to tell if the bug due to the PRE is still present. LibreOffice used: Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 8; OS: Windows 6.1; UI render: default; Locale: en-US (fr_CH); Calc: CL
(In reply to Jo Bobit from comment #11) > Created attachment 127678 [details] > screenshot LO 5.2.1.2 > > I tested with LO 5.2.1.2 Portable (see screenshot added) and the bug is > still there. > > I used Sheet->Link to External Data... pointed to the Example of HTML file > and selected automatic language detection, then HTML_all. > > I got the same result (missing Dat11 in the second table). I still repro with attachment 116626 [details] Arch Linux 64-bit Version: 6.1.1.2 Build ID: 6.1.1-1 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: d357ea1d1ff95cb5ce2ee6b4828afa2484707256 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; Locale: fi-FI (fi_FI.UTF-8); Calc: threaded Built on 28 September 2018
Dear Jo Bobit, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 170079 [details] Prinscreen from LO 7.1.1.1
Bug is still present. Version: 7.1.1.1 / LibreOffice Community Build ID: 575c5867c4cc13d7ae78f9ce39a54a52ed38c769 CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
Still reproducible in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 197e5f81213d14fdcbff40edf73385ecd4cd9815 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded With attachment 116626 [details], imported table in Calc misses cell B6. Can be imported by drag-and-dropping into Calc too.