We will be migrating from Ask to Discourse on the first week of August, read the details here

Pergunte aqui

Perfil de d4mx - atividade

2021-07-04 10:50:30 +0200 Medalha recebida  Pergunta famosa (fonte)
2021-07-04 10:50:30 +0200 Medalha recebida  Pergunta notável (fonte)
2020-10-26 13:45:41 +0200 Pergunta comentada CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

vcs sabem se no excel dá pra fazer COS(90) - com o ângulo direto em graus? Se der daí nao aparece o problema no numero m

2020-10-26 13:33:01 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

do you know if it is possible to do cos(90) [direct in degrees - without the conversion to rad] on Calc? Apparently when

2020-10-26 11:46:00 +0200 Medalha recebida  Pergunta popular (fonte)
2020-10-25 20:31:38 +0200 Pergunta comentada CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

it seems that I made a mistake by saying that on Excel and on GoogleSpreadsheets they calculate the way I said. Apparent

2020-10-25 20:31:20 +0200 Marcada como a melhor resposta CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

Aqui nesse site (item 16 - cos - https://help.libreoffice.org/3.4/Calc...) diz que "=COS(PI()/2) returns 0, the cosine of PI/2 radians" mas na verdade quando eu faço =COS(PI()/2) aqui no Calc retorna: 6,12323399573677E-017 e não 0. o mesmo acontece com =SIN(PI()), que retorna 1,22464679914735E-16

Como resolver esse problema? Minha teoria é que o PI do calc usa poucos algarismos, apenas 15, daí o erro.

in English: =COS(PI()/2) returning 6,12323399573677E-017 =SIN(PI()) returning 1,22464679914735E-16 How to solve this? It should return zero.

Version: 6.1.5.2 Build ID: 1:6.1.5-3+deb10u6 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: pt-BR (pt_BR.UTF-8); Calc: group threaded

2020-10-25 20:30:33 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

it seems that I made a mistake by saying that on Excel and on GoogleSpreadsheets they calculate the way I said. Apparent

2020-10-25 20:23:25 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

if you are working with matrix operations with very small numbers and another very small number show up in a place where

2020-10-25 19:57:35 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-10-25 19:35:42 +0200 Respondeu uma pergunta CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

Escolhi a função ROUND com precisão de 14 dígitos e resolveu o problema.

2020-10-25 19:33:24 +0200 Medalha recebida  Palpiteiro
2020-10-25 19:33:24 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

thanks! actually I chose a 14 decimal digit and got the Zero and precision I needed.

2020-10-25 19:28:05 +0200 Marcada como a melhor resposta CALC: Cosine of 90° and sine of 180° are different from zero.

Here says: item 16 - cos - https://help.libreoffice.org/3.4/Calc...) "=COS(PI()/2) returns 0, the cosine of PI/2 radians"

Actually, when I try: =COS(PI()/2) is returning 6,12323399573677E-017 and =SIN(PI()) is returning 1,22464679914735E-16 How to solve this? It should return zero.

Does it happen to you as well?

My theory is that Calc only use 15 characters for PI.

Version: 6.1.5.2 Build ID: 1:6.1.5-3+deb10u6 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: pt-BR (pt_BR.UTF-8); Calc: group threaded

2020-10-25 19:28:05 +0200 Medalha recebida  Acadêmico (fonte)
2020-10-25 19:13:29 +0200 Pergunta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

Thank you!

2020-10-25 18:57:38 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

Thanks for your answer. I am not talking about of pi (and other sins-cosines results), which is an irrational number li

2020-10-25 18:21:13 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

I think it would make it much easier for all users working with trigonometry in Calc to have an exact answer for COS (PI

2020-10-25 17:55:23 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

Thanks for your time answering it. But in my opinion, it is about time for the Calc developers solve this issue that do

2020-10-25 17:53:26 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

thanks for your answer. but I think it would be easier to use GoogleSpreadsheets online. like Excel, they do not have th

2020-10-25 17:50:38 +0200 Medalha recebida  Pergunta notável (fonte)
2020-10-25 17:24:18 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

Cos(pi/2) is different from Cos(0) if you mean type manually 0 on the several cells that should return me the correct a

2020-10-25 17:18:39 +0200 Medalha recebida  Pergunta popular (fonte)
2020-10-25 17:17:36 +0200 Pergunta comentada CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

sorry. It is my first time using this forum. I thought the portuguese question would go only for portuguese responders a

2020-10-25 17:15:47 +0200 Pergunta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

sorry. It is my first time using this forum. I thought the portuguese question would go only for portuguese responders a

2020-10-25 17:13:17 +0200 Resposta comentada CALC: Cosine of 90° and sine of 180° are different from zero.

Thanks for your answer. I understand it. When Calc developers will solve this uncomfortable issue of sin(pi)=0 and cos(p

2020-10-25 15:14:16 +0200 Perguntou CALC: Cosine of 90° and sine of 180° are different from zero.

CALC: Cosine of 90 ° and sine of 180 ° are different from zero. Here says: item 16 - cos - https://help.libreoffice.org/

2020-10-25 15:05:03 +0200 Perguntou CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero.

CALC: Cosseno de 90 e seno de 180 diferente de zero. Cosine of 90 ° and sine of 180 ° are different from zero. Aqui ness