Re: Incorrect formula of function RECEIVED.

2023-05-02 Thread Czesław Wolański
On 2023/05/02 16:22:10 Czesław Wolański wrote: > It follows that the function > RECEIVED(settlementdate; maturitydate; purchasevalue; discountrate; basis) > should return the same value as the formula > = purchasevalue * ( 1 - discountrate * > YEARFRAC(settlementdate;maturitydate

Re: Incorrect formula of function RECEIVED.

2023-05-02 Thread Czesław Wolański
Hi, On 2023/05/02 15:59:01 Vijay Vardhan wrote: > Correct formula is as follows: > RECEIVED = PurchaseValue*(1/( 1 - > (DiscountRate*days_difference/days_in_year))). You're right. For a zero coupon bond [1]: received = purchasevalue + received * discountrate * ( days_to_maturity / days_in_year

Re: Registering to report an issue in OpenOffice

2022-12-28 Thread Czesław Wolański
Hello, Self-registration (user account creation) has been disabled due to an epidemic of spam. There is a topic on the French forum "Reporter une bogue, demander une amélioration ou voter" where you shall find relevant information. https://forum.openoffice.org/fr/forum/viewtopic.php?p=165300&s

Re: Cell grid lines not printing

2022-12-05 Thread Czesław Wolański
Hi, On 2022/12/05 14:51:15 Joost Andrae wrote: > the cell grid lines won't print. This can be changed, via 'Format - Page - Sheet tab', the "Grid" check box Regards, Czesław - To unsubscribe, e-mail: users-unsubscr...@openoffi

Re: Disappearing Toolbar

2022-06-02 Thread Czesław Wolański
Hi all, I can't confirm it either with 4.2.0 Two Bugzilla issues describe naughty behaviour of the Find toolbar: 123415 and 123790. It started with version 3.4.0 https://bz.apache.org/ooo/show_bug.cgi?id=123415 https://bz.apache.org/ooo/show_bug.cgi?id=123790 Regards, Czesław

Re: What Open Office version do I use?

2021-02-20 Thread Czesław Wolański
Hi William, AOO 4.1.9. Release Notes https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1.9+Release+Notes Please see section "For macOS users" You might also find useful "[Tutorial] Mac FAQ" https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=89283 section "Q05: MacOS won't le

Re: Error 511

2020-11-27 Thread Czesław Wolański
e the name of your function to something unique e.g. addressPM() and it shall work. (of course your function must be saved in the default module). Regards, Czesław Wolański - To unsubscribe, e-mail: users-unsubscr...@openoffi