I am trying to do vlookup on 50k, however every time Libreoffice calc gets in no-responding mode. Is there any other way to do vlookup in LibreOffice Calc?
Sorry, but let me tell that I not believe you! I have just tested the array of one million rows and VLOOKUP () worked very well. Maybe you have an error in a formula or in the data. Can you show your formula?
Thanks for your feed back John,Here I am trying to search this value =vlookup(A29,My_Data.A1:B157286,2,0), using (search criteion,array,index,sort order), finding value for 50k record from next sheet sheet which have 150k records, vlookup is working fine if i do on less record, i;e 2-3k, continue…
However same formula not responding if applied over 3k or 10 k records, showing Fill row and adapt hieght row on bottow of spreadsheet.
What is you have in cell A29? The text? Number? Date? What is you have in column A of the worksheet My_Data? Value types are the same? The entire length of the column? Try to change the formula to =vlookup(A29,**$My_Data.$A$1:$B$**157286,2,0)
I don’t have issue with formula, its performance issue of Calc, i have tried the same formula, with same value in cell. i;e all value are in number format, its working on 100 records or more, but not able to apply same formula on large data,
Showing Fill row and adapt hieght row on bottow of the spreadsheets and after few minutes file show not responding on title Currently using I5 core 2007 OS with 4 gb ram memory
Please opne a bug report with a test document. We are always interested in test documents showing performance problems because we think that we have fixed the most obvious ones and now need some help of users to find more during import or during execution of calculations.
Thanks for your feedback Moggi, i am not sure how to fetch bug report as my entire sheet get stuck while doing vlookup. Please let me know if you have any email address or other contac, so that i can share all screen shot and excell file were i actually doing vlookup.
Any help on this?
I am afraid that there is no help. You can try to fill in the search column in small portions - 1-2K. Then convert the result of the formula in the value and repeat. My experiments with alternative formulas searches lead to the same results - the computer for a long time to think.
For a bug report you just need to create a test document showing the issue or providing the test document as far as possible and a detailed instruction how to reproduce it. Please remember that the developer trying to fix your bug report will only do what you explicitly mentions in your description.
I think you should use Base instead of Calc for such a amount of data. Base is much more powerful handling a big amount of data. Here’s a OOo forum thread how to import a Calc sheet in Base.