Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 24 Mar 2018 16:23:25 +0100Formulae appear as text - how do I make it calculate (v.6 64-BIThttps://ask.libreoffice.org/en/question/150361/formulae-appear-as-text-how-do-i-make-it-calculate-v6-64-bit/ I've used several spreadsheets, including yours. When I type "=left(a4)" I hoped to get a number representing the length of the text string located at A4. All I get is the formula, and I can't figure out how to get around this. I've typed the formula directly and I've constructed it with the wizard, same result.DHoffSat, 24 Mar 2018 16:23:25 +0100https://ask.libreoffice.org/en/question/150361/Calculate total duration of an impress presentationhttps://ask.libreoffice.org/en/question/63035/calculate-total-duration-of-an-impress-presentation/ Hello guys,
Is there any way to I calculate the total duration of my presentation? Maybe reading the metadata from my .odp file and using some script.
I need this to kill the process after my presentation ends. I didn't found another way to just start my presentation from terminal, show all slides and close the presentation.
If you know another way to do this please tell me :) I'm just beginning in the free software world.
I'm using LibreOffice 4.2.8.2 420m0(Build:2)
In a Elementary OS
thiagoThu, 14 Jan 2016 03:12:44 +0100https://ask.libreoffice.org/en/question/63035/Calculating elapsed time problemshttps://ask.libreoffice.org/en/question/74380/calculating-elapsed-time-problems/ I am new to LibreOffice. The formula to calculate the elapsed time works in Excel but it's not working in LibreOffice. I found this to try - https://help.libreoffice.org/Calc/Calculating_Time_Differences and it worked when I inputted it on my windows PC Excel spreadsheet. So I used it on LO and the time difference I get from 10am to 6pm is .333. What am I doing wrong?swestMon, 01 Aug 2016 03:47:29 +0200https://ask.libreoffice.org/en/question/74380/Can one calculate age from a birthday field in Libre Office Base?https://ask.libreoffice.org/en/question/74302/can-one-calculate-age-from-a-birthday-field-in-libre-office-base/The question I am asking really refers to any date. Can one calculate time (either in days or years) between a past date (in a date field) and today. I know this can easily be done in Libre Office Calc, but I am wondering if it can be done in Libre Office Base. I am not familar with sql, so I was wondering if this could be done in a design query or through a wizard. I am also interested in knowing how to calculate time between two date fields, and two hour/minute fields (in minutes).
I am currently trying to transfer some of my data and queries from Lotus Approach which was very user friendly for those who do not know sql. However, if this cannot be done any other way is there a Libre Office tutorial or textbook to learn sql for libre office base?
Thanks for any help you can give. The learning curve between a simple minded use of Approach and Base is a difficult one for me.Quarto DieSat, 30 Jul 2016 20:41:54 +0200https://ask.libreoffice.org/en/question/74302/I cannot get a formula to work in LibreOffice Calchttps://ask.libreoffice.org/en/question/74307/i-cannot-get-a-formula-to-work-in-libreoffice-calc/It is simply the sum of a column, but it just displays the formula and does not calculate. I am using Ubuntu 16.04 on a Dell Inspiron 1545. This is a spreadsheet that I derived from a downloaded CSV that was comma delimited. I removed those fields that were the title and description of the spreadsheet, leaving only columns. The column I'm trying to add is "currency" data type.snurd1Sat, 30 Jul 2016 21:28:54 +0200https://ask.libreoffice.org/en/question/74307/How to calculate the numbers of days between two dates in a query in base?https://ask.libreoffice.org/en/question/62272/how-to-calculate-the-numbers-of-days-between-two-dates-in-a-query-in-base/How can I calculate the numbers of days between two dates in a query in base?
Simple example: In a query I have a field called **DateArrived** and another called **DatePurchase**. Both display fine.
I added a field called **NOW()** and it correct showed the current date on each record.
I then added a field called:
**DateArrived DatePurchase**
(..and Base converted it to:)
**"DateArrived" - "DatePurchase"**
..in order to calculate the number of days between the two dates. I got the error:
**SQL Status: 37000
Error code: -16
Wrong data type: java.lang.NumberFormatException in statement [SELECT "DatePurchase" "DatePurchase", "DateArrived" "DateArrived", "DateArrived" - "DatePurchase" "Days" FROM "T_Drives"]**
How can I resolve this please?TheDatabaseGuyThu, 24 Dec 2015 11:55:56 +0100https://ask.libreoffice.org/en/question/62272/how to calculate age from birth day in libreoffice calc?https://ask.libreoffice.org/en/question/47898/how-to-calculate-age-from-birth-day-in-libreoffice-calc/I want to calculate age like Years, Months and Days between Date_Of_Birth and Todays Date. Its work fine in EXCEL =DATEDIF() function, But Libreoffice Calc i could not calculate. Please can anybody help me in these regard...
I use UBUNTU 12.04 LTS
LibreOffice 3.5
Golam007Wed, 18 Mar 2015 20:24:12 +0100https://ask.libreoffice.org/en/question/47898/Change GMT date and time to GMT minus 7https://ask.libreoffice.org/en/question/42041/change-gmt-date-and-time-to-gmt-minus-7/Sorry, I can't upload my example because I need 3 points to do so. But you can copy/paste the semi-colon separated values below, save it as a .csv file then open it in LibreOffice spreadsheet and delimit on semicolons only (since there are commas in the formulas). :)
When I download Twitter stats, I get a .csv file that contains this date and time format (in one cell):
2014-11-02 01:58 +0000
Their date and time is provided in Greenwich Mean Time, but I want the data to display in my local date and time (GMT - 7, Arizona USA).
I concocted a time-consuming and manual workaround where I delimit/break apart the contents of the original cell so that the info is spread across 12 columns, like this:
Begin copy paste into .csv file here:
a;b;c;d orig gmt;e date only;f hour;g minute;h gmt;i gmt-7;j azHour;k azTime;l azDate
528727735825601000;https://twitter.com/radiophoenix/status/528727735825600513;Tune in now (7-9 p.m.) for @HipRawkNation http://t.co/UHeZPRk6Ls;2014-11-02 01:58 +0000;2014-11-02;01;58;+0000;=F2-7;=IF(F2<7, F2+24-7-12+12, F2-7);=TIME(J2, G2, 0);=IF(F2<7, (E2-1), E2)
528697813476340000;https://twitter.com/radiophoenix/status/528697813476339712;Now Playing The Revelations - How Could You Walk Away (Featuring Tre Williams) http://t.co/vzLPekOpsL;2014-11-01 23:59 +0000;2014-11-01;23;59;+0000;=F3-7;=IF(F3<7, F3+24-7-12+12, F3-7);=TIME(J3, G3, 0);=IF(F3<7, (E3-1), E3)
NOTES:
"separated by other = ;"
format columns E as date Y/M/D
The date should change in the first row of data (from Nov. 2 to Nov. 1, 2014), but not in the second (should remain Nov. 1, 2014).
End copy paste.^^
I really do not want to go through this formatting, etc. every time I download new data from Twitter. Is it possible to update both the date and the time in one or two lines? Math is NOT my strong suit so I've burned hours on something you can probably whip up in 5 minutes.
Thank you! :)
PS I am using LibreOffice 3.5.5.3
Build ID: 7122e39-92ed229-498d286-15e43b4-d70da21
Mac OS 10.6.8 pamelar987Wed, 05 Nov 2014 02:32:49 +0100https://ask.libreoffice.org/en/question/42041/Draw, indicate area (and perimeter) of a closed polygon ?https://ask.libreoffice.org/en/question/32441/draw-indicate-area-and-perimeter-of-a-closed-polygon/Area, perimeter, as part of description of a closed polygon ?
It could also be useful as a tool to calculate an surface area on a bitmap layer.twinsunSun, 06 Apr 2014 20:00:07 +0200https://ask.libreoffice.org/en/question/32441/how to calculate percentage with 2 decimal value and percentage sign?https://ask.libreoffice.org/en/question/38165/how-to-calculate-percentage-with-2-decimal-value-and-percentage-sign/when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer.
My Operating System is ubuntu 12.04 LTS.
LibreOffice Calc 3.5.7.2
my work details
in Cell F2 Total Marks Obtained 460 Out of 700
then calculate percentage in cell G2
Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571
then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%
GOLAM007Mon, 11 Aug 2014 19:11:39 +0200https://ask.libreoffice.org/en/question/38165/how to make a computed field in query within basehttps://ask.libreoffice.org/en/question/38833/how-to-make-a-computed-field-in-query-within-base/Table.Amount = num
calculate new field: Tax = Amount * 0.2DickStompMon, 25 Aug 2014 21:22:37 +0200https://ask.libreoffice.org/en/question/38833/