Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | The html based xls file does not open in Spreadsheet component | ||||||
---|---|---|---|---|---|---|---|
Product: | General | Reporter: | biq <balique> | ||||
Component: | code | Assignee: | kla <thomas.klarhoefer> | ||||
Status: | CLOSED FIXED | QA Contact: | issues@framework <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | caolanm, issues, rainerbielefeld_ooo_qa, realgrouchy, stephan_schaefer | ||||
Version: | OOo 3.2 RC4 | Keywords: | oooqa | ||||
Target Milestone: | OOo 3.3 | ||||||
Hardware: | PC | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
biq
2008-05-12 14:11:38 UTC
I cannot verify on Windows, so I correct the OS as Linux. confirmed I can confirm this, and will upload a sample file. There are two problems here: Definition: The "html based xls file" is a file with extension .xls, and which, when viewed in plaintext, contains a table created with html tags in the format <table border="0" width="1000"><tr><th>Cell1</th><th>Cell2</th><th>Cell3</th></tr></table> Problem 0: When clicking this file on the desktop or in a folder, it opens properly in the Calc component. This is not a problem. Problem 1: When opening this file using File > Open (or the "open a file" button in the welcome screen), it opens in the HTML editor component. Problem 2: When attempting to open a very large file of this format (I'm not sure if the limit is amount of total data or number of rows, but my file has over 3200 rows), it has the following response: Problem 2a: When opening it using File > Open, it opens in the HTML editor component, and only the first 3200 rows are rendered. The rest are concatenated into a long paragraph. Problem 2b: When clicking on the file from the desktop, the OOo title screen opens, and the process grows to over 100MB (taking 99% of the processor, according to Windows Task Manager), and the file does not open in five minutes (I gave up after that). Such a file opens fine in Excel for XP (which was my workaround until the other computer with that program was discarded), but the file doesn't open properly in Excel:mac 2004 or 2008, as accented characters are not decoded properly. (é comes out as È, etc.) Unfortunately, the vendor whose software creates these files treats this problem as "worksforme [in Excel for XP]", and I am not in a position to get them to create a properly working file. In addition, double-clicking the files to open them is a very time-consuming workaround for me. I keep my files on the OSX part of my computer, and access them in OOo/XP via networked folders. I also don't have space on my XP virtual hard drive to save them. And for some reason, I can't open files on folders networked via Parallels (see issue #85650). While 3200 rows may be a reasonable limit for an HTML editor, it is not for a spreadsheet program. Therefore any workarounds involving opening the file in OOo's HTML editor component is not a true solution. OOo should obey the file's .xls extension when opening such files, and when opening them in the spreadsheet module, they should be able to accept files with over 3200 lines. - RG> Created attachment 59728 [details]
Sample file, following description by RG
I see this opening as "Text Encoded" with "Ooo 3.2.0 RC2 WIN XP DE-multilingual version German UI activated [OOo320m9 (Build 9476)]", so I modify OS Worked fine with "2.4.1 Multilingual version English UI WIN XP: [680m17(Build9310)]" *** Issue 108350 has been marked as a duplicate of this issue. *** HTML files with "xls" suffix should always open in calc. Would be great if the filter detection could be changed accordingly. Setting component to framework and target to 3.3 (if possible in that time frame). Taking over for further assignment *** Issue 109698 has been marked as a duplicate of this issue. *** I think it doesn't matter as in fact the code here is wrong and was wrong. I assume that solar.hrc was not included in addonmenu.cxx, but due to changes in other CWS integrated into m72 it is now included indirectly and so we have the clash. Let's remove the line defining the constant SID_SFX_START and move on. *** Issue 110207 has been marked as a duplicate of this issue. *** taking the issue Fixed in CWS "calc53". HTML files with extension XLS are opened in Calc by default (with the "Web Page Query" filter), both if passed to "soffice" or "scalc", and from the "Open" dialog. Thanks nn! This might allow me to stop needing MSO! *** Issue 109739 has been marked as a duplicate of this issue. *** reassigning to QA for verification Seen ok in cws calc53 -> verified *** Issue 96362 has been marked as a duplicate of this issue. *** *** Issue 111579 has been marked as a duplicate of this issue. *** closing, integrated DEV300_m80 I just installed 3.2.1 and it is still opening in the Writer/Web component, not in the Calc component. I thought this was fixed? Or is there a setting I am missing? See the "target" field, the target is 3.3, not 3.2.1, its supposed to be fixed in that version. Any of the development milestones made available with a number >= DEV300_m80 should have the fix in it, e.g. http://download.openoffice.org/next/index.html currently has DEV300_m82 available Oops, thanks for that. I look forward to seeing it in 3.3, then! |