To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104377
User er changed the following:
What |Old value |New value
================================================================================
Status|RESOLVED |CLOSED
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Aug 21 12:25:43 +0000
2009 -------
The spec mostly defines what major spreadsheet implementations do. Gnumeric,
Excel, Calc and KSpread calculate as described, it wouldn't make sense to change
the spec.
@multimiffo:
As you mentioned issue 75536, no it was not agreed there to implement something
different than Excel does. For details about the modulo handling please see my
comment http://www.openoffice.org/issues/show_bug.cgi?id=75536#desc10
If really needed you can easily define your own REMAINDER function that
calculates
='dividend'-QUOTIENT('dividend';'divider')*'divider'
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]