Ask Your Question

benchrest's profile - activity

2019-04-09 00:25:06 +0200 received badge  Popular Question (source)
2019-02-22 00:02:17 +0200 answered a question How can I change the default font color in calc?

I would like to know also. I never use the default "Dark Red 2". I would like to change it to the color I use most.

2019-02-09 18:33:55 +0200 edited question add data series to existing chart from 2nd sheet

add data series to existing chart from 2nd sheet With 6.2.0.3 I cannot add a new data series to a chart if the data seri

2019-02-09 18:33:55 +0200 received badge  Editor (source)
2019-02-09 16:26:44 +0200 asked a question add data series to existing chart from 2nd sheet

add data series to existing chart from 2nd sheet With 6.2.0.3 I cannot add a new data series to a chart if the data seri

2019-02-08 16:46:22 +0200 received badge  Famous Question (source)
2019-02-03 18:15:38 +0200 received badge  Notable Question (source)
2019-01-31 00:06:59 +0200 received badge  Notable Question (source)
2019-01-31 00:06:59 +0200 received badge  Popular Question (source)
2019-01-10 18:12:47 +0200 received badge  Popular Question (source)
2018-12-30 18:36:00 +0200 asked a question In LO Calc right click causes cut

In LO Calc right click causes cut LO 6.0.7.3 Calc LinuxMint 19.0 - right click on selected cell results in CUT about 10%

2018-12-29 00:01:04 +0200 received badge  Enthusiast
2018-11-28 01:17:33 +0200 edited question font color recent

font color recent SOLVED How do I reset the recent font colors? Select a wrong color by accident and it is there for ev

2018-11-28 01:16:37 +0200 answered a question font color recent

tools/options/advanced/open expert configuration/ search for "recent" org.openoffice.Office.Common / UserColors edit "Re

2018-11-27 23:36:45 +0200 asked a question font color recent

font color recent How do I reset the recent font colors? Select a wrong color by accident and it is there for ever since

2018-07-09 21:50:59 +0200 received badge  Famous Question (source)
2018-05-23 23:24:54 +0200 received badge  Popular Question (source)
2018-05-23 23:24:54 +0200 received badge  Notable Question (source)
2018-04-09 00:31:24 +0200 asked a question LO Calc 6.0.3.2 saves one file very slow that saved fine on 5.2.4.2

LO Calc 6.0.3.2 saves one file very slow that saved fine on 5.2.4.2 Moving from LO 5.2.4.2 to 6.0.3.2 loading and savin

2014-06-27 02:29:32 +0200 received badge  Famous Question (source)
2014-02-24 14:54:45 +0200 received badge  Popular Question (source)
2014-02-24 14:54:45 +0200 received badge  Notable Question (source)
2014-01-29 19:02:39 +0200 asked a question XIRR with expected negative rate of return gives Err:502

Sometimes when I get a negative rate of return with the XIRR function I get a Err:502. I did some testing today. I have my spreadsheet entries the opposite of examples I see. I thought that might be the problem. The latest entry at the top instead of bottom as typically shown. First I did a simple example in each order

=XIRR(B6:B8,A6:A8,0.1)

05/22/13 28384.68 39.35%

01/27/14 7999.99

01/28/14 -43667.92

=XIRR(E6:E8,D6:D8,0.1)

01/28/14 -43667.92 39.35%

01/27/14 7999.99

05/22/13 28384.68

Both seem to work correctly. It doesn't seem to matter the order of the entries. Then I changed the ending total so the result would be negative.

05/22/13 28384.68 Err:502

01/27/14 7999.99

01/28/14 -23667.92

01/28/14 -23667.92 -57.78%

01/27/14 7999.99

05/22/13 28384.68

Now the order makes a difference! But it is the opposite of what I expected. As my entries that give Err:502 are in the order given in most examples.

Here is an actual failure I get

=XIRR(E13:E14,B13:B14,0.4) Err:502

01/28/2014 ($4,811.29)

01/23/2014 23.464 $213.09 $4,999.94

What am I doing wrong that I get an Err:502 instead of showing a negative rate of return? I have tried negative numbers in the guestamation without help.