Peruttu

Looking for a LibreOffice Calc Javascript Macro/Script

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

Taidot: Javascript, jQuery / Prototype

Näytä lisää: excel macro fill empty cells, macro script, javascript required script, libreoffice basic vs vba, openoffice scripting tutorial, openoffice calc macro examples, libreoffice calc macros, libreoffice pdf javascript, can libreoffice run excel macros, libreoffice basic, running macros in libreoffice, excel macro script reference, javascript pop script wordpress, macro script vba, macro script add text file, macro copy paste cells, macro script excel, macro script update database excel, javascript snowflakes script, javascript search script jsp servlets

Tietoa työnantajasta:
( 9 arvostelua ) Essen, Germany

Projektin tunnus: #19014401

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

WEB9andAPP6Max

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 suitabl Lisää

$30 USD 1 päivässä
(2 arvostelua)
1.6
norbware

Dear Sir / Madame, I can start working on your project immediately: "Looking for a LibreOffice Calc Javascript Macro/Script" best regards Norbert

$27 USD 1 päivässä
(0 arvostelua)
0.0