[Libreoffice-bugs] [Bug 87973] XLSX:vlookup formula changed in path to external csv file after saved and re-opened

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
I checked this problem and still happens in:

Version: 7.1.0.0.alpha0+ (x64)
Build ID: f266feaebea39668392e3a3830e20e4670344658
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL

I'll attach a bunch of reproducer documents in a zip:

test2.ods: source file made in LO7.1alpha that contains a VLOOKUP function
referencing XLSX and CSV files in the same directory (data3.csv and
data3-copy.xlsx) and in a subdirectory (data2.csv and data2-copy.xlsx) as well.

test2.xlsx: the above ods saved as XLSX. The VLOOKUP does not work in this one
for the referenced files in the same directory, but works for the ones in the
subdirectory. 
Excel 2013 reports invalid contents in this one and removes the formula with
references to the same directory.

test2-rel.ods: the above ods saved with Options - Load/Save - Save URLs
relative to filesystem OFF.

test2-rel.xlsx: test2-rel.ods saved to XLSX with Options - Load/Save - Save
URLs relative to filesystem OFF. In this one all VLOOKUP functions work both in
Calc/Excel.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201006/933abeea/attachment.htm>