https://bugs.documentfoundation.org/show_bug.cgi?id=166787
Bug ID: 166787
Summary: Suggestion: Add MOD (modulo) function to Writer
(error: Expression is faulty)
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
Trying to calculate a simple MOD in writer gives error "** Expression is faulty
**" because the function was not implemented.
Writer's list of implemented functions (
https://help.libreoffice.org/latest/en-US/text/swriter/02/14020000.html ) is
not long, but it still includes functions that I can't even imagine why people
would use. I am not advocating to remove anything. And while fully
understanding that Calc exists, but MOD is such a basic function (on the level
of addition, subtraction, multiplication and division) that I think it should
be implemented in the Writer as well.
Example use case:
- A monthly document with important info. Should include date and weekday for
each day of the month. The date row can be easily solved with formula "take the
value of the cell above and add 1". But a similar function ("value of cell
above" MOD 7) can't be done with the weekday.
Related bug: #123384,
https://bugs.documentfoundation.org/show_bug.cgi?id=123384
Steps to Reproduce:
Try to use MOD in table cell.
Actual Results:
Doesn't work.
Expected Results:
Modulo works.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Ubuntu package version: 4:25.2.3-0ubuntu0.22.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
