1. the Macro should be written in Javascript;
2. get the first empty cell in column C, the number of the first empty cell in column C is n(we will use this number n in step 4). For example, if C101 is not empty and C102 is empty, then C102 is the first empty cell in column C;
3. Using function [login to view URL]() to get the second pet name to the first empty cell in column C from the following URL:
[login to view URL]
the second pet name of this URL is "Felix"
4. create a CSV file and named as "[login to view URL]", copy the contents of the following cells to the CSV file, and save the CSV file to the same folder of the LibreOffice Calc file. If the CSV file [login to view URL] existed in this folder, then replace it.
A1, C1, D1;
A(n-100), C(n-100), D(n-100);
.
.
.
.
.
A(n-3), C(n-3), D(n-3);
A(n-2), C(n-2), D(n-2);
A(n-1), C(n-1), D(n-1);
An, Cn, Dn;
which n is the number of the first empty cell in column C in step 2, (n-1) = n-1, (n-2) = n-2, ......, (n-100) = n-100