<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE XLSX Link to external file loses parent directory part if it points to file in parent directory"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138824">138824</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Link to external file loses parent directory part if it points to file in parent directory
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, szucs.attila3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>108917
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=168060" name="attach_168060" title="Example file from Calc">attachment 168060</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=168060&action=edit" title="Example file from Calc">[details]</a></span>
Example file from Calc
When a formula targets a cell range in a file that is in the parent directory
of the files storing directory and the file is saved as XLSX, the parent
directory is lost and both Calc and Excel would start to find the target file
in the same directory.
Steps to reproduce:
1. Open attached file
2. Save as XLSX
3. Reopen in Calc or Excel
4. Observe the second parameter of VLOOKUP in cell D2 (or in Edit – Links
to external files / Data ribbon – Connections - Links)
Actual results:
Target files path changes from parent directory of current file to the
directory of current file.
Expected results:
Target files path unchanged.
LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 61d07657caab5e0fb8ec4446f67a7044e14dae4b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Cell references bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108917">Bug 108917</a>] [META] Cell references bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>