Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 29 Jun 2020 12:08:07 +0200Data 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](https://imgur.com/download/pcld0Am/) 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.
Thanks
(edit: activated screenshot)cranmaxTue, 04 Jul 2017 13:15:12 +0200https://ask.libreoffice.org/en/question/108060/[Calc] List of changed functions with the languagehttps://ask.libreoffice.org/en/question/252770/calc-list-of-changed-functions-with-the-language/Hi,
I was wondering if there is reference list with all the functions that change its name when you change the language. ManulsMon, 29 Jun 2020 12:08:07 +0200https://ask.libreoffice.org/en/question/252770/Summing Hours as duration not correcthttps://ask.libreoffice.org/en/question/240290/summing-hours-as-duration-not-correct/I am having a time sheet where it monitors the start date and time with the end date and time .
I have successfully managed to subtract the end time from the start time and get the duration .
I want to calculate the duration and I am using the sum for that .
I have formatted my duration cells to be of [H]:MM:SS
and my start and end time formats are HH:MM:SS
however when summing up the duration the number is not correct when the duration is passing midnight :
An example:
from 23:00:00 (11:00 PM ) to 01:00:00 (01:00 AM)
This 2 hours duration is not summedpete28Thu, 23 Apr 2020 22:37:38 +0200https://ask.libreoffice.org/en/question/240290/Is there a list of functions for use in Basic?https://ask.libreoffice.org/en/question/239520/is-there-a-list-of-functions-for-use-in-basic/ I have been searching for a list of functions for LibreOffice Basic. ThankssteveaMon, 20 Apr 2020 06:01:14 +0200https://ask.libreoffice.org/en/question/239520/Libre Office vsn 6.3.4.2 spreadsheet RIGHT function stopped workinghttps://ask.libreoffice.org/en/question/226899/libre-office-vsn-6342-spreadsheet-right-function-stopped-working/ It was working and I selected all in the column containing mixed calculation and manually entered text and paste special as text. Now 'RIGHT' doesn't work. Calculation fields work, but RIGHT doesn't. The column is formatted as General. ="anther column" works. It was working an hour ago and now it doesn't in any column. Any ideas of what happened? JrflanneMon, 27 Jan 2020 23:28:20 +0100https://ask.libreoffice.org/en/question/226899/Is it possible to write Basic macros for Libre Office Calc in Windows that access the cell and range objects??https://ask.libreoffice.org/en/question/216049/is-it-possible-to-write-basic-macros-for-libre-office-calc-in-windows-that-access-the-cell-and-range-objects/I have written VBA code in Excel for many years and want to write some in Libre Office. Specifically I want to write functions that I can enter into cells on Libre Office Calc. I am able to create such functions but for some reason when I pass in a range of cells I get only an array of Basic variants, not the references to ranges that I can manipulate.
Any attempt to use code copied and pasted from Andrew Pitonyak's Macros Explained book (for example Listing 418 on page 478) results in a 'BASIC runtime error. Object variable not set.' at the first attempt to access the argument as a range object (the oRange.queryContentCells line).
Here is the code from Andrew Pitonyak:
Function NonEmptyCellsInRange(oRange, sep$) As String
Dim oCell 'The cell to use!
Dim oRanges 'Ranges returned after querying for the cells
Dim oAddrs() 'Array of CellRangeAddress
Dim oAddr 'One CellRangeAddress
Dim oSheet 'Sheet that contains the cell range
Dim i As Long 'General index variable
Dim nRow As Long 'Row number
Dim nCol As Long 'Column number
Dim s As String
REM First, find the cells that are NOT empty in this range!
REM I consider a cell to be not empty if it has a value,
REM date/time, string, or formula.
oRanges = oRange.queryContentCells(_
com.sun.star.sheet.CellFlags.VALUE OR _
com.sun.star.sheet.CellFlags.DATETIME OR _
com.sun.star.sheet.CellFlags.STRING OR _
com.sun.star.sheet.CellFlags.FORMULA)
oAddrs() = oRanges.getRangeAddresses()
For i = 0 To UBound(oAddrs())
REM Get a specific address range
oAddr = oAddrs(i)
For nRow = oAddr.StartRow To oAddr.EndRow
For nCol = oAddr.StartColumn To oAddr.EndColumn
oCell = oRange.Spreadsheet.getCellByPosition(nCol, nRow)
s = s & oCell.AbsoluteName & sep$
Next
Next
Next
NonEmptyCellsInRange = s
End Function
I am assuming that this has to do with the fact that I am on Windows and that Libre Office behaves a little differently. I using Libre Office Version 6.2.8.2 on a 64 bit Windows 10 PC.
I really want to use Libre Office Calc for data modelling on my Windows PC and I need to be able to create my own functions. Also I contribute money monthly to Libre Office. Any help much appreciated.DavigWed, 06 Nov 2019 09:48:23 +0100https://ask.libreoffice.org/en/question/216049/Error in asin-function? - "#NAME?"https://ask.libreoffice.org/en/question/210705/error-in-asin-function-name/The following formulae:
=ASIN(0.5)
Gives me this result: "#NAME?"
I don't understand that.
Both =ASIN(1) and =ASIN(0) works...
Henrik-RMon, 30 Sep 2019 12:51:25 +0200https://ask.libreoffice.org/en/question/210705/How this works (=SUMPRODUCT(MAX(ROW($C$52:$C$190)*($C$52:$C$190<>""))))https://ask.libreoffice.org/en/question/203807/how-this-works-sumproductmaxrowc52c190c52c190/This is the first time I have asked a quetion. I searched the community about finding the last occupied cell in a column and found this (=SUMPRODUCT(MAX(ROW($C$52:$C$190)*($C$52:$C$190<>"")))). It returned the row number and worked for me.
I tried to look up the functions and how it works but there was nothing about multiplying rows and "<>" and how "max" would work in this equation. Could someone explain this equation to me in detail? I like to know how things work.
Thanks LarryHWed, 07 Aug 2019 17:09:50 +0200https://ask.libreoffice.org/en/question/203807/Conditional totalshttps://ask.libreoffice.org/en/question/202574/conditional-totals/I have a spreadsheet which totals prize money in our village flower show.
Is it possible please to do a function which looks back along a row and counts up how many people got a score of exactly 100?
Any ideas gratefully received! HeskieMon, 29 Jul 2019 09:57:31 +0200https://ask.libreoffice.org/en/question/202574/calc text function stopped workinghttps://ask.libreoffice.org/en/question/200971/calc-text-function-stopped-working/A LibreOffice Calc spreadsheet (Linuxmint OS) with a small column of LEFT(A1,2) type text functions in Column B, with the source text in Column A (obvously), and all cells pre-formatted to "text", will not now accept new text functions of the same type. Nor is it even now possible to delete and retype a couple of characters in an existing formula and not be left with the function showing rather than the result. I am not aware of doing anything that caused this.
Only possible candidate is insertion of "character" or "shape" elsewhere in the spreadsheet, but in any case, problem still exists in trying to create a new spreadsheet with just test text data and text functions.
The standard Cntrl F8 "to show value" and" Cntrl` or Cntrl~ "to show formula/results" all work as expected on formulae entered earlier BUT it seems that new ones, even on a new spreadsheet, or even a modified old ones will not enter and execute. They just sit there as a text formula.
Its like the keyboard is now startedputting in an extra invisible corruption character. As mentioned above, even deleting the letters "LEFT" in the above function and retyping the replacement letters in, leaves a formula showing, and the only way back is to using cntrl-z to revert to old value.
I have shut and rebooted the computer to no avail. I am running Linuxmint Cinnamon about 18.3 and everything else is fine. I can, for example enter new maths type like SUM(A1:A8) in a number formatted range and that works OK. It's just the text functions that seem to not work.DinoProfSat, 13 Jul 2019 07:58:23 +0200https://ask.libreoffice.org/en/question/200971/Libreoffice Calc basic error:508 when setting formulahttps://ask.libreoffice.org/en/question/198334/libreoffice-calc-basic-error508-when-setting-formula/Hi all,
I am trying to set a formula using the net present value function to sum a column of numbers. This is in order to calculate the cost of a rising annuity.
i have separately calculated the column of numbers, but because I only want to sum a certain number of them I need to set the formula precisely.
I have tried the following commands;
Sheet.getCellByPosition(8,12).Formula = "=NPV(H3,G15:G" & 15+lifeExpectancy% & ")*(1+H2)"
and
Sheet.getCellByPosition(8,12).setFormula("=NPV(H3,G15:G" & 15+lifeExpectancy% & ")*(1+H2)")
where lifeExpectancy% is a positive integer.
Both command place the formula I would expect in the target cell;
=NPV(H3,G15:G25)*(1+H2)
But in both cases it doesn't calculate but instead gives me error:508
If I copy and paste the formula into that or any other cell it then calculates as expected.
Is this a bug, or am I doing something wrong?
It seems to work fine with other formulae, and appears to be related to the concatenation of rows being summed. I'd rather not have to iteratively build an array of rows to insert into the formula - can anyone think of another way of doing it please?
I am on version 6.1.1.2 on Windows 10johnsjsThu, 20 Jun 2019 14:41:38 +0200https://ask.libreoffice.org/en/question/198334/Calc How to make Chunking the words?https://ask.libreoffice.org/en/question/193736/calc-how-to-make-chunking-the-words/Hi,
i am doing Crossword need to chunking the words into a single litter
Example> <br>Beautiful B, E, A, U, T, I, F, U, L, <br>
each litter in column
![image description](/upfiles/15577610886569989.jpg)
<hr>Thanksevx80Mon, 13 May 2019 16:58:04 +0200https://ask.libreoffice.org/en/question/193736/Calculate some, not all functions after each update to spreadsheethttps://ask.libreoffice.org/en/question/192273/calculate-some-not-all-functions-after-each-update-to-spreadsheet/ I am writing a ledger program, where the results in some columns depend on cells in the lowest row being filled in, and other cells from the next row up. When I copy these functions down a whole column, I get values down the whole column, even though I would like these functions to only trigger for the row I'm in. How is that done?jrdoner@gmax.comWed, 01 May 2019 00:20:35 +0200https://ask.libreoffice.org/en/question/192273/Does Calc add automatically sheet name in cell ranges used in functions?https://ask.libreoffice.org/en/question/189914/does-calc-add-automatically-sheet-name-in-cell-ranges-used-in-functions/I am using SUM() -function to calculate a sum from a cell range from the same sheet, like
=SUM(B6:B15)
At some point I noticed Calc automatically adding sheet name to cell range.
=SUM('Sheet one'.B6:B15)
Is Calc doing this automatically in some situations? I know sheet names are being updated if sheet they are referring to is changed, but if no sheet name is used in the first place?
This became a problem to me, as Calc did not highlight anymore referred cells of the function when selecting the function input line. After testig a bit, I noticed this is caused by the fact that sheet name used has a space (or any other special character) on it. When using a sheet name without special characters (and thus without hyphens), UI shows the selection correctly.
=SUM(SheetOne.B6:B15)
See attachment [referred-cells-highlight.ods](/upfiles/1554909746582334.ods)
Is this a bug in Calc?
I'm using
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default;
Locale: fi-FI (en_US.UTF-8); Calc: groupEddie AirheadWed, 10 Apr 2019 17:24:48 +0200https://ask.libreoffice.org/en/question/189914/[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/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/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/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 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/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/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/