Article View: es.comp.os.linux.programacion
Article #412Re: ayuda openoffice calc-excel
From: Discreto
Date: Tue, 04 Mar 2008 15:22
Date: Tue, 04 Mar 2008 15:22
29 lines
2194 bytes
2194 bytes
Me parece que hay un problema en la seleccion de idioma, que afecta
incluso al nombre de las funciones, explora esa posibilidad.
yadepvi escribió:
> 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:
<dPdzj.1851$pg.603@fe44.usenetserver.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!out04a.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!pc03.usenetserver.com!fe44.usenetserver.com.POSTED!232df425!not-for-mailReferences:
<xxRxj.24951$nq3.22724@news.ono.com>Show Full Headers
Complete Article Headers
X-Google-Thread: f86c8,174a29d4a664aea7 X-Google-Attributes: gidf86c8,public,usenet X-Google-Language: SPANISH,ASCII Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!out04a.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!pc03.usenetserver.com!fe44.usenetserver.com.POSTED!232df425!not-for-mail From: Discreto <ftp777@terra.es> Reply-To: ftp777@terra.es User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 Newsgroups: es.comp.os.linux.programacion Subject: Re: ayuda openoffice calc-excel References: <xxRxj.24951$nq3.22724@news.ono.com> In-Reply-To: <xxRxj.24951$nq3.22724@news.ono.com> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: quoted-printable Lines: 30 Message-ID: <dPdzj.1851$pg.603@fe44.usenetserver.com> X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. NNTP-Posting-Date: Tue, 04 Mar 2008 10:22:49 EST Date: Tue, 04 Mar 2008 16:22:47 +0100