Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 01 Sep 2020 18:16:48 +0200XIRR with non-contiguous cellshttps://ask.libreoffice.org/en/question/263590/xirr-with-non-contiguous-cells/Can I use CALC's XIRR with non-contiguous cells?
When I try I get a 504 error.
<pre><code> (100.00) 01/01/20
(100.00) 105.00 01/03/20
107.00 01/15/20
110.00 02/25/20
0.42
Err:504</code></pre>
The formula in B7 is =XIRR(B1:B4,C1:C4,0.01)
The formula in B8 is =XIRR((A2,B2:B4),C1:C4,0.01)
Thanks
[C:\fakepath\XIRR Sample.ods](/upfiles/1599068345264858.ods)
(*Edit:* fixed PRE formatting -AK)jdkinneTue, 01 Sep 2020 18:16:48 +0200https://ask.libreoffice.org/en/question/263590/How can I prevent Calc from automatically selecting all the cells above a function? Excel is so easy, you just hold the Ctrl key and select any cells, even non-contiguous cells. Calc's auto selection is driving me crazy!https://ask.libreoffice.org/en/question/98185/how-can-i-prevent-calc-from-automatically-selecting-all-the-cells-above-a-function-excel-is-so-easy-you-just-hold-the-ctrl-key-and-select-any-cells/ Let's say you have a column of 10 cells (Rows 1-10) and you want to find the sum. You click cell 11 (where you want to display the sum) and hit the SUM (sigma) radio button. Calc will automatically highlight all 10 entries in the cells above. That's fine if you want to sum ALL of the cells. But what if you want to sum only 8 of the 10 and perhaps they are not all contiguous? I cannot figure out how to just include the desired cells! Excel is so very easy. You just hold the CTRL key down and click on each cell that you want to include in the sum. No gymnastics..it just works and so simple. Why can't Libre Calc do this? What am I missing?WillBMon, 05 Jun 2017 22:56:46 +0200https://ask.libreoffice.org/en/question/98185/Writer: print non-contiguous pages?https://ask.libreoffice.org/en/question/94370/writer-print-non-contiguous-pages/In Word I was able to print non-contiguous pages and different sections by entering commands in the "Pages" field of the Print Dialog. For example, by entering "p1s1,p1s2" I could print the first pages of sections 1 and 2.
This is critical in creating brochures that print with multiple pages per printed page and on both sides.
This does not seem to work in Libre Office "Writer" (v 5.2.6.2) Is there a different approach that I can utilize?
Thanks!
Todd
ToddLibreSat, 06 May 2017 21:28:07 +0200https://ask.libreoffice.org/en/question/94370/How can non-contiguous entries be selected for use with the AVERAGE function?https://ask.libreoffice.org/en/question/38329/how-can-non-contiguous-entries-be-selected-for-use-with-the-average-function/HOW are they selected?abiThu, 14 Aug 2014 20:43:07 +0200https://ask.libreoffice.org/en/question/38329/