Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 09 Feb 2019 19:36:21 +0100Passing variables from one sub to another Libre Office basichttps://ask.libreoffice.org/en/question/182487/passing-variables-from-one-sub-to-another-libre-office-basic/ Hi,
I have found a few related answers but none of them seem to work for me, so I thought I would ask by myself.
I would like to simply pass two string arrays and an integer from one sub to another. To learn how to do that I tried to pass one integer like that:
Sub test
Dim Variable as Integer
Variable = 1
test1(Variable)
End Sub
Sub test1(Variable as Integer)
Print Variable
End Sub
However, when I ran this macro I got an error "Argument is not optional". Does someone know how to fix that?
mav192Sat, 09 Feb 2019 19:36:21 +0100https://ask.libreoffice.org/en/question/182487/[Calc] How would I go about adding multiple functions to one keyboard shortcut?https://ask.libreoffice.org/en/question/182115/calc-how-would-i-go-about-adding-multiple-functions-to-one-keyboard-shortcut/[Windows 10, 64 bit, LibO version 6.2]
Javascript Developer, latest version of JRE
I'm trying to set up my keyboard shortcuts to copy the cells and delete the cells.
I cannot select multiple functions for the custom keyboard short cut, since I cannot do it this way, I'd like to create my own function to be listed for the keyboard shortcuts that allow me to copy all of the selected cells, and then delete them, or if it can be done, an explanation of how, I've considered custom macros outside of LibO that use a combination of different key strokes, but I would much rather employ those directly into LibO instead.
This isn't the entirety of the problem I'm attempting to resolve, it's just the clearest representation of what it is I am trying to do.crcordineWed, 06 Feb 2019 17:24:21 +0100https://ask.libreoffice.org/en/question/182115/New question on how can I get the total count [Solved]https://ask.libreoffice.org/en/question/180704/new-question-on-how-can-i-get-the-total-count-solved/ I am going to revise my question with a new sample. What I am trying to do is to count the items based on their current status. I cannot seem to "see" on how to do this.Thanks ahead for any and all suggestions.
[C:\fakepath\Item Total Count.ods](/upfiles/15485735712308065.ods)_daveSun, 27 Jan 2019 08:20:19 +0100https://ask.libreoffice.org/en/question/180704/Find Difference in two spreadsheetshttps://ask.libreoffice.org/en/question/179362/find-difference-in-two-spreadsheets/I have two large spreadsheets with similar data and structure but with small and undetermined differences.
Is there a ready function in Calc or some other tool which will locate and show these differences.Bill L.Tue, 15 Jan 2019 04:50:42 +0100https://ask.libreoffice.org/en/question/179362/Can I use LibreOffice Math to graph functionshttps://ask.libreoffice.org/en/question/178094/can-i-use-libreoffice-math-to-graph-functions/ I want to plot a simple function such as y = (x * x) +x + 1 on the screen and then hopefully to the printer using a range of values for x and an increment of my choosing.shoenig369Thu, 03 Jan 2019 04:41:49 +0100https://ask.libreoffice.org/en/question/178094/CALC. How to apply a function in cells where another cell in the row has a specific valuehttps://ask.libreoffice.org/en/question/172519/calc-how-to-apply-a-function-in-cells-where-another-cell-in-the-row-has-a-specific-value/Hi! Sorry if this was already asked. I know it's very basic, but I'm not able to solve it and didn't find a post about it.
I want to know the AVERAGE of the cells in column 'value' depending on the 'name'. Until now, I used to order column 'Name', so =AVERAGE(B1:B3) for µ and B4:B5 for ß, but I need to order my data constantly using other columns. Therefore, I would like to know how to select cells depending of the value of another cell in the same row. Something like AVERAGE in B1:B5 (the whole spreadsheet) WHERE column A = µ.
Could you help me?
Thanks!
A: NAME B: VALUE
µ 50
ß 90
µ 10
µ 7
ß 65kiko35Thu, 15 Nov 2018 11:25:50 +0100https://ask.libreoffice.org/en/question/172519/firebird functionshttps://ask.libreoffice.org/en/question/167414/firebird-functions/No expert in SQL, I'm having great difficulty finding the syntax of firebird and in particular its functions. Is there a good reference to the version of firebird used in Base v6?
Then how do I use the DATEDIFF function (which appears to be different to the forme HSQLDB)? I have in a SELECT statement:
DATEDIFF( year, "DOB", "TestDate") "Age"
but it is creating SQL syntax error.
Any advice appreciated.PansmanserTue, 02 Oct 2018 18:17:42 +0200https://ask.libreoffice.org/en/question/167414/how to use exact function to compare a text value from a cell to a constant valuehttps://ask.libreoffice.org/en/question/156430/how-to-use-exact-function-to-compare-a-text-value-from-a-cell-to-a-constant-value/In cell C6 , I have the value "Shot" without the quotes. In another cell I have the formula as shown below
=IF(EXACT(C6,"Shot"),1,2)
always I get the result 2 irrespective of what value I have in cell c6
How do I compare the text value in cell c6 with the constant value "Shot" and return 1 if they are same and else 2
CNWed, 30 May 2018 02:05:57 +0200https://ask.libreoffice.org/en/question/156430/Minif and Maxif function in calchttps://ask.libreoffice.org/en/question/62260/minif-and-maxif-function-in-calc/On sheet one, I have a list of URLs, with duplicates in column B. In column J, I have dates visited.
On sheet two, I have a list of all the URLs from sheet 1, with no duplicates.
On sheet two, I want to lookup the highest date that a URL from sheet one matching the url from sheet two in one column, and the earliest date in another.
Something like:
A|B|C
URL|Most recent update|first checked
[url]|=maxif(S1.B2:B25001,a2,S1.J2:J25001)|=minif(S1.B2:B25001,a2,S1.J2:J25001)
I realize that there is no minif or maxif functions (or if there are, I haven't found them), but if someone could show me a way to implement something that would work in the same way as they might work, I would really appreciate it.
Oh yeah: Fully updated English language Windows 7 x64 Ultimate edition with Japanese locale, using LibreOffice v4.4.4.3 Calc with en_US locale.
Had no idea what tags I was supposed to use, so please forgive me if I used the wrong ones.ThorniestmaxThu, 24 Dec 2015 01:34:33 +0100https://ask.libreoffice.org/en/question/62260/How do I.... a1/b1=c1(round result to 2 places) then ..a2/b2=c2 without manually entering that in each c(x) cellhttps://ask.libreoffice.org/en/question/136216/how-do-i-a1b1c1round-result-to-2-places-then-a2b2c2-without-manually-entering-that-in-each-cx-cell/ I have some data on gas mileage of my car. I would like to move it from paper to a spreadsheet. if I could do it recursively ......a1{some operation}b1 = c1 .... then.... a2{same operation}b2 = c2 etc. etc. I would have to manually enter less data from my paper records. The car has an avg mpg meter also so I have been keeping track of actual vs. reported m/g. So in
general I need ... cell{function}cell =cell .... for each cell in a column. I really have looked in various tutorials for this but I can't find it.
P.S. does anyone know of a good book on libreoffice calc. Thanks in advance to any who can help.sam1951Fri, 27 Oct 2017 15:49:38 +0200https://ask.libreoffice.org/en/question/136216/Filter by year of date older than 70 yearshttps://ask.libreoffice.org/en/question/131670/filter-by-year-of-date-older-than-70-years/Hi, I'm relatively new to LibreOffice Base. I can't find information on how to use functions and calculations in sql. Id like to do something like the following
SELECT *
FROM tblPeople
WHERE YEAR(TODAY()) - YEAR(tblPeople.birth) > 70
Also I cant figure out how to exclude empty fields.
WHERE tbl.field not null
doent seem to work.bulldozerWed, 20 Sep 2017 21:01:07 +0200https://ask.libreoffice.org/en/question/131670/Re: Calc - COS(), can this be fixed?https://ask.libreoffice.org/en/question/126338/re-calc-cos-can-this-be-fixed/ It is readily apparent that the COS() function is inaccurate (check COS(PI()/2).
I do not know if this is a system call, or an internal math library. Either way it can be fairly unhelpful for precision calculations. Also, SIN() on larger angles is not accurately handled (check: SIN(PI()) should return 0, it does not).
A work-around is to instead:
1) if angle > pi/2 then reduce it to QI and deal with sign issues separately
2) if COS(angle) is desired, call SIN(PI()/2 - angle) instead
Can the trig function accuracy be improved? Or, failing that, is there any hope of incorporating this into the program itself so that the function error is more transparent to the end-user? Any factor of pi/2 should be correct regardless of other floating point errors. (Many other functions you may care to perform rely upon factors of PI/2 cancelling out variables in those locations).PiHunter_LMThu, 24 Aug 2017 09:38:10 +0200https://ask.libreoffice.org/en/question/126338/Data Table Alternativehttps://ask.libreoffice.org/en/question/108060/data-table-alternative/Hi,
I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table.
This helps me to calculate the results of 1 cell with different values of 1 or 2 variables.
I post here a photo to understand it better:
![DataTable](http://imgur.com/a/FxmsK) http://imgur.com/a/FxmsK
On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.
ThankscranmaxTue, 04 Jul 2017 13:15:12 +0200https://ask.libreoffice.org/en/question/108060/search, match, and redirect resulthttps://ask.libreoffice.org/en/question/95353/search-match-and-redirect-result/beating my head against a wall trying to understand how to do this.
for every cell in column B, i want to search for a match in column A. for every match, i want to take the contents of the cell in column D on the same row as the key in column B, and put that result into the cell in column C on the same row as the match in column A.
unfortunately i don't have enough points to upload a file, but here's a link:
https://docs.google.com/spreadsheets/d/1IKLb_-mKUA8JEZ6w_reRY5scg6lgLv7d1dv4wX8FYTk/edit?usp=sharing
any help would be greatly appreciated.thefinn2003Tue, 16 May 2017 20:41:09 +0200https://ask.libreoffice.org/en/question/95353/How to find out if a search string is found as (part of a) content in a range of cells?https://ask.libreoffice.org/en/question/94268/how-to-find-out-if-a-search-string-is-found-as-part-of-a-content-in-a-range-of-cells/I would need a good formula for this for calc.inJesusFri, 05 May 2017 19:11:20 +0200https://ask.libreoffice.org/en/question/94268/How to find a description of a calc function fast by its name?https://ask.libreoffice.org/en/question/94309/how-to-find-a-description-of-a-calc-function-fast-by-its-name/ Would be great.inJesusSat, 06 May 2017 07:48:31 +0200https://ask.libreoffice.org/en/question/94309/how to convter dec num2 binary in libre writerhttps://ask.libreoffice.org/en/question/93677/how-to-convter-dec-num2-binary-in-libre-writer/ i created a table in libre writer , i tried to convert decimal numbersin one coloums to binary in other colum , but it showing faulty expression
i used dec2bin(A4) ;;; Here A4 Previous rowsampath74Fri, 28 Apr 2017 05:56:05 +0200https://ask.libreoffice.org/en/question/93677/LibreCalc- correspond few columns and rows across sheetshttps://ask.libreoffice.org/en/question/92272/librecalc-correspond-few-columns-and-rows-across-sheets/ Hello, I'm Libre Calc newbie that never went beyond SUM function. I have a complex and specified problem- I don't expect help, but if there is even a slight chance I'll get it, it's worth trying, **so**
I have three sheets:
- Governments revenues in domestic currency **(sheetA)**, ![](http://i.imgur.com/lGuHHvY.png)
- exchange rates- US$ per national currency **(sheetB)**, ![](http://i.imgur.com/ilXfWJx.png)
- and a sheet where I need government revenues shown in $dollars **(sheetC)**. ![image description](http://i.imgur.com/DIyRET3.png)
**SheetA** has columns with countries and revenue type listed (central gov/general) and rows with years listed. XY positions are different countries revenues in domestic currency in exact year. I need each XY position to correspond with **SheetB** which has three columns: country name, year and corresponding exchange rate.
Now I need to match **SheetA** country name column and year row with **SheetB** country name and year columns in a way that revenue in domestic currency **A** is multiplied by exchange rate **B** then value is returned to required **C** cell.
*Thus, **SheetC** is built like **SheetA** - two columns with country name and revenue type (central government/general) and one row with years, giving accurate **SheetA** XY positions. For curious- next I will compare 2000 private corporations and their factors with countries organisations in a scale of time, and try to make sense of their relative dynamics.*
zewnyFri, 07 Apr 2017 16:30:48 +0200https://ask.libreoffice.org/en/question/92272/How to make LibreOffice Calc treat empty cells as zeros when using ranges in formulas?https://ask.libreoffice.org/en/question/92199/how-to-make-libreoffice-calc-treat-empty-cells-as-zeros-when-using-ranges-in-formulas/I need to take the minimum over a range of cells, treating empty cells as zeros. However, both `MIN` and `MINA` functions ignore empty cells (in LibO 5.1). What can I do?
More precisely, what I currently need is to calculate the minimum of each line in a table treating empty cells as `0` and to store the results in the last column.alexeymuranovThu, 06 Apr 2017 17:16:10 +0200https://ask.libreoffice.org/en/question/92199/COUNTIF criteria evaluation - function applied on range cells?https://ask.libreoffice.org/en/question/85416/countif-criteria-evaluation-function-applied-on-range-cells/ My friend asked me for help and we only found a solution we don't like 100%.
**Problem:**
I have a table with angle values in degrees (0, 10, 20, ..., 180) - that is range A2:A20. I want to use COUNTIF to tell me, how many of these have SIN > 0,95.
**My solution:**
In column B I use RADIANS to convert degrees to radians. In column C I calculate the SIN value. Then I can write COUNTIF(C2:C20;">0,95").
I don't like this solution because I had to add two extra columns that hold values I don't need to see, I only have them so that COUNTIF can tell me what I need.
![image description](http://i.imgur.com/0vRnsC5.png)
----------
**Anything like this?**
I was hoping for something like this:
- COUNTIF(SIN(RADIANS(A2:A20)); "> 0,95") or better
- COUNTIF(A2:A20; "SIN(RADIANS(value))>0,95")
The "value" would be the value of the evaluated cell. In ">0,95" you can feel this keyword... "value > 0,95"... but not having it means not being able to apply functions to it.
Is there a better solution to my problem?Michal PtákWed, 11 Jan 2017 15:31:36 +0100https://ask.libreoffice.org/en/question/85416/Collect, Fusion, Intersection functions (asking for example database and queries)https://ask.libreoffice.org/en/question/48984/collect-fusion-intersection-functions-asking-for-example-database-and-queries/Hello
I've been searching information about the Collect, Fusion, Intersection functions and sadly, I did not find any easy to understand and clear example about how these functions works. In fact, I know how to use all the Base functions, except these functions.
I'd like to understand the practical use of these functions, and the best way is dealing with a database and some examples to see the results.
Please, could someone give me some practical examples of these functions with a sample database?
Cheers
mrmisterThu, 09 Apr 2015 00:31:05 +0200https://ask.libreoffice.org/en/question/48984/calc - copy formulae without adjustinghttps://ask.libreoffice.org/en/question/83352/calc-copy-formulae-without-adjusting/ So I have prepared a summary sheet with some really nasty formulae that reference other sheets in the same file.
In their simplest form, they are of the form
=AVERAGE(OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1))
In the uglier versions, they come as
=PERCENTILE(OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1),0.9)
and need to be entered with ``CTRL+SHIFT+ENTER``.
As I have other files that need the same kind of summary but for THEIR sheets, I have named the sheets in these files accordingly.
So I ``CTRL+A, CTRL+C``, switch to the other document and ``CTRL+V``.
Works "great", *EXCEPT* all the sheet references have been prefixed by the file name (i.e. ``$mw_rep0`` becomes ``'file:///home/.../myFirstDocument.ods'#$mw_rep0``), which in turn results in most cells displaying ``Err:502`` instead of the calculated values from the new sheet.
How do I copy the sheet WITHOUT doing that transformation? I can't copy-paste each cell's formula one-by-one into all the files that need them because I kind of need to get done before I die of old age.DiesNutsWed, 07 Dec 2016 15:05:02 +0100https://ask.libreoffice.org/en/question/83352/calc - #value when computing vector percentiles?https://ask.libreoffice.org/en/question/83351/calc-value-when-computing-vector-percentiles/The range below basically say "cut off everything before ``$B$8`` and everything after ``$B$9$`` and for the remaining, sum columns ``I,J`` where the values are distributed over multiple sheets (3 in this case, "mw_rep0", "mw_rep1", "mw_rep2").
``OFFSET($mw_rep0.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.J:J,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep1.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.J:J,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep2.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.J:J,$B$8,0,$B$9-$B$8,1)``
I will refer to this as ``range1`` (though I have to copy-paste it to use it because apparently, you cannot create a name for it).
So ``=AVERAGE(range1)`` entered with ``CTRL+SHIFT+ENTER`` will calculate me the average sum.
Now I want percentiles. To that end, I modify ``range1`` such that the terms for each sheet are separeted by ``~``, rather than by ``,``:
e.g: ``=PERCENTILE(OFFSET($mw_rep0.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.J:J,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.J:J,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.J:J,$B$8,0,$B$9-$B$8,1),0.9)``
when I enter *this* with ``CTRL+SHIFT+ENTER``, I get ``#VALUE!``.
Which I find strange because I have an even uglier range summing up columns ``B,C,D,E``, for which this works:
``OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1)``
I will refer to this as ``range0``.
Here, both, ``=AVERAGE(range0)`` and percentiles (for which we again modify ``range0`` such that the individual sheets' terms are separated by tilde, rather than comma) work.
e.g. ``=PERCENTILE(OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1),0.9)``
So how do I get the percentiles working in the "easier" case?DiesNutsWed, 07 Dec 2016 13:56:25 +0100https://ask.libreoffice.org/en/question/83351/Need help with Libre functionshttps://ask.libreoffice.org/en/question/80593/need-help-with-libre-functions/Thanks in advance for help.
Here is what I am trying to do.
If cells D2 through M2 are all empty then leave designated cell empty regardless of other circumstances. If cells D2 through M2 are not empty and the SUM of cells D2 through M2 is zero, then enter “OK”. If cells D2 through M2 are not empty and the SUM of cells D2 through M2 is not zero, then enter “Error”.
When I enter
=IF(D2:M2="","",IF(SUM(D2:M2)=0,"OK';"error""))
I get Err:508
Help is appreciatedCalcasieuFri, 28 Oct 2016 23:49:40 +0200https://ask.libreoffice.org/en/question/80593/How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)https://ask.libreoffice.org/en/question/73716/how-do-i-derive-a-text-day-monday-tuesday-from-a-date-field-7212016/So far, I have a long, complicated "IF" statement, using WEEKDAY()..
There must be an easier way!EasyRiderThu, 21 Jul 2016 15:49:17 +0200https://ask.libreoffice.org/en/question/73716/Multiplication in function returning boolean valuehttps://ask.libreoffice.org/en/question/76539/multiplication-in-function-returning-boolean-value/I am trying to write a function to sort through a list of abbreviated numbers using K and M, and converting these into numbers (e.g. 3.4K, .98M --> 3400, 980000). However, for some reason, when I add the multiplication to the function, instead of returning a number, it returns a boolean value.
So for instance, where A2 = 2.3K, the function
#####`=IF(ISNUMBER(SEARCH("K",A2)), LEFT(A2,LEN(A2)-1), IF(ISNUMBER(SEARCH("M",A2)), LEFT(A2,LEN(A2)-1), "ERROR"))`
returns 2.3, but the function
#####`=IF(ISNUMBER(SEARCH("K",A2)), (LEFT(A2,LEN(A2)-1) * 1000), IF(ISNUMBER(SEARCH("M",A2)), (LEFT(A2,LEN(A2)-1) * 1000000), "ERROR"))`
returns TRUE. Furthermore, the function
#####`=LEFT(A2,LEN(A2)-1)*1000`
returns 2300.
How can this be? Thanks!GuribotSun, 04 Sep 2016 05:52:06 +0200https://ask.libreoffice.org/en/question/76539/How to output a date as text string in a specified format?https://ask.libreoffice.org/en/question/75840/how-to-output-a-date-as-text-string-in-a-specified-format/I'm trying to concatenate text with dates.
I found this question which https://ask.libreoffice.org/en/question/21962/calc-how-to-copy-a-date-format-in-a-text-string/ helps me half the way. Using the function TEXT I can covert a date to a text string. But it only seems to work with yyyy-mm-dd as format. How can I get a text string in the dd.mm.yyyy format?FreeMindedThu, 25 Aug 2016 18:18:17 +0200https://ask.libreoffice.org/en/question/75840/How to setup 2 different calculation functions with a drop down menu or 2 radio buttonshttps://ask.libreoffice.org/en/question/68943/how-to-setup-2-different-calculation-functions-with-a-drop-down-menu-or-2-radio-buttons/ I would like to create a list drop down with Male and Female. Which I figured out how to do but what I dont know is if they chose male in the drop down that it calls calculation function and if they chose female it uses a different calculation formula.jeepnjeffThu, 28 Apr 2016 15:22:33 +0200https://ask.libreoffice.org/en/question/68943/multiply cellshttps://ask.libreoffice.org/en/question/67238/multiply-cells/ LibreOffice is great at opening files that newer office software can no longer open, but very difficult to use.
---Help leads nowhere
---Spreadsheet columns cannot be expanded to create a header, nor is there a way to create a header
How do I access Help, or a tutorial?
What and where are the formulas for SUM and Multiply? I cannot get it to do anything? Nor do I have any luck with MSCalc so it must be %*$#@ Windows 10 pro....wdhcFri, 25 Mar 2016 06:35:22 +0100https://ask.libreoffice.org/en/question/67238/base calculation in queryhttps://ask.libreoffice.org/en/question/56495/base-calculation-in-query/ I have this sentence `ROUND( ( 10 - ABS( DATEDIFF( 'ss', "lahto_t", "tulo_t" ) - 9000 ) / 211.5 ), 0 )` several times in my queries.
The calculation is working correctly but I'm looking for a user friendlier solution to do it. Can the result of this calculation be somehow stored in base so that it can be called when needed.
regards
harritapio
harritapioThu, 20 Aug 2015 21:23:08 +0200https://ask.libreoffice.org/en/question/56495/