Ditutup

LibreOffice calc programmatic cell data copying

We have a spreadsheet in LibreOffice calc that we use for estimation.

The cells on several different sheets [Sheet1, Sheet2, Sheet3] are in the following format:

Description (text), Estimate (numeric; drop down values restricted to 1,2,3,5,8), Experience (numeric; drop down values restricted to 1,2,3,4,5), Low (formula), High (formula), Full description (text), Solution (text)

Based on a user selection of Yes (it could be either drop-downs, radio buttons or check boxes) a number of cells (from 10-30 cells) in the Description column from another sheet [Sheet4, Sheet5, or Sheet6] will be copied into a specific sheet [Sheet1, Sheet2, or Sheet3], starting at a specific cell number (For example, A3).

To clarify, the Description cells should only be copied; all other fields will be left blank.

If the user selects No, the Description fields will be cleared in either Sheet1, Sheet2, or Sheet3. In other words, selecting Yes or No will only erase or overwrite the values in the specific Description cells; it would never erase values in any other cells.

Kemahiran: Memasang Skrip

Lihat lebih lanjut: script sheets, programmatic, libreoffice, erase a, copying, cell, calc, drop downs, blank fields, formula sheet, format cell, radio data, calc spreadsheet, formula based, estimation script, spreadsheet cell format, spreadsheet solution, spreadsheet install, install spreadsheet, radio install script, install radio, example script radio, script radio, format data sheets, numeric values

Tentang Majikan:
( 12 ulasan ) Portland, United States

ID Projek: #1583672

1 pekerja bebas membida secara purata $250 untuk pekerjaan ini

AM9G78fHa

Pls check PMB.

$250 USD dalam sehari
(0 Ulasan)
0.0