[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

Eike Rathke  changed:

   What|Removed |Added

 OS|Windows (All)   |All
Version|3.6.4.3 release |Inherited From OOo
   Hardware|Other   |All

--- Comment #21 from Eike Rathke  ---
(In reply to Richard Jelinek from comment #19)
> I'd consider the importance of this as critical, as for now it makes it
> impossible to work on the same set of cross-linked files on different
> computers.
Certainly not, if you actually let links getting saved as relative and use cell
ranges. Affected here are external named expressions and ranges, as I explained
in comment 12 already. Linking to external data by cell ranges works.


(In reply to Wolfgang Jäger from comment #20)
> As there weren't many users coming to this bug discussion and claiming
> urgency I wouldn't expect immediate action if you change the importance.
> But: Simply try.
Right, upping importance won't change much because you'd have to find someone
to actually implement that feature.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #20 from Wolfgang Jäger  ---
(In reply to Richard Jelinek from comment #19)
> ...
> and the answers CLAIMING the absolute path only being shown, but it's simply
> not true.
> 
> * any relative path given is immediately converted to an absolute path
> * the absolute path shown is actually the path stored in the file (I checked
> the XML)
> * any attempt to hand edit the XML into a relative path is met with an error

This shouldn't matter if the loading process re-interprets it as INTENDED
relative, checks for the existence of a top common path node, creates the new
absolute paths to get access using ordinary (absolute) file URLs, and later
saves everything correctly.

> As a consequence a set of .ods files referring to each other immediately
> breaks when transferred to another computer. Even for the simplest
> configuration: all files located in the same directory.
> 
> I'd consider the importance of this as critical, ...

I reported this bug as my very first one more than 10 years ago, and got some
"education" about bug reports. See my comment #4. I never was again afflicted
personally, and also the first time it was only in pursuit of a question in a
forum. ...

The only substantial comment since was #12 by Eike (who should actually know). 

As there weren't many users coming to this bug discussion and claiming urgency
I wouldn't expect immediate action if you change the importance. But: Simply
try.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #19 from Richard Jelinek  ---
The problem still persists as of 7.5.5.2

I am aware of
https://ask.libreoffice.org/t/referencing-a-cell-in-other-document-using-relative-path/24288
https://ask.libreoffice.org/t/lo-calc-relative-path-to-external-sheet/33995

and the answers CLAIMING the absolute path only being shown, but it's simply
not true.

* any relative path given is immediately converted to an absolute path
* the absolute path shown is actually the path stored in the file (I checked
the XML)
* any attempt to hand edit the XML into a relative path is met with an error

As a consequence a set of .ods files referring to each other immediately breaks
when transferred to another computer. Even for the simplest configuration: all
files located in the same directory.

I'd consider the importance of this as critical, as for now it makes it
impossible to work on the same set of cross-linked files on different
computers.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

Rainer Bielefeld Retired  changed:

   What|Removed |Added

 CC|LibreOffice@bielefeldundbus |
   |s.de|

--- Comment #18 from Rainer Bielefeld Retired  
---
Following STR 1-5 in Comment 3 I did not see anything unexpected with Version:
7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #17 from QA Administrators  ---
Dear Wolfgang Jäger,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #16 from QA Administrators  ---
Dear Wolfgang Jäger,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #15 from ferre-jacq...@wanadoo.fr ---
Same problem with 
Version: 6.0.6.2 (x64)
Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77
Threads CPU : 4; OS : Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: group

One file with 3 cells named CELL1, CELL2 and CELL3.
One file with :
- 3 cells with links as :
='file:///C:/Users/Jacques/Documents/Test1.ods'#CELL1 (or CELL2 or CELL3)
- 3 cells with links as :
='file:///C:/Users/Jacques/Documents/Test1.ods'#$Feuille1.A1 (or B1 or C1)

Links with named cells are broken when I open the second file, links with cells
addresses are OK.

J.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #14 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

Buovjaga  changed:

   What|Removed |Added

 CC||ferre-jacq...@wanadoo.fr

--- Comment #13 from Buovjaga  ---
*** Bug 112224 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #12 from Eike Rathke  ---
Problem seems to be that named expressions/ranges of external documents aren't
saved in the external references cache of the referring document. Thus when
reloading the document after the path was changed attempting to compile such a
formula the name isn't found and the formula results in error, which then
displays the original formula including the old path instead of an adapted one
because the document path and the range name at that stage are one entity that
results in the bad name token.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #11 from riesslibo  ---
Created attachment 126004
  --> https://bugs.documentfoundation.org/attachment.cgi?id=126004=edit
external link for an ODS with a lost slotname in the path (originally it was
there)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #10 from riesslibo  ---
Hi,

I observed this behaviour similar to the described one here with 

Version: 5.1.4.2
Build-ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
CPU-Threads: 8; BS-Version: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE)

I moved 2 ods at the bottom of the file system c:, 
one of it with a link to a named range from one to the other.
Opening this one after aksing to refreshing the data I organized
manualy the external link with the new link destination, in words c:

Data was correctly updated, even the chart uppon it.

Closing both, changing some data in the source file, saved, opening 
the other linking to it, it asks me if in it should update the data,
answering with yes it gives a error message not possible, file not found.

Looking up manualy for the link to the named range of the source file
in the path there is the c: missing, just file:\\\
see screenshot.

This is a realy strange thing, and I think an important one, there are
several other issues belonging to external links. if new ods example files
are needed give me a hint, I just not want to overdue this description,
as the original reporter gives excelent information and examples.

Thanks for overseeing this,
Lothar

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #9 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

   Test to see if the bug is still present on a currently supported version of
LibreOffice 
   (5.0.5 or 5.1.0)  https://www.libreoffice.org/download/

   If the bug is present, please leave a comment that includes the version of
LibreOffice and 
   your operating system, and any changes you see in the bug behavior

   If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
   a short comment that includes your version of LibreOffice and Operating
System

Please DO NOT

   Update the version field
   Reply via email (please reply directly on the bug tracker)
   Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
   appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 1. Download and install oldest version of LibreOffice
(usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 3. Leave a comment with your results. 4a. If the bug was
present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not
present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-02-21

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 61743] Wrongly Absolute Path Referencing to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=61743

--- Comment #8 from QA Administrators qa-ad...@libreoffice.org ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (4.4.0.3 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

Thank you for your help!

-- The LibreOffice QA Team
This NEW Message was generated on: 2015-02-19

-- 
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 to named Ranges Across Documents

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=61743

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

Summary|: Wrongly Absolute Path |Wrongly Absolute Path
   |Referencing Across  |Referencing to named Ranges
   |Documents   |Across Documents

-- 
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