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 +0000 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
