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]

Reply via email to