Bug 52201 - EDITING: Unable to edit the ods location source if it contain a LETTER: in path (made under windows)
Summary: EDITING: Unable to edit the ods location source if it contain a LETTER: in pa...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.5.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-17 14:43 UTC by Friedmann Bruno
Modified: 2013-05-30 16:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
odb database linked to mapped network share, using an ods as source (1.76 KB, application/vnd.oasis.opendocument.database)
2012-07-17 14:43 UTC, Friedmann Bruno
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Friedmann Bruno 2012-07-17 14:43:25 UTC
Created attachment 64317 [details]
odb database linked to mapped network share, using an ods as source

Problem description: 

If you create a new database using the assistant under windows build.
and use network map letter ( for example N:\blabla\sources\ods\mysources.ods ) as source for the odb (saved at the same place)
you will be unable to edit the database properties 

Inside the odb content.xml a work only one time path is registered like

db:file-based-database xlink:href="file:
///N:/Correspondance/Communes/Géomètre%20conservateur/2013-2017/Décisions/Remerciements/Communes.ods/" db:media-type="application/vnd.oasis.opendocument.spreadsheet"


Steps to reproduce:
(Warning : long story, extract from real life!)

1. Install 3.5.5 Loo windows version under Windows (was 7 64bits here)
2. Connect one or several remote cifs server to letter
3. Create a kind of mailing ods (like name,firstname,birthday,bla informations with data) this will be used as source
And place it to a complex path on a mapped network letter
4. Use Mailing assistant to create a new database, search your source ods call the db whatever
5. Save the odb in the same folder of the ods.
5. You will be able to create a mailing.
6. Now a friend need those odb and ods under his linux, or you send them grouped in a zip file by email. (You can emulate that by simply moving the 2 files in a new location on the network.
7. You want to use the odb, open it, and try to change the location of the ods, menu edit database properties : the field is grayed and you can't change anything. The path is still the old one.

8. This become a hack, your partner extract the content.xml and use ../bla.ods as url for the file. And save it again in the .odb
9. Your partner is able to work with the odb, and best he can move it to new location, and the ods,odb coupling stay working.
10. Your partner send the odb,ods back to you. You place it on the mapped network path, and the best is, now you can also work with, and can even move it inside your infrastructure freely, as you should have been able from the start :-)


Current behavior:
The full network mapped file is registered by windows even if odb and its source are in the same directory. Worst it seems that the url decoder is then unable to treat the second semi-colon in the url, and then the UI doesn't allow the user to change it.


Expected behavior:
if a source is located in the same directory as the odb, apply the same principle on windows than on Linux and use ../mysource.ods scheme.
Benefit : LibreOffice end users will be able to use cross-platform office suite.

Platform (if different from the browser): 
All : an odb has to be able to abstract the way file path work and never use a fixed one. If allowed, also permit UI to allow relative path so a Windows Network share can correspond to a nfs share.
    
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20100101 Firefox/13.0
Comment 1 Jochen 2012-08-30 08:47:19 UTC
@Rainer
Reporter describes a special constellation. I can´t this test. Do you know someone who can try to reproduce?
Comment 2 QA Administrators 2013-05-29 14:00:07 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 3 Friedmann Bruno 2013-05-29 14:27:53 UTC
Sorry the description and test case were valid.

So marked as unconfirmed.

In a few hours a test on 3.6.6.2 and 4.0.3 will be done to revalidate on recent versions
Comment 4 Joel Madero 2013-05-29 15:38:18 UTC
Thanks for doing the extra work! Much appreciated from QA :-D
Comment 5 Friedmann Bruno 2013-05-29 16:00:54 UTC
Cool, someone with a big heart save our soul ...


Working on 3.6.6.2 & 4.0.3
Closing
Comment 6 Joel Madero 2013-05-29 16:15:10 UTC
Should be WFM as we don't know what patch fixed it
Comment 7 Joel Madero 2013-05-29 16:16:15 UTC
@Friedmann - a bit off topic but would you be willing to help out a bit with QA activity (confirming some bugs)? If so please join us on freenode at #libreoffice-qa or email me. We could use the help as we have a massive backlog of bugs to confirm


Thanks!
Comment 8 Friedmann Bruno 2013-05-30 16:11:14 UTC
@Joel Madero really thanks for the offer. I would have be happy to say yes, but I'm already too overloaded on other contribution to give back here the attention, quality and time LibreOffice deserve.
Really sorry. Keep the good work, and continue to kill nasty, dirty bugs.
:-)