https://bugs.freedesktop.org/show_bug.cgi?id=87973
raal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Summary|vlookup formula changed in |XLSX:vlookup formula |path to external csv file |changed in path to external |after saved and re-opened |csv file after saved and | |re-opened Ever confirmed|0 |1 --- Comment #6 from raal <[email protected]> --- I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 7f476fea47f06a7f8cc961dd4f6595a524346fa5 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-27_23:36:28 steps to reproduce: - save csv file to /tmp - create xlsx file in /tmp/testBug - add formula to xlsx file =IF(B2=0;"";VLOOKUP(A2;'file:///tmp/data2.csv'#$data2.A1:B20;2;0)) - save as xlsx, close , reopen Actual results: formula changed to =IF(B2=0;"";VLOOKUP(A2;'file:///tmp/testBug/data2.csv'#$data2.A$1:B$20;2;0)) Expected results: formula unchanged -- 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
