https://bugs.documentfoundation.org/show_bug.cgi?id=160081
--- Comment #3 from Kevin Suo <[email protected]> --- (In reply to ady from comment #2) > First, the "A:A" entire column notation is usually a source of slowness for > Calc. Try changing it to use a delimited range of rows wherever you can. No, that notation does not make a difference for this performance issue. Calc will automatically determine the last allocated cell in a column if we use A:A notation. Changing the formula to: =VLOOKUP(A2,$工作表1.A$2:A$41670,1,0) takes the same amount of time as compared with A:A. -- You are receiving this mail because: You are the assignee for the bug.
