[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 Rafael Lima changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |rafael.palma.l...@gmail.com |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 --- Comment #4 from Rafael Lima --- Patch available for review at: https://gerrit.libreoffice.org/c/help/+/128244 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 Rafael Lima changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 --- Comment #3 from Rafael Lima --- Created attachment 177465 --> https://bugs.documentfoundation.org/attachment.cgi?id=177465=edit Exported XLSX file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 --- Comment #2 from Rafael Lima --- Created attachment 177464 --> https://bugs.documentfoundation.org/attachment.cgi?id=177464=edit Sample ODS file Another interesting finding. I created an ODS file using both ROUNDDOWN and TRUNC functions (see attached ODS file) without using the Count argument. When I exported the file as XLSX (from LibreOffice), it automatically added the Count = 0 to ROUNDDOWN to ensure MS compatibility. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 --- Comment #1 from Rafael Lima --- They're both documented in the same help page: https://helponline.libreoffice.org/7.3/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3145991 Fun-fact, in MS Excel ROUNDDOWN and TRUNC have one minor difference: in ROUNDDOWN the argument Num_digits is mandatory, whereas in TRUNC it is optional. See this discussion: https://www.mrexcel.com/board/threads/trunc-vs-rounddown.1066382/ However, in LO Calc the argument is optional in both functions. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions
https://bugs.documentfoundation.org/show_bug.cgi?id=145332 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Component|Calc|Documentation CC||79045_79...@mail.ru -- You are receiving this mail because: You are the assignee for the bug.