Prime Numbers in Calc

is there a way to auto-fill column with only prime numbers in the same way as we auto-fill a column with “normal” numbers (like starting to write 1 in A1, 2 in A2, select with the mouse and extend the selection down to automatically fill A3, A4, A5 etc… with the next following numbers) ?

  1. i need to fill up the first 2 000 prime numbers in calc, so i can’t imagine to fill it up manually

Thank you for sharing your time

No easy way to accomplish this task. You can try to write a macro that implements the algorithm “Sieve of Eratosthenes” and put the result of it’s work in the table. However, it takes much more time than a simple Internet search on the string “all the prime numbers under 200000”. So you can find, for example, the file that contains 78,498 Prime Numbers. You will only need to copy to your table the necessary number of values.

2000 Prime Numbers.ods

Thank you very much for your help