Looking for a LibreOffice Calc Javascript Macro/Script
$10-30 USD
Annulleret
Slået op næsten 5 år siden
$10-30 USD
Betales ved levering
A. the Macro should be written in Javascript;
B. the Macro should be run on LibreOffice Calc;
C. The Macro should loop the follows Step 1 to Step 3 every 30 minutes
Step 1. 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 3). For example, if C107 is not empty and C108 is empty, then C108 is the first empty cell in column C and n is 108;
Step 2. 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]
Explanation of the above URL:
[login to view URL]
Step 3. 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 (copy to the first row of the CSV file "[login to view URL]")
A(n-100), C(n-100), D(n-100) (copy to the second row of the CSV file "[login to view URL]")
.
.
.
.
.
.
A(n-3), C(n-3), D(n-3) (copy to the 99th row of the CSV file "[login to view URL]")
A(n-2), C(n-2), D(n-2) (copy to the 100th row of the CSV file "[login to view URL]")
A(n-1), C(n-1), D(n-1) (copy to the 101th row of the CSV file "[login to view URL]")
An, Cn, Dn (copy to the 102th row of the CSV file "[login to view URL]")
which n is the number of the first empty cell in column C in step 1, (n-1) = n-1, (n-2) = n-2, ......, (n-100) = n-100
Hello
Thanks for your good description and i understood what you want.
As an expert company. we have strong skills and experience in development for 9 years.
I hope work for you because our skill set is very suitable to your project.
I are confident to handle this project according to your expectations perfectly.
Please send message so we can discuss more
if have time,visit my profile.
Best regards.
Li Yi