ayuda openoffice calc-excel

Article View: es.comp.os.linux.programacion

Article #410

Back to es.comp.os.linux.programacion Previous Next

#410

From: yadepvi
Date: Fri, 29 Feb 2008 10:56

16 lines
1756 bytes

tengo un problema en un documento de open office a ver si me podeis echar un cable. 
Creé un documento en excel y le puse una macro de validación de datos para
elegir entre una lista 
de varios datos y cuando lo he abierto con openoffice me ha habilitado los
datos pero la lista no funciona. si me convierte la lista a basic de
openoffice. En la opción validar de openoffice si pongo lista no me deja
poner un comando de estos operativos.
  
(excel)
=ELEGIR(J15;F_1S;M_1S;F_2S;M_2S;F_3SA;F_3SB;F_3SC;F_3SD;M_3SA;M_3SB;F_1JA;F_
1JB;M_1JA;M_1JB;F_2JA;F_2JB;F_3JA;F_3JB;F_1C;M_1C;F_2CA;F_2CB;F_2CC;F_1IA;F_
1IB;M_1IA;M_1IB)

(calc)
TRIA('Jos'.J15;F_1S;M_1S;F_2S;M_2S;F_3SA;F_3SB;F_3SC;F_3SD;M_3SA;M_3SB;F_1JA
;F_1JB;M_1JA;M_1JB;F_2JA;F_2JB;F_3JA;F_3JB;F_1C;M_1C;F_2CA;F_2CB;F_2CC;F_1IA;F_1IB;M_1IA;M_1IB)

Technical Details

Message-ID: <xxRxj.24951$nq3.22724@news.ono.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!62.216.30.27.MISMATCH!newsgate.cistron.nl!xs4all!feeder.news-service.com!newspeer1.de.telia.net!newspeer4.de.telia.net!de.telia.net!newsf01.ono.com!news.ono.com.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f86c8,174a29d4a664aea7,start
X-Google-Attributes: gidf86c8,public,usenet
X-Google-Language: SPANISH,UTF8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!62.216.30.27.MISMATCH!newsgate.cistron.nl!xs4all!feeder.news-service.com!newspeer1.de.telia.net!newspeer4.de.telia.net!de.telia.net!newsf01.ono.com!news.ono.com.POSTED!53ab2750!not-for-mail
From: "yadepvi" <sand.nestor@gmail.com>
Subject: ayuda openoffice calc-excel
Newsgroups: es.comp.os.linux.programacion
User-Agent: pan 0.112 (Elijah Craig)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Lines: 16
Message-ID: <xxRxj.24951$nq3.22724@news.ono.com>
Date: Fri, 29 Feb 2008 10:56:29 GMT
NNTP-Posting-Host: 81.184.165.128
X-Trace: news.ono.com 1204282589 81.184.165.128 (Fri, 29 Feb 2008 11:56:29 MET)
NNTP-Posting-Date: Fri, 29 Feb 2008 11:56:29 MET