Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 10 Aug 2018 23:11:25 +0200Leave only differing cellshttps://ask.libreoffice.org/en/question/162612/leave-only-differing-cells/I have a file (table) and its new version with 11486 new rows and some changes to some of the existing 108408. How to delete same rows so that only modified/new ones are left?SabhotepFri, 10 Aug 2018 23:11:25 +0200https://ask.libreoffice.org/en/question/162612/Calculate the difference between two cellshttps://ask.libreoffice.org/en/question/126545/calculate-the-difference-between-two-cells/ In cell 1A value = 100
in cell 2A value = 200
In cell 3A value = 300
..and so on
Difference amount goes into 1B
So in this case 1B = 200 (3A-1A)
Without knowing how many entries will be introduced in column A (could be 10 or could be 110 entries)
How can I ask calc to calculate the difference between the last entry in Column A and the first Entry in Column A (1A)
So Basically I just want to subtract the first entry from the last current entry In Column A with out out knowing how many entries there might be.
Thanks for the helpsimontfsThu, 24 Aug 2017 21:22:33 +0200https://ask.libreoffice.org/en/question/126545/Display Difference Between Values In 2 Sheetshttps://ask.libreoffice.org/en/question/107431/display-difference-between-values-in-2-sheets/Need some help eliminating used element from a huge list & retain only unused ones.
I have attached a spreadsheet file. It contains 2 sheets:
* Master Sheet - contains Element Number [Column A] & Number of each Element [Column B]
* Subset Sheet - contains Elements used [Column B] & Quantity used [Column D]
https://drive.google.com/file/d/0B5LHkic88qkpaUE2UVpWcy1Tclk/view?usp=sharing
How can I create a new sheet, that is a copy of the Master Sheet, that has eliminated the elements that have been included in Subset Sheet?
For example, the Master List contains 12 Nos. of the Element 05-10000 [A4, B4]. The Subset indicates that 7 Nos. of 05-10000 [B2, D2] have been utilized.
Therefore, I would like the new sheet to indicate that 5 Nos. of Element 05-10000 remain.
Additionally, the Subset sheet indicates that 1 Nos. of element 05-10100 was used. Therefore, the new sheet must indicate that 0 Nos. of 05-10100 remain.
Do note that the Element Numbers in the Subset are not arranged in sequential order.
Alternately, it is also fine, if the balance quantity can be displayed in a new column of the Master Sheet itself.sluggerSun, 02 Jul 2017 21:06:46 +0200https://ask.libreoffice.org/en/question/107431/cell format date time durationhttps://ask.libreoffice.org/en/question/68968/cell-format-date-time-duration/Need to find a clean way to **change a remainder value of time, from decimal to minutes**. ie 0.25 should be 0.25/60 = 15 mins. if I format the result cell C1 , best I can come up with is a fraction with a **format code** 0.00/60
The following formula I am using gives the duration or time difference between 2 dates and times. I can't seem to seperate my exponent to the left of the decimal from the trig on the right of the decimal point? should be basic. Don't want macros.
Cells A1 = 28/04/2016 , B1 = 06:15
A2 = 29/04/2016 , B2 = 12:25
C1= =SUM((A2+B2)-(A1+A2))*24
C1 looks like 30.10/60 with my format code.
So , any ideas how I can remove the /60 part for a clean number. I'd ideally like 40hrs 15Min as a result. If the exp and trig can be seperated,I can do that bit. Thanks for any help.
StarMarinerThu, 28 Apr 2016 22:43:04 +0200https://ask.libreoffice.org/en/question/68968/applying function in Calchttps://ask.libreoffice.org/en/question/49216/applying-function-in-calc/Hi all,
How to make function that calculate time difference from col A and B and automatically the result is shown in col C
function I used is: =(Bn<An)+Bn-An, where n is number of row.
The problem is, that function must be applied manually each time I want the result / time difference /kylieMon, 13 Apr 2015 13:30:21 +0200https://ask.libreoffice.org/en/question/49216/How do I find the differences between two lists in LibreOffice?https://ask.libreoffice.org/en/question/18393/how-do-i-find-the-differences-between-two-lists-in-libreoffice/Here's my problem: I need to take two lists, each consisting of many tens of thousands of items, most of them identical between the two lists, and find the relatively few new items in the second list.
I posed this question on a tech advice site, asking if any software existed that could do this. One answer I got included a YouTube video where a guy showed exactly how to do it in Excel, using three separate techniques. The first two were "match" and "vLookup".
So my question is: Do either of these two techniques have an equivalent in LibreOffice, and if so, where do I find explicit instructions on how to use them?gravitonSat, 01 Jun 2013 16:53:45 +0200https://ask.libreoffice.org/en/question/18393/Find values in Column B that are not in column A?https://ask.libreoffice.org/en/question/11233/find-values-in-column-b-that-are-not-in-column-a/I guess I'm looking for a SQL Difference like function
I have column A with login ids
I have column B with all possible login IDs
I want to find a way to display in Column C which items in Column B are not being used. Would this require a function or a macro?pueblonativeSat, 02 Feb 2013 05:43:39 +0100https://ask.libreoffice.org/en/question/11233/