Apache OpenOffice (AOO) Bugzilla – Issue 125679
Sheet with encoded URL in its name does not open
Last modified: 2014-10-27 13:41:27 UTC
Created attachment 83993 [details] 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.
Attached file does not correspond to described issue. Filename is ST_SpecialCharacter(1).ods and have just one sheet.
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.
According with bmarcelly's comment, status changed to NOT_AND_ISSUE
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 ;)
(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.
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 ;)