You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/06/30 11:23:32 UTC
[Issue 127021] New: Cannot open file in oo
https://bz.apache.org/ooo/show_bug.cgi?id=127021
Issue ID: 127021
Issue Type: DEFECT
Summary: Cannot open file in oo
Product: Calc
Version: 4.1.2
Hardware: All
OS: Windows 10
Status: UNCONFIRMED
Severity: Blocker
Priority: P5 (lowest)
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: icegood1980@gmail.com
Open office hang while trying to open file in attach
Expected result: show error on whatever it is but never hang.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
icegood1980@gmail.com <ic...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|NOT_AN_ISSUE |---
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #2 from oooforum (fr) <oo...@free.fr> ---
Your document is an XLSX.
It doesn't open with the MS-Excel viewer.
Result: blank page.
So, AOO can't make it better.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
--- Comment #1 from icegood1980@gmail.com <ic...@gmail.com> ---
failed to asdd attach. Get link to it instead:
https://drive.google.com/file/d/0B4mLkzBXmYycQy14M2o2Y2wwbzg/view?usp=sharing
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
--- Comment #8 from orcmid <or...@apache.org> ---
(In reply to icegood1980@gmail.com from comment #7)
> "Was the original file produced by some software means other than from Excel
> itself?"
>
> Yes, it was. We used 3rd party library (from axolot) to be able to produce
> excel for other users.
It appears that there is some sort of edge case in the production from the
third-party library that trips over a situation AOO Calc was never designed nor
tested for and now results in excessive conversion time in Calc.
It could also be that there are discrepancies related to what version of the
OOXML spec is being produced against by the third-party software.
This is a classic interoperability problem and, while it can be considered a
defect in the AOO implementation, there is really no way we can get to that
with such gigantic files.
I think the important consideration is that there is little chance of a change
in Apache OpenOffice XSLX import in the foreseeable future. You might consider
a workaround if it is important to open those files in Apache OpenOffice. In
particular, using Microsoft Office to open the .xlsx and save it in .xls format
should provide a remedy so long as unique features of .xlsx are not being
depended upon.
(An alternative would be to endure the incredibly-long file-open time and then
save the result as a .xls or even .ods from Calc. But I think using Excel to
do the .xlsx -> .xls is more likely to maximize fidelity as well as being much
quickler.)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
karko@spaml.de changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |karko@spaml.de
--- Comment #9 from karko@spaml.de ---
Seems to be a duplicate of the issue #124704.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
--- Comment #5 from orcmid <or...@apache.org> ---
(In reply to icegood1980@gmail.com from comment #3)
> What? Given xlsx opened in Excel 2013 very great. With which Excel do you
> try to open it? Besides, other simplier xlxs ones opened in aoo too.
> xlsx is open format (you may change extension to zip and extract plan text
> inside) so i don't see any reason to not support it well...
The structure of the OOXML files in a .xlsx package is very complex. That it
uses Zip as a carrier is the least of the problems in importing it correctly.
The same goes for .odp files produced by OpenOffice Calc. ODF and OOXML and
*very* different.
In addition, the problematic file is 3MB, so it is very difficult to
trouble-shoot it enough to see what the problem is.
I did manage to save the file, from Excel 2016, to .xls format. That opens in
Apache OpenOffice. One peculiarity is the presence of a comment whose text is
a GUID. This does not appear when opened as read-only in Excel 2016 (a default
precaution for internet-downloaded files when first opened).
If I open that .xls in Excel 2016 and save that as .xlsx, Apache OpenOffice
fails the same way it does on the original .xlsx.
Observation: The original .xlsx has no creator, but it does have a
last-modification author. Was the original file produced by some software
means other than from Excel itself?
Conclusion: Calc cannot open the file. It is not clear what feature of the
file is problematic for Calc.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |DUPLICATE
Status|CONFIRMED |RESOLVED
--- Comment #10 from oooforum (fr) <oo...@free.fr> ---
According
> Seems to be a duplicate of the issue #124704.
*** This issue has been marked as a duplicate of issue 124704 ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
--- Comment #3 from icegood1980@gmail.com <ic...@gmail.com> ---
What? Given xlsx opened in Excel 2013 very great. With which Excel do you try
to open it? Besides, other simplier xlxs ones opened in aoo too.
xlsx is open format (you may change extension to zip and extract plan text
inside) so i don't see any reason to not support it well...
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orcmid@apache.org
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #4 from orcmid <or...@apache.org> ---
(In reply to oooforum (fr) from comment #2)
> Your document is an XLSX.
> It doesn't open with the MS-Excel viewer.
> Result: blank page.
> So, AOO can't make it better.
The document opens where it is stored on Google Drive just fine.
Downloaded, it also opens in Microsoft Excel 2016 on the desktop.
It also opens with LibreOffice Calc x64 5.0.0.5.
With Apache OpenOffice 4.1.2, the application appears to be stuck at "Loading
..." On Windows 10 Pro x64 I needed to use the Task Manager to shut down AOO
and then clear the open-file lock. (It was using 17% of my cpu and slowly
growing memory.)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|orcmid@apache.org |
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
--- Comment #7 from icegood1980@gmail.com <ic...@gmail.com> ---
"Was the original file produced by some software means other than from Excel
itself?"
Yes, it was. We used 3rd party library (from axolot) to be able to produce
excel for other users.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127021] Cannot open file in oo
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127021
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |damjan@apache.org
--- Comment #6 from damjan@apache.org ---
The file opens for me eventually, after 70 seconds of waiting. FreeBSD 10.3 on
AMD64.
--
You are receiving this mail because:
You are the assignee for the issue.