Description: The ROUNDDOWN and TRUNC functions in Calc perform exactly the same function (implemented by C++ function ScRoundDown()). However this is not apparent from the help, which provides independent and (perhaps more importantly) different descriptions of the two. When time allows, suggest reviewing the help information for these two funtions with a view to achieving greater consistency in wording across them. Steps to Reproduce: Read help descriptions for ROUNDDOWN and TRUNC functions. Actual Results: Different wording for two functions that perform exactly the same function. Expected Results: Consistent wording for two functions that perform exactly the same function. Reproducible: Always User Profile Reset: No Additional Info: Viewed latest 7.3 online help.
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.
Created attachment 177464 [details] 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.
Created attachment 177465 [details] Exported XLSX file
Patch available for review at: https://gerrit.libreoffice.org/c/help/+/128244
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/6b1075e1e032be5bb6cba1dbdcc11de2a1824add tdf#145332 Improve help pages for TRUNC and ROUNDDOWN
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/36f71cb8d29fde0c8b42238ba59bc1d73b042cc6 Related tdf#145332 Fix sentence about TRUNC function