When it came to holiday she brought the value correctly, but for day of the week "Saturday"and "Sunday" did not bring any value.
If you need I send the original worksheet. I used the online translator. My version is in Portuguese. Thank you. Everton --- Em qui, 10/2/11, Leo Arias <y...@elopio.net> escreveu: > De: Leo Arias <y...@elopio.net> > Assunto: [Bug 683600] Re: Fómulas feitas no Excel não funcionam no Calc > Para: everton_m...@yahoo.com.br > Data: Quinta-feira, 10 de Fevereiro de 2011, 16:04 > I noticed that some of the sentences > in this bug report are not in > English. If they were translated to English they would be > accessible to > more triagers. Could you please translate them? > > ** Changed in: openoffice.org (Ubuntu) > Status: New => > Incomplete > > -- > You received this bug notification because you are a direct > subscriber > of the bug. > https://bugs.launchpad.net/bugs/683600 > > Title: > Fómulas feitas no Excel não funcionam no Calc > > Status in “openoffice.org” package in Ubuntu: > Incomplete > > Bug description: > Binary package hint: openoffice.org > > A seguinte fórmula criada no Microsoft Excel não > funcionou no Broffice > Calc. > > > =SE(PROCV($A12&"/"&$N$3&"/"&$L$3;$B$57:$D$421;2;0)="PONTO > FACULTATIVO";" > > FACULTATIVO";SE(PROCV($A12&"/"&$N$3&"/"&$L$3;$B$57:$D$421;2;0)<>"";" > > FERIADO";SE(DIA.DA.SEMANA($A12&"/"&$N$3&"/"&$L$3)=7;" > > Sábado";SE(DIA.DA.SEMANA($A12&"/"&$N$3&"/"&$L$3)=1;" > Domingo";"")))) > > Quando se tratava de feriado ela trouxe o valor > corretamente, mas para > os dias da semana de "Sábado" e "Domingo" não > trouxe valor algum. > > Se necessitarem eu envio a planilha original. > > Grato. > Everton > > To unsubscribe from this bug, go to: > https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/683600/+subscribe > -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/683600 Title: Fómulas feitas no Excel não funcionam no Calc -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
