Tengo un documento sobre números con 3 hojas.
-
Tabla de entrada de datos 1 (basada en la hoja de "datos").
-
Mesa dada de 2 copias con:
-- I.una columna adicional que contenga la siguiente fórmula
if(reference no of data entery=reference no of this row;1;0)-- Tabla II.filter, mayor que 0
- Tabla de 3 datos
Quiero utilizar Applescript para rellenar los datos de la hoja 1 a la hoja 2
tell application "Numbers" to ¬
tell table 2 of sheet 1 of document (1)
set getRef to the value of cell "A1"
set fileinfolder to the value of cell "A2"
set Outof to the value of cell "A3"
set valqora to the value of cell "A9"
set valqno to the value of cell "A10"
set valQout to the value of cell "A11"
set valcomment to the value of cell "A13"
set valnoclue to the value of cell "A14"
set valhard to the value of cell "A15"
set valok to the value of cell "A16"
set valeasy to the value of cell "A17"
end tell
tell application "Numbers" to ¬
tell table 1 of sheet 3 of document (1)
set the value of cell "K2" to the value of fileinfolder
set the value of cell "L2" to the value of Outof
set the value of cell "M2" to the value of valqora
set the value of cell "N2" to the value of valqno
set the value of cell "O2" to the value of valQout
set the value of cell "P2" to the value of valcomment
set the value of cell "Q2" to the value of valnoclue
set the value of cell "R2" to the value of valhard
set the value of cell "S2" to the value of valok
set the value of cell "T2" to the value of valeasy
end tellSigo recibiendo un error de sintaxis - No se puede obtener el valor de true
