Description: Hi guys! NOTE: I'm noob at this, so forgive me if this is NOT an ERROR and I did something wrong I had and Sheet and when updated to the version mentioned above stopped working correctly. Ex: Cell------Contains M148 = DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;1;2));0;1)+DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;3;2));0;1)+DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;5;2));0;1) N148 =ARRED(M148/100;1) Results N148 shows 420 N148 shows 0 Thank you very much! Kind Regards, elo Actual Results: (see Description) Expected Results: 4 Reproducible: Always User Profile Reset: No Additional Info:
Thank you for the report! Please provide a test document to be able to reproduce. Also please setup your LibreOffice to use English function names to post formulas that others could test (not everyone uses Portuguese UI). To do this: Options→LibreOffice Calc→Formula→Use English function names (at the top of the options page; Ferramentas→Opções→LibreOffice Calc→Fórmula→Utilizar fórmulas em inglês).
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Good morning, Sorry for the late answer, but this is not my everyday email. I've installed and reinstalled Office versions, and finally changed the way I did the calculus. So, at this time, I cannot recreate the problem! Next time I'll send you the spreadsheet with the Bug! Meanwhile if you have a Kaizen team I'll be more than happy to join! Thanks for your hard work! And Sorry once again! Best Regards, elo
Let's close this then.
(In reply to elo.f360 from comment #3) > > Meanwhile if you have a Kaizen team I'll be more than happy to join! > Hello, see tdf.io/joinus