From Excel97 help:
QUOTIENT
Returns the integer portion of a division. Use this function when you
want to discard the remainder of a division.
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must
enable it by using the Add-Ins command on the Tools menu.
CPHennessy wrote:
On Thu February 2 2006 15:11, Brian C. Huffman wrote:
I recently encountered an incompatibility when exporting from OOO to
Excel97/2000/XP. Apparently, Excel doesn't have a Quotient function.
While I know there's a specific warning that some formatting information
may be lost, I'm wondering why this was done. Certainly coming as close
to possible in compatibility (at least when doing the export) with the
MS products will help to make OOO a more attractive product.
Is there any way to resolve this export issue or is this just something
that the user of OOO should keep in mind when creating equations?
HI Brian,
If Excel has something similar that OOo should be using then you could
consider it a bug that OOo is not using that when exporting to XLS. However
if what you have found is a missing feature in Excel then you should open a
bug report with Microsoft :)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
