Fómulas feitas no Excel não funcionam no Calc

[Everton Machado]

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

[Leo Arias (elopio)]

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?

[Everton Machado (everton-mach)]

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 <email address hidden> escreveu:

> De: Leo Arias <email address hidden>
> Assunto: [Bug 683600] Re: Fómulas feitas no Excel não funcionam no Calc
> Para: <email address hidden>
> 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
>

[Everton Machado (everton-mach)]

The problem occurs both in Debian and Ubuntu.
I will test the new versions of office.

I used the online translator.
My version is in Portuguese.

Thank you.
Everton

[penalvch (penalvch)]

Everton Machado, thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal:
apport-collect 683600
When reporting bugs in the future please use apport by using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

Could you please attach the spreadsheet that demonstrates this problem? Does this occur for you in LibreOffice Calc?

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

[Launchpad Janitor (janitor)]

[Expired for openoffice.org (Ubuntu) because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

[penalvch (penalvch)]

Everton Machado, we are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!