[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Status|NEEDINFO|ASSIGNED Assignee|libreoffice-b...@lists.free |LibreOffice@bielefeldundbus |desktop.org |s.de --- Comment #5 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- I got additional detailed and structured info how to reproduce the problem from Wolfgang, so that I now am able to reproduce his observations. It's easy, but currently I only see the effect without any ideas concerning the roots. I should be able to contribute a much simplified test kit and step by step instruction tomorrow. With that kit it will be easy to do more tests (OS? Started with Version?, ...) So I assign Bug to myself for this work. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Status|ASSIGNED|NEW Assignee|LibreOffice@bielefeldundbus |libreoffice-b...@lists.free |s.de|desktop.org CC||er...@redhat.com, ||kohei.yosh...@suse.de, ||markus.mohrhard@googlemail. ||com --- Comment #7 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- @Spreadsheet Team: Comment 6 Step by step instruction shows how to reproduce easily. Of course some additional tests (what's with different OS, strange side effects and so on) can be done, but may be with your code knowledge you can do most of that more efficient? Please tell us if you still need more results normal users can contribute! Please change Status to ASSIGNED and add yourself to Assigned To if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 --- Comment #4 from Wolfgang j...@psilosoph.de --- @ Rainer Bielefeld We should avoid misunderstandings about our attitude and our intentions. Therefore I retire (temporarily) from commenting this thread. I sent a PN. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||LibreOffice@bielefeldundbus ||s.de Ever confirmed|0 |1 --- Comment #1 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- @reporter (In reply to comment #0): 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? Please add all information requested in following: - Write a meaningful Summary describing exactly what the problem is - Attach a test kit with source and target sample document (not only screenshot) or refer to an existing sample document in an other Bug with a link; to attach a file to this bug report, just click on Add an attachment right on this page. - Attach screenshots with comments if you believe that that might explain the problem better than a text comment. Best way is to insert your screenshots into a DRAW document and to add comments that explain what you want to show (attachment 68877, attachment 68490) - Contribute a document related step by step instruction containing every key press and every mouse click how to reproduce your problem (similar to example in Bug 43431) – if possible contribute an instruction how to create a sample document from the scratch - add information -- what EXACTLY is unexpected Does it look absolute, or do you really get problems when you rename the folder?) -- and WHY do you believe it's unexpected (cite Help or Documentation!) -- concerning your PC -- concerning your Operating System (Version, Distribution, Language) -- concerning your LibO version localization (UI language, Locale setting) –- Libo settings that might be related to your problems (menu 'Tools - Options - Load/Save - General - Links relative to file system?) -- how you launch LibO and how you opened the sample document –- Whether your problem persists when you renamed your user profile before you launch LibO (please see https://wiki.documentfoundation.org/UserProfile#User_profile_location) -- Whether that worked in former LibO Verions or AOOo / OOo -- everything else crossing your mind after you read linked texts Please keep in mind that you should not talk about what you see but to describe how we can reproduce the problem. Please always give hint what seems unexpected to you. It's really too hard to examine your long links and to try to find out what might be unexpected for you. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 --- Comment #2 from Wolfgang j...@psilosoph.de --- ### 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
[Libreoffice-bugs] [Bug 61743] : Wrongly Absolute Path Referencing Across Documents
https://bugs.freedesktop.org/show_bug.cgi?id=61743 --- Comment #3 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- I gambled a little, fond an error message in ..\2nd Other Path Step 1 Named\NewWorkingFolder\WochenKalender002.ods, of cousre in Sheet DruckWochenblatt Cell E5 I see the reference to drive G:, but no idea what that should tell me, ... May be someone else is willing to try to find out what the problem is? I will not do before we have a description for what less than 1 wee holidays is needed to understand. @Wolfgang: There seems some misunderstanding. We do not need lots of information, we need relevant information. There is no need to run a complete universe simulation to show what happens if you turn a water glass. Simply put the glass on a table and turn it. As long as your report does not look like following (and is not much longer) you are doing something wrong. Most important: Do not tell what you did, tell what we have to do to reproduce the problem with your test kit. --- Example 1. Unzip testkit, copy folder testkit into root folder c:\ 2. Open document C:\testkit\xyz.ods 3. Check Cell A3, should show value 12345, linked from document in C:\testkit\subfolder\uvw.ods, Cell A3 4. Close all documents 5. rename folder testkit to testkit1 6. redo analogous from step 2 Expected: In step 3 cell A3 still shows 12345 Actual: A3 shows message Error:xyz How to create problem-links: 11. In C:\testkit\subfolder1\uvw.ods, Cell A4: 12. do this 13. do that 14. and so on 15. close all documents 16. rename folder testkit1 to testkit2 17. Open, check, Expeced -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs