https://bugs.freedesktop.org/show_bug.cgi?id=67071
--- Comment #10 from Menno Scholten <scholten.me...@gmail.com> --- Hello Mario, i agree that the example files i posted are very large, most of the time the file to enrich is smaller (100 lines), but the file where the information is coming from is often big. You are right that a database solution would be better, but vlookup is used by normal users, who have a basic knowledge of Excel/Calc. The information is often exported from our ERP DB en then manipulated in Calc, because we don't want to program 100 different lists for 100 different purposes every week. Sometimes we receive a spreadsheet from a customer to enrich. Hi Petr, i just tested with both sheets in one spreadsheet instead of two spreadsheets. Then it workes fine. It look like the connections between two spreadsheets is the problem. -- 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
