Created attachment 47586 [details] XLS file containing HTML table (from ZuluTrade) Hello, I found on some websites .xls file that contain HTML table. See attachment of such file that can be found on Tradency or ZuluTrade. Using MS Office, these kind of file are opened with Excel... and not Word It should be the same with LibreOffice. (because there are opened with Writer instead of Spreadsheet even when I click on File menu/Open in Spreadsheet !) Kind regards
Created attachment 47587 [details] XLS file containing HTML table (from Tradency)
Reproduced with Ubuntu 10.04.2 x86 LO 3.4 Opens in Calc with double click. Opens in Writer with drag-n-drop, File->Open, "open with" and command line.
I'm using Mac OS X 10.6.7
Created attachment 47927 [details] Another kind of file which open with Excel... but not with OpenOffice Calc
NOT reproducible with any of the first 3 smaple documents and "LibreOffice 3.4.1RC1 – WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:101)]". I opened documents directly from Seamonkey browser with LibO. OS related or fixed in between? Modified OS due to Comment 2 I will assign due to several confirmations. I am pretty sure that I saw a similar bug few time ago, but I can't find it. @scls19fr: Please always contribute information concerning your LibO version and localization! @Kohei: Please feel free to reassign if it’s not your area or if provided information is not sufficient.
I'm using now LibreOffice 3.4.0 OOO340m1 (Build:12) French localization under Mac OS but I don't think it is OS related because as I have the same problem with Windows XP.
Created attachment 48580 [details] Automated 'read out' from a remote fuel tank gauage Loads blank sheet. if opened as 'read only' sometimes the data is displayed, but as you would expect, does not permit editing.
Hi, this was previously fixed in Open Office 3.2 so can we class as a regression? the original fault was fixed under http://openoffice.org/bugzilla/show_bug.cgi?id=89332 David
I doubt that problem from Comment 7 is the same as reported, but might be related.
Created attachment 51256 [details] another exaple of the spreadsheet format that doesn't load in Calc
Hi all, I have updated the affected version - as I have tested in 3.4.3 OOO340m1 (Build:302) running on Windows 7 and Windows Vista 32bit. I have attached a sample file. Expected behaviour - open with Calc, should load as a 'normal' spreadsheet. result - Calc loads and opens with a blank spreadsheet with no data. Workaround - change 'default program' to sweb.exe. Content loads and is 'readable', however this cannot be edited as would be possible under Calc. This issue has been going on for some time now and has been present in several point versions, so I would like to see if we can get this addressed. David
Known issue. A workaround is to open it from Explorer (if you are on Windows) and specify Calc as the application to open it. The reason is that, LibreOffice determines which app to open an HTML file solely based on the file content, which is HTML in this case, regardless of where you open the file from. The extension plays a very little role here unfortunately. This is in fact a long standing issue dating back to the very old version of OOo. I remember this because I filed the same bug against OOo many years ago. To fix this, we need to send from which app the file is being opened, to the file detection code, and use it as a hint in case the file format alone cannot determine which app should open the file (which HTML file format is a prime example). We already do something similar when opening a file from the command line when --calc option is passed. Anyway this is not a Calc specific issue but applies to the shared framework code. BTW please don't set the status to ASSIGNED unless I specifically set it.
(In reply to comment #12) > Known issue. A workaround is to open it from Explorer (if you are on Windows) > and specify Calc as the application to open it. > > The reason is that, LibreOffice determines which app to open an HTML file > solely based on the file content, which is HTML in this case, regardless of > where you open the file from. The extension plays a very little role here > unfortunately. > > This is in fact a long standing issue dating back to the very old version of > OOo. I remember this because I filed the same bug against OOo many years ago. > > To fix this, we need to send from which app the file is being opened, to the > file detection code, and use it as a hint in case the file format alone cannot > determine which app should open the file (which HTML file format is a prime > example). We already do something similar when opening a file from the command > line when --calc option is passed. > > Anyway this is not a Calc specific issue but applies to the shared framework > code. > > BTW please don't set the status to ASSIGNED unless I specifically set it. Hi Kohei, Thank you for your quick response. I tried your suggestion of setting Calc as the 'open with' application, however this does not change anything for me (on windows 7), I continue to get a blank spreadsheet. I can remember the bug from OO about 2.x, I think I too commented on it at the time. As far as I know this was actually fixed at 2.4, however when 3.x came out I found that this had the issue back, and thought it would be a minor fix to add to the 3 build....this didn't happen and hence where we are now with the LO code base. I assumed that the handling of the file would have been identified by the file extension, before the app performed some type of analysis as to the contents, so the sequence would go File > Calc > HTML, whereas you are saying that the process is more File > HTML > Calc. as to why mine is just blank when I specify the app, I am unsure but I will try and test on the Vista and an XP machine. As far as I know I didn't change the status, it wasn't intentional so please accept my apologies. David
This issue looks to have been resolved in LO 3.5.0beta2 could someone else confirm. David
NOT reproduced with LibreOffice 3.5.0rc3 7e68ba2-a744ebf-1f241b7-c506db1-7d53735 Ubuntu 10.04.3 x86 Linux 2.6.32-38-generic Russian UI So RESOLVED.
Hi, Changed to re-opened. looks like regression I was hoping this had been fixed for good. Seems to have only come back in 3.5.3.2 Could someone confirm. As far as I am aware it didn't happen under 3.5.2 I can supply sample files if required. David
"It happens" is a very rare description My results with attached samples and "LibreOffice 3.5.3.2 (RC2) German UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7 Home Premium (64bit) opening documents from LibO File open dialog. - ZuluTrade-TradeHistory.xls, indicated as .csv, opens with visible html tags as .csv with message "max number of rows exceeded" - Performance.xlsindicated as .csv, opens with visible html tags as .csv in CALC + Zulutrade_BBSqueeze_Performance_2011-06-13.xls opens in CALC as a normal Spreadsheet - BATA001-001 Service Issues 2011-06-30 05-16-28.xlsindicated as .csv, opens with visible html tags as .csv in CALC - BATA001-003 Current Levels 2011-09-16 08-28-42.xls, indicated as .csv, opens with visible html tags as .csv in CALC That looked much better with "LibreOffice 3.5.2.2 German UI/Locale [Build-ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f] on German WIN7 Home Premium (64bit), where all documents were opened as spreadsheets. The 3.5.3 behavior is completely different from behavior in 3.4.5, where the Documents simply opened in WRITER, so the bug did not reappear, but a new different problem came up. I am tending to close this bug again as WFM and to open a new one for the new problem, but let's wait for David's results. @David Clayton: <https://wiki.documentfoundation.org/BugReport_Details#General_hints> Are your results confidential or can you tell us your observations?
Hi Rainer, Sorry I didn't test with the existing files, and my description was a bit vague. I will upload my two test case files, and could open another report if required. When you open the files in calc you get an import dialogue, and the data is brought in with all the html formatting. If you delete the .xls file exension and open using sweb.exe, the table and data seem as expected. one of the other bug reports sightly better described the behavior, but was closed as a duplicate as the problem / solution was the same Tested on Win 7 32bit and Win Vista, it has only just started happening on 3.5.3 after we upgraded these machines last week. David
Created attachment 61221 [details] Sample 1 html xls file that is not opened in calc
Created attachment 61222 [details] Sample 2 html xls file that is not opened in calc
So that's something new here and I close the bug again. @David Clayton Can you please report a new Bug with reference the the sample documents here for the new problem?
okay. I have opened Bug 49639. David
Status change must be cached on edit / submit comment. It was just closed!
Life is full of surprises, closed again