https://bugs.freedesktop.org/show_bug.cgi?id=61743
--- Comment #2 from Wolfgang <[email protected]> --- ### Restart ### See also ZIP: http://psilosoph.de/LibO_BugReports/61743/61743LibO_Calc_BugReport_AbsoluteInsteadOfRelativePathsIfRangesNamed.zip On my PC with OS: Win XP Professional 2002 SP3 32 Bits Germnan locale Processor: AMD Athlon 64 3000+ , 2.01 GHz, 1.00GiB RAM the following steps were performed. Already designed was a triple of Calc-documents. These were part of a little project initiated by the questions of a user in the forum 'http://en.libreofficeforum.org/forum/apps/calc'. The final document 'WochenKalender002.ods' takes over values from 'Bearbeitet_AGr_NT_MaK003.ods' by formulas and so does the second document from 'HerrnhuterLosungenFree 2013.ods'. LibreOffice Calc was Ver 3.6.4.3, English UI and function names. The options 'Save URLs relative to file system / internet' were both activated. 1) On an USB stick drive (in my case G:) in the first level directory 'OtherDocs' the tree (German locale) Auflistung der Ordnerpfade für Volume TOSHIBA Volumenummer: ... G:. | +---CalcBugs | | | +---1st Other Path Step 1 Addressed | | \---NewWorkingFolder | | | +---AbsoluteInsteadOfRelative Named | | | \---2nd Other Path Step 1 Named | \---NewWorkingFolder | +---tmp | ... was created. 2) From a folder on my drive 'D:' where it was developed the triple of linked files of which the project consists was packed into a .zip (with WinZIP 9.0) named 'KalenderTripel20130302CalendarByAddressedRanges.zip'. The 'WochenKalender002.ods' contained in this zip file was finally put in a version avoiding named ranges in certain formulas because some days ago a bug had occurred if named ranges were used. 3) The zip file was copied to the folders 'G:\OtherDocs\CalcBugs\AbsoluteInsteadOfRelative Named' and 'G:\OtherDocs\CalcBugs\1st Other Path Step 1 Addressed\NewWorkingFolder' . 4) In the first one of these folders the files were extracte from the zip, opened in the order 'Herrn...', 'Bearb...' and 'Wochen...' with updating the links and the correct function was tested. 5) The formulas in the cells E4 and E5 of the sheet 'DruckWochenblatt' of the document 'WochenKalender002' were now edited changing a total of 4 parts (2 in each formula): Replace the addressed range '$ZuordSchluessel.$AL$11:$AP$8010 by the named range 'nrAGrVerse' ! Replace the addressed range '$ZuordSchluessel.$K$11:$K$8010 by the named range 'nrKalenderTage' (occurs in both formulas)! Replace the addressed range '$ZuordSchluessel.$L$11:$L$8010 by the named range 'nrStellen' ! Each of these ranges occurs exclusively following the '#' as target inside the file 'Bearbeitet_AGr_NT_MaK003.ods' existing in its then directory path described as 'file:///G:/OtherDocs/CalcBugs/AbsoluteInsteadOfRelative Named' . Inside the file the addressed ranges and the named ranges respectively denote exactly the same references. 6) The edited document was saved under unchanged name. 7) The two unchanged documents and the edited one were now zipped into 'KalenderTripel20130302CalendarByNamedRanges.zip' and this file was copied to 'G:\OtherDocs\CalcBugs\2nd Other Path Step 1 Named\NewWorkingFolder' . 8) The 'Addressed' version was unzipped and tested in its NewWorkingFolder. All Files and LibreOffice were closed again. 9) Same procedure performed with the 'Named' version in its dedicated folder. 10) The results were as formerly described: In the cell E4 the expression could not be evaluated because the MATCH part contained the now wrong absolute path to the former location where the file did no longer exist. 11) NotaBene: EXACTLY the same MATCH part occurred in E5. There the path was correctly saved in relative mode. 12) Imagine this file existed still but was for some purpose changed! 13) It's really a problem of reliability, too. Finally the (malfunctioning) version of the project (using named ranges) was also tested with Portable LibreOffice Ver. 4.0.0.3, German UI and function names. Same result. All files closed LibreOffice closed Unzipped files deleted Tree containing the zip files and the LibO Writer document containing this text zipped into 'LibO_Calc_BugReport_AbsoluteInsteadOfRelativePathsIfRangesNamed.zip' This text added to new comment to Bug Report #61743 Zip file attached comment posted Thank you for caring! PS Of course I might be as well more concise and more precise if writing about this in German. ### Another Kind Of Reply ### Dear expert! Thank you very much for your quick reaction. I really appreciate that there are experts fighting bugs. In this case I experienced a bug that I find annoying though it occurred only during work on one "project" - and this not being one that might get critical for me but one that I undertook to help a guy who asked a question in the LibreOfffice Calc forum. Unfortunately I did obviously not succeed in describing the problem precisely. You complained my report being not helpful enough. > Thank you for your report – unfortunately important information is missing. > May be hints on <http://wiki.documentfoundation.org/BugReport> will help you > to find out what information will be useful to reproduce your problem? I tried understanding and regarding that. > Please add all information requested in following: > - Write a meaningful Summary describing exactly what the problem is I did as well I can. At least I thought so. My only example so far is a triple of documents and the bug shows in connection with MOVING these documents to another location in a directory tree - (or to another file system or computer). So it is really not easy to deliver a simple example. Anticipating your reply I already tried to design a minimal example - but did not succeed. I told all this in the original report. OK! Let's try another approach. Please be aware of my not being an expert. Terminology as well as interpretations may be erroneous without my knowing it. My poor English may be another problem. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
