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 2014/09/26 11:41:11 UTC
[Issue 125679] New: Sheet with encoded URL in its name does not
open
https://issues.apache.org/ooo/show_bug.cgi?id=125679
Issue ID: 125679
Issue Type: DEFECT
Summary: Sheet with encoded URL in its name does not open
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: svante.schubert@gmail.com
Created attachment 83993
--> https://issues.apache.org/ooo/attachment.cgi?id=83993&action=edit
The second sheet of the document has an encoded URL as its sheet name
A document with an encoded file URL as sheet name is not being imported into
latest Calc, only the first sheet is being shown.
The none reachable external source of the second sheet does not influence it,
as renaming the sheet name in the XML to something naive fixes the problem.
Although the document is created from an old OOo 2.4 version this should not be
a problem.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
bmarcelly <ma...@club-internet.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |marcelly@club-internet.fr
Ever confirmed|0 |1
--- Comment #2 from bmarcelly <ma...@club-internet.fr> ---
Reading the content.xml subdocument of your file, your second sheet is named:
'file://nandisrv2/OpenXML/ODF%20Translator%20Test/MS_Excel_Trans/Testing_Excel/Sanity_Excel/Input_Sanity_Excel/Testfeatures%20M4%20and%20M5%20Datarange.xlsx'#Sheet1
On a new spreadsheet, if I try to rename a sheet to this name, it is rejected.
A few tests show that OpenOffice rejects sheet names containing:
- apostrophe as first character
- character /
- character :
Your sheet name contains all three cases.
I think that this issue is INVALID.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #3 from oooforum <oo...@free.fr> ---
According with bmarcelly's comment, status changed to NOT_AND_ISSUE
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
--- Comment #6 from svanteschubert <sv...@gmail.com> ---
ODF allows any string in the table name.
The name might be long and might contain special characters, but it is valid.
<table:table
table:name="'file://nandisrv2/OpenXML/ODF%20Translator%20Test/MS_Excel_Trans/Testing_Excel/Sanity_Excel/Input_Sanity_Excel/Testfeatures%20M4%20and%20M5%20Datarange.xlsx'#Sheet1"
table:style-name="ta2" table:print="false">
The document is a valid ODF and there is any restriction in loading the
document is the bug.
Unless of course someone is programming Cobol and added an 8 character String
restriction, which is AFAIK not a problem of he office ;)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
svanteschubert <sv...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|NOT_AN_ISSUE |---
--- Comment #4 from svanteschubert <sv...@gmail.com> ---
You argumentation is that as AOO does not create the given document state with
the GUI the bug is not valid.
May I point out that the given state was created by AOO with the MS Office
import filter and that there are documents out there with this state, which can
not be loaded.
If you fully aware of the above facts, please make chain of logic a little more
easier to reproduce, as some user face the problem to open the document and
will hardly understand that this is not a problem at all ;)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
--- Comment #5 from bmarcelly <ma...@club-internet.fr> ---
(In reply to svanteschubert from comment #4)
> May I point out that the given state was created by AOO with the MS Office
> import filter and that there are documents out there with this state, which
> can not be loaded.
So the problem is in the import of an MS Office document.
But you only provided an ODF document...
Attach an original MS Office document so the developers can :
- see what it looks like on MS Office
- decide what to do on importing such document into OpenOffice.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125679] Sheet with encoded URL in its name does not open
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125679
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #1 from oooforum <oo...@free.fr> ---
Attached file does not correspond to described issue.
Filename is ST_SpecialCharacter(1).ods and have just one sheet.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.