Stel uw vraag

mikebibo's profiel - activiteit

2020-05-31 07:51:46 +0100 badge ontvangen  Mooi Antwoord (bron)
2020-05-27 05:36:04 +0100 badge ontvangen  Goed Antwoord (bron)
2019-12-31 00:02:54 +0100 badge ontvangen  Tovenaar (bron)
2019-08-09 11:02:36 +0100 badge ontvangen  Mooi Antwoord (bron)
2018-04-07 04:04:51 +0100 beantwoorde een vraag Need Guidance on Formatting a book

I would recommend Bruce Byfield's Designing with LibreOffice, free to download:

2018-03-08 01:21:53 +0100 bewerkte een antwoord trend line over multiple scatter plots

I think the problem is the way you are trying to do it. The 'add trendline' entry on the insert menu is probably greyed

2018-03-08 01:16:06 +0100 beantwoorde een vraag trend line over multiple scatter plots

I think the problem is the way you are trying to do it. The 'add trendline' entry on the insert menu is probably greyed

2018-02-06 14:32:09 +0100 bewerkte een antwoord How to set up a layout with marginalia and mirrored pages in Writer?

I haven't used marginalia myself, but I noticed that there is a section on how to set them up in Bruce Byfield's excelle

2018-02-06 11:46:45 +0100 beantwoorde een vraag How to set up a layout with marginalia and mirrored pages in Writer?

I haven't used marginalia myself, but I noticed that there is a section on how to set them up in Bruce Byfield's excelle

2017-10-13 02:30:03 +0100 beantwoorde een vraag Will there ever be a LibreOffice equivalent to MS Publisher?

In the open-source world there is Scribus ( for desktop publishing. It is available for Linux,

2017-06-25 21:18:45 +0100 badge ontvangen  Mooi Antwoord (bron)
2017-05-30 10:59:40 +0100 beantwoorde een vraag Can I see the stats of how much I have written during each day in a writing document?

This might interest you: It hasn't been updated for a while, and I have no

2017-04-22 07:07:02 +0100 bewerkte een antwoord Reasons to use LibreOffice versus Office?

While I personally believe in open-source software, running LibreOffice on a Linux machine, I feel obliged to point out

2017-04-22 06:57:05 +0100 beantwoorde een vraag Reasons to use LibreOffice versus Office?

While I personally believe in open-source software, running LibreOffice on a Linux machine, I feel obliged to point out

2017-04-12 11:10:36 +0100 beantwoorde een vraag New GUI Interface

It's already there - but not by default. See

2017-04-12 11:00:48 +0100 beantwoorde een vraag What is your preferred way to manage bibliography automatically in LibreOffice?

Have used both Zotero and Mendeley successfully. Mendeley has a pdf viewer built in which enables annotations. Zotero

2017-04-12 10:51:56 +0100 beantwoorde een vraag Is it possible to export LibreOffice .odt as Latex?

Have a look at Pandoc:

2016-12-16 01:34:50 +0100 beantwoorde een vraag Libre HTML pages do not validate at

Any of the many text editors that support Markdown/Pandoc. Haroopad (cross-platform) and MacDown (Mac), for example, are both free and export in both HTML and PDF.

2016-12-04 05:16:40 +0100 beantwoorde een vraag Can I input a date earlier than year 1583 in LO (Base and Calc)?

Short answer: yes.

Long answer: Libreoffice stores date values as a number. The number represents the number of days from an arbitrary reference date. In the case of Libreoffice calc, the default reference date is 30 Dec 1899. Dates earlier than this are simply stored as negative numbers. Other options for reference dates can be chosen under Preferences > LibreOffice Calc >> Calculate.

I'm impressed that you have been able to trace your family back this far.

Are you aware that there are specific applications for genealogical projects? One free, cross-platform and open-source example is Gramps (

2016-12-02 23:30:17 +0100 reageerde op een antwoord Can anyone give me a good online training site or book to learn with
2016-12-01 06:07:09 +0100 beantwoorde een vraag Help writing a formula

How about showing us what your calc syntax looks like, and providing some example data with correct and incorrect answers? I would have thought:

If T value is in cell A1, and the angle A is in cell B1, then the formula for R for example in cell C1 = 2*A1*COS(B1/2) would be what you want.

Are you sure the calculator answer is correct? Angle A measured in degrees or radians? Calculator correctly handles the sequence of operations?

You could try breaking down the formula and calculating each part separately, e.g. do you get the same answer from calculator and calc for just COS(A/2) aka =COS(B1/2)?


I just found this (

COS Returns the cosine of the given angle (in radians).

Syntax COS(Number)

Returns the (trigonometric) cosine of Number, the angle in radians.

To return the cosine of an angle in degrees, use the RADIANS function.


=COS(PI()2) returns 1, the cosine of 2PI radians.

=COS(RADIANS(60)) returns 0.5, the cosine of 60 degrees.

So maybe what you need is:


2016-12-01 05:43:00 +0100 beantwoorde een vraag Why can't I save docs as PDFs and all my PDFs turn into Wordpad??

There is a difference between the format files are saved in and the application used to open them. There may be nothing wrong with your PDFs (a file format), just the application (e.g. Wordpad) that you are attempting to open them with. Wordpad is a simplified word processor and is not meant for PDFs.

If you export to PDF from within LibreOffice, does it save a PDF file?

Do you have a PDF reader, such as Adobe Acrobat Reader, Foxit reader or PDF Xchange viewer, installed? Did your service person perhaps uninstall it?

Try specifically opening your PDF files in a PDF reader by either opening Acrobat Reader first and then from within that application opening your file or, in windows explorer, right-clicking the PDF file and choosing open with... and choosing your PDF reader from the list of applications. Do the files open OK?

If these things check out OK, then it is probably an issue with telling Windows what application to use by default to open PDF files. As you haven't told us what version of Windows you are running, see here for multiple instructions:

2016-11-30 23:21:54 +0100 beantwoorde een vraag Mac OS download won't install after moving icon

On OSX, for software distributed as disk images (.dmg), installation is as simple as copying the .dmg file to applications. Does LO now appear in your Applications folder? Does LO appear in Launchpad? You should be able to start it from either location.

If you have trouble starting LO and see messages about 'verifying' or 'unknown developers', have a look here: or change your settings under System Preferences >> Security and Privacy.

2016-11-30 06:11:13 +0100 reageerde op een antwoord APA-Style Graphs

I've never actually used it, but I found this: Good luck with your project.

2016-11-29 05:04:09 +0100 beantwoorde een vraag APA-Style Graphs

As no-one else has responded, and at the risk of embarrassing myself, I can't find any obvious way to extend the x-axis scale beyond the categories for a line chart either. Someone else might know better. Annoyingly, Excel does what you want by default. You might like to submit an enhancement request.

For a work-around, see here: But in your case, with only two categories, this probably produces too much space on either side.

If you instead use a scatterplot with points and lines, you can get the format you want, but the x-axis becomes a numerical scale. An ugly hack, if you are in a hurry to produce something, is to use the scatterplot and suppress the x-axis labels. You can then add your category labels manually, with text boxes.

The legend can simply be dragged and re-sized as desired.

For high-resolution, publication-ready graphs I can recommend the open-source R project (, but it does come with a learning curve.

2016-11-29 03:43:03 +0100 beantwoorde een vraag Reverse value: "07-03-2014" to "2014-03-07

Find and replace should work, with regular expressions.

In the find and replace dialogue, under other options, make sure regular expressions is checked.

Then search for: ([0-9]{2})-+([0-9]{2})-+([0-9]{4})

and replace with: $3-$2-$1

This searches for a pattern of two digits, a dash, two digits, a dash, and four digits. It then simply reverses the order of the components. See for more detail.

It worked for a simple example in both a text document and a spreadsheet, but it is not extensively tested. Someone with greater skills in using regular expressions may be able to improve on this. Hope it helps.

2016-09-20 14:37:04 +0100 beantwoorde een vraag Impress; why is it not possible to highlight text?

The highlighting colour button is found on the text formatting toolbar, as the help indicates. However, it can also be accessed through the format menu: Format > Character > Highlighting. It can also be found on the properties sidebar under Character.

2016-08-13 02:58:38 +0100 beantwoorde een vraag no font color change option in Impress

Font colour is character formatting. You can find controls under Format > Character > Font Effects > Font Colour or on the Character formatting section on the sidebar or on the Text Formatting toolbar.

2016-08-11 04:25:14 +0100 beantwoorde een vraag Stacked bar chart, multiple rows

Perhaps the easiest way is by rearranging your data. This can be done with a pivot table, so that you end up with dates as rows, usernames as columns and quantities as data. Remember to de-select row and column totals, as you probably don't want them included in your barchart. From there, simply selecting a stacked barchart should give you want you want.

2016-08-10 07:51:46 +0100 beantwoorde een vraag How do I turn a power curve trendline equation into a predictive column?

The figures you have given match a power trendline rather than an exponential trendline, as drawn by calc. I may be wrong, but isn't the formula simply f(x)=8369.72*A1^-0.8242118082 ? This yields predicted values that seem to match the drawn curve.

2016-08-05 23:40:33 +0100 badge ontvangen  Mooi Antwoord (bron)
2016-06-10 02:20:54 +0100 beantwoorde een vraag Write an initial letter

Try Format -> Paragraph -> Drop Caps and choose "Display drop caps", and select the number of lines you want to appear in the height of the first letter.

2016-06-10 01:12:11 +0100 beantwoorde een vraag right mouse button menu "create new LibO ... document" in LINUX

I have a fresh install of Kubuntu 16.04 with KDE PLasma version 5.5. I just checked and I do have "Create new... LO calc...; LO Writer...; etc on the right-click context menu in Dolphin. These are installed by package "libreoffice-kde" (I checked by uninstalling it and the context menu items disappeared). OpenSuse seems to have a package by the same name. You could check to see if that is installed. The direct download of the latest version of LibreOffice includes a package called "kde-integration". I don't know for sure if this provides similar functionality.

2016-05-27 05:29:09 +0100 beantwoorde een vraag 5.2 rc1 release date
2016-05-13 08:14:04 +0100 beantwoorde een vraag I paid a donation to LibreOffice but it still doesn't download

As previously stated, downloads are independent of donations:

Did you perhaps just not notice that the download started automatically? Some browsers don't make it very obvious. If the download did not start automatically, did you manually click on the link? hint: the link is the filename in green in the line near the top of the page:

Your download LibreOffice_5.1.2_MacOS_x86-64.dmg should begin shortly. Please click the link in case it doesn't start.

2016-05-07 12:48:19 +0100 beantwoorde een vraag Installation Problem of Libre Office on my Mac

If you are simply wanting to use LO, it is not the SDK (Software Development Kit) that you want. What you do want is LibreOffice_5.1.2_MacOS_x86-64.dmg - linked to the big green download button on the download page. This will be over 200MB in size. Once you have the correct download, installation should be straightforward.

2016-03-06 09:20:20 +0100 beantwoorde een vraag PivtTable-"Create" command missing. Only 'refresh' and 'delete' are there

Apparently it has been moved to the insert menu, see:

2016-01-21 23:28:24 +0100 beantwoorde een vraag How can I cross-reference a table

You first need to apply a caption to the table. Once you give the table a caption (put cursor anywhere in the table, Insert >>Caption), it should appear among the cross-reference options.

2016-01-13 12:46:33 +0100 beantwoorde een vraag how do you ugrade to latest version in ubuntu

You can (perhaps depending on what version of Ubuntu you are running), either by using a PPA, such as and upgrading through your usual package manager, or by downloading the DEB version and following the installation instructions in the README file.

2016-01-07 02:30:09 +0100 beantwoorde een vraag Is there any website that is not at all connected to LO that I can contact that has absolutely no affiliations with LO?

Firstly, yes, I believe so. Secondly, most/many of the people contributing to this site have no official connection to the LO organisation, but are simply users of the software trying to 'give something back' in return for great free software, and they may find some of your comments disappointing if not actually insulting. Thirdly, you do not help yourself in this matter by not stating which version of LO or even which operating system you are using, as you are specifically asked to do every time you post a question. On some operating systems, the LO built-in help is a separate download and installation, without which it reverts to the online help. Fourthly, the only way I can reproduce anything like your description, particularly the part about 'the second and subsequent pages are now way way to the left of the top page', is by changing the view to book view. Make sure the status bar is visible (View-->Status Bar is ticked). Then , in the status bar at the very bottom of the window, on the right hand side, next to the zoom control, you can switch between book view, multiple-page view and single-page view. If this is the issue, select single-page view and adjust the level of zoom to whatever works for you. ( ). If this is not your issue, perhaps further description or a screenshot would help members of the LO community to help you.

2015-12-21 01:52:42 +0100 reageerde op een antwoord Cannot install 5.0.4 .deb Linux package

There are PPA repositories for LO that work with Ubuntu and, I think, Mint. I don't know if they are compatible with Linux Lite.

2015-12-18 02:09:47 +0100 beantwoorde een vraag I’m a brand-new user. Can you make mailing labels with Libre Office? I use a mac

File -> New -> Labels

Also, in Writer, Insert -> Envelopes if your printer can handle envelopes directly.

2015-12-16 01:25:22 +0100 beantwoorde een vraag R integration

You can work in R with Markdown (RStudio integrates the two nicely), and then output to ODT using Pandoc. See

2015-12-16 00:37:44 +0100 beantwoorde een vraag Can't load once installed using new macbook w/Yosemite just shows "Verifying"

Probably to do with gatekeeper, as explained here:

2015-12-03 00:32:39 +0100 beantwoorde een vraag How can I add columns to textbox in Draw?

Not to denigrate LibreOffice at all, if you are doing a lot of desktop publishing and would like to use an open-source tool, you could also have a look at Scribus ( ). It is open-source, and cross-platform. It will allow you, for example, to 'flow' text from one text box to another and gives very fine control over columns and margins in individual text boxes.