To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89332
------- Additional comments from [email protected] Wed Jan 28 18:23:43 +0000 2009 ------- 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> --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
