To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=107849
Issue #|107849
Summary|Lack of Formulas
Component|Word processor
Version|OOO310m19
Platform|Other
URL|
OS/Version|Windows Vista
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P1
Subcomponent|editing
Assigned to|writerneedsconfirm
Reported by|predatorking
--- Additional comments from predatork...@openoffice.org Tue Dec 22
22:53:17 + 2009 ---
I have noticed that the OpenOffice.org Writer is missing many functions that
are otherwise available in the OpenOffice.org Calc application. The incident
at hand concerns writing a form letter that will automatically calculate a
financial value. The original formula from Calc is:
=H19*(POWER(1+(0.05/12);((12)*(MONTHS(J19;K19;1)
This formula is used to calculate compound interest of a principal amount
located in H19 over a time period of months between J19 (Date1) and K19
(Date2). However, as I change the values of H19 to equal a preset user field
of any number that I choose to input, but labeled Amount, and as I change
the beginning dates of J19 to Date1 and K19 to Date 2, the expression (shown
below) is considered to be faulty in the Writer application.
Amount*(POWER(1+(0.05/12);((12)*(MONTHS(Date1;Date2;1)
This, I believe, though I may be mistaken, is due to the limited formula
calculation abilities of the Writer application. I am simply asking that all
of the formulas available in the Calc application be made available in the
Writer application, perhaps in the next update. Thank you for recieving this
support request!
Jordan Lunda
-
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: issues-unsubscr...@sw.openoffice.org
For additional commands, e-mail: issues-h...@sw.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
