https://bugs.documentfoundation.org/show_bug.cgi?id=160081
--- Comment #4 from ady <[email protected]> --- (In reply to Kevin Suo from comment #0) > Steps to Reproduce: > > 1. Open the test ods file in attachment 147932 [details]. > > The file is 145 KB in size, contains only one column with 41670 records, so > it is not too big dataset. > > 2. Insert new Sheet2. Copy column A of sheet 1 to Sheet2. When reading the whole set of steps, the “copy” part in step 2 seems unneeded. Alternatively, the use of the worksheet name in the formula in step 3 seems not needed. > > 3. Set vlookup formula in Sheet2.B2, e.g. > =VLOOKUP(A2,$工作表1.A:A,1,0) > > 4. Double-click the cell handle in B2 to fill formulas down. > > All the 8 cpu of my Thinkpad X1 Carbon is running at 99% for this and it > took 6 minutes 23 seconds to run. By comparison, the same operation takes 85 > seconds in MS Excel even with 2 CPU cores in a virtualbox guest OS. Since the default setting is to recognize asterisks as wildcards, but there is such a difference in performance when comparing with Excel, I must ask… Is the resulting data in column B in Excel exactly the same (and in the same location/order) as in Calc? In particular, we need to know whether the wildcard in Excel is considered for the formula only, or instead, it is also considered when evaluating the content of column A, when the formula uses a reference to it (instead of using a string that includes wildcards itself). For example, when the content of a cell in column A is: GZZN-AJLIA-5.6/5UV-5*55 and another is: GZZN-AJLIA-5.6/5UV-5*555 then Calc considers the asterisk "*" as a wildcard, even when the asterisk is not used directly in the formula itself. So, is Excel considering those asterisks in column A as wildcards too? Or, instead, the asterisk must be used in the formula itself for Excel to consider it a wildcard? As for efficiency in general, a lookup on sorted data using the sort argument should be faster (but again, that's generally speaking and without counting for current known bugs). -- You are receiving this mail because: You are the assignee for the bug.
