https://bugs.freedesktop.org/show_bug.cgi?id=85617
Bug ID: 85617
Summary: VLOOKUP formula garbled after save as .xlsx
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
VLOOKUP formula garbled after save as .xlsx
LO 43.2.2, win 7
Steps to reproduce:
- open attachment from bug 85553
https://bugs.freedesktop.org/attachment.cgi?id=108570
- The formula in column C is: =VLOOKUP(A3;'file:///C:/temp/home/yar4e/Рабочий
стол/home/finman/Рабочий стол/Файл 1.xls'#$Лист1.A3:B23;2;0)
- Save as .xlsx
- close, reopen
Actual results: Formula garbled =VLOOKUP(A3;[1]$Лист1.A3:B23;2;0)
Expected results: formula works
Works in LO 4.2.6, regression
--
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
