[Libreoffice-bugs] [Bug 145332] Consider updating Calc help for ROUNDDOWN and TRUNC functions

2022-01-11 Thread bugzilla-daemon
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

2022-01-11 Thread bugzilla-daemon
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

2022-01-11 Thread bugzilla-daemon
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

2022-01-11 Thread bugzilla-daemon
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

2022-01-11 Thread bugzilla-daemon
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

2021-11-26 Thread bugzilla-daemon
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

2021-11-26 Thread bugzilla-daemon
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

2021-11-10 Thread bugzilla-daemon
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

2021-10-27 Thread bugzilla-daemon
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.