I’m an experienced Excel user and when I click into a cell, and right click on the small black square in the bottom right corner, I can drag and get options for results. I tried that in Calc but doesn’t seem to do the same thing. Am I missing something? Is there another way to get that right mouse click drag option to work?
The black square in the lower right corner of the cell has the Auto fill function in Calc.
Hold the square with the left mouse button and drag.
If my answer has solved your problem, please click on the checkmark ✓ in the circle 
to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.
With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: 6.2.5.2 (x64).
So it does not support the MS Excel right click functionality then correct? Only left mouse.