Ask Your Question

benchrest's profile - activity

2019-11-05 13:08:29 +0200 received badge  Notable Question (source)
2019-10-24 18:11:44 +0200 received badge  Famous Question (source)
2019-08-23 05:02:45 +0200 commented question Which Libreoffice app is for creating and opening PDF files?

Above is for creating. But if you want to open an existing PDF for edit, draw might be your answer.

2019-08-23 04:57:23 +0200 commented question Which Libreoffice app is for creating and opening PDF files?

All of them. What are you wanting specifically? If you want to type up a document and export as PDF use writer. If you h

2019-08-17 20:04:49 +0200 answered a question LO6.2.5 no menu box that shows the contents of selected cell for editing

To my above comment: from View/ Toolbars / check "Formula Bar"

2019-08-17 18:51:33 +0200 commented question LO6.2.5 no menu box that shows the contents of selected cell for editing

Maybe I don't understand your problem. But selecting a cell in Calc show on the input line the value or formula. Select

2019-08-17 16:03:52 +0200 received badge  Famous Question (source)
2019-08-10 16:10:10 +0200 answered a question how can i disable auto correct in calc?

https://help.libreoffice.org/Common/AutoCorrect To turn on or to turn off the AutoCorrect feature, in LibreOffice Calc c

2019-08-09 16:28:11 +0200 commented question Why is this popping up in my pc - the application cannot be started. User installation could not be completed.

What operating system and release? What version of Libre office? If on linux open terminal and type libreoffice and see

2019-08-09 00:48:05 +0200 commented answer Can LibreOffice be configured to show filename extensions

I'm using 6.3 and my file extension for calc files, .ods shows in the title bar. I am using LinuxMint 19. I know windows

2019-08-09 00:43:50 +0200 commented answer Can LibreOffice be configured to show filename extensions

I'm using 6.3 and my file extension for calc files, .ods shows in the title bar. I am usinf LinuxMint 19. I know windows

2019-08-09 00:01:00 +0200 answered a question Are there paper formats for label printing?

Yes, I can't answer completely as I don't use them. On the upper left of writer File/New/Labels/Brand/AveryA4 etc. also

2019-08-07 00:50:14 +0200 answered a question How do I tie a secondary Y axis to chart data?

I just create my chart with all the items I want both primary and secondary. They will all be in the primary.. The doulb

2019-08-05 23:19:49 +0200 commented question The top menubar is corrupted

Just a guess, are you using a different theme in this Fedora than your other Fedora systems? LO follows the system theme

2019-08-03 04:40:14 +0200 answered a question How to remove a hyperlink

Select the cell with the hyperlink, select Format/Clear Direct Formatting I just tried it on 6.3 and works. The other o

2019-07-14 22:45:57 +0200 received badge  Famous Question (source)
2019-07-08 21:07:20 +0200 received badge  Popular Question (source)
2019-07-03 19:52:51 +0200 received badge  Notable Question (source)
2019-07-03 19:02:00 +0200 asked a question Calc import CSV file with weekly data every fifth row to monthly

Calc import CSV file with weekly data every fifth row to monthly I could do this manually but would have some 400 entrie

2019-05-20 15:59:47 +0200 received badge  Notable Question (source)
2019-05-20 06:08:11 +0200 received badge  Popular Question (source)
2019-05-20 04:54:58 +0200 received badge  Notable Question (source)
2019-05-20 04:35:51 +0200 edited question how do I change calc sheet tab size in 6.3 alpha1

how do I change calc sheet tab size in 6.3 alpha1 I just upgraded from LO 6.3 Alpha0 (from March) to Alpha1 and the calc

2019-05-20 02:02:42 +0200 edited question how do I change calc sheet tab size in 6.3 alpha1

how do I change calc sheet tab size in 6.3 alpha1 I just upgraded from LO 6.3 Alpha0 (from March) to Alpha1 and the calc

2019-05-20 01:46:47 +0200 edited question how do I change calc sheet tab size in 6.3 alpha1

how do I change calc tab size I just upgraded from LO 6.3 Alpha0 (from March) to Alpha1 and the calc sheet tabs are far

2019-05-20 00:16:26 +0200 asked a question how do I change calc sheet tab size in 6.3 alpha1

how do I change calc tab size I just upgraded from LO 6.3 Alpha0 (from March) to Alpha1 and the calc sheet tabs are far

2019-05-19 19:13:15 +0200 received badge  Popular Question (source)
2019-05-18 23:51:27 +0200 asked a question Can I have two X Axis in a chart?

Can I have two X Axis in a chart? This question has been around for many years, but now that I am on 6.3 of calc I was h

2019-04-29 14:02:14 +0200 received badge  Popular Question (source)
2019-04-28 22:34:18 +0200 asked a question Daily build does not work, how to report?

Daily build does not work, how to report? I have been running master~2019-03-02_23.38.22_LibreOfficeDev_6.3.0.0.alpha0_L

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  Notable Question (source)
2018-05-23 23:24:54 +0200 received badge  Popular 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

2016-02-19 11:50:15 +0200 marked best answer 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.